Verifying the Installation and Configuration of MySQL Cluster

Language:

Before you install the 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 Cluster 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.

(Optional) For a zone cluster, log in to your target zone.
```
# zlogin mysql-zone
```

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

# cd MySQL-Cluster-management-server-data-directory
# MySQL-Cluster-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.

Check the status of the management servers on all hosts running the MySQL Cluster management server.
```
# MySQL-Cluster-installation-directory/bin/ndb_mgm -e show
```

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

# cd MySQL-Cluster-ndb-daemon-data-directory
# MySQL-Cluster-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.

Check the status of the ndb daemons on one host running the MySQL Cluster cluster management server.
```
# MySQL-Cluster-installation-directory/bin/ndb_mgm -e show
```
Start the MySQL Cluster 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 Cluster server at the end of the procedure.
Check the status of the management servers on one host running the MySQL Cluster management server.
```
# MySQL-Cluster-installation-directory/bin/ndb_mgm -e show
```
Stop the MySQL Cluster server on all nodes that host the MySQL Cluster server.
```
# kill -TERM `cat MySQL-Cluster-database-directory/mysqld.pid`
```

On one node, stop the MySQL Cluster components.

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

Check the status of the MySQL Cluster components on all hosts which ran the management server.
Ensure that all components are shut down.
```
# ySQL-Cluster-installation-directory/bin/ndb_mgm -e show
```