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.
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