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 …