Example: How to Enable the MySQL Software to Run in the Cluster

Language:

Start the MySQL database manually on both nodes.

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

Note - Make sure to change phys-schost-1 to phys-schost-2 on the second node.

Set the password for localhost in MySQL to root on both nodes.
```
phys-schost-1# /usr/local/mysql/bin/mysqladmin -S /tmp/phys-schost-1.sock -uroot \ password 'root'
```
Note - Make sure to change phys-schost-1 to phys-schost-2 on the second node.

Add an administrative user in the MySQL database for the physical host on both nodes.

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

Note - Make sure to change phys-schost-1 to phys-schost-2 on the second node.

Prepare the Oracle Solaris Cluster specific test database on both nodes.

phys-schost-1# ksh /opt/SUNWscmys/util/mysql_register -f /local/mysql_config

Stop the MySQL database.

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

Encrypt the fault monitor user password on one node to run the MySQL database.
```
phys-schost-1# clpstring create -t resource -b RS-MYSQL RS-MYSQL
```
Enter the same password you provided in Step 4 when you are prompted for the fault monitoring user password.

Register the MySQL resource.

For a scalable resource, use the following command:

phys-schost-1# clresource create -d -g RG-MYSQL \
-t ORCL.mysql \
-p Mysql_basedir=/usr/local/mysql \
-p Mysql_datadir=/local/mysql-data \
-p Mysql_user=mysql \
-p Mysql_host=ha-host-1 \
-p Mysql_fmuser=fmuser \
-p Mysql_logdir=/local/mysql-data/logs \
-p Scalable=true \
-p Port_list=3306/tcp \
-p Resource_dependencies=ha-host-1 \
RS-MYSQL

For a multiple-master resource, use the following command:

phys-schost-1# clresource create -d -g RG-MYSQL \
-t ORCL.mysql \
-p Mysql_basedir=/usr/local/mysql \
-p Mysql_datadir=/local/mysql-data \
-p Mysql_user=mysql \
-p Mysql_fmuser=fmuser \
-p Mysql_logdir=/local/mysql-data/logs \
RS-MYSQL

Enable the resource.

phys-schost-1# clresource enable RS-MYSQL