Considering that you have the following hosts and MySQL Cluster
deployed in the following ways:
A: ndb_mgmd, ndbd , mysqld
B: ndb_mgmd, ndbd , mysqld
Now you have a couple of options on how to handle potential network partitioning/split brain which could occur if the computer A and B lose contact with each other. Let's see the implications of these options.
Option 1: ArbitrationRank=1, no NIC bonding
- If ndb_mgmd on A is elected as the arbitrator and host A crashes, then data node on host B will also die (cannot reach arbitrator).
- If ndb_mgmd on A is elected as the arbitrator and host B lose contact with host A, then the data node on B will shut down since it can't reach the arbitrator. For further discussions, call this situation X.
- If you are in situation X and if you restart data node on B and you have not fixed the link), then it will start isolated …