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

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

Verifying the Installation and Configuration of MySQL Cluster

How to Verify the Installation and Configuration of MySQL Cluster

Installing the HA for MySQL Cluster Package

How to Install the HA for MySQL Cluster Package

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

B.  Deployment Example: Installing MySQL Cluster in the Global Zone

Index

Planning the HA for MySQL Cluster Installation and Configuration

This section contains the following information that you need to plan your HA for MySQL Cluster installation and configuration.

MySQL Cluster and Oracle Solaris Containers

Oracle Solaris Cluster HA for MySQL Cluster is supported in the following forms.

Oracle Solaris Cluster HA for MySQL Cluster Components

Oracle Solaris Cluster HA for MySQL Cluster is a combination of the following components.

Table 1-2 Oracle Solaris Cluster HA for MySQL Cluster Components

Component Name
Description
ndb management server
MySQL Cluster requires a daemon called the ndb management server to start, stop, and configure a MySQL cluster. The presence of the management server is required for probing the ndbd daemon as well.
ndb daemon
The ndb daemon implements the MySQL storage engine called ndbengine.
ndbd shutdown controller
The ndbd shutdown controller brings the MySQL Cluster to a state that enables the ndbd daemons to be shut down in any order.
MySQL Server
A normal MySQL server which provides the SQL interface for the MySQL Cluster tables.

Configuration Restrictions

This section describes configuration restrictions that apply only to HA for MySQL Cluster.


Caution

Caution - Your data service configuration might not be supported if you do not observe these restrictions.


Configuration Requirements

Dependencies Between HA for MySQL Cluster Components

The dependencies between the HA for MySQL Cluster components are described in the following table.

Table 1-3 Dependencies Between HA for MySQL Cluster Cluster Components

Component
Dependency
MySQL Cluster management server resource in a global zone or non-global zone
SUNW.SharedAddress is required only if the MySQL Cluster management server should be load balanced in a scalable configuration.
MySQL Cluster ndbd daemon resource in a global zone or non-global zone
MySQL Cluster management server resource is required.
MySQL Cluster shutdown controller resource in a global zone or non-global zone
MySQL Cluster ndbd daemon resource is required.
MySQL server resource in a global zone or non-global zone
  1. MySQL Cluster shutdown controller resource is required.
  2. SUNW.SharedAddress is required only if the MySQL Cluster server should be load balanced in a scalable configuration.

For any other possible dependency in a MySQL Server resource like SUNW.HAStoragePlus, failover container resource, or SUNW.LogicalHostname, see, the MySQL documentation at http://docs.oracle.com/cd/E17952_01/index.html for more details.

You set these dependencies when you register and configure HA for MySQL Cluster. For more information, see Registering and Configuring HA for MySQL Cluster.

If more elaborate dependencies are required, see the r_properties(5) and rg_properties(5) man pages for further dependencies and affinities settings.

Configuration Recommendations