Ponuka kurzov

Zasielanie noviniek




Autorizované školenia

  • Microsoft Partner Gold Learning
  • ORACLE Gold Partne
  • HP Eperto One
  • IBM Authorized Training
  • Apple Authorized Training Center
Potrebujete pomoc?
FAQ Kontakty Kontaktný formulár
Kontaktný formulár


Kontakty
Kód kurzu: D61920GC10« Krok zpět

MySQL High Availability Ed 1 (SQL-4301)

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.

Podrobnejšie informácie o kurze
Neboli nájdené žiadne termíny, kontaktujte náš klientsky servis.
V prípade záujmu o iný termín uvedeného kurzu, kontaktujte klientsky servis, prosím.

PobočkaDníKatalógová cenaCena príručkyITB*
Praha3 33 000 CZK v cene kurzu 45
Brno3 33 000 CZK v cene kurzu 45
Bratislava3 1 200,00 EUR v cene kurzu 45

*Body se vztahují pouze na kurzy realizované v prostorách Gopasu.

Predošlé kurzy

Požadované predpokladané znalosti

Ciele kurzu

  • 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

Témy kurzu

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!

Predošlé kurzy

Nasledujúce kurzy

žiadny nadväzujúci kurz
Oracle University eKit

Cena:
cena kurzu zahŕňa
Uvedené ceny sú bez DPH.