top considerations for backup of mysql
Download
Skip this Video
Download Presentation
Top considerations for backup of MySQL

Loading in 2 Seconds...

play fullscreen
1 / 12

Top considerations for backup of MySQL - PowerPoint PPT Presentation


  • 92 Views
  • Uploaded on

Top considerations for backup of MySQL. Dmitri Joukovski, Zmanda. Why do you need to backup MySQL? . Disaster recovery Compliance requirements Protecting against user error Application testing. What are your recovery objectives?. To what point in time do you want to recover your database?

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about ' Top considerations for backup of MySQL' - mckile


An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
why do you need to backup mysql
Why do you need to backup MySQL?
  • Disaster recovery
  • Compliance requirements
  • Protecting against user error
  • Application testing
what are your recovery objectives
What are your recovery objectives?
  • To what point in time do you want to recover your database?
      • Recovery Point Objective (RPO)
  • How much time will you have to recover your database?
      • Recovery Time Objective (RTO)
be ready for different types of recovery
Be ready for different types of recovery
  • The whole server
  • Specific database
  • Specific table
  • Specific transactions
easy recovery successful recovery
Easy recovery = successful recovery
  • Make a list of possible recovery situations
      • Original location
      • New hardware and same OS and MySQL version
      • New hardware and different OS
  • Test all of them
  • Actual recoveries happen under stress
how much backup will impact your application
How much backup will impact your application?
  • Backup window – the amount of time your application is unavailable or degraded
      • Cold, warm and hot backup
  • Size of database
  • Database activity
  • Business requirements
  • Plan for backup early on

Define your backup window

do you know what to backup
Do you know what to backup?
  • Number of MySQL servers
  • Storage engines (don’t forget about the future)
  • Use of MySQL replication
  • Pay special attention to:
  • Referential integrity
  • MySQL versions being used
  • Application might store data outside of MySQL
what is the best time to backup
What is the best time to backup?
  • Database activity
    • Is there a time database is less active?
    • Nature of activity (selects, inserts/updates)
  • Postpone backup if database is busy
  • Where do you want to backup?
  • Not on the same spindles!
how do you manage backups
How do you manage backups?
  • Automation
  • Pre-backup and post-backup
  • Security
    • Encryption
    • Who has the rights to recover data
    • technical and business rights
what kind of tracking and reporting you need
What kind of tracking and reporting you need?
  • Timely notifications
    • Backup failures
  • Reports about backups
  • Retention period of your backups
      • Defines how much space you need
      • Purging expired backups
what are the available solutions
What are the available solutions?
  • Write your own script
  • Pay $300 for MySQL recommended solution – Zmanda Recovery Manager
takeaways
Takeaways
  • Think about recovery first and be ready for different types of recovery
  • Understand impact of backup on your application
  • Figure out what, where and when to backup
  • Notifications and reports will simplify your backup procedures and ensure successful recoveries
ad