Statement based replication

Problems

Write Ahead Log (WAL)

Issues

Logical or row-based replication

Trigger-based replication

In case of master-slave replication the master is responsible for shipping changes received via write requests from clients to its followers. These changes are initially recorded on the master’s end in a log file. We’ll examine the various ways log files are implemented.