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

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