mysql-proxy-discuss team mailing list archive
-
mysql-proxy-discuss team
-
Mailing list archive
-
Message #00241
Re: DB Splitting
Hi Ilya,
That should work, are you getting any errors using the simplified Lua script?
Thanks
Diego
On Sun, Aug 2, 2009 at 5:19 AM, Illia Nechay<stalker.llug@xxxxxxxxx> wrote:
> Hi, list.
>
> I 'm trying to implement query splitting based on a key word in query.
> For example, we have 2 mysql servers: backend1 (master) and backend2
> (slave), both are RW. If we get a query without a key word (let it be
> 'foobar') we should send it to backend1, if we get a query containing
> the word 'foobar' we send it to backend2.
> Am I right? Any help is appreciated.
>
> Thanks in advance,
> Ilya.
>
> _______________________________________________
> Mailing list: https://launchpad.net/~mysql-proxy-discuss
> Post to : mysql-proxy-discuss@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~mysql-proxy-discuss
> More help : https://help.launchpad.net/ListHelp
>
--
Diego Medina
Web Developer
http://www.fmpwizard.com
References