Re: Simple backend change in read_query

[Hardik Soni]

But it does not change the connection to the other server. It will execute the same query on the same server (mostly the master backend server)

See what I want to do is I want to run all SELECT queries on slave machine and all other queries on the master machine, Using tutorial-keepalive.lua i can get that the SELECT query is going to execute, even I can chagne the id of backend using 'proxy.connection.backend_ndx' but the query is not executed there. It is going on the main connection database. What I found is that we can not change the database connection in the read_query function. I tried to make connection change in 'connect_server()' function but in this function I am not able to get the query or query type so that I can change my connection according to the query.