We are happy to advise you!
+49 40 253346-10     Contact
> > > D61920

Hochverfügbarkeit von MySQL (D61920)



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

Course Objectives

  • 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

Course Content


  • 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

Duration 3 days

Price (excl. tax)
  • Germany: 2,010.- €
  • Switzerland: CHF 2,484.-
incl. catering
Catering includes:

  • Coffee, Tea, Juice, Water, Soft drinks
  • Pastry and Sweets
  • Fresh fruits
  • Lunch in a nearby restaurant

* Catering information only valid for courses delivered by Fast Lane.

Digital courseware

Courseware language: English

Online Training

Duration 3 days

Digital courseware

Courseware language: English


Currently there are no training dates scheduled for this course.  Enquire a date