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)