MySQL Forums
Forum List  »  Router & Proxy

Re: Load balancing issues on a Master/Master architecture
Posted by: Diego Medina
Date: July 17, 2009 08:30PM

Hi Ken,

The mysql proxy by itself (no lua script involved) does not know about load balancing.

You will need to use a lua script to distribute the load between your servers.

Now, that being said, balancing writes has proven to be very tricky (as in, there are so many cases you need to watch for ... etc)


Here you can find some information about those limitation
http://forge.mysql.com/wiki/MySQL_Proxy_RW_Splitting

Thanks

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

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

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Load balancing issues on a Master/Master architecture
2764
July 17, 2009 08:30PM


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.