mysql-proxy-discuss team mailing list archive

[Diego Medina <diego@xxxxxxxxxxxxx>]

Hi Samit,

Yes, it is possible, there are a few things to consider.

You will need to start a few connections through the mysql proxy port
3306, so that the proxy has a pool of connections. So far the proxy
cannot create new connections to the backend servers.

And you can see the username by looking at proxy.connection.client.username

Thanks

Diego


On Mon, Jun 8, 2009 at 1:11 PM, Samit Pal<samit04@xxxxxxxxx> wrote:
> Hi Folks,
>
> I plan to use the following mysql architecture. We will have multiple
> mysql servers on different ports on the same machine. Each db server
> process will run as a different user. I want to use mysql proxy and
> run it on port 3306 (on the same machine may be to start with), so
> essentially users connect to the mysql proxy which should switch the
> connection to the appropriate db server possibly based on the username
> supplied. I am not looking for load balancing, just pure switching. Is
> this possible with mysql proxy?
>
> Thanx
> Samit
>
> _______________________________________________
> Mailing list: https://launchpad.net/~mysql-proxy-discuss
> Post to     : mysql-proxy-discuss@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~mysql-proxy-discuss
> More help   : https://help.launchpad.net/ListHelp
>



-- 
Diego Medina
Web Developer
http://www.fmpwizard.com