MySQL Forums
Forum List  »  Router & Proxy

MySQL Proxy load balancer
Posted by: alex lurthu
Date: February 27, 2008 11:54PM

Is there a way to obtain the user id that was authenticated for a particular thread. Right now i am building a table whenever read_auth gets called and make a entry in the table with the combination of backend_idx, thread_id and username. Is there an inbuilt variable that i can leverage ?

Also, when we are using mysql proxy in load balancer mode, do we have existing controls to slowly phase out server like first stop sending new connect requests to a server and once all existing connections are completed, remove it from the server list completely.

Options: ReplyQuote


Subject
Views
Written By
Posted
MySQL Proxy load balancer
3867
February 27, 2008 11:54PM
2468
March 11, 2008 09:14PM
2400
March 28, 2008 12:58AM


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.