News for hackers. Stuff that matters.

A comment on An update from Linode about the recent DDoS attacks. Parent comment

Re:An update from Linode about the recent DDoS attacks by pbowyer on Thursday December 31, 2015 @06:53PM (#10820411)
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?

[ Parent | on HN ]
Re:An update from Linode about the recent DDoS attacks by mschuster91 on Thursday December 31, 2015 @07:08PM (#10820469)
> What happens with 1/10 second's database records not replicated?

You can use a multi-master setup and strict consistency checks, though.

[ Parent | on HN ]
Re:An update from Linode about the recent DDoS attacks by scurvy on Thursday December 31, 2015 @10:10PM (#10820971)
Multi-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.
[ Parent | on HN ]