test

Sun Cluster Data Service for MySQL Guide for Solaris OS

ProcedureExample: 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 admin 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 Sun Cluster specific test database. 


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

  5. Stop the MySQL database. 


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

  6. Leave the zone.

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

  8. 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=fmuser
LOGDIR=/global/mnt3/mys-data/logs
CHECK=YES

  9. Save and close the file.

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

  11. Enable the resource.


    phys-schost-1# clresource enable RS-MYS