SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-28-2008, 09:25 AM
| ||||
| ||||
 Disaster recovery when a Master fails: Replicate writes from Slave? I'm looking for specific information about disaster recovery and MySQL 4.1. I have 1 master and 1 slave. We want to do a test scenario and bring the Master offline. Easy enough; but the question is, what happens if the slave receives writes? How will that be reconciled back to the Master? If the Master is brought back online, should be be brought back in read-only mode until <whatever procedure> is completed to sync the slave (which took over Master)? Is that even correct? I see the read-only option that can be placed in the Slave's my.cnf. But again, in a disaster situation, re: the above, I'm curious how to recover or if the design itself is just plain wrong... and the Slave should always be read-only. The goal here is that if the Master goes down, we want do continue to be able to function, which includes writes to the database --- with hopes that there's a proper procedure to replicate those back to the Master. Thanks.      |
Linear Mode
