MySQL High Availability

Versión para impresoraVersión para impresora

Código: D61920GC10
Total Horas: 18 horas (3 días)

Fechas previstas:
Curso  bajo demanda

Descripción del Curso

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.

Objetivo

  • 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

Contenido

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