JavaScript is required to for searching.
Skip Navigation Links
Exit Print View
Oracle Solaris Cluster Data Service for MySQL Guide
search filter icon
search icon

Document Information

Preface

1.  Installing and Configuring HA for MySQL

A.  Deployment Example: Installing MySQL in the Global Zone

B.  Deployment Example: Installing MySQL in the Non-Global HA Container

C.  Deployment Example: Installing MySQL in a Non-Global Zone

Target Cluster Configuration

Software Configuration

Assumptions

Installing and Configuring MySQL on Local Storage in a Non-Global Zone

Example: Preparing the Cluster for MySQL

Example: Configuring the Zone

Example: Configuring Cluster Resources for MySQL

Example: Installing the MySQL Software on Local Storage

Example: Bootstrapping the MySQL Software on Local Storage

Example: Modifying the MySQL Configuration File

Example: Enabling the MySQL Software to Run in the Cluster

D.  Deployment Example: Installing MySQL in a Scalable or Multiple-Master Configuration

Index

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=root MYSQL_HOST=ha-host-1 FMUSER=fmuser FMPASS=fmuser 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.