MySQL Forums
Forum List  »  Router & Proxy

Re: R/W splitting. All requests only to write server.
Posted by: Diego Medina
Date: June 01, 2009 09:45AM

Hi Pavel,

You first need to start several connection through port 4040 so that the mysql proxy has some connections on the pool.

So far the mysql proxy does not start new connections to the backends.

You can do this by running something like this:

$ for i in `seq 1 500` ; do mysql -uusername -ppassword -e "exit"; done ;


and then try your select statements.

Thanks

P.S. It will be better if you try the latest version 0.7.1, which has many, many bug fixes and is more stable.

http://forums.mysql.com/read.php?146,265193,265193#msg-265193

--
Diego Medina, QA Engineer
Enterprise Tools - Database Group, Sun Microsystems

Are you MySQL certified? http://www.mysql.com/certification

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: R/W splitting. All requests only to write server.
3209
June 01, 2009 09:45AM


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.