4 ms·
What's the current status for Database failover? MySQL in my case - to mirror that is what's been holding me back. What happens with 1/10 second's database rec
by pbowyer 11y ago
What's the current status for Database failover? MySQL in my case - to mirror that is what's been holding me back.
What happens with 1/10 second's database records not replicated? That could be a successful transaction on one, and no record of it on the other?
- mschuster91 11y ago> What happens with 1/10 second's database records not replicated? You can use a multi-master setup and strict consistency checks, though.
- scurvy 11y agoMulti-master MySQL is generally regarded to be a very, very bad idea. Single master with multiple GTID replicas and promoting a replica to master upon failure is BCOP.