mysql-proxy-discuss team mailing list archive

[zoly farkas <zolyfarkas@xxxxxxxxx>]

I have a set of mysql servers with identical schemas, but with different data, that I want to access as one database.

I would like the backend database to be selected by something provided in the sql query like a hint, or a where clause (or something else) where I will provide the server name or ip of the backend.

I cannot resolve this at application level because I have no control of the application (a reporting tool).

Does it make sense to use mysqlproxy for this purpose?

thanks

--zoly