Sams Teach Yourself MySQL in 21 Days, Second Edition

Summary

Today's lesson looked at replication: what it is and how you can implement it.

You learned some of the strengths of a database that runs in a replicated configuration but also looked at the limitations and costs of replicating databases.

You went through the process of setting up a replicating master-slave pair using two MySQL servers, configuring the master to write to its binary update log and the slave to read updates from this log.

There are several SQL commands for monitoring the status of replication on a server and for modifying the setup. You also encountered the mysqlbinlog utility for displaying binary logs.

Finally you saw a brief overview of some of the replication topologies that are possible. Although the architectures described ...