Re: master-slave replication good solution?

[Huu Da Tran]

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