89286

Capturing a Connection with connect_server o

When the proxy accepts a connection from a MySQL Client, the

connect_server () function is called.

There are no arguments to the function, but you can use and if necessary manipulate the information in

the proxy.connection table, which is unique to each Client session.

For example, if you have multiple backend servers, you can specify which server that connection

should use by setting the value of proxy.connection.backend_ndx to a valid server number. The

following codę chooses between two servers based on whether the current time in

minutes is odd or

even:

function connect_server ()

print("--> a Client really want3 to talk to a server")

if (tonumber(os.date("%M")) % 2 == 0) then

proxy.connection.backend_ndx - 2

print("Choosing backend 2")

else

proxy.connection.backend_ndx - 1 print("Choosing backend 1") end

print("Using " ..

proxy.global.backends[proxy.connection.backend_ndx).dst.name) end

This example also displays the IP address/port combination by accessing the information from the

intemal proxy.global.backends table.