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

Document Information

Preface

1.  Installing and Configuring HA for MySQL Cluster

A.  Files for Configuring HA for MySQL Cluster

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

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

How to Configure the Data Nodes on Both Nodes

  1. Create the configuration on both nodes.
    1. Create the data directory for the data node in the non-global zones.
      zone1:/ # mkdir /ndbd-data
      zone2:/ # mkdir /ndbd-data
    2. Copy the my.cnf file from the /temp/cluconfig in this directory.
      zone1:/ # cp /temp/cluconfig/my.cnf_ndbd /ndbd-data/my.cnf
      zone2:/ # cp /temp/cluconfig/my.cnf_ndbd /ndbd-data/my.cnf
    3. Modify the my.cnf_ndbd file from the /temp/cluconfig directory.

      Alternatively, copy the content from the my.cnf File for the Data Nodes to Store in /ndbd-data and overwrite the copied file.

  2. Start the data nodes.
    zone1:/ # cd /ndbd-data
    zone2:/ # cd /ndbd-data
    zone1:/ndbd-data # /usr/local/mysql/bin/ndbd \
    > --defaults-file=/ndbd-data/my.cnf \
    > --ndb-connectstring=zone_1_p:1186,zone_2_p:1186 --ndb-nodeid=3
    zone2:/ndbd-data # /usr/local/mysql/bin/ndbd \
    > --defaults-file=/ndbd-data/my.cnf \
    > --ndb-connectstring=zone_1_p:1186,zone_2_p:1186 --ndb-nodeid=4
  3. Verify the configuration on the zone, check the ndb nodes.
    zone1:/ndbd-data # /usr/local/mysql/bin/ndb_mgm \ 
    > --ndb-connectstring=zone_1_p,zone_2_p -e show

    Note - Repeat the show command until both ndbd processes are fully up and running.


    zone:/ # /usr/local/mysql/bin/ndb_mgm  
    > --ndb-connectstring=zone_1_p,zone_2_p -e show 
    Connected to Management Server at: zone_1_p:1186
    Cluster Configuration
    ---------------------
    [ndbd(NDB)]   2 node(s)
    id=3  @172.16.4.66 (mysql-5.1.35 ndb-7.0.7, Nodegroup: 0, Master)
    id=4  @172.16.4.65 (mysql-5.1.35 ndb-7.0.7, Nodegroup: 0)
    
    [ndb_mgmd(MGM)] 2 node(s)
    id=1  @172.16.4.66 (mysql-5.1.35 ndb-7.0.7)
    id=2  @172.16.4.65 (mysql-5.1.35 ndb-7.0.7)
    
    [mysqld(API)]  2 node(s)
    id=7 (not connected, accepting connect from zone1)
    id=8 (not connected, accepting connect from zone2)