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

Tuning the HA for MySQL Cluster Fault Monitor

The HA for MySQL Cluster fault monitor verifies that the data service is running in a healthy condition.

An HA for MySQL Cluster fault monitor is contained in each resource that represents the MySQL Cluster instance. You created these resources when you registered and configured HA for MySQL Cluster. For more information, see Registering and Configuring HA for MySQL Cluster.

System properties and extension properties of the MySQL Cluster resources control the behavior of the fault monitor. The default values of these properties determine the preset behavior of the fault monitor. Because the preset behavior should be suitable for most Oracle Solaris Cluster installations, tune the HA for MySQL Cluster fault monitor only if you need to modify this preset behavior.

Tuning the HA for MySQL Cluster fault monitor involves the following tasks, depending on the specific component:

The fault monitor HA for MySQL Cluster ndb daemon differentiates between connection problems and definitive application failures. The value of ERROR_ON_SHOW in the MySQL Cluster ndb daemon parameter file specifies the return code for connection problems. This value results in a certain amount of ignored consecutive failed probes as long as they all return the value of ERROR_ON_SHOW. The first successful probe reverts this back to zero. The maximum number of failed probes is calculated as 100 / ERROR_ON_SHOW. A definitive application failure will result in an immediate restart or failover.

The definition of the return value ERROR_ON_SHOW defines one of two behaviors for failed database connections of a MySQL Cluster ndb daemon resource.

To achieve either of these behaviors, use the standard resource properties retry_interval and thorough_probe_interval.

This section contains the following additional information:

Operation of the HA for MySQL Cluster Management Server Parameter File

The HA for MySQL Cluster management server resources use a parameter file to pass parameters to the start, stop, and probe commands. Changes to these parameters take effect at least at every restart, or enabling, or disabling of the resource.

Changing one of the following parameters, takes effect at the next probe of the MySQL Cluster management server resource:


Note - An unexpected change of the parameters with an enabled MySQL Cluster management server resource might result in an unplanned service outage. To avoid such an outage, first disable the MySQL Cluster management server resource, execute the change, and then re-enable the resource.


Operation of the HA for MySQL Cluster ndb Daemon Parameter File

The HA for MySQL Cluster ndb daemon resources use a parameter file to pass parameters to the start, stop, and probe commands. Changes to these parameters take effect at least at every restart, or enabling, or disabling of the resource.

Changing one of the following parameters, takes effect at the next probe of the MySQL Cluster ndb daemon resource:


Caution

Caution - Do not lower the Probe_timeout property of the ndbd daemon resource below 70 seconds. The probe algorithm relies on the presence of a management server. If the first physical node specified in the CONNECT_STRING is down, you will get a 60 seconds timeout. There must be enough time left, to run the probe request on the second node specified in the CONNECT_STRING.



Note - An unexpected change of the parameters with an enabled MySQL Cluster ndb daemon resource might result in an unplanned service outage. Therefore, disable the MySQL Cluster ndb Daemon resource first, execute the change, and then re-enable the resource.


Operation of the Fault Monitor for HA for MySQL Cluster Management Server

The fault monitor for HA for MySQL Cluster management server ensures that all the requirements for the MySQL Cluster management server component to run are met. These requirements include the following:

Operation of the Fault Monitor for HA for MySQL Cluster ndb Daemon

The fault monitor for HA for MySQL Cluster ndb daemon ensures that all the requirements for the MySQL Cluster ndb daemon component to run are met. These requirements include the following: