Advanced MySQL and MariaDB training

You are already familiar with the MySQL or MariaDB and you are challenged to operate a serious MySQL database. If this is the case this training is the right one for you.

Requirements

You are familiar with the MySQL basics and have already some experience with MySQL or MariaDB operations. The SQL language does not look strange to you any more. Further you are familiar with the Linux console and rule the most important UNIX commands.

Audience

• MySQL application developer
• MySQL and MariaDB database administrators
• System administrators with database responsibility

Contents

The following 3 modules can also be booked separately for our facility in Essen (Linuxhotel).

MySQL and MariaDB operations (1 day)

• Installation and configuration of MySQL and MariaDB
• Backup and restore with mysqldump and xtrabackup
• Point-in-Time-Recovery (PiTR)
• Security

MySQL and MariaDB High Availability (2 days)

• Overview over the MySQL architecture
• MySQL architectures
• Master/Slave replication
• Master/Master replication
• Virtual IP
• Read/Write distribution
• Active/active clustering with Galera Cluster
• Load Balancing

MySQL and MariaDB Performance Tuning (2 days)

• General things about performance
• Hardware and performance
• Operating System (Linux)
• MySQL database configuration (my.cnf)
• Schema Tuning
• Indexing
• SQL Query Tuning
• Profiling

Duration

5 days (1 + 2 + 2)

Booking trainings

Trainings for Germany can be booked on-line here and trainings in Switzerland here.

Advanced trainings

• Galera Cluster for MySQL and MariaDB training
• MySQL and MariaDB developer training