Oracle^® Solaris Cluster Data Service for MySQL Guide

Example: Enabling the MySQL Software to Run in the Cluster

1. Start the MySQL database manually on the node where the resource group is online.

   phys-schost-1# cd /usr/local/mysql
   phys-schost-1# ./bin/mysqld --defaults-file=/global/mnt3/mysql-data/my.cnf \
   --basedir=/usr/local/mysql --datadir=/global/mnt3/mysql-data \
   --pid-file=/global/mnt3/mysql-data/mysqld.pid \
   --user=mysql >> /global/mnt3/mysql-data/logs/ha-host-1.log 2>&1 &

2. Set the password for localhost in MySQL to root.

   phys-schost-1# /usr/local/mysql/bin/mysqladmin -S /tmp/ha-host-1.sock -uroot \
   password 'root'

3. Add an administrative user in the MySQL database for the logical host.

   phys-schost-1# /usr/local/mysql/bin/mysql -S /tmp/ha-host-1.sock -uroot -proot
   mysql> use mysql;
   mysql> GRANT ALL ON *.* TO 'root'@'phys-schost-1' IDENTIFIED BY 'root';
   mysql> GRANT ALL ON *.* TO 'root'@'phys-schost-2' IDENTIFIED BY 'root';
   mysql> UPDATE user SET Grant_priv='Y' WHERE User='root' AND Host='phys-schost-1';
   mysql> UPDATE user SET Grant_priv='Y' WHERE User='root' AND Host='phys-schost-2';
   mysql> exit

4. Prepare the Oracle Solaris Cluster specific test database.

   phys-schost-1# ksh /opt/SUNWscmys/util/mysql_register \
   -f /global/mnt3/mysql_config

   1. Enter root when you are asked for the MySQL admin password.

      You set it to root in Step 3.

   2. Enter a password when you are prompted for the fault monitor user password.
5. Stop the MySQL database.

   phys-schost-1# kill -TERM $(cat /global/mnt3/mysql-data/mysqld.pid)

6. Encrypt the fault monitor user password on one node to run the MySQL database.

   phys-schost-1# clpstring create -t resource -b RS-MYS RS-MYS

   Enter the same password you provided in Step 4 when you are prompted for the fault monitoring user password.

7. Register the MySQL resource.

   phys-schost-1# clresource create -d -g RG-MYS \
   -t ORCL.mysql \
   -p Mysql_basedir=/usr/local/mysql \
   -p Mysql_datadir=/global/mnt3/mysql-data \
   -p Mysql_user=mysql \
   -p Mysql_host=ha-host-1 \
   -p Mysql_fmuser=fmuser \
   -p Mysql_logdir=/global/mnt3/mysql-data/logs \
   -p Resource_dependencies=RS-MYS-HAS,ha-host-1 \
   RS-MYS