Replication basics in MySQL - Cheat Sheet & Quick Revision

Recall & Review

beginner

What is database replication?

Database replication is the process of copying and maintaining database objects, like tables and data, from one database server (master) to another (slave) to keep them synchronized.

beginner

What roles do the master and slave servers play in MySQL replication?

The master server records all changes to its data and sends them to the slave server. The slave server receives these changes and applies them to its own data to stay up-to-date.

intermediate

What is the binary log (binlog) in MySQL replication?

The binary log is a file on the master server that records all changes made to the database. It is used to send these changes to the slave server for replication.

beginner

Why is replication useful in real life?

Replication helps keep copies of data in different places for backup, faster reading by spreading load, and high availability if one server fails.

advanced

What is the difference between asynchronous and semi-synchronous replication?

In asynchronous replication, the master does not wait for the slave to confirm it received changes. In semi-synchronous replication, the master waits for at least one slave to confirm before continuing, improving data safety.

In MySQL replication, which server sends the data changes to the other?

A Master server

B Slave server

C Both servers simultaneously

D Neither server

The master server records changes and sends them to the slave server.

What does the binary log (binlog) store in MySQL replication?

A User passwords

B All database changes

C Backup files

D Server configuration

The binary log stores all changes made to the database on the master.

Which of these is NOT a benefit of replication?

A High availability

B Load balancing for reads

C Data backup

D Faster writes on master

Replication does not speed up writes on the master server.

In asynchronous replication, when does the master consider a transaction complete?

A Immediately after writing to binlog

B After slave confirms receipt

C After slave applies changes

D After backup completes

The master does not wait for the slave in asynchronous replication.

What is the main role of the slave server in replication?

A To send data changes to master

B To backup the master server

C To receive and apply changes from master

D To manage user access

The slave receives and applies changes sent by the master.

Explain how MySQL replication works between master and slave servers.

Think about the flow of data changes from one server to another.

List three practical reasons why database replication is important.

Consider what problems replication helps solve in real life.