MySQL High Availability

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.

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