MySQL Forums
Forum List  »  Router & Proxy

Re: Want to know more about the load-balancing
Posted by: mike mike
Date: July 22, 2007 03:59AM

this assumes that the mysql nodes are setup using replication...

i am not sure, but is there any thoughts on making replication more fail-safe, or using the proxy product as a way to do multicast style queries (like continuent's m/cluster or uni/cluster products)

i have had poor experience with replication and don't want to rely on it personally. if it could auto-heal itself, it might be an option; or be able to do a hot-resync online without taking the master down (or read-only) ...

if the proxy was beefed up though to handle sending the queries (i guess that may require XA?) it could effectively be used in place of other solutions...

please reply to my thread about mysql usage - i'd like to collect some data! thanks!,57080

Options: ReplyQuote

Written By
Re: Want to know more about the load-balancing
July 22, 2007 03:59AM

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.