What's the current status for Database failover? MySQL in my case - to mirror th... | Hacker News

Hacker Newsnew | past | comments | ask | show | jobs | submit

		pbowyer on Dec 31, 2015 \| parent \| context \| favorite \| on: An update from Linode about the recent DDoS attack... 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 on Jan 1, 2016 [–]

> What happens with 1/10 second's database records not replicated?

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

scurvy on Jan 1, 2016 | [–]

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.

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact