Summary
In this chapter, we learnt how to synchronize both the structure and data from one database to another, on the same server or on different servers. We covered the goals of synchronization and how to perform a complete or selective synchronization. We then examined how to use phpMyAdmin to guide us into replication setup, including a master and a slave server; how to prepare a test environment using the MySQL Sandbox, and how to control the slave servers.
The next chapter will show you how to keep permanent bookmarks of your queries.
