MySQL Forums
Forum List  »  Replication

mySQL Master-Slave Replication Problem
Posted by: Adam
Date: November 28, 2005 12:14AM

Hi!

This is my first post, I really hope that someone can give some good advice on this topic.

I run a high-traffic PHP-mySQL site.

We have three servers:

One apache server and two database server.

These two database servers are in a master-slave configuration.

We do INSERT and UPDATE queries to the master server and it replicates to the slave server, where we do READ queries.

In theory we thought this would be great. However, in practice it's been a nightmare.

The replication takes 30 seconds to a minute to complete. This delay has lead to problems left and right with our scripting. People post comments on the site and their comments don't appear, so they try to post again, etc.

There has to be a better way to distribute our database load without having this terrible delay. How do the major sites handle this? Any mySQL gurus that can help?

Thanks,

Adam



Edited 1 time(s). Last edit at 11/28/2005 12:14AM by Adam .

Options: ReplyQuote


Subject
Views
Written By
Posted
mySQL Master-Slave Replication Problem
2512
November 28, 2005 12:14AM


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.