Diamond Notes

Just a quick post. This information is fairly readily available but more information is better right?

Adding a SQL node to a cluster is a fairly simple task:

Step 1: Add the new SQL node to the config.ini file on the management node.
Step 2: Make sure that the SQL node is configured identically (i.e. my.cnf) to the other cluster SQL nodes,
Step 3: Issue the ’stop’ command from the ndb_mgm console and then do a normal restart of the cluster: management node first, data nodes second and then SQL nodes.
Step 4: Issue the ’show’ command from the ndb_mgm console and you see the new SQL node (it takes about a minute to show up)

Hope that is useful for someone!!