Example: Modifying the MySQL Configuration Files

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 Zone

Target Cluster Configuration

Software Configuration

Assumptions

Installing and Configuring MySQL on Local Storage in the HA Zone

Example: Preparing the Cluster for MySQL

Example: Configuring Cluster Resources for MySQL

Example: Configuring the HA Container

Example: Installing and Bootstrapping the MySQL Software on Local Storage

Example: Modifying the MySQL Configuration Files

Example: Enabling the MySQL Software to Run in the Cluster

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

Index

Copy the MySQL database configuration file from the agent directory to its deployment location.
```
phys-schost-1# cp /opt/SUNWscmys/util/mysql_config /config-files
```

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="ha-host-1"
MYSQL_DATADIR=/global/mnt3/mys-data
NDB_CHECK=

Save and close the file.

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