Tel: UK 0845 757 3888 | Ireland: 01 284 6796
MySQL High Availability
Course type Essentials (What does this mean?)
| Course title | MySQL High Availability |
|---|---|
| Delivery method |  Classroom |
| RRP | £1533 exc. VAT |
| Days/Duration | 3 |
| Code | SQL4301 |
Secure online payment
- view dates / book course
- course description
- blogs
Course dates
| Location | May | Jun | Jul | Aug | view later dates |
|---|---|---|---|---|---|
| Location | Sep | Oct | Nov | Dec | view earlier dates |
London
Tabernacle Street, EC2 |- |- |- |- 
Location Sep Oct Nov Dec view earlier dates Tabernacle Street, EC2 |- |17 |- |- Tabernacle Street, EC2 location information and directions
17 Oct 5 or more places available £1,533 exc VAT 16 Jan 5 or more places available £1,533 exc VAT MySQL High Availability training in Tabernacle Street, EC2
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
Related blogs
Did you have a satisfactory course?
Posted by Phil Stirpe on 25 May 2012
I have written and delivered training courses for many years and in all that time there has always been some form of evaluation at the end of the course. Although there are several questions on the current QA evaluation form, the most important is Overall Satisfaction.
vSphere 5 CLI reference poster
Posted by Bryan O'Connor on 24 May 2012
The vCAP-DCA 5 is coming, and having a look at the blue print, there will be command line and as such the reference poster will be a good resource for revision
Connection Options for the vMA (VMware Management Assistant)
Posted by Bryan O'Connor on 23 May 2012
This article covers the various conn-options for the vMA
Let’s have a Fling
Posted by Bryan O'Connor on 22 May 2012
Not the type you thought, but an offering from VMware
Windows 7 Native Boot Adding the VHD to Bare Metal
Posted by Andrew Mallett on 21 May 2012
I have written before on the native boot feature of Windows 7 where it can boot to a VHD, Virtual Hard Drive. In this blog though we look at adding in a VHD to a completely clean disk with no OS ....
