MySQL
For this project, take a look at the following concepts
Replication is the process of creating and maintaining copies of a database, typically across multiple servers, for the purpose of load balancing, redundancy, and disaster recovery. MySQL replication involves the use of a master-slave architecture, where one server acts as the master and the other servers act as slaves. The master server receives and processes all write requests and then replicates these changes to the slave servers in real-time. This allows for read scaling and high availability, as well as the ability to distribute load across multiple servers
Read or Watch:
- What is a primary-replica cluster
- MySQL primary replica setup
- Build a Robust Database backup strategy
- mysqldump
At the end of this project, you are expected to be able to explain to anyone, Without the help fo Google:
- What is the main role of a database
- What is a database replica
- What is the purpose of a database replica
- Why database backups need to be stored in different physical locations
- What operation should you regularly perform to make sure that your database backup strategy actually works