problem with drbd, heartbeat and mysql

[jyoukhana]

i set up two machines to be a cluster, they both have drbd and heartbeat running and working, the shared resource is a mysql database. The problem i got is when the nodes are connected again after being disconnected, drbd thinks the nodes are not connected and are always on a standalone status.

What this means is say after unplugging the cable that is used for the direct drbd connection between these two computers the status changes to standalone which is the correct behavior but when i put the cable back in they will never connect and stay as a standalone connection.

So any help on why this is happening or how to fix it is appreciated.

Thanks

[falko]

Any errors in your logs?

[bhellman]

The reason you are seeing this is because you are manually inducing a split brain, the worst possible case scenario. This is not something that should ever occur in a properly configured custer.

For your test fail over try taking one node offline via the interface connected to the switch, or unplugging the power to the node.