MySQL Forums
Forum List  »  Router & Proxy

Need some help with manual backend switching
Posted by: Anton Vorobev
Date: July 25, 2007 06:53AM

I've got two backends and I have to switch mysqlproxy from one to another manually.As I understood, now I can do it only by changing backend_ndx inside connect_server(). So, I try to do it via this lua script:

function connect_server( )
local file ="/root/lua/backend_ndx", "r") -- file contains only desired backend index (0 or 1)
ndx = file:read()
proxy.connection["backend_ndx"] = ndx
print (proxy.connection["backend_ndx"])

function read_query( packet )
local file ="/root/lua/backend_ndx", "r")
local new_ndx = file:read()

print ("< new ndx: " .. new_ndx .. " >")
if new_ndx ~= ndx then
proxy.response = {
type = proxy.MYSQLD_PACKET_ERR,
errmsg = "Backend has changed"

return proxy.PROXY_SEND_RESULT

proxy.queries:append(1, packet )
return proxy.PROXY_SEND_QUERY

It works fine, but when I stop mysql server on backend and already connected client tries to reconnect, mysqlproxy gets caught in an endless loop trying to connect to backend. Without line `proxy.connection["backend_ndx"] = ndx` it tries to reconnect only once, as I expected. What am I doing wrong? Help, please.

Options: ReplyQuote

Written By
Need some help with manual backend switching
July 25, 2007 06:53AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.