MySQL Forums :: Utilities :: Is this a suitable plan


Advanced Search

Is this a suitable plan
Posted by: Richard Gladman ()
Date: May 05, 2010 06:52AM

I have two web servers which are load balanced and a single MySQL Server handling all of the database traffic as well as serving up our images. This single server is proving to be a bottle neck. I am hoping to improve performance as well as provide a failsafe should one of the servers have a problem.

I am planning to move a copy of the database to each of the web servers and have them read and write the local server with replication between the servers to keep them in sync.

This seems too easy and I am sure I am missing at least one major pitfall.

Does anyone have any thoughts on this?

Thanks in advance.



Edited 1 time(s). Last edit at 05/05/2010 06:56AM by Richard Gladman.

Options: ReplyQuote


Subject Views Written By Posted
Is this a suitable plan 3637 Richard Gladman 05/05/2010 06:52AM
Re: Is this a suitable plan 1857 Rick James 05/06/2010 08:55AM
Re: Is this a suitable plan 2266 Richard Gladman 05/06/2010 01:38PM
Re: Is this a suitable plan 1948 Rick James 05/06/2010 10:08PM


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.