TR

Scaling and High Availability Course for MySQL

Course Audience

MY203
2 DAYS

System administrators who manage a MySQL database service and aim to scale this service across multiple servers, enhance its backup capabilities, and ensure its continuous service in case of disasters.

Course Prerequsities

Informations that required by participants before course:

  • Participants who will join this course should also have joined MY201, MY202, MY101 courses before or mastered related subjects of these courses.

Course Goals

  • Learning scaling and high availability options applicable to MySQL service
  • Setting up a master-slave cluster in MySQL
  • Setting up a master-master cluster in MySQL
  • Being able to revert the database in MySQL to a desired state at a specific point in time

Course Subjects

  • Replication Concepts and High Availability Options
  • Clustering Solutions for MySQL
  • Master-Slave Clustering
  • Master-Master (Active-Active) Clustering
  • Load Balancing
  • Data Distribution (Sharding)
  • Point-in-Time Recovery