I have a Percona MySQL 5.5.30 as a master(Debian 6.0.7). I got a weird issue that all my binary logs started saving in format OFF.00* instead of the specified format in .cnf file.
mysql> show binary logs; +------------+------------+ | Log_name | File_size | +------------+------------+ | OFF.000084 | 1073744171 | | OFF.000085 | 1073741909 | | OFF.000086 | 1073742904 | | OFF.000087 | 1073745627 | | OFF.000088 | 1073742910 | | OFF.000089 | 1073742081 | | OFF.000090 | 1075694984 | mysql> show variables like "%log_bin%"; +---------------------------------+-------+ | Variable_name | Value | +---------------------------------+-------+ | log_bin | ON | | log_bin_trust_function_creators | OFF | | sql_log_bin | ON | +---------------------------------+-------+ bash-4.1# grep log-bin /etc/mysql/conf.d/mycustom.cnf log-bin = /var/log/mysql/acct-db1-bin.log
Haven't restarted or done anything on MySQL service, but wondering how the format of binary logs got changed.
I have a setup a new slave to this master, and don't have any issue with the replication. But I am thinking whether it will cause any issue in future.