Oracle^® Solaris Cluster Data Service for MySQL Cluster Guide

How to Create and Enable Resources for the MySQL Cluster Server

Before You Begin

Before you begin make sure you already bootstrapped the MySQL Cluster server on all nodes to host the MySQL Cluster server.

This procedure provides the general steps to register a MySQL Cluster server. For complete instructions, see Registering and Configuring HA for MySQL Cluster. However, the deployment example in Appendix B, Deployment Example: Installing HA for MySQL Cluster in a Global Cluster shows all the steps to their full extent.

If you want monitoring of an ndb table by each SQL server you are about to configure, set NDB_CHECK=yes in the configuration files mysql_config and ha_mysql_config. This setting creates a functional dependency between the MySQL Cluster servers and the MySQL Cluster data node processes. Consider deploying the MySQL Cluster server in a scalable or multiple-masters topology.

1. Prepare the MySQL Cluster server on each node to run the MySQL Cluster server.
   1. Execute the mysqladmin command.
   2. Include the GRANT and UPDATE statements on each MySQL Cluster server you configured.

      For more details about the GRANT and UPDATE statements for each of the MySQL Cluster server you have configured, see Oracle Solaris Cluster Data Service for MySQL Guide .

2. Issue the /opt/SUNWscmys/util/mysql_register command on each MySQL Cluster server you configured.
3. (Optional) Make the ha_mysql_config file available on all nodes where the MySQL Cluster server is to run and execute.

   # /opt/SUNWscmys/util/ha_mysql_register -f config-file -e

   –e

   (Optional) Specifies that you want password encryption.

4. On one node, run the resource registration script.

   # /opt/SUNWscmys/util/ha_mysql_register -f config-file