MySQL Forums
Forum List  »  Router & Proxy

R/W splitting
Posted by: Jan Kneschke
Date: July 30, 2007 04:54PM

Some early tests seem to show that read/write splitting works nicely.

Check out the latest SVN code and read the examples from http://svn.mysql.com/svnpublic/mysql-proxy/trunk/examples/tutorial-keepalive.lua

For testing I used a local replication setup with :3306 been the master and :3307, 8 and 9 being the slaves.

$ ./src/mysql-proxy --no-daemon \
--proxy-lua-script=./examples/tutorial-keepalive.lua \
--proxy-backend-addresses=:3306 \
--proxy-read-only-backend-addresses=:3307 \
--proxy-read-only-backend-addresses=:3308 \
--proxy-read-only-backend-addresses=:3309

The connect_server() call tries to setup the connection pool and connect the each backend at least once. If we see a SELECT query outside of a transaction we try to balance it over the slaves.

--
Jan Kneschke, MySQL Enterprise Tools

Options: ReplyQuote


Subject
Views
Written By
Posted
R/W splitting
5774
July 30, 2007 04:54PM
2810
July 31, 2007 02:19PM
3164
July 31, 2007 09:10PM
2855
July 31, 2007 09:26PM
2945
July 31, 2007 10:03PM
2687
July 31, 2007 09:32PM
2645
July 31, 2007 10:11PM
3010
July 31, 2007 10:38PM
3173
July 31, 2007 11:04PM
2925
August 01, 2007 01:11AM
3165
August 01, 2007 09:05AM
2941
August 01, 2007 09:34AM
2713
August 01, 2007 09:45AM
2935
August 01, 2007 10:06AM
2990
August 01, 2007 10:16AM
2942
August 01, 2007 10:16AM
2865
August 02, 2007 01:05AM


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.