MySQL Forums
Forum List  »  Replication

Rather slow replication
Posted by: Cristi PAntus
Date: March 12, 2009 11:45PM

Hello,

I have a web application runnning on 2 servers and using master-slave replication. All writes are done on the master via IP address and all reads are done on localhost. The problem is as folows: the web app uses rather frequent update/select clauses and, from time to time, the select clause gets the "old" data rather than the replicated and updated one. This problem appears on the slave only.

One possible solution to this would be master-master replication, but i want to avoid that at all costs because it's a split brain waiting to happen scenario.

Is there any way I could prevent the situation (locks, cache, etc)?

Thank you,

Cristi

Options: ReplyQuote


Subject
Views
Written By
Posted
Rather slow replication
3008
March 12, 2009 11:45PM
1805
March 13, 2009 09:37AM


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.