MySQL Forums
Forum List  »  Router & Proxy

feature request: dynamic updating of backend server list
Posted by: Laurentiu Badea
Date: July 24, 2007 06:49PM

I've noticed that MySQL Proxy supports retrieving its internal configuration via SQL. It would be really nice if this configuration, or at least parts of it, could be updated via the same mechanism.

The idea is to be able to change the backend servers dynamically from an external replication monitoring program. I realize it can probably be done in LUA but the monitor wouldn't be in LUA itself so it would still need to communicate with the Proxy in some way, might as well be in a known fashion (SQL). This may well become a possible common usage scenario for the Proxy so it's worth implementing at some point. The reasons for being able to update the backend list on-the-fly include:

- pick the most up-to-date servers, avoiding slaves that are lagging. Even for reads, where you want to read the freshest data;

- with read/write splitting, select the Write backend based on predefined algorithms that take into account replication state (monitored externally);

- synchronize a set of Proxy servers so they use the same Write backend after a backend failure;

- implement any number of server selection algorithms tightly integrated with the application using the database. Being able to query backend usage stats from the Proxy (queries, times, active etc) would also be useful in this context.

What do you think ?

Options: ReplyQuote

Written By
feature request: dynamic updating of backend server list
July 24, 2007 06:49PM
July 26, 2007 11:54AM

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.