- Lab
-
Libraries: If you want this lab, consider one of these libraries.
- Core Tech
MySQL Disaster Recovery and Failover
In this lab, you will implement high availability and disaster recovery. You will implement instance-to-instance replication complete with manual failover, and verify that it works. You will configure a physical database backup, and restore your application data up to a specific point in time.
Lab Info
Table of Contents
-
Challenge
Configure replication for HA and execute a manual failover
In this objective, you will configure a two-node MySQL replication pair, validate replication, perform a manual failover, and resynchronize the old primary as a replica of the new primary.
-
Challenge
Backup and restore from a physical backup
In this objective, you'll take a hot physical backup of a MySQL instance, simulate catastrophic data loss, and restore the complete server and its data from the backup.
-
Challenge
Restore a logical backup and verify the recovery point
In this objective, you will restore a logical backup and use the MySQL binary log to recover post-backup transactions to a specific recovery point before data loss.
Real skill practice before real-world application
Hands-on Labs are real environments created by industry experts to help you learn. These environments help you gain knowledge and experience, practice without compromising your system, test without risk, destroy without fear, and let you learn from your mistakes. Hands-on Labs: practice your skills before delivering in the real world.
Learn by doing
Engage hands-on with the tools and technologies you’re learning. You pick the skill, we provide the credentials and environment.
Follow your guide
All labs have detailed instructions and objectives, guiding you through the learning process and ensuring you understand every step.
Turn time into mastery
On average, you retain 75% more of your learning if you take time to practice. Hands-on labs set you up for success to make those skills stick.