MySQL has a useful feature called replication, which is where one or more databases from a server (called the master) are automatically mirrored onto one or more other servers (called slaves). Replication is useful as a backup strategy and a performance-tuning technique. This chapter explains how replication works and shows you how to set up and configure it.
Featured in this chapter:
Setting up replication
Configuring slave and master files
Understanding slave and master SQL statements