Oracle^® Solaris Cluster Data Service for MySQL Guide

Enabling MySQL

Determine whether you need to install MySQL in a failover, scalable, or multiple-master configuration and follow the appropriate procedure:

• How to Enable MySQL for a Failover Resource

• How to Enable MySQL to Run in a Scalable Configuration

• How to Enable MySQL to Run in a Multiple-Master Configuration

How to Enable MySQL for a Failover Resource

1. On one of the nodes in the cluster that will host MySQL, become an administrator that provides solaris.cluster.admin authorization.
2. Register the ORCL.mysql and SUNW.HAStoragePlus resource types.

   # clresourcetype register ORCL.mysql SUNW.HAStoragePlus

3. Create a failover resource group.

   # clresourcegroup create MySQL-failover-resource-group

4. Create a resource for the MySQL disk storage.

   # clresource create \
   -g MySQL-failover-resource-group \
   -t SUNW.HAStoragePlus \
   -p FilesystemMountPoints=MySQL-instance-mount-points MySQL-has-resource

5. Create a resource for the MySQL logical hostname.

   # clreslogicalhostname \
   -g MySQL-failover-resource-group \
   -h MySQL-logical-hostname \
   MySQL-lh-resource

6. Enable the failover resource group that now includes the MySQL disk storage and Logical Hostname resources.

   # clresourcegroup online -M -n current-node MySQL-failover-resource-group

How to Enable MySQL to Run in a Scalable Configuration

1. On one of the nodes in the cluster that will host MySQL, become an administrator that provides solaris.cluster.admin authorization.
2. Register the ORCL.mysql resource type.

   # clresourcetype register ORCL.mysql

3. Create a failover resource group.

   # clresource create SharedAddress-failover-resource-group

4. Create the shared address resource.

   # clressharedaddress create \
   -g SharedAddress-failover-resource-group \
   -h MySQL-logical-hostname \
   MySQL-lh-resource

5. Enable the failover resource group that now includes the shared address resources.

   # clresourcegroup online -M -n current-node MySQL-failover-resource-group

6. Create a resource group to run on at minimum two nodes.

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

How to Enable MySQL to Run in a Multiple-Master Configuration

1. On one of the nodes in the cluster that will host MySQL, become an administrator that provides solaris.cluster.admin authorization.
2. Register the ORCL.mysql resource type.

   # clresourcetype register ORCL.mysql

3. Create a resource group to run on at least two nodes.

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