Re: What about slaves delay ?

[Grégory Duchatelet]

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