Advanced MySQL training content

Requirements

The participants should be familiar with the Linux console and rule the most important UNIX commands.

Further the participants should be used to MySQL already and they should be familiar with SQL commands.

If you are not sure we would be glad to advise you by e-Mail or phone.

Content

MySQL Operations

Backup, Restore, Recovery

• Differences between logical and physical backups
• Key figures of Backup/Restore and derived Backup strategies
• Export and import of data
• Logical backup with mysqldump
• Restore and Point-in-Time-Recovery (PiTR)
• Physical backup wit Xtrabackup and LVM

MySQL High Availability (HA)

Master/Slave and Master/Master Replication

• Set-up of a Master/Slave replication
• Row Based Replication (RBR)
• Semi-synchronous replication
• Virtual IP
• Read/Write distribution

Overview active/passive fail-over Cluster with DRBD

• The concept of an active/passive Clusters
• DRBD - Poor man's SAN
• Cluster glue (Pacemaker or Heartbeat)
• How do I attach the Slaves?

Synchronous multi-Master Replication with Galera Cluster for MySQL

• Active/active Clustering
• Possible Load Balancer
• Scaling read- and write access with Galera Cluster

Overview MySQL Cluster (NDB)

• Active/active Clustering
• Scaling rean- and write access with MySQL Cluster
• MySQL Cluster Replication

MySQL Performance Tuning

General information about Performance

• Performance, what does it mean?
• Critical ressources
• Measure
• Influence on performance

System configuration

• Hardware
• Operating System (Linux)
• MySQL configuration (my.cnf)

Application

• Schema Tuning
• Indexing
• SQL Query Tuning
• Tools: Slow Query Log, MySQL Profile, General Query Log, etc.
• Parallelizing

Architecture

• Scaling, sharding and how can the application can contribute to it.