Simple backend change in read_query

[Reinis Rozitis]

Hello,
according to changes it should be possible now to change backend at the read_query() stage right? Looking at rw-splitting.lua code sample also looks like it.

I wanted to make a simplified script (for now without connection pooling) which just redirects queries to right backend based on some substrings in the SQL (for example specific table names).

In the end I have just stopped at:

function read_query( packet )
proxy.connection.backend_ndx = 3
return proxy.PROXY_SEND_QUERY
end

Still although the variable is changed (by printing it later out) the connection is still handled in a load balanced (SQF) way.

It can be simply tested by letting a script connect to mysql-proxy and execute something like SHOW VARIABLES LIKE 'hostname'. I always get different server.

What I'm doing wrong?
I didn't saw anything in the commands, tokenizer, lb or auto_config scripts which are loaded in the rw-splitting script.