Re: Proxy pool member. How to...?

[Maxim Volkov]

At first I tried load balancing without a script (better say using script to only print out proxy.connection.backend_ndx in connect_server() function). Result: the first server out of five was executing queries. By reading previous post about 1ms connection time now I understand why round robin wasn't happening in this case.

Tried script from (http://dev.mysql.com/doc/refman/5.0/en/mysql-proxy-scripting-connect-server.html).
Result: Error --> (connect_server) /opt/dba/mysql-proxy/share/connect.lua:4: attempt to index field 'connection' (a userdata value). Wondering what is happening there.

Tried own improvised load balancing script with 6 servers behind proxy:
--------------------------------------------------
-- m.lua
function connect_server()

print ("~~> " .. proxy.connection.backend_ndx)
id = (math.random(1,10000) % 6) + 1
proxy.connection.backend_ndx = id
print ("~~> " .. proxy.connection.backend_ndx)
print("Choosing backend" .. id)
print("Using " .. proxy.servers[id].address)
end
------------------------------------------------------

Randomization works perfectly. However, proxy.connection.backend_ndx = id fails again. I guess there is a deeper issue with it.