Summary

Replication is a useful feature that allows you to keep an exact copy of data from one server on another server. The master database writes to the binary log, and any number of slave servers connect to the master, read the binary update log, and replicate these statements on their servers.

Replication is useful as a form of backup and also to improve performance.

The relationship between the binary log on the master and the master.info file on the slave is the key to keeping replication in sync. If the master binary logs are removed before the slaves have used them, replication will fail.