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 ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access