Re: A database redirect Question

[Pete Clapham]

Aha, many thanks for the pointer. The script now works every other mysql connection.. i.e. connect to test 1 then test 2 (test 2 will fail) repeat connect to test 2 and it will succeed. Then connect to test 1 and it will attempt test 2 again. Redo and it will connect to test 1.

It clearly remembers the last connect but doesn't refresh on the next connect. Apologies again, this can't be the best way to achieve the objective, any pointers are as always much appreciated.

Existing script below:

function read_auth( auth )   
        proxy.global.dbtest=auth.default_db
end

function connect_server()

        if proxy.global.dbtest == "test1" then
                print("Connecting to database : " .. proxy.global.dbtest)
                proxy.connection.backend_ndx = 1
                print("Choosing backend port 5301");

        elseif proxy.global.dbtest == "test2" then
                print("Connecting to database : " .. proxy.global.dbtest)
                proxy.connection.backend_ndx = 2
                print("Choosing backend port 5302");

        elseif proxy.global.dbtest == "test3" then
                print("Connecting to database : " .. proxy.global.dbtest)
                proxy.connection.backend_ndx = 3
                print("Choosing backend port 5303");
        end
end

Edited 1 time(s). Last edit at 04/02/2008 06:20PM by Jan Kneschke.