Go to main content

Oracle® Solaris Cluster Data Replication Guide for MySQL

Exit Print View

Updated: August 2018
 
 

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 the disaster recovery framework 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:

  • 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.