From: nik600 Date: September 23 2012 6:21pm Subject: Re: how to manage one master and many slaves List-Archive: http://lists.mysql.com/replication/2384 Message-Id: MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 > > 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