What happens when mysql binlog reaches mysql-bin.999999

684 views Asked by At

Lets say my mysql replication is enabled for long time, and the server has been quite busy, so new bin log files get created every few seconds. So in a few months, it is possible for latest bin log file to have name "mysql-bin.999999". Does the next file again become "mysql-bin.000001"?

The question is important from check pointing view, since I'm using the replication to stream changes of the DB. If the name starts back from 000001, then I cannot assume that file names would be always incrementing, so if older record are received, then it cannot be ignored just because file name is numerically smaller.

0

There are 0 answers