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.

How 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.


    # scstat 
    

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


    # scswitch -e -j MySQL- resouce
    
  3. Run the scswitch command to switch the MySQL resource group to another cluster node, such as node2.


    # scswitch -z -g MySQL-failover-resource-group -h node2