MySQL Forums
Forum List  »  Router & Proxy

Get asked database to switch backend
Posted by: Basile Zack
Date: November 17, 2009 11:01AM

Hi,

I have 2 mysql server on 2 different machines. My aim, is to use mysql-proxy to switch server depending on the wanted database.

For example :

Mysql-proxy is running on the first server with mysql server 1

databaseX is on mysql server 1
databaseY is on mysql server 2


If I ask databaseX (through mysql-proxy) I want to use server 1, and if I ask databaseY (through mysql-proxy) I want to use server 2.

Could this be possible with mysql-proxy ?

If this possible, do you know where I could find an example of Lua script doing that.

Thanks,

Basile.

Options: ReplyQuote


Subject
Views
Written By
Posted
Get asked database to switch backend
3954
November 17, 2009 11:01AM


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.