Mysql – Dual management node for thesql clustering

clusteringfailoverMySQLndbcluster

I currently have mysql cluster setup and running.
Here is my current setup:
1 – management node
2 – data nodes
2 – mysql nodes

I wish to incorporate a failover for the management node. The management node seems to be the bottleneck in my current setup. If the management node fails, my entire cluster is down. How can I incorporate a dual management node settings? Is it possible to have a 2nd management node? Must I also increase my data node and mysql node to accommodate the 2nd management node. Please assist.

This is what I have in my config.ini now: The 2 data nodes is together with my management node. I have separate out the mysql nodes. 

[ndb_mgmd]
hostname=192.168.0.1
datadir=c:\Users\user1\my_cluster\ndb_data
NodeId=1
[ndbd default]
noofreplicas=2
datadir=c:\Users\user1\my_cluster\ndb_data
[ndbd]
hostname=192.168.0.1
NodeId=3
[ndbd]
hostname=192.168.0.1
NodeId=4
[mysqld]
hostname=192.168.0.2
NodeId=5
[mysqld]
hostname=192.168.0.3
nodeId=6

Best Answer

Hmm, the two data nodes on one server means that if you lose 192.168.0.1 (node 3/node 4) you lose the whole cluster (possibly why you are experiencing the failure).

In fact the fact that you have effectively a single data node (unless I'm missing something) means you don't really have a cluster - you only have one copy of data.

Related Question