Verifying the Installation and Configuration of MySQL Cluster

Before you install the Oracle Solaris Cluster HA for MySQL Cluster packages, verify that each MySQL Cluster instance that you created is correctly configured to run in a cluster. The instance consists of the MySQL Cluster processes together with the associated MySQL servers.

How to Verify the Installation and Configuration of MySQL Cluster

Perform this procedure for each MySQL Cluster instance that you created in Installing and Configuring MySQL Cluster.

This procedure does not verify that your application is highly available because you have not yet installed your data service.

1. (Optional) Log in to your target zone.

   # zlogin mysql-zone

2. Start the management server on all nodes or zones that host the MySQL Cluster management server.

   # cd MySQL-Cluster-management-server-data-directory
   # MySQL-installation-directory/bin/ndb_mgmd --configdir= \
   MySQL-Cluster-management-server-data-directory \
   > -f MySQL-Cluster-management-server-data-directory/config.ini \
   > --ndb_nodeid=actual-nodeid

   ---

   Note - The actual node ID is mentioned in the config.ini file.

   ---

3. Check the status of the management servers on all hosts running the MySQL Cluster management server.

   # MySQL-installation-directory/bin/ndb_mgm -e show

4. Start the ndbd daemon on all nodes to host the MySQL Cluster ndb daemon.

   # cd MySQL-Cluster-ndb-daemon-data-directory
   # MySQL-installation-directory/bin/ndbd \
   > --defaults-file=MySQL-Cluster-ndb-daemon-data-directory/my.cnf 
   > --ndb-connectstring=node1:1186 -ndb-nodeid=actual-nodeid

   ---

   Note - The actual node ID is mentioned in the config.ini file.

   ---

5. Check the status of the ndb daemons on one host running the MySQL cluster management server.

   # MySQL-installation-directory/bin/ndb_mgm -e show

6. Start the MySQL server on all nodes to host the SQL server.

   Perform to the verification procedure in Oracle Solaris Cluster Data Service for MySQL Guide, except do not kill the MySQL server at the end of the procedure.

7. Check the status of the management servers on one host running the MySQL Cluster management server.

   # MySQL-installation-directory/bin/ndb_mgm -e show

8. Stop the MySQL server on all nodes and zones that host the MySQL server.

   # kill -TERM `cat MySQL-database-directory/mysqld.pid`

9. On one node, stop the MySQL Cluster components.

   # MySQL-installation-directory/bin/ndb_mgm -e shutdown

10. Check the status of the MySQL Cluster components on all hosts which ran the management server.

    Ensure that all components are shut down.

    # MySQL-installation-directory/bin/ndb_mgm -e show