I've used mysql-mmm in the past as well, in production environments with 2 masters and 4 slaves, where master database servers have gone down. It's not perfect, and won't guarantee 100% accuracy, but it does do its job fairly well.
Paul On 11/04/2010 07:46 AM, Justin Lintz wrote: > A co-worker recently setup http://mysql-mmm.org/ and it seems to be > working as advertised. We haven't had a production failure with it in > place yet but testing failovers before it was deployed worked well. > > - Justin Lintz > > > > On Thu, Nov 4, 2010 at 1:27 PM, Christian Paredes<c...@redbluemagenta.com> > wrote: >> Hey guys, >> >> I'm curious if anyone has implemented a solution for automatically >> promoting a MySQL slave machine to be a master for an entire pool of >> MySQL machines when the primary master goes down? >> >> I saw that lbpool (http://code.google.com/p/mysql-lbpool/) might do >> what I want, but I wasn't sure if anyone has used this before, or if >> anyone has implemented another way of doing this? >> >> Thanks guys, >> >> -- >> christian "ian" paredes >> http://about.me/cparedes/bio >> _______________________________________________ >> Tech mailing list >> Tech@lists.lopsa.org >> http://lists.lopsa.org/cgi-bin/mailman/listinfo/tech >> This list provided by the League of Professional System Administrators >> http://lopsa.org/ >> > _______________________________________________ > Tech mailing list > Tech@lists.lopsa.org > http://lists.lopsa.org/cgi-bin/mailman/listinfo/tech > This list provided by the League of Professional System Administrators > http://lopsa.org/ _______________________________________________ Tech mailing list Tech@lists.lopsa.org http://lists.lopsa.org/cgi-bin/mailman/listinfo/tech This list provided by the League of Professional System Administrators http://lopsa.org/
