The Five Minute DBA
You have just inherited a production MySQL system and there is no confirmation that an existing MySQL backup strategy is in operation. What is the least you need to do? Before undertaking any backup strategy there are some necessary prerequisites about your database size and storage engine usage that have a direct effect on your system availability during any backup approach.
In this chapter we will discuss the approach necessary to identify a minimum functionality backup, including:
• Determine your database size
• Determine your storage engine usage
• Locking and downtime implications
Approaching a MySQL Backup