Oracle - Course Details

MySQLHA MySQL High Availability

Oracle Course Description:
This MySQL High Availability training is designed for experienced database administrators and system architects who want to analyze and form a basis of understanding different high availability options, including clustering and replication solutions within MySQL. You'll learn to use the tools required to decide which high availability solution is appropriate and how to implement a system with the correct design.
Oracle Course Duration:
3 DAYS
Oracle Course Target Audience:
NONE
Oracle Course Prerequisite:
Should have attended the MySQL for DBAs course or have similar knowledge
Course Content:
  • 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!