Go to main content

Oracle® Solaris Cluster Data Service for MySQL Guide

Exit Print View

Updated: October 2019
 
 

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