|
Learn Oracle from Oracle - Original Oracle University Seminar
Nur Oracle University Schulungen bieten die notwendige Voraussetzung zur Teilnahme an den Prüfungen zum:
OCA (Oracle Certified Assosiate)
OCP (Oracle Certified Professional)
OCM (Oracle Certified Master)
Seminarinhalt
Teilnehmerkreis
Vorkenntnisse
Sachgebiete
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.
Students who can benefit from this course:
- Experienced database administrators and system architects
nach oben
- Administratoren
- Technischer Berater
- Projektmanager
nach oben
Erforderliche Vorkenntnisse:
nach oben
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
Dauer
Dauer: 3 Tage
nach oben
|
