MySQL Forums
Forum List  »  Router & Proxy

Re: Implement new R/W split strategy meet some problems
Posted by: Frank Flynn
Date: May 06, 2008 12:29PM

One easy solution is to run two proxys - one for RO and one for RW. Perhaps not elegant but most applications out there already understand this issue and are already sending their common reads to the read slaves and the more critical reads and all writes to the RW master. So setting up two proxy servers is easy from that point of view.

If you can do it in Lua all the better but the above will work and is easy.

Good Luck,
Frank

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Implement new R/W split strategy meet some problems
2394
May 06, 2008 12:29PM


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.