MySQL High Availability

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.

Students who can benefit from this course:

• Experienced database administrators and system architects

Audience
Course Topics Introduction

• 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

Conclusion

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

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