MySQL Forums
Forum List  »  Replication

Re: master-slave replication good solution?
Posted by: Huu Da Tran
Date: July 23, 2008 03:22PM

I have not played a lot with replication, but it's done pretty fast. It's not an immediate update, but pretty close.

To minimize the impact, you could query the master if the user actually did some modifications in the current page, and query the slave in other circumstances. This could be weird if master/slave are not in sync and the user modifies something, and loads another page that should display the modification within a few seconds.

You could show slave status (on the slave) and see how much delay there are between the master and the slave. Of course, assuming you did setup a master/slave.

Huu Da
MySQL flirter

Options: ReplyQuote

Written By
Re: master-slave replication good solution?
July 23, 2008 03:22PM

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.