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