Verifying the HA for MySQL Cluster Installation and Configuration

After you install, register, and configure HA for MySQL Cluster, verify this installation and configuration to determine whether the HA for MySQL Cluster data service makes your MySQL Cluster database highly available.

How to Verify the HA for MySQL Cluster Installation and Configuration

1. Become superuser on a cluster node that is to host the MySQL Cluster component.
2. Determine whether resources are online by issuing the following commands for each resource.

   If a resource is not online, use the clresource enable resources command to bring the resource online.

   
   

   MySQL Cluster Component Resource Name MySQL Cluster management server mgm-rs MySQL Cluster ndb daemon ndb-rs MySQL Cluster ndb shutdown controller ndb-shut-rs MySQL Cluster server mysql-rs

3. Stop all MySQL Cluster resource groups.
   1. Stop the MySQL server resource group.

      # clresourcegroup offline mysql-rg

   2. Stop the MySQL ndb resource group.

      # clresourcegroup offline ndb-rg

   3. Stop the MySQL management server resource group.

      # clresourcegroup offline mgm-rg

4. Start all MySQL Cluster resource groups in reverse order .
   1. Start the MySQL management server resource group.

      # clresourcegroup online mgm-rg

   2. Start the MySQL ndb resource group.

      # clresourcegroup online ndb-rg

   3. Start the MySQL server resource group.

       # clresourcegroup online mysql-rg

5. Verify the status of all MySQL Cluster resource groups.

   # clresource status
   # clresourcegroup status