Re: [lopsa-tech] Automatic MySQL Slave => Master Promotion

2010-11-04 Thread Christian Paredes
Awesome, thanks guys. I'll see what I can come up with. Cheers, -- 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

Re: [lopsa-tech] Automatic MySQL Slave => Master Promotion

2010-11-04 Thread Tracy Reed
On Thu, Nov 04, 2010 at 08:23:04AM -1000, Paul Graydon spake thusly: > 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. Another very useful tool in this area is maatkit. Maatkit is genious. Among man

Re: [lopsa-tech] Automatic MySQL Slave => Master Promotion

2010-11-04 Thread Paul Graydon
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-worke

Re: [lopsa-tech] Automatic MySQL Slave => Master Promotion

2010-11-04 Thread Justin Lintz
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 wrote: > Hey guys, >

[lopsa-tech] Automatic MySQL Slave => Master Promotion

2010-11-04 Thread Christian Paredes
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