MySQL Forums
Forum List  »  Router & Proxy

Advanced Search
New Topic

read queries are not executing on backend-read-only server
Posted by: Yogesh Malik
Date: July 20, 2009 06:17AM

I have two mysql server in master-slave setup,

i am using mysql-proxy 0.6.1

/usr/local/sbin/mysql-proxy --proxy-backend-addresses=db1:3306 --proxy-read-only-backend-addresses=db2:3306 --proxy-lua-script=split.lua

all my queries read and write are executing on proxy-backend-addresses db1,
how can i configure it to split read and write request.

thank you
yogesh

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
read queries are not executing on backend-read-only server
4486
Yogesh Malik
July 20, 2009 06:17AM
Re: read queries are not executing on backend-read-only server
2743
Diego Medina
July 20, 2009 02:10PM
Re: read queries are not executing on backend-read-only server
2395
Yogesh Malik
July 21, 2009 12:19AM
Re: read queries are not executing on backend-read-only server
2694
Yogesh Malik
July 21, 2009 12:31AM
Re: read queries are not executing on backend-read-only server
2426
Diego Medina
July 24, 2009 12:08PM


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.