> > D61920GC10

MySQL High Availability (D61920GC10)

Course Description Schedule Course Outline
 

Prerequisites

Required Prerequisites

  • Should have attended the MySQL for DBAs course or have similar knowledge

Course Objectives

  • 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, 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 Content

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

Classroom Training
Modality: C

Duration 3 days

Price (VAT excl.)
  • Belgium: 2,010.- €
  • The Netherlands: 2,010.- €
Dates and Booking
 
Schedule

Currently there are no training dates scheduled for this course.  Enquire a date