[Bucardo-general] what to do when master-master replication failed?
Yan Chunlu
springrider at gmail.com
Sat Dec 10 10:24:50 UTC 2011
hi, all:
I have just tried bucardo and found it is great to do master-master
replication, especially for me that I have two master db across
datacenter which has 200ms latency.
currently I am planning to using bucardo to do master-master
replication, plus repmgr to do master-slave replication in case one
master failed. I only sync the tables, and the sequences are seperate
with odd and even.
like this:
DC1 DC2
master1(odd) master2(even)
slave1 slave2
what I am wondering is, database always have a chance to fail, in my
use case, both master need to be alive all the time, because they all
need to accept writes.
so once a master died, I need to promote the slave immediately, but
then what happened with bucardo synchronizer? could I just change the
server ip in bucardo's database? because the master-slave is using
PITR, all the schema, triggers, users would be the same between master
and slave.
If that could work, I think it should be the way to handle failover.
I can not afford for even one of the master to fail. thanks for all the help!
More information about the Bucardo-general
mailing list