Recovery and high availability (MDB)

This subject introduces participants to advanced techniques for recovering data and ensuring the high availability of database systems. The course begins with the basics of point-in-time recovery. Students will learn how to set up and use binary log files to restore a database to a point in time. Best practices for performing a point-in-time recovery are also covered to ensure that data integrity is maintained and downtime is minimized.

Another key component of the subject is high availability. Participants are introduced to the concepts of high availability and learn about different replication methods, including master-slave and master-master replication. These methods make it possible to configure databases so that they remain available even in the event of outages or maintenance work.

It also provides an introduction to Galera Cluster, a technology that enables synchronous multi-master replication. Participants will learn how to implement load balancing and failover strategies to distribute the load across multiple servers and maximize the availability of database services.