Re: Under what conditions destination backend is changed?

[Vladimir Linevich]

Acccording to this article, (http://www.arcetri.astro.it/CC/Mysql/load-balancer.html),

> Distribution is handled by a simple count for the number connections distributed to each server - new connections are automatically sent to the server with the lowest count.

> The monitor plugin connects to each of the backends the proxy knows about and executes queries on each one in regular intervals. The results of those queries are used to determine the state of each backend.

This article is about MySQL Load Balancer,
are those statements right for mysql-proxy too?

I see 'SHOW GLOBAL STATUS' in general query log on my mysql backends,
i suppose that 'threads_connected' or 'threads_running' variables are cheched, but i haven't found any evidences of this.



Edited 1 time(s). Last edit at 03/27/2013 08:32AM by Vladimir Linevich.