Sun Cluster Data Service for MySQL Guide for Solaris OS

Verifying the Sun Cluster HA for MySQL Installation and Configuration

This section contains the procedure you need to verify that you installed and configured your data service correctly.

ProcedureHow to Verify the Sun Cluster HA for MySQL Installation and Configuration

  1. Become superuser on one of the nodes in the cluster that will host MySQL.

  2. Ensure all the MySQL resources are online with scstat.


    # cluster status 
    

    For each MySQL resource that is not online, use the clresource command as follows.


    # clresource enable MySQL-resource
    
  3. Run the clresourcegroup command to switch the MySQL resource group to another cluster node, such as node2.


    # clresourcegroup -h node2 MySQL-failover-resource-group