MySQL - advanced administration (EN)

David Solnař

You will be guided by David Solnař

Information

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

MySQL server administrator

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

Materials are in electronic form.

MySQL - advanced administration (EN)

Selected course term

18.12.2024 –  19.12.2024  ONLINE

Price
15 000 CZK + 21% VAT

Course terms

Contact the supplier


Because of spam protection, please answer the following question how much is five and eight ? Write the sum in digits.