MySQL Backup Training and Recovery Training

General Course Description

This instructor led hands on training course focuses on the OVERVIEW of MySQL backups and restoring options, and is an EXCELLENT overview of the MUST know commands to run in order to perform MySQL backups and restoring data from backups. Students will get over 20+ hours of hands-on-labs! The labs account for over 80% of the class and allows the student to learn FIRST hand from real world scenarios. Your instructor is a former Sun Microsystems employee & a MySQL Certified DBA & have a minimum of 10 years of MySQL deployment experience.

Course Details: MySQL Backup & Restoring

What You Will Learn

This course is a detailed overview of performing MySQL backups and restoring.

Course Objective

This course will help attendees perform SOLID MySQL backups and restoring backups.

Version Covered

This course will cover MySQL 5.6 and SOME parts of 5.7, subject to instructors discretion.

Related Training

If possible, please attend MySQL DBA Training courses as this will complete the FULL training.

Class Details

Who Should Attend
  • Sales Engineers
  • Systems Engineers
  • Database Administrators
  • IT Managers
  • Developers
    • Prerequisites
  • Basic understanding of databases - helpful but NOT necessary.
  • Understanding of installing and uninstalling programs.
  • Basic knowledge of the Internet, networks and ports.
  • Have read and know a little about MySQL.
  • Basic grasp of command line execution syntax and editors.
    • Course Outline

    Module 1 - MySQL Backup Overview

  • MySQL Backup - What / Why
  • Storage Engines
  • MySQL Backup Files
  • Backup Stratigies
  • Backup Cost and Locks


    • Module 2 - MySQL Backup Options - Local and Popular

  • MySQLdump 101
  • Securing Your Backup
  • Verifying Your Backup
  • 3rd Party Tools & Popular Options
  • MySQL Data Format / Compression and Output


    • Module 3 - Backup Hardware Challenges & Options

  • Backup Hardware & OS Considerations
  • Backup Hardware & OS Checklist
  • Hardware & OS Effects During a Backup
  • MySQL Backup Gotchas - Memory / HDD / CPU / Network
  • MySQL Enterprise Backup Option


    • Module 4 - Replication - Local / Data Center / Global

  • Replication Essentials
  • Replication As a Means of Backup - Considerations
  • Types of Replication Formats
  • Group Replication - What??
  • Pros and Cons of Replication - WARNING!


    • Module 5 - Backup Tuning and Optimization

  • Options, Options & More Options - 300+ in 5.5!
  • Balancing Between Options - An Art!
  • What To Look For When Backing Up & Restoring
  • To Compress OR Not To Compress
  • Backup Files, Logs and Databases


    • Module 6 - PITR - Point In Time Recovery

  • What Is PITR
  • MySQL and PITR Options
  • MySQL PITR Files & Logs
  • Pitfalls of PITR
  • PITR Options and Tools


    • Module 7 - Backup OUTSIDE the company

  • Pros and Cons To Sending Your Data OUTSIDE
  • Top THREE most popular options
  • Read The Fine Print To YOUR Cloud Backup
  • Security & Performance Consiserations
  • MySQL Cloud Gotcha / Resources and Monitoring


    • Module 8 - Backup Security Considerations

  • MySQL Backup Security Basics
  • Common Sense System To System Security
  • To Encrypt or NOT to Encrypt
  • Hardware / OS and Network Security Issues
  • Delaying Commands / Silent Backup Server


    • Module 9 - MySQL Disaster Recovery

  • Your Company Policy / Mandates / Approval
  • Effects of NOT choosing the correct Hardware / OS
  • Disaster Recovery Essentials
  • Disaster Recovery Checks and Balances
  • Case Study - Soup to Nuts


    • Course Logistics
    Course Schedule