Skip Navigation Links
Oracle Solaris Cluster Data Service for MySQL Cluster Guide
Oracle Solaris Cluster 3.3 3/13
Search Scope:
This Document
Entire Library
Oracle Solaris Cluster Data Service for MySQL Cluster Guide
March 2013, E38170–01
Describes the Oracle Solaris Cluster HA for MySQL Cluster data service.
Document Information
Preface
1. Installing and Configuring HA for MySQL Cluster
HA for MySQL Cluster Overview
Overview of Installing and Configuring HA for MySQL Cluster
Planning the HA for MySQL Cluster Installation and Configuration
MySQL Cluster and Oracle Solaris Containers
Oracle Solaris Cluster HA for MySQL Cluster Components
Configuration Restrictions
Configuration Requirements
Dependencies Between HA for MySQL Cluster Components
Configuration Recommendations
Installing and Configuring MySQL Cluster
How to Enable a MySQL Cluster Database to Run in a Global Zone Configuration
How to Install and Configure MySQL Cluster in a Global Zone
How to Enable a Zone to Run MySQL Cluster in a Zone Configuration
How to Install and Configure MySQL Cluster in a Non Global Zone
Verifying the Installation and Configuration of MySQL Cluster
How to Verify the Installation and Configuration of MySQL Cluster
Installing the HA for MySQL Cluster Packages
How to Install the HA for MySQL Cluster Packages
Registering and Configuring HA for MySQL Cluster
Specifying Configuration Parameters for the MySQL Cluster Management Server Resource
How to Create and Enable Resources for MySQL Cluster Management Server
Specifying Configuration Parameters for the MySQL Cluster
ndb
Daemon Resource
How to Create and Enable Resources for the MySQL Cluster
ndb
Daemon
Specifying Configuration Parameters for the MySQL Cluster
ndb
Shutdown Controller Resource
How to Create and Enable Resources for MySQL Cluster
ndb
Shutdown Controller
How to Suspend the
ndb
Shutdown Controller's Stop Action
How to Create and Enable Resources for the MySQL Server
Verifying the HA for MySQL Cluster Installation and Configuration
How to Verify the HA for MySQL Cluster Installation and Configuration
Tuning the HA for MySQL Cluster Fault Monitor
Operation of the HA for MySQL Cluster Management Server Parameter File
Operation of the HA for MySQL Cluster
ndb
Daemon Parameter File
Operation of the Fault Monitor for HA for MySQL Cluster Management Server
Operation of the Fault Monitor for HA for MySQL Cluster
ndb
Daemon
Debugging HA for MySQL Cluster
How to Activate Debugging for HA for MySQL Cluster
A. Files for Configuring HA for MySQL Cluster
mysql_ndb_mgmd_config
File
mysql_ndbd_config
File
ndb_shutdown_config
File
B. Deployment Example: Installing MySQL Cluster in the Global Zone
Target Cluster Configuration
Software Configuration
How to Install MySQL Cluster Software
Setting up the MySQL Cluster Control
How to Configure the Management Server on Both Nodes
How to Configure the Data Nodes on Both Nodes
How to Initialize the MySQL Server
How to Create the HA for MySQL Cluster Configuration With Scalable Services
Example Configuration Files for Installation in the Global Zone
config.ini
File for Both Nodes to Store in
/mgm-data
my.cnf
File for the Data Nodes to Store in
/ndbd-data
my.cnf
File for the First SQL Node
phys-schost-1
to Store in
/mysql-data
my.cnf
File for the Second SQL Node
phys-schost-2
to Store in
/mysql-data
mysql_config
File for the First SQL Node
phys-schost-1
to Store in
/temp/cluconfig
mysql_config
File for the Second SQL Node
phys-schost-2
to Store in
/temp/cluconfig
mysql_ndb_mgmd_config
File for the First Node
phys-schost-1
mysql_ndb_mgmd_config
File for the Second Node
phys-schost-2
mysql_ndbd_config
File for the First Node
phys-schost-2
mysql_ndbd_config
File for the Second Node
phys-schost-2
ndbd_shutdown_config
File for One Node
ha_mysql_config
File for One Node
C. Deployment Example: Installing MySQL Cluster in a Non-Global Zone
Target Cluster Configuration
Software Configuration
How to Install MySQL Cluster Software
Setting Up the MySQL Cluster Control
How to Configure the Management Server on Both Nodes
How to Configure the Data Nodes on Both Nodes
How to Initialize the MySQL Server
How to Create the HA for MySQL Cluster Configuration With Scalable Services
Example Configuration Files for Installation in a Non-Global Zone
config.ini
File for Both Nodes to Store in
/mgm-data
my.cnf
File for the Data Nodes to Store in
/ndbd-data
my.cnf
File for the First SQL Node
phys-schost-1
to Store in
/mysql-data
my.cnf
File for the Second SQL Node
phys-schost-2
to Store in
/mysql-data
mysql_config
File for the First SQL Node
phys-schost-1
to Store in
/temp/cluconfig
mysql_config
File for the Second SQL Node
phys-schost-2
to Store in
/temp/cluconfig
mysql_ndb_mgmd_config
File for the First Node
phys-schost-1
mysql_ndb_mgmd_config
File for the Second Node
phys-schost-2
mysql_ndbd_config
File for the First Node
phys-schost-2
mysql_ndbd_config
File for the Second Node
phys-schost-2
ndbd_shutdown_config
File for One Node
ha_mysql_config
File for One Node
Index
C
D
E
G
H
I
L
M
N
P
R
S
T
Z