Hi, I have a question regarding mysql master-slave replication's Relay_Master_Log_File. I hope someone can answer me.
I have mysql setup to purge old logs that arent being used by master, and also the max log size is set as 500MB. I see that new logs are created with next number in order. What could happen when this numbering reaches the limit, say, mysql-bin.999999. Will it break replication in anyway or will it just get reset, and the slave starts to pick up replication from the new log(which I presume to be mysql-bin.000001) Thank you.