MySQL Forums
Forum List  »  Router & Proxy

Re: Architecture problem, rw-splitter does not work
Posted by: Daniel Wharton
Date: May 09, 2008 03:33PM

It definitely works. You just have to get some connections going to it. If you have a high-traffic site, it will happen naturally. During testing I wrote a primer script to get a bunch of connections going.

Now I do hundreds of millions of queries per month through mysql-proxy and its definitely splitting up my read and r/w traffic. Cacti and dbmon.pl assure me of that : )

I'm working on some lua mods to split session DB out to a separate pool and not send ANY non-transaction selects to the primary rw server.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Architecture problem, rw-splitter does not work
2981
May 09, 2008 03:33PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.