MySQL: Administration, Transactions, Optimization, Scaling, Backup, and Recovery

Target Audience
Expected Duration
Lesson Objectives
Course Number
Expertise Level

As an organization grows, so will its database requirements. In this course, you'll explore the core administrative tasks of managing and maintaining your MySQL databases as they grow and as performance demands increase. The course also covers the transactions in MySQL, storage engines and server optimization, and scaling and high availability. You'll also learn about partitioning, replication, import and export, and backup and recovery.

Target Audience
Personnel at all levels of an enterprise seeking to attain competency in MySQL


Expected Duration (hours)

Lesson Objectives

MySQL: Administration, Transactions, Optimization, Scaling, Backup, and Recovery

  • start the course
  • describe the concepts of autonomous, consistent, isolated, and durable (ACID) transactions
  • define and use explicit transactions in MySQL statements
  • recognize how transactions can be isolated from each other for greater stability
  • recognize how locks prevent update conflicts and what happens when deadlocks occur
  • resolve your database when transactions are interrupted or incomplete
  • identify which storage engine best supports the desired performance features
  • identify appropriate optimization strategies for InnoDB usage
  • identify the optimal hardware configuration for the servers running MySQL
  • configure OS settings to optimize MySQL performance
  • configure MySQL values for optimal performance
  • describe and use transactions and optimize the server using different methods
  • describe the concept of partitioning large objects into smaller ones for greater performance
  • recognize how tables are partitioned
  • configure a partitioned table
  • recognize the concept and use of replicated databases
  • identify the different types of replication and their appropriate uses
  • configure replication between MySQL servers
  • use the database export feature to move a copy of a database to another server or instance
  • use the import database feature to implement a received copy of a database
  • create separate configurations of MySQL on a single server to support different database configurations
  • identify the importance of protecting your databases
  • identify the appropriate backup types
  • describe various options for when and how often to backup your databases
  • recognize your options for recovering databases from backup
  • perform a full database backup
  • perform a database recovery
  • recognize the various types of disasters that can occur and the appropriate mitigation strategies
  • implement scaling, clustering, failover, partitioning, replication, importing and exporting, and perform backup and recovery tasks
  • Course Number:

    Expertise Level