List:Replication« Previous MessageNext Message »
From:nik600 Date:September 23 2012 6:21pm
Subject:Re: how to manage one master and many slaves
View as plain text  
>
> I've only said that it has an impact on the server-side, on many
> aspects application-level,networking-level,security-aspects (for
> example, using a proxy you can allow access to slaves only from the
> proxy,just for one example), or if you have many web servers adding a
> new slave node requires some configuration on all of them.
>
> Having a proxy in the middle just simplify it: you don't have to
> change the application and you can manage the proxy with less
> constraints.
>
> You are true about transactions.
>
> Thanks for your answer.
>
> --
> /*************/
> nik600
> http://www.kumbe.it

By the way, looking at the code of mysq-proxy i've found a
rw-splitting.lua example that manage transactions, probably you have
to provide also the lua file to mysql-proxy.

I'll let you know

-- 
/*************/
nik600
http://www.kumbe.it
Thread
how to manage one master and many slavesnik60023 Sep
  • Re: how to manage one master and many slavesMarcus Bointon23 Sep
    • Re: how to manage one master and many slavesnik60023 Sep
      • Re: how to manage one master and many slavesnik60023 Sep