MySQL High Availibility

Logo TailorIT RGB

MySQL High Availibility

 1.965,00

MySQL High Availibility

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

Doel

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

Doelgroep

Experienced database administrators and system architects

Voorkennis

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

Vorm

Klassikaal en Maatwerk

Inhoud

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

Vervolgopleidingen

Bijzonderheden

Geen

3 dagen

€ 1.965

Cursusdata

Data op aanvraag

Andere data?

Locaties

Breda, Tilburg, Amsterdam, Rotterdam, Utrecht, Eindhoven, Antwerpen, Zwolle

Andere locatie?

Meer weten over een training of advies? Bel met onze opleidingsadviseurs 085 02 01 070 of gebruik het contactformulier.