MySQL Forums :: Utilities :: separate the Query and direction

Advanced Search

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

Subject Views Written By Posted
separate the Query and direction 4482 Foong Kim Seong 05/30/2009 11:57AM
Re: separate the Query and direction 3131 Rick James 05/31/2009 01: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.