[PLUG] round robin mysql

[Ronald Chmara]

BTDT. Also a PITA, but at least there's less machines. The "best practice"
I got from the MySQL AB folks was HALinux+DRBD, so there's only *one* live
master, and both are close to each other (within milliseconds).



On Fri, Jun 21, 2013 at 2:17 PM, Russell Johnson <russ at dimstar.net> wrote:

> So, at a minimum, I'm thinking of switching to master<>master. At least
> then if something goes down, I can get things back up by just repointing
> things. Then repairing the damage can happen while things continue to work.
>
>
>
> On Jun 21, 2013, at 1:53 PM, Ronald Chmara <ronabop at gmail.com> wrote:
>
> > I've done it. It's a huge headache. As in, 3 hours a day getting
> everything
> > working right again after a simple "ALTER TABLE" breaks all the things,
> or
> > a transaction doesn't make it through (etc.).
> >
> >
> > On Fri, Jun 21, 2013 at 1:45 PM, Russell Johnson <russ at dimstar.net>
> wrote:
> >
> >> Has anyone else used round robin mysql servers? Where each server is a
> >> master and slave, like so:
> >>
> >> +-->1-->2-->3-->4-->n+1->+
> >> +<----<-------<-------<--+
> >>
> >> I'm thinking something like that with a load balancer in front of it
> would
> >> allow me to run fewer total db servers, and at the same time, if one
> goes
> >> down, things don't stop in their tracks. I'd rather have more of a star
> >> topology, but I don't see a real way to have 3 or more masters that are
> >> also slaves of each other. I can see a possible failure if, for example,
> >> node 3 goes down, node 4 and up won't get updates anymore until
> something
> >> does a SWITCH MASTER TO on node 4, but that can be scripted.
> >>
> >> Ideas? Suggestions? Reasons why I shouldn't do this?
> >>
> >> Background: I'm currently working with several mysql servers that are
> >> running in a master-->slave configuration. I'd like to find a way to
> make
> >> this so it's not quite as fragile.
> >>
> >> Russell Johnson
> >> russ at dimstar.net
> >>
> >>
> >>
> >> _______________________________________________
> >> PLUG mailing list
> >> PLUG at lists.pdxlinux.org
> >> http://lists.pdxlinux.org/mailman/listinfo/plug
> >>
> > _______________________________________________
> > PLUG mailing list
> > PLUG at lists.pdxlinux.org
> > http://lists.pdxlinux.org/mailman/listinfo/plug
>
> Russell Johnson
> russ at dimstar.net
>
>
>
> _______________________________________________
> PLUG mailing list
> PLUG at lists.pdxlinux.org
> http://lists.pdxlinux.org/mailman/listinfo/plug
>