Content switching with multi-user environment

[Gianluca Berardi]

Hello,
I have a problem that I'd like to try to solve with MySQLProxy.

I'd like to implement a sort of "advanced load balancer" that is able to
choose the right server to process a query only after seeing it.

This architecture should work in a multi-user environment.

The pool of connection solution ( that is avaible in the tutorial-keepalive.lua ) does not re-authenticate the connections taken from the pool , so a user A would have the GRANTs of the user B that created the connection.

In the documentation of MySQL Proxy there is an option "proxy-pool-no-change-user", so i thougt that every connection from the pool by default re-authenticates to the current user.

In the tests i have done this doesn't happen. Is there something i'm missing, or a different way to trigger the CHANGE_USER protocol?

Could you suggest me other ways to attain the same result?

Thank you very much for your help
Best Regards,
Gianluca



Edited 1 time(s). Last edit at 11/09/2013 05:20AM by Gianluca Berardi.