JavaScript is required to for searching.
Skip Navigation Links
Exit Print View
Oracle Solaris Cluster Data Service for MySQL Guide     Oracle Solaris Cluster 3.3 3/13
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