MySQL High Availability

Level

MySQL High Availability

Aikona
Logo Aikona

Need more information? Get more details on the site of the provider.

Starting dates and places

This product does not have fixed starting dates and/or places.

Description

Special Notices

Please note that Oracle courses running at London training centres are subject to a 10% surcharge.

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.

Prerequisites

  • Should have attended the MySQL for DBAs course or have similar knowledge
  • MySQL for Database Administrators (SQL4502)

Delegates will learn how…

Read the complete description

Frequently asked questions

There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.

Didn't find what you were looking for? See also: .

Special Notices

Please note that Oracle courses running at London training centres are subject to a 10% surcharge.

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.

Prerequisites

  • Should have attended the MySQL for DBAs course or have similar knowledge
  • MySQL for Database Administrators (SQL4502)

Delegates will learn how to

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

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
There are no reviews yet.

    Share your review

    Do you have experience with this course? Submit your review and help other people make the right choice. As a thank you for your effort we will donate £1.- to Stichting Edukans.

    There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.