Example: Modifying the MySQL Configuration File

In this task, you will create the configuration file to prepare the MySQL database. It is assumed that you are still logged in to this zone.

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

   zone-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="zone-1 zone-2"
   MYSQL_DATADIR=/global/mnt3/mys-data

3. Save and close the file.