Friday, September 03, 2004
Mysql & Replication falling over
Mysql's replication feature is a great
way of providing redundancy and load sharing for database servers.
Unfortunately, as we've learnt from bitter experience, it doesn't recover
particularly well from system crashes (clean shutdowns are okay). My guess
is, since the bin log is being written almost constantly, corruption occurs.
Having spent a fair amount of time ploughing through documentation on how to
recover from this, I thought I'd share our quick? and easy step by step
solution.
See more ...
posted by guy at: 08:54 SAST |
path: /systems |
permanent link
