Oracle^® Solaris Cluster Data Service for MySQL Guide

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= 
   MYSQL_HOST= phys-schost-1
   FMUSER=fmuser 
   FMPASS=
   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= 
   LOGDIR=/local/mys-data/logs 
   CHECK=YES 
   NDB_CHECK=

4. Save and close the file.