Re: Debugging

[Adrian Boughey]

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.