MySQL Forums
Forum List  »  Utilities

separate the Query and direction
Posted by: Foong Kim Seong
Date: May 30, 2009 11:57AM

Hi, we are planning to do some sort like Database load balancing. The concept is, each time we execute the READ operation, i plan to direct the query to server A only.

When user want to do UPDATE, INSERT or DELETE, it'll direct to server B.

Just wondering how to do that? Shall i only use the connection String by putting the 2 server, A and B IP only?

I don't mind to do my own reading but i can't find any URL on the web. Please share with me.

Options: ReplyQuote

Written By
separate the Query and direction
May 30, 2009 11:57AM

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.