Sun Cluster Data Service for MySQL Guide for Solaris OS

ProcedureExample: Enabling the MySQL Software to Run in the Cluster

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


    zone# cd /usr/local/mysql
    zone# ./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# /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# /usr/local/mysql/bin/mysql -S /tmp/ha-host-1.sock -uroot -proot
    mysql> use mysql;
    mysql> GRANT ALL ON *.* TO 'root'@'ha-host-1' IDENTIFIED BY 'root';
    mysql> UPDATE user SET Grant_priv='Y' WHERE User='root' AND Host='ha-host-1';
    mysql> exit
    
  4. Prepare the Sun Cluster specific test database.


    zone# ksh /opt/SUNWscmys/util/mysql_register -f /config-files/mysql_config
    
  5. Stop the MySQL database.


    zone# 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
    .
    .
    .
    ZONE=clu1
    ZONE_BT=RS-MYS-ZONE
    PROJECT=.
    .
    .
    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