Hi I have had replication working for the past couple of years and have, at fairly regular intervals, restarted the whole replication process by distributing new snapshots to slaves, and reseting master and slaves.
Last sunday I started replication from scratch. This time, however, I noticed that the binary log on the master was not rotating correctly. As I understand it the binary log file should "rotate" when "mysqladmin flush-logs" is called from within the 'logrotate' script which is called from cron.daily. However, 'mysql-bin.log' does not rotate to 'mysql-bin.log.1' and it appears as if logging merely overwrites the existing file when "mysqladmin flush-logs" is called. In addition, the 'mysql-bin.index' contains: /var/log/mysql/mysql-bin.log /var/log/mysql/mysql-bin.log /var/log/mysql/mysql-bin.log /var/log/mysql/mysql-bin.log Needless to say this has messed up replication somewhat. Does anyone have any idea how this could have happened and what I can do to ensure it does not occur again (when I restart replication from new a snapshot and "reset master"). The procedure I follow to get replication is this: 1) shutdown database driven services 2) shutdown master database 3) cp -a /path/to/mysql /var/backups/ 4) restart master database 5) reset master 6) restart database driven services 7) distribute snapshot to slaves 8) start slave databases 9) reset slave After following the above procedure replication occurred nicely until I noticed that the master binary logs were not rotating and that replication seemed to stop (but, without errors reported -- no clashes). I have ample disk space on the master. Log directory permissions are correct. Version info is in the subject line. Any help would be greatly appreciated. Cheers, Ryan -- Ryan Tracey | +27 21 937 8909 Thawte Certification | https://www.thawte.com Work consists of whatever a body is obliged to do. Play consists of whatever a body is not obliged to do. -- Mark Twain -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
