Skip Navigation Links
Exit Print View
| Oracle Solaris Cluster Data Service for MySQL Guide Oracle Solaris Cluster 4.1

Search Scope:

- This Document
- Entire Library

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

Copyright © 2000, 2012, Oracle and/or its affiliates. All rights reserved. Legal Notices |