tucj7 <com> wrote:
Hehe. 1.5GB is not considered large :-)
Yes. And Yes.
Then start reading the manual:
some notes from me:
- I intentionally gave the link to 5.1 manual because tion
chapters have been restructured to be better understandable.
- I suggest to use the mysqldump --master-data method to get a
clean copy of your staging server (master) to your live server
- There is no need to have the slave process running all time.
If you want to stay with daily synchronization, just start the
slave once a day (START SLAVE) and when it has ted all
changes (seen in Seconds_Behind_Master from SHOW SLAVE STATUS)
then just stop it (STOP SLAVE)
- You should set a sensible max. binlog size on your master and/or
rotate the binlog (e.g. with FLUSH LOGS). There are more options
re. tion and binary log:
- If you stay with daily synchronization, you should setup a routine
1. FLUSH LOGS on master to start a new binlog
2. START SLAVE, wait until the slave reached the new binlog
3. STOP SLAVE
4. PURGE MASTER LOGS TO '<insert current binlog>'
This is no problem and will work out of the box.
Axel Schwenke, Support Engineer, MySQL AB
Online User Manual: http://dev.mysql.com/doc/refman/5.0/en/
MySQL User Forums: http://forums.mysql.com/