DRBD with MySQL
- by tdimmig
Question about using DRBD to provide HA for MySQL.
I need to be sure that my backup MySQL instance is always going to be in a functional state when the failover occurs. What happens, for example, if the primary dies part way through committing a transaction?
Are we going to end up with data copied to the secondary that mysql can't handle? Or, what if the network goes away while the two are syncing, and not all of the data makes it across.
It seems like it's possible to get into a state where incomplete data on the secondary makes it impossible for mysql to start up and read the database.
Am I missing something?