Oracle® Solaris Cluster Geographic Edition Data Replication Guide for MySQL

Exit Print View

Updated: July 2014, E41326-01
 
 

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 of your clusters in the MYSQL_NIC_HOSTNAME variable. For example:

MYSQL_NIC_HOSTNAME="phys-paris-1,phys-paris-2,phys-newyork-1,phys-newyork-2"

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

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

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

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