MySQL - advanced administration (EN)

Description

The MySQL - Advanced Administration course introduces MySQL database server administrators to important advanced administration options. Participants will learn in detail the differences between individual storage engines, explain partitioning and access to metadata, learn to use replication as a supplement to backup for high availability, try to recover data from backups in case of problems and learn basic principles and procedures for optimizing database system performance. 

Target

Contents

• Storage Engines in detail - InnoDB, MyISAM, MEMORY, CSV, MERGE, FEDERATED, ARCHIVE
• Partitioning - principle, reasons for use, creation of partitioned tables, modifications and configuration, partitioning and locking
• Metadata - access to metadata, INFORMATION_SCHEMA, use of SHOW and DESCRIBE, mysqlshow command
• Replication - Introduction to High Availability (HA), principle, design, procedures, use and monitoring of replication
• Backup and recovery - scheduling, tools, backup options, replication and backup, method comparison, Log and Status file backup, data recovery options
• Disaster Recovery (DR) - differences between HA and DR, planning, testing
• Basics of performance optimization - EXPLAIN for analysis, table optimization, MySQL server variables, best practice 

Study Materials