MySQL High Availability Training

MySQL High Availability Training (MySQL5-HA)


MySQL High Availability Training Course Description

This MySQL High Availability training course 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. In this MySQL High Availability Training, 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.

Customize It:

With onsite Training, courses can be scheduled on a date that is convenient for you, and because they can be scheduled at your location, you don’t incur travel costs and students won’t be away from home. Onsite classes can also be tailored to meet your needs. You might shorten a 5-day class into a 3-day class, or combine portions of several related courses into a single course, or have the instructor vary the emphasis of topics depending on your staff’s and site’s requirements.

Audience/Target Group

Database Administrators
Web Administrator

MySQL High Availability Training (MySQL5-HA)Related Courses:

Duration: 3 days

Class Prerequisites:

Should have attended the MySQL for DBAs course or have similar knowledge

Skills Gained:

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

Course Content:


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

Request More Information

Time Frame: 0-3 Months4-12 Months

No Comments Yet.

Leave a comment