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

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

Target Cluster Configuration

Software Configuration

Assumptions

Installing and Configuring MySQL on Local Storage in a Non-Global Zone

Example: Preparing the Cluster for MySQL

Example: Configuring the Zone

Example: Configuring Cluster Resources for MySQL

Example: Installing the MySQL Software on Local Storage

Example: Bootstrapping the MySQL Software on Local Storage

Example: Modifying the MySQL Configuration File

Example: Enabling the MySQL Software to Run in the Cluster

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

Index

Example: Installing the MySQL Software on Local Storage

These steps illustrate how to install the MySQL software in the default directory /usr/local/mysql. If only one node is mentioned, it needs to be the node where your resource group is online.


Note - This procedure assumes that you inherited the /usr directory, so you cannot write to /usr/local in the zones. If you linked /usr/local to a local directory, start at Step 4.


  1. Add the mysql user.
    phys-schost-1# groupadd -g 1000 mysql
    phys-schost-1# useradd -g 1000 -d /global/mnt3/mysql -m -s /bin/ksh mysql
    phys-schost-2# groupadd -g 1000 mysql
    phys-schost-2# useradd -g 1000 -d /global/mnt3/mysql -m -s /bin/ksh mysql
  2. Install the MySQL binaries on both nodes.
    phys-schost-1# cd /usr/local
    phys-schost-1# tar xvf mysql-max-5.0.22-solaris10-architcture_64.tar.gz
    phys-schost-1# ln -s mysql-max-5.0.22-solaris10-architcture_64 mysql
  3. Change the ownership of the MySQL binaries on both nodes.
    phys-schost-1# chown -R mysql:mysql /usr/local/mysql
  4. Log in to the zone.
    phys-schost-1# zlogin clu1
    phys-schost-2# zlogin clu1
  5. Add the mysql group and user.
    zone-1# groupadd -g 1000 mysql
    zone-1# groupadd -g 1000 mysql
    zone-2# useradd -g 1000 -d /global/mnt3/mysql -m -s /bin/ksh mysql
    zone-2# useradd -g 1000 -d /global/mnt3/mysql -m -s /bin/ksh mysql
  6. Leave the zone.