Become superuser on one of the nodes in the cluster that will host MySQL.
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 |
Run the clresourcegroup command to switch the MySQL resource group to another cluster node, such as node2.
# clresourcegroup -h node2 MySQL-failover-resource-group |