Go to main content

Oracle® Solaris Cluster Data Service for MySQL Cluster Guide

Exit Print View

Updated: September 2015
 
 

Deployment Example: Installing HA for MySQL Cluster in a Global Cluster

This appendix presents a complete example of how to install and configure the HA for MySQL Cluster data service in a global cluster. It presents a simple two-node cluster configuration. If you need to install the application in any other configuration, refer to the general-purpose procedures presented elsewhere in this manual.

Target Cluster Configuration

    This example uses a two-node cluster with the following node names:

  • phys-schost-1 (a global-cluster node)

  • phys-schost-2 (a global-cluster node)

This configuration also uses the shared address host name sa-host-1.

The clprivnet addresses used by the MySQL Cluster configuration use the following names:

  • phys-schost-1-p running on phys-schost-1

  • phys-schost-2-p running on phys-schost-2

Software Configuration

    This deployment example uses the following software products and versions:

  • Oracle Solaris 11 software for SPARC or x86 platforms

  • Oracle Solaris Cluster 4 core software

  • Oracle Solaris Cluster HA for MySQL Cluster

  • MySQL Cluster version 7.0.7 tar file

This example assumes that you have already installed and established your cluster. It illustrates installation and configuration of the data service application only.

The projected configuration is as follows:

  • A scalable service for the management servers

  • A multiple-master service for the data nodes

  • A scalable service for the SQL nodes

The general tasks are:

  1. Install the MySQL Cluster software.

  2. Set up cluster control.

  3. Initialize the MySQL Cluster server and shut down the components.

  4. Create the resource groups and resources.

The following example procedures are provided in this section:

You will also need several configuration files, which are shown in Appendix A, Files for Configuring HA for MySQL Cluster.

On both nodes there is a file containing the MySQL Cluster available in /temp/mysql-7.0.7-solaris11-sparc.tar.gz.