Example: How to Modify the MySQL Configuration Files

1. Copy the MySQL configuration file from the agent directory to its deployment location on both nodes.

   phys-schost-1# cp /opt/SUNWscmys/util/mysql_config /local 
   phys-schost-1# cp /opt/SUNWscmys/util/ha_mysql_config /local 

2. Add this cluster's information to the mysql_config configuration file on both nodes.

   The following listing shows the relevant file entries for a scalable service and the values to assign to each entry.

   …
   MYSQL_BASE=/usr/local/mysql MYSQL_USER=root MYSQL_PASSWD=root MYSQL_HOST= phys-schost-1 FMUSER=fmuser FMPASS=fmuser MYSQL_SOCK=/tmp/phys-schost-1.sock MYSQL_NIC_HOSTNAME="phys-schost-1" MYSQL_DATADIR=/local/mysql-data NDB_CHECK= 

   ---

   Note - Make sure that the parameter MYSQL_HOST reflects the physical hostname on both nodes.

   ---

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

   ---

   Note - For a multiple-master resource leave the variables SCALABLE and LH empty.

   ---

   …
   RS=RS-MYSQL RG=RG-MYSQL PORT=3306 LH=ha-host-1 SCALABLE=yes LB_POLICY= HAS_RS= … BASEDIR=/usr/local/mysql DATADIR=/local/mysql-data MYSQLUSER=mysql MYSQLHOST= FMUSER=fmuser FMPASS=fmuser LOGDIR=/local/mys-data/logs CHECK=YES NDB_CHECK=

4. Save and close the file.