mmm for slave farm

[Jacky Shu]

All,

I want to build a mysql slave farm (no master included), which has
load balance, fail over. I was wondering anybody use mmm for it. Any
suggestions are welcome.

Thanks,

Jacky

[Istvan Podor]

Hi Jacky,

I would recommend using LVS.
I gave a talk about it not long ago:

http://www.percona.com/redir/files/presentations/FROSCON2010-Keep-Your-Mysql-Backend-Online-No-matter-what.pdf

Istvan

> --
> You received this message because you are subscribed to the Google Groups "MySQL Multi Master Manager Development" group.
> To post to this group, send email to mmm-...@googlegroups.com.
> To unsubscribe from this group, send email to mmm-devel+...@googlegroups.com.
> For more options, visit this group at http://groups.google.com/group/mmm-devel?hl=en.
>

[Jacky Shu]

Thanks Istvan,

So did you suggest use mmm? Sorry, I'm a bit lost. I want to limit
mmm on load balance, and manual failover virtual ip between slaves. It
seems risky to switch masters automatically.

On Dec 15, 10:04 am, Istvan Podor <istvan.po...@gmail.com> wrote:
> Hi Jacky,
>
> I would recommend using LVS.
> I gave a talk about it not long ago:
>

> http://www.percona.com/redir/files/presentations/FROSCON2010-Keep-You...

[Istvan Podor]

Jacky,

if you read my email, you can see I recommend LVS. you can see in the PDF I linked what I mean by that. That doesn't need MMM to be placed, that's of what you asked. Load balance reads between slaves.

Istvan