Have you ever wondered what could happen if your MySQL database
Although it’s evident such a crash will cause downtime – and
surely some business impact in terms of revenue – can you do
something to reduce this impact?
The simple answer is “yes” by doing regular backups (of course)
but are you 100% sure that your current backup strategy will
really come through when an outage occurs? And how much precious
time will pass (and how much revenue will be lost) before you get
your business back online?
I usually think of backups as the step after HA fails. Let’s say
we’re in M<>M replication and something occurs that kills
the db but the HA can’t save the day. Let’s pretend that the UPS
fails and those servers are completely out. You can’t failover;
you have to restore data. Backups are a key piece of “Business
Continuity.” Also factor in the frequent need to restore data
that’s been …[Read more]