> > > D61920GC10

MySQL High Availability (D61920GC10)

Kursbeschreibung Kurstermine


Should have attended the MySQL for DBAs course or have similar knowledge


  • Describe the implementation of MySQL replication
  • Setup a basic master-slave replication environment
  • Set up a master-master and circular replication system
  • Monitor a MySQL replication setup
  • Use MySQL replication for advanced tasks such as software upgrades to increase availability
  • Analyze the design and limitations of MySQL cluster
  • Setup a basic MySQL cluster instance
  • Analyze how it is possible to setup MySQL with a shared-disk cluster solution
  • Understand different shared-disk cluster setups depending upon operating system choices, such as LVM, Windows Cluster Agent, Veritas Cluster Agent, etc
  • Understand the differences with third-party clustering solutions, such as DRBD or m/cluster
  • Explore the impact of different backup solutions on highly available solutions
  • Identify the effects of different maintenance tasks and how to maintain high availability while performing these operations
  • Describe the future development path of the different solutions
  • Develop a plan to implement the appropriate high availability solution
  • Analyze the performance impact of a high availability decision
  • Recognize the business decision side of the solutions, such as cost and risk



  • MySQL Overview
  • MySQL Products and Services
  • Community Vs. Enterprise
  • Supported Operating Systems
  • MySQL Certification Program and Training Curriculum Paths
  • MySQL Website
  • Installing MySQL
  • Installing the world database

Introduction to MySQL High Availability

  • What is HA?
  • Terminology Overview
  • Third Party Software
  • Heartbeat

MySQL Replication

  • Basic Architecture
  • Binary Logging
  • Replication threads and files
  • Setting up MySQL Replication
  • Monitoring MySQL Replication
  • Advantages and Disadvantages of MySQL Replication
  • Advanced Replication Topologies
  • Replication Optimization

MySQL Cluster

  • Architecture
  • Setup of MySQL Cluster
  • Managing the Cluster
  • Cluster Asynchronous Replication
  • Cluster Pros and Cons

Shared Disk Clustering

  • Shared Disk Clustering
  • Active-Passive Setups
  • Active-Active Clustering
  • Usage Cases

Other Clustering

  • Product architecture of Continuent Uni/Cluster?
  • Distributed Replicated Block Device (DRBD)
  • DRDB and Heartbeat
  • Other DRBD Benefits
  • Additional Resources

System Maintenance Impacts

  • Introduction
  • Backups
  • Table Reorganization
  • Schema Alterations
  • Index Optimizations
  • Conclusions

HA Conclusions

  • Overview of Availability Tools
  • Combinations


  • Course Overview
  • MySQL System Overview
  • Training and Certification Website
  • Course Evaluation
  • Thank You!
  • QA Session
Classroom Training

Dauer 3 Tage

Preis (exkl. MwSt.)
  • Deutschland: 2.010,- €
Termine und Buchen
Online Training
Preis (exkl. MwSt.)
  • Deutschland: 1.965,- €
Termine und Buchen
Zum Buchen bitte auf den Ortsnamen klickenKurstermine
09.01. - 11.01.2017 Münster (iTLS)
20.02. - 22.02.2017 Stuttgart
10.04. - 12.04.2017 Frankfurt
22.05. - 24.05.2017 Berlin
22.05. - 24.05.2017 Hamburg