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

Verifying the Installation and Configuration of MySQL Cluster

Before you install the Oracle Solaris Cluster HA for MySQL Cluster packages, verify that each MySQL Cluster instance that you created is correctly configured to run in a cluster. The instance consists of the MySQL Cluster processes together with the associated MySQL servers.

How to Verify the Installation and Configuration of MySQL Cluster

Perform this procedure for each MySQL Cluster instance that you created in Installing and Configuring MySQL Cluster.

This procedure does not verify that your application is highly available because you have not yet installed your data service.

  1. (Optional) Log in to your target zone.
    # zlogin mysql-zone
  2. Start the management server on all nodes or zones that host the MySQL Cluster management server.
    # cd MySQL-Cluster-management-server-data-directory
    # MySQL-installation-directory/bin/ndb_mgmd --configdir= \
    MySQL-Cluster-management-server-data-directory \
    > -f MySQL-Cluster-management-server-data-directory/config.ini \
    > --ndb_nodeid=actual-nodeid

    Note - The actual node ID is mentioned in the config.ini file.


  3. Check the status of the management servers on all hosts running the MySQL Cluster management server.
    # MySQL-installation-directory/bin/ndb_mgm -e show
  4. Start the ndbd daemon on all nodes to host the MySQL Cluster ndb daemon.
    # cd MySQL-Cluster-ndb-daemon-data-directory
    # MySQL-installation-directory/bin/ndbd \
    > --defaults-file=MySQL-Cluster-ndb-daemon-data-directory/my.cnf 
    > --ndb-connectstring=node1:1186 -ndb-nodeid=actual-nodeid

    Note - The actual node ID is mentioned in the config.ini file.


  5. Check the status of the ndb daemons on one host running the MySQL cluster management server.
    # MySQL-installation-directory/bin/ndb_mgm -e show
  6. Start the MySQL server on all nodes to host the SQL server.

    Perform to the verification procedure in Oracle Solaris Cluster Data Service for MySQL Guide, except do not kill the MySQL server at the end of the procedure.

  7. Check the status of the management servers on one host running the MySQL Cluster management server.
    # MySQL-installation-directory/bin/ndb_mgm -e show
  8. Stop the MySQL server on all nodes and zones that host the MySQL server.
    # kill -TERM `cat MySQL-database-directory/mysqld.pid`
  9. On one node, stop the MySQL Cluster components.
    # MySQL-installation-directory/bin/ndb_mgm -e shutdown
  10. Check the status of the MySQL Cluster components on all hosts which ran the management server.

    Ensure that all components are shut down.

    # MySQL-installation-directory/bin/ndb_mgm -e show