1. Installing and Configuring HA for MySQL Cluster
A. Files for Configuring HA for MySQL Cluster
B. Deployment Example: Installing MySQL Cluster in the Global Zone
C. Deployment Example: Installing MySQL Cluster in a Non-Global Zone
How to Install MySQL Cluster Software
Setting Up the MySQL Cluster Control
How to Configure the Management Server on Both Nodes
How to Configure the Data Nodes on Both Nodes
How to Initialize the MySQL Server
How to Create the HA for MySQL Cluster Configuration With Scalable Services
Example Configuration Files for Installation in a Non-Global Zone
config.ini File for Both Nodes to Store in /mgm-data
my.cnf File for the Data Nodes to Store in /ndbd-data
my.cnf File for the First SQL Node phys-schost-1 to Store in /mysql-data
my.cnf File for the Second SQL Node phys-schost-2 to Store in /mysql-data
mysql_config File for the First SQL Node phys-schost-1 to Store in /temp/cluconfig
mysql_config File for the Second SQL Node phys-schost-2 to Store in /temp/cluconfig
mysql_ndb_mgmd_config File for the First Node phys-schost-1
mysql_ndb_mgmd_config File for the Second Node phys-schost-2
mysql_ndbd_config File for the First Node phys-schost-2
mysql_ndbd_config File for the Second Node phys-schost-2
ndbd_shutdown_config File for One Node
This deployment example uses the following software products and versions:
Oracle Solaris 10 10/09 software for SPARC or x86 platforms
Oracle Solaris Cluster 3.3 core software
Oracle Solaris Cluster HA for MySQL
MySQL Cluster version 7.0.7 tar file
This example assumes that you have already installed and established your cluster. It illustrates installation and configuration of the data service application only.
The projected configuration is as follows:
A scalable service for the management servers
A multiple master service for the data nodes
A scalable service for the SQL nodes
The general tasks are:
Install the MySQL Cluster software.
Set up cluster control.
Initialize the MySQL server and shut down the components.
Create the resource groups and resources.
To achieve that we need several configuration files which are available in the Appendix.
On both nodes there is a tar file containing the HA for MySQL Cluster available in /temp/mysql-7.0.7-solaris10-sparc.tar.gz.