Scheda corso
NovaNext Training / Oracle / MySQL / MySQL High Availability

MySQL High Availability

3 Giorni
1.800,00 € (iva escl.)
Virtual Classroom
Corso in aula


Luogo Data Iscrizione
A Richiesta



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



This course is designed for experienced database administrators and system architects that want to analyze and form a basis of understanding different high availability options, including clustering and replication solutions within MySQL[tm]. This course will provide the tools required to make the decision of what high availability solution is appropriate and how to implement a system with the correct design.

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

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
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
Table Reorganization
Schema Alterations
Index Optimizations

HA Conclusions
Overview of Availability Tools

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