News for hackers. Stuff that matters.

A comment on Don't ever use Digital Ocean as your production System.. Parent comment

Re:Don't ever use Digital Ocean as your production System. by coolboykl on Sunday May 11, 2014 @09:00AM (#7728588)
Yes, lesson learn from us.. We do have a scripts to auto cut over our Slave to Master DB once it detect our Master DB "death"..

Guess it's best to setup Master to Master replication..

[ Parent | on HN ]
Re:Don't ever use Digital Ocean as your production System. by stevekemp on Monday May 12, 2014 @08:06AM (#7732225)
> Guess it's best to setup Master to Master replication..

Master-Master has issues of its own, if you use shoddy applications that assume next-id=max(id)+1.

In the worst case situation you can find data on one master, and not the other, and vice-versa. So be prepared to reconcile things if you get into a split-brain scenario.

[ Parent | on HN ]