Skip Navigation Links
Exit Print View
| Oracle Solaris Cluster Data Service for MySQL Cluster Guide Oracle Solaris Cluster 4.1

Search Scope:

- This Document
- Entire Library

## 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

Copyright © 2000, 2012, Oracle and/or its affiliates. All rights reserved. Legal Notices |