← Back to team overview

mysql-proxy-discuss team mailing list archive

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