View Single Post
Old 02-08-2008, 03:14 PM   #6 (permalink)
iisbum
The Wanderer
 
Join Date: Nov 2007
Posts: 20
Thanks: 1
iisbum is on a distinguished road
Default

Quote:
Originally Posted by Sam Granger View Post
Ok iisbum, you say all db updates should go to the master - how does the slave know when the master is down - just check if connection cannot be made? And how would I get the master to first of all get updated details from slave when back up without going online straight away receiving data? (to prevent 2 semi-different db's?)
When I last did this, we had a manual cut over to the slave, which usually only happened when something really bad happened. The master was taken out of service entirely until we could diagnose what was wrong with it. We'd then manually sync things up and restore the the master into service. Its probably possible to automate much of this now, but I haven't need to do use replication recently.

We did have a "read only" mode for the webapp, so that if the master went down the website would still work reading content from the slave but no updates to the content could be made until we did our manual cutover, or the temporary problem with the master was resolved.

Mubs
iisbum is offline  
Reply With Quote