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
-
Assume the root role on a cluster node that is to host the
MySQL Cluster component.
-
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 management server
|
mgm-rs
|
MySQL Cluster ndb daemon
|
ndb-rs
|
MySQL Cluster ndb shutdown controller
|
ndb-shut-rs
|
MySQL Cluster server
|
mysql-rs
|
|
-
Stop all MySQL Cluster resource groups.
-
Stop the MySQL Cluster server resource group.
# clresourcegroup offline mysql-rg
-
Stop the MySQL Cluster ndb resource group.
# clresourcegroup offline ndb-rg
-
Stop the MySQL Cluster management server resource group.
# clresourcegroup offline mgm-rg
-
Start all MySQL Cluster resource groups in reverse order.
-
Start the MySQL Cluster management server resource group.
# clresourcegroup online mgm-rg
-
Start the MySQL Cluster ndb resource group.
# clresourcegroup online ndb-rg
-
Start the MySQL Cluster server resource group.
# clresourcegroup online mysql-rg
-
Verify the status of all MySQL Cluster resource groups.
# clresource status
# clresourcegroup status