MySQL High Availability (SQL-4301) Training Course

MySQL High Availability (SQL-4301) course 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.

Who is MySQL High Availability (SQL-4301) training for?

• Experienced database administrators and system architects

Prerequisites for MySQL High Availability (SQL-4301) course

• Should have attended the MySQL for DBAs course or have similar knowledge
• MySQL for Database Administrators (SQL-4502)

What will I get?

• 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