Pardon my ignorance, but if the master is down for lets say 30 minutes,
the sqlite temp storage is used on the slave during that time as you
stated. Will the remote master be updated when it comes back online? If
so, how? What about vice versa?
I am all about using new techniques and I barely knew anything about
mysql master/master, but I did at least have it working. So I am just
trying to get a better grasp on how things would work.
I am not much of a sysadmin and more an IT consultant, so sometimes its
hard for me to wrap my head around some configurations.
Thanks for your time and patience,
Mark
On 2012-10-16 02:06, Andrew Colin Kissa wrote:
On 16 Oct 2012, at 8:57 AM, Mark Chaney wrote:
So if the master server is down and only the slave is up. Do we have
to manually promote the slave to a master or what? How do you envision
this setup to work?
There is many ways to do it, you can use solutions like bucardo to do
your master master if you want that or you manually promote the
slave,
during
failure mail filtering still works due to the sqlite temp storage.
- Andrew
--
www.baruwa.org
_______________________________________________
Keep Baruwa FREE - http://pledgie.com/campaigns/12056
_______________________________________________
Keep Baruwa FREE - http://pledgie.com/campaigns/12056