Is there a way to keep replication settings current after restarting the master server, without having to change master on the slave. I notice that everytime the master restarts, you must change master bin log to the new name (eg. mysql-bin.000006 will becoem mysql-bin.000007). Is there a way to automate this without having to reconfigure the bin log settings on the slave?
Run Code: STOP SLAVE; on the MySQL shell on the slave before you take down the master. What's in the my.cnf on the master?
Code: [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock user=mysql # Default to using old password format for compatibility with mysql 3.x # clients (those using the mysqlclient10 compatibility package). old_passwords=1 log-bin = /var/log/mysql/mysql-bin.log binlog-do-db=CRISData binlog-do-db=cellular_bruce server-id=1 [mysqld_safe] log-error=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid Will running stop slave make slave increment the bin log suffix?
I'd also add Code: expire_logs_days = 10 max_binlog_size = 500M to the [mysqld] section so that the slave can catch ip again if any of the servers is down for a longer time.