MySQL Proxy

Is it possible to add a new backend without restart mysql-proxy

Asked by Alex

I understand that we can add a new proxy before running mysql-proxy by using "--proxy-read-only-backend-addresses=". I am just wondering if we can add new backend to mysql-proxy on-the-fly (via LUA or to insert into MySQL table ) without restart it?

For example, if my db-tier becomes overload, I would like to start a new MySQL slave and inform mysql-proxy that there is a new backend available. Is it possible?

Thanks

Question information

Language:
English Edit question
Status:
Solved
For:
MySQL Proxy Edit question
Assignee:
No assignee Edit question
Solved by:
Alex
Solved:
Last query:
Last reply:
Revision history for this message
fmpwizard (diego-fmpwizard) said : 		#1

Hi Alex,

No, this isn't possible, you would need to restart the proxy and
specify the new backend

Regards,

  Diego

On Tue, Sep 13, 2011 at 12:15 AM, Alex
<email address hidden> wrote:
> New question #170961 on MySQL Proxy:
> https://answers.launchpad.net/mysql-proxy/+question/170961
>
> I understand that we can add a new proxy before running mysql-proxy by using "--proxy-read-only-backend-addresses=". I am just wondering if we can add new backend to mysql-proxy on-the-fly (via LUA or to insert into MySQL table ) without restart it?
>
> For example, if my db-tier becomes overload, I would like to start a new MySQL slave and inform mysql-proxy that there is a new backend available. Is it possible?
>
> Thanks
>
> --
> You received this question notification because you are a member of
> MySQL Proxy Discuss, which is an answer contact for MySQL Proxy.
>

--
Diego Medina
Web Developer
<email address hidden>
http://www.fmpwizard.com

Revision history for this message
Alex (sonpth) said : 		#2

Hi Diego,
Thanks very much for quick reply.
I just found your answer here : http://forums.mysql.com/read.php?146,269616,269616#msg-269616.
Sorry for duplicating.