How to Enable MySQL to run in Failover Zone Configuration

1. Become superuser or assume a role that provides solaris.cluster.verb RBAC authorization on one of the nodes in the cluster that will host MySQL.

2. As superuser register the SUNW.HAStoragePlus and the SUNW.gds resource types.

   # clresourcetype register SUNW.HAStoragePlus SUNW.gds

3. Create a failover resource group.

   # clresourcegroup create MySQL-resource-group

4. Create a resource for the MySQL zone`s disk storage.

   # clresource create -t SUNW.HAStoragePlus \ -p FileSystemMountPoints=MySQL-instance-mount-points \ MySQL-has-resource

5. (Optional) If you want the protection against a total adapter failure for your public network, create a resource for the MySQL`s logical hostname.

   # clreslogicalhostname create -g MySQL-resource-group \ -h logical-hostname \ MySQL-logical-hostname-resource-name

6. Place the resource group in the managed state.

   # clresourcegroup online -M MySQL-resource-group

7. Install the zone.

   Install the zone according to the Sun Cluster HA for Solaris Containers agent documentation, assuming that the resource name is MySQL-zone-rs and that the zone name is MySQL-zone.

8. Verify the zone's installation.

   # zoneadm -z MySQL-zone boot # zoneadm -z MySQL-zone halt

9. Register the zone's boot component.

   1. Copy the container resource boot component configuration file.

      # cp /opt/SUNWsczone/sczbt/util/sczbt_config zones-target-configuration-file

   2. Use a plain text editor to set the following variables:

      RS=MySQL-zone-rs
      RG=MySQL-resource-group
      PARAMETERDIR=MySQL-zone-parameter-directory
      SC_NETWORK=true|false
      SC_LH=MySQL-logical-hostname-resource-name
      FAILOVER=true|false
      HAS_RS=MySQL-has-resource
      Zonename=MySQL-zone
      Zonebootopt=zone-boot-options
      Milestone=zone-boot-milestone
      Mounts=

   3. Create the parameter directory for your zone's resource.

      # mkdir MySQL-zone-parameter-directory

   4. Execute the Sun Cluster HA for Solaris Container's registration script.

      # /opt/SUNWsczone/sczbt/util/sczbt_register -f zones-target-configuration-file

   5. Enable the Solaris Container resource

      # clresource enable MySQL-zone-rs

10. Enable the resource group.

    # clresourcegroup online MySQL-resource-group