Example: Enabling the MySQL Software to Run in the Cluster

This task will initialize and prepare your database. It is essential that you perform it on one node only. It is assumed that you are still logged in to this zone.

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

   zone-1# cd /usr/local/mysql
   zone-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.

   zone-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.

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

4. Prepare the Oracle Solaris Cluster specific test database.

   zone-1# ksh /opt/SUNWscmys/util/mysql_register -f /global/mnt3/mysql_config

   • When prompted for the MySQL administrative password, enter root. This is the password you set in Step 3.

   • When prompted for the fault monitor user password, enter a password.

5. Stop the MySQL database.

   zone-1# kill -TERM `cat /global/mnt3/mysql-data/mysqld.pid`

6. Make the /global/mnt3/ha_mysql_config file available on the zone to run the MySQL database.
7. Enter the zone.
8. Encrypt the fault monitor user password on all nodes to run the MySQL database.

   zone# ksh /opt/SUNWscmys/util/ha_mysql_register \
   -f /global/mnt3/ha_mysql_config -3

   Enter the same fault monitor user password that you supplied in Step 4.

9. Leave the zone.
10. Copy the MySQL database configuration file from the agent directory to its deployment location.

    phys-schost-1# cp /opt/SUNWscmys/util/ha_mysql_config /global/mnt3

11. Add this cluster's information to the ha_mysql_config configuration file.

    The following listing shows the relevant file entries and the values to assign to each entry.

    …
    RS=RS-MYS
    RG=RG-MYS
    PORT=5432
    LH=ha-host-1
    HAS_RS=RS-MYS-HAS
    …
    BASEDIR=/usr/local/mysql
    DATADIR=/global/mnt3/mysql-data
    MYSQLUSER=mysql
    MYSQLHOST=ha-host-1
    FMUSER=fmuser
    FMPASS=
    LOGDIR=/global/mnt3/mys-data/logs
    CHECK=YES

12. Save and close the file.
13. Run the ha_mysql_register script to register the resource.

    phys-schost-1# ksh /opt/SUNWscmys/util/ha_mysql_register \
    -f /global/mnt3/ha_mysql_config

14. Enable the resource.

    phys-schost-1# clresource enable RS-MYS