MySQL Forums
Forum List  »  Router & Proxy

Re: What about slaves delay ?
Posted by: Grégory Duchatelet
Date: July 09, 2007 01:50AM

Ok, thanks.

This solution is not the best: it's the lua script who choose the backend.

I think it will better if mysql-proxy choose the backend, then the lua script check that this backend have a low replication delay via the cron file, and remove this backend if not.

So, i have to know in lua script how to :
- know which backend was choosed by mysql-proxy
- say to MP to remove a backend
- say to MP to choose next backend
- say to MP to re-add a backend (when delay are acceptable)

Greg

Options: ReplyQuote


Subject
Views
Written By
Posted
4815
July 06, 2007 05:41AM
2842
July 06, 2007 07:51AM
2556
July 06, 2007 08:22AM
2584
July 06, 2007 12:21PM
Re: What about slaves delay ?
3020
July 09, 2007 01:50AM
2847
July 09, 2007 03:15AM


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.