Live Backups of MySQL Using Replication
Subject:   Replica requirements
Date:   2005-07-08 10:53:49
From:   ugob
Response to: Replica requirements

If your slave is dedicated, it doesn't have to be very powerful, as it only receives Updates + Inserts.
Main Topics Newest First

Showing messages 1 through 1 of 1.

  • Replica requirements
    2005-07-29 06:39:58  leeg [View]

    Thanks for this article; I now have a replica of my production DB :-) However, I was using OS X (I suppose you'd call my server DAMP rather than LAMP) and had to change a couple of things. There's no /etc/my.cnf by default, you have to copy one from somewhere (there's a sample file at /usr/share/mysql/my-medium.cnf). Even so, once you've edited the files as described in this article you still explicitly have to run the 'CHANGE MASTER TO' SQL statement before you can 'START SLAVE'.