You are here:Courses|Oracle|MySQL|MySQL High Availability

MySQL High Availability

The ideal audience for this course are experienced system architects and database administrators. The training offers understanding of various high availability features. Students obtain knowledge of replication solutions, as well as clustering options. The program makes participants proficient in taking decisions regarding high availability solutions. You also learn how to choose correct design for effective system implementation.

The MySQL High Availability certification makes students capable to:

  • Describe MySQL replication implementation
  • Set up an environment based on master-slave replication
  • Set up a circular replication and master-master system
  • Monitor MySQL replication systems
  • Use MySQL replication for high-level activities like software upgrade to improve availability

In addition, students start analyzing the limitations and design of MySQL cluster. They become capable of installing MySQL cluster instance, as well as analyzing the method of MySQL setup with shared-disk cluster solutions. Participants are additionally able to develop the implementation path for deploying high availability solutions. Other than this, students:

  • Understand the setup of shared-disk clusters. This depends on various OS choices like Veritas Cluster Agent, Windows Cluster Agent, LVM etc
  • Gain know-how about variances between third-party clustering solutions
  • Analyze the effect of various backup solutions
  • Recognize the impact of several maintenance activities. They also understand the way of maintaining high availability whilst running such operations.
  • Learn how to take decisions pertaining to high availability, and then evaluate the performance impact
  • Identify business related aspects like cost and risk

 

Course Regular Track
(days)
MySQL High Availability 3
Balance Days  for day of arrival and practice 1
Total duration 4

Prerequisites:

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

 

 

Our Location

Get In Touch

1st Floor of CHABAH House,

Chabah Bus Stop on the Odokor-Mallam HighWay

Opposite Total Filling Station

P. O. Box DS 2022

Accra, Ghana

Phone: +233 303 393 1256 / +233 302 325 815

Cell: +233 244036 522

Email: [email protected]