JavaScript is required to for searching.
Skip Navigation Links
Exit Print View
Oracle Solaris Cluster Data Service for MySQL Guide
search filter icon
search icon

Document Information

Preface

1.  Installing and Configuring HA for MySQL

A.  Deployment Example: Installing MySQL in the Global Zone

B.  Deployment Example: Installing MySQL in the Non-Global HA Container

Target Cluster Configuration

Software Configuration

Assumptions

Installing and Configuring MySQL on Local Storage in the HA Container

Example: Preparing the Cluster for MySQL

Example: Configuring Cluster Resources for MySQL

Example: Configuring the HA Container

Example: Installing and Bootstrapping the MySQL Software on Local Storage

Example: Modifying the MySQL Configuration Files

Example: Enabling the MySQL Software to Run in the Cluster

C.  Deployment Example: Installing MySQL in a Non-Global Zone

D.  Deployment Example: Installing MySQL in a Scalable or Multiple-Master Configuration

Index

Example: Configuring the HA Container

  1. On shared cluster storage, create a directory for the HA container root path.

    This example presents a sparse root zone. You can use a whole root zone if that type better suits your configuration.

    phys-schost-1# mkdir /global/mnt3/zones
  2. Create a temporary file, for example /tmp/x, and include the following entries:
    create -b
    set zonepath=/global/mnt3/zones/clu1
    set autoboot=false
    set pool=pool_default
    add inherit-pkg-dir
    set dir=/lib
    end
    add inherit-pkg-dir
    set dir=/platform
    end
    add inherit-pkg-dir
    set dir=/sbin
    end
    add inherit-pkg-dir
    set dir=/usr
    end
    add net
    set address=ha-host-1
    set physical=hme0
    end
    add attr
    set name=comment
    set type=string
    set value="MySQL cluster zone" Put your desired zone name between the quotes here.
    end
  3. Configure the HA container, using the file you created.
    phys-schost-1# zonecfg -z clu1 -f /tmp/x
  4. Install the zone.
    phys-schost-1# zoneadm -z clu1 install
  5. Log in to the zone.
    phys-schost-1# zlogin -C clu1
  6. Open a new window to the same node and boot the zone.
    phys-schost-1a# zoneadm -z clu1 boot
  7. Close this terminal window and disconnect from the zone console.
    phys-schost-1# ~~.
  8. Copy the container's configuration file to a temporary location.
    phys-schost-1# cp /opt/SUNWsczone/sczbt/util/sczbt_config /tmp/sczbt_config
  9. Edit the /tmp/sczbt_config file and set variable values as shown:
    RS=RS-MYS-ZONE
    RG=RG-MYS
    PARAMETERDIR=/global/mnt3/zonepar
    SC_NETWORK=false
    SC_LH=
    FAILOVER=true
    HAS_RS=RS-MYS-HAS
    
    
    Zonename=clu1
    Zonebootopt=
    Milestone=multi-user-server
    Mounts=

    Note - For more information about creating a zone, see Oracle Solaris Cluster Data Service for Solaris Containers Guide.


  10. Register the zone resource.
    phys-schost-1# ksh /opt/SUNWsczone/sczbt/util/sczbt_register -f /tmp/sczbt_config
  11. Enable the zone resource.
    phys-schost-1# clresource enable RS-MYS-ZONE