Skip Navigation Links
Exit Print View
| Oracle Solaris Cluster Data Service for MySQL Cluster Guide Oracle Solaris Cluster 4.1

Search Scope:

- This Document
- Entire Library

### How to Configure the Data Nodes on Both Nodes

1. Create the configuration.
   1. On both nodes create the data directory for the management server.

          phys-schost-1:/ # mkdir /ndbd-data
          phys-schost-2:/ # mkdir /ndbd-data

   2. Copy the `my.cnf_ndbd` file from `/temp/cluconfig` in the `ndbd-data` directory.

          phys-schost-1:/ # cp /temp/cluconfig/my.cnf_ndbd /ndbd-data/my.cnf
          phys-schost-2:/ # cp /temp/cluconfig/my.cnf_ndbd /ndbd-data/my.cnf

   3. Modify the `my.cnf_ndbd` file from `/temp/cluconfig`.

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

2. Start the data nodes and verify the settings.

       phys-schost-1:/ # cd /ndbd-data
       phys-schost-2:/ # cd /ndbd-data

       phys-schost-1:/ndbd-data # /usr/local/mysql/bin/ndbd \
       > --defaults-file=/ndbd-data/my.cnf \
       > --ndb-connectstring=phys-schost-1-p:1186,phys-schost-2-p:1186 --ndb-nodeid=3
       phys-schost-2:/ndbd-data # /usr/local/mysql/bin/ndbd \
       > --defaults-file=/ndbd-data/my.cnf \
       > --ndb-connectstring=phys-schost-1-p:1186,phys-schost-2-p:1186 --ndb-nodeid=4

3. On one node, check the data nodes.

       phys-schost-1:/ndbd-data # /usr/local/mysql/bin/ndb_mgm \
       > --ndb-connectstring=phys-schost-1-p,phys-schost-2-p -e show

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

   Example output:

       phys-schost-1:/ # /usr/local/mysql/bin/ndb_mgm
       > --ndb-connectstring=phys-schost-1-p,phys-schost-2-p -e show
       Connected to Management Server at: phys-schost-1-p:1186
       Cluster Configuration
       ---------------------
       [ndbd(NDB)]   2 node(s)
       id=3  @172.16.4.2 (mysql-5.1.35 ndb-7.0.7, Nodegroup: 0, Master)
       id=4  @172.16.4.1 (mysql-5.1.35 ndb-7.0.7, Nodegroup: 0)

       [ndb_mgmd(MGM)] 2 node(s)
       id=1  @172.16.4.2 (mysql-5.1.35 ndb-7.0.7)
       id=2  @172.16.4.1 (mysql-5.1.35 ndb-7.0.7)

       [mysqld(API)]  2 node(s)
       id=7 (not connected, accepting connect from phys-schost-1)
       id=8 (not connected, accepting connect from phys-schost-2)

Copyright © 2000, 2012, Oracle and/or its affiliates. All rights reserved. Legal Notices |