Oracle^® Solaris Cluster Data Service for MySQL Guide

Example: Modifying the MySQL Configuration Files

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

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

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

   The following listing shows the relevant file entries and the values to assign to each entry.

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

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.

   …
   RS=RS-PGS
   RG=RG-MYS
   PORT=5432
   LH=hahostix1
   HAS_RS=RS-MYS-HAS
   …
   BASEDIR=/usr/local/mysql
   DATADIR=/global/mnt3/mysql-data
   MYSQLUSER=mysql
   MYSQLHOST=ha-host-1
   FMUSER=fmuser
   FMPASS=
   LOGDIR=/global/mnt3/mys-data/logs
   CHECK=YES
   LB_POLICY=
   SCALABLE=

4. Save and close the file.