Article:  |
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. | ||
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'.
