MySQL Forums
Forum List  »  Router & Proxy

Re: Debugging
Posted by: Adrian Boughey
Date: October 01, 2007 09:46AM

Okay, I figured out that I simply had to change is_debug = true in rw-splitting.lua (docs need updating?), however this has only confirmed that mysql-proxy is ignoring my read-only database and is not proxying any queries to it. Here's an excerpt from the debug information...

current backend = 0
client default db = prod
client username = dbuser_prod
query = SELECT count(*) AS count_all FROM friendships WHERE (friend_id = 15 AND confirmation_id IS NULL)
sending to backend :
is_slave : false
server default db: prod
server username : dbuser_prod
in_trans : false
in_calc_found : false
COM_QUERY : true

I want mysql-proxy to send ALL read queries to my read-only database. What do I need to do?

Edited 1 time(s). Last edit at 10/11/2008 12:14AM by Adrian Boughey.

Options: ReplyQuote

Written By
October 01, 2007 05:38AM
October 01, 2007 08:59AM
Re: Debugging
October 01, 2007 09:46AM
October 01, 2007 10:38AM

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.