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...

[read_query] xxx.xxx.xxx.xxx:23491
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 : xxx.xxx.xxx.xxx:3306
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


Subject
Views
Written By
Posted
3529
October 01, 2007 05:38AM
2168
October 01, 2007 08:59AM
Re: Debugging
2420
October 01, 2007 09:46AM
2213
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.