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
Installing and Configuring MySQL on Local Storage in a Non-Global Zone
Example: Preparing the Cluster for MySQL
Example: Configuring Cluster Resources for MySQL
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
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.
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
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
phys-schost-1# chown -R mysql:mysql /usr/local/mysql
phys-schost-1# zlogin clu1 phys-schost-2# zlogin clu1
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