Re: Load balancing issues on a Master/Master architecture

[Diego Medina]

Hi Kin,


In your test scenario, the mysqld servers are not really doing much. Try this:


Using two terminals

Send queries that would actually return a larger resultset, like

select * from mysql.user;

By using two terminals to send queries, it will give the proxy a chance to see that one backend is busy while the other backend is idle.

Let me know if this works.

Thanks

--
Diego Medina, QA Engineer
Enterprise Tools - Database Group, Sun Microsystems

Are you MySQL certified? http://www.mysql.com/certification