Do you need to ensure that the MySQL database will experience a minimal loss of availability over time?
Do you want to increase the availability for MySQL?
Do you need to be able to present a MySQL high availability business case to the managerial positions which will make the final decision?
Then you will find MySQL High Availability is the course for you! 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.
Skills Gained
At the completion of this course, you should be able to:
Describe the implementation of MySQL replication
Setup a basic master-slave replication environment
Understand when a master-master or circular replication environment is possible
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
Discuss how to integrate MySQL cluster and replication
Analyze how it is possible to setup MySQL with a shared-disk cluster solution
Know when you can do active-active and active-passive shared-disk setups
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
Minimize downtime due to these maintenance tasks
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
Who Can Benefit
Experienced database administrators and system architects
Prerequisites
Students who wish to attend this course, should have attended the MySQL 5.0 for DBAs course or have similar knowledge.
Format
Instructor led, with extensive hands-on lab exercises
Each student will be provided with their own computer
Applies to MySQL Version:
Instructor led, with extensive hands-on lab exercises
Each student will be provided with their own computer
Code:
MySQL5-HA
Length:
3 days
Type:
Instructor-Led
Certified By:
MySQL
Tuition:
$1,499
This course is taught by Certified MySQL instructors. There is a difference. Learn More
This course is in the following categories. Click the categories to find similar courses and topics of interest.
There are currently no scheduled dates for this course. If you are interested in this course, request a course date with the links below. We can also contact you when the course is scheduled in your area.
Course Topics
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.
At the completion of this course, you should be able to:
When you take a certified course with ExitCertified, you are learning from
the creators of the products you use. Our commitment to your IT
community, along with our authorization to deliver certified courses,
ensures you receive a premium training experience.
