MySQL High Availability Certification

Course Outline

MySQL High Availability (SQL-4301) course overview

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.

Who is MySQL High Availability (SQL-4301) training for?

Experienced database administrators and system architects

Prerequisites for MySQL High Availability (SQL-4301) course

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

MySQL for Database Administrators (SQL-4502)

What will I get?

Delegates will learn:

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

MySQL High Availability (SQL-4301) Course Contents

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

View Complete Course outline

10:00	11:30	11:45	13:00	14:00	15:30	15:45
Classroom Activity This course explains how to create web pages from scratch using different techniques, such as	Tea Break	Classroom Activity This course explains how to create web pages from scratch using different techniques, such as	Lunch Break	Classroom Activity This course explains how to create web pages from scratch using different techniques, such as	Tea Break	Classroom Activity This course explains how to create web pages from scratch using different techniques, such as