Jump Start MySQL

Chapter 7Backups and Replication

As our lives become more and more datacentric, the importance of having backups cannot be overstated. The effects of data loss can range from mildly irritating, such as losing your contacts list, to having a serious economic impact, such as a bank losing financial records. The more important your data is, and the more difficult it is to recreate, the more important it is to have backups.

I feel it’s important to share with you a few ways to back up your MySQL databases before we say our goodbyes, so in this chapter we’ll discuss making physical and logical backups. I’ll also walk you through the steps to set up basic replication. Replication requires at least two MySQL installations—one to be the master and another ...