Oracle^® Solaris Cluster Data Service for MySQL Guide

Example: Modifying the MySQL Configuration Files

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

   phys-schost-1# cp /opt/SUNWscmys/util/mysql_config /config-files

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="ha-host-1"
   MYSQL_DATADIR=/global/mnt3/mys-data
   NDB_CHECK=

3. Save and close the file.