Recall & Review
beginner
What is replication in database systems?
Replication is the process of copying and maintaining database objects, like data, across multiple servers to improve availability and reliability.
Click to reveal answer
beginner
What is the main goal of replication strategies?
The main goal is to ensure data consistency, availability, and fault tolerance by managing how data is copied and synchronized across multiple database nodes.
Click to reveal answer
intermediate
Explain master-slave replication.
In master-slave replication, one server (master) handles all writes and updates, while one or more servers (slaves) copy data from the master and handle read requests. This improves read performance and data backup.
Click to reveal answer
intermediate
What is multi-master replication?
Multi-master replication allows multiple servers to accept write operations and synchronize changes with each other. This increases availability but requires conflict resolution to keep data consistent.
Click to reveal answer
intermediate
Describe synchronous vs asynchronous replication.
Synchronous replication waits for data to be copied to all replicas before confirming a write, ensuring strong consistency but slower performance. Asynchronous replication confirms writes immediately and copies data later, improving speed but risking temporary inconsistency.
Click to reveal answer
Which replication strategy allows multiple servers to accept writes simultaneously?
✗ Incorrect
Multi-master replication allows multiple servers to accept writes and synchronize changes.
In which replication type does the master server handle all write operations?
✗ Incorrect
In master-slave replication, the master handles all writes.
What is a key advantage of asynchronous replication?
✗ Incorrect
Asynchronous replication improves write speed by not waiting for all replicas to confirm.
Which replication strategy is best for improving read performance by distributing read requests?
✗ Incorrect
Master-slave replication distributes reads to slaves, improving read performance.
What is a challenge of multi-master replication?
✗ Incorrect
Multi-master replication requires conflict resolution to handle simultaneous writes.
Explain the differences between master-slave and multi-master replication strategies.
Think about how many servers can accept writes and how data conflicts are handled.
You got /4 concepts.
Describe the trade-offs between synchronous and asynchronous replication.
Consider speed versus data consistency.
You got /4 concepts.