Oracle^® Solaris Cluster Data Service for MySQL Cluster Guide

How to Enable a MySQL Cluster Database

For a complete example of deploying in a global zone, see Appendix B, Deployment Example: Installing HA for MySQL Cluster in a Global Cluster.

1. (Optional) Adjust the heartbeat_quantum and the heartbeat_timeout parameter if appropriate.

   # cluster set -p heartbeat_quantum=50%-of-heartbeat-timeout \
   -p heartbeat-timeout=value-in-milliseconds

2. (Optional) If you want to configure MySQL Cluster in a zone cluster, log in to the target zone.

   # zlogin zone-name

3. As the root role, register the SUNW.gds resource types.

   # clresourcetype register SUNW.gds

4. (Optional) Create a failover resource group to contain the shared-address resource.

   # clresourcegroup create shared-address-resource-group

5. (Optional) Create the shared-address resource.

   # clressharedaddress create -g shared-address-resource-group shared-address-resource

6. (Optional) Enable the shared-address resource group.

   # clresourcegroup online -eM shared-address-resource-group

7. Create the management server resource group.

   # clresourcegroup create -p Maximum_primaries=2 -p Desired_primaries=2 \
   mgmd-resource-group

8. Create the ndbd daemon resource group.

   # clresourcegroup create -p Maximum_primaries=2 -p Desired_primaries=2 \
   ndbd-resource-group

9. Create the MySQL Cluster server resource group.

   # clresourcegroup create -p Maximum_primaries=2 -p Desired_primaries=2 \
   mysql-resource-group

10. (Optional) Set the affinities for the MySQL Cluster server resource group.

    # clresourcegroup set -p RG_affinities=++ndbd-resource-group mysql-resource-group

Next Steps

Go to How to Install and Configure MySQL Cluster.