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.
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 & |
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' |
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 |
Prepare the Sun Cluster specific test database.
zone-1# ksh /opt/SUNWscmys/util/mysql_register -f /global/mnt3/mysql_config |
Stop the MySQL database.
zone-1# kill -TERM `cat /global/mnt3/mysql-data/mysqld.pid` |
Leave the zone.
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 |
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 |
Save and close the file.
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 |
Enable the resource.
phys-schost-1# clresource enable RS-MYS |