Top considerations for backup of mysql
Download
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
Top considerations for backup of mysql
Top considerations for backup of MySQL

  • Dmitri Joukovski, Zmanda


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