Re: RW not going to server

[John Croucher]

I have made a change to the code I have commented out the break lines in this section

if s.type == proxy.BACKEND_TYPE_RW and
s.state ~= proxy.BACKEND_STATE_DOWN and
cur_idle < pool.min_idle_connections then
proxy.connection.backend_ndx = i
slave_backend = i
--break
elseif s.type == proxy.BACKEND_TYPE_RO and
s.state ~= proxy.BACKEND_STATE_DOWN and
cur_idle < pool.min_idle_connections then
proxy.connection.backend_ndx = i
--break
elseif s.type == proxy.BACKEND_TYPE_RW and
s.state ~= proxy.BACKEND_STATE_DOWN and
rw_ndx == 0 then
rw_ndx = i
end

It now sends all the select statements to the correct IP and sends all the Update statements to the right IP. The only issue is that when the server is first started when I run insert statements i get this error

network-mysqld-proxy.c.2927: I have no server backend, closing connection
network-mysqld.c.1122: plugin_call(CON_STATE_READ_QUERY) failed

After I run a number of insert statements it seems to go away and works fine.