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

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


Expected Duration
214 minutes

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.


Transactions in MySQL

  • 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

Storage Engines and Server Optimization

  • 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

Practice: Transactions and Server Optimization

  • describe and use transactions and optimize the server using different methods

Partitioning, Replication, and Import/Export

  • 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

Backup and Recovery

  • 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

Practice: High Availability Methods

  • implement scaling, clustering, failover, partitioning, replication, importing and exporting, and perform backup and recovery tasks





Multi-license discounts available for Annual and Monthly subscriptions.