Initial Configuration of MySQL Replication

Performing the initial configuration consists of the following tasks:

1. Installing MySQL and configuring the MySQL database resource group

2. Configuring the MySQL replication

3. Configuring the MySQL application resource group

This section contains the following information:

• Installing MySQL and Configuring the MySQL Database Resource Group

• Configuring the MySQL Application Resource Group

Installing MySQL and Configuring the MySQL Database Resource Group

You can install MySQL and configure both clusters as described in Oracle Solaris Cluster Data Service for MySQL Guide.

The database resource group and its resources do not have to have the same name on both clusters.

Requirements for Geographic Edition controlling MySQL are as follows:

• Do not use the bind-address keyword in the MySQL configuration file my.cnf.

• Specify the nodes of all clusters in the mysql_config file for database preparation.

When preparing the MySQL database for cluster usage with the mysql_register script, you must provide all the physical node names or zone names of your clusters in the variable: MYSQL_NIC_HOSTNAME. For example:

MYSQL_NIC_HOSTNAME="cl1-phys1,cl1,phys2,cl2-phys3,cl2-phys4"

When you are configuring the database resource, keep the following restrictions in mind :

• The configuration of the MySQL database resource as a Service Management Facility (SMF) component on top of a failover container resource is not allowed.

• The MySQL replication between the two clusters must be the only MySQL replication configured in the two databases.

• The MySQL databases on both clusters must be configured to listen on the same port.