As part of Percona Remote DBA for MySQL service we recognize that reliable backups are one of the most important things we can bring to the table. In my experience handling emergencies, the single worst thing that can happen is finding out you don’t have backups available when some sort of data loss or catastrophic event occurs.
With our Remote DBA service we can take care of backups for you, what follows are some of the internals of our implementation.
What kind of outages can happen?
- Someone runs UPDATE or DELETE and forgets the where clause or filters weren’t quite right
- The application had a bug causing data to be removed or overwritten
- A table (or entire schema) was dropped …