Re: relay-bin files not being cleaned up
I have encountered non-deleted relay logs a few times. But it has always been "my fault".
The way I was cloning slaves led to old relay logs from the source machine. They had no useful info, and could easily be deleted. I think there was another case, but again, "my fault".
The relay logs necessarily go away on their own. So, if valid logs are sticking around, let's check some things:
* Are the server_id values (SHOW VARIABLES LIKE 'server_id';) distinct across all connected Master(s) and Slave(s)? That is a requirement.
* SHOW SLAVE STATUS; -- is replication caught up? Check Seconds_behind_master, plus the various file names, plus the two Yes/No fields. If replication stopped, or is behind, the relay logs are necessary. In this case, the 'real' solution is to discover why it stopped or is lagging.
Subject
Views
Written By
Posted
7319
July 24, 2014 12:30PM
Re: relay-bin files not being cleaned up
3150
July 25, 2014 08:55AM
2624
August 13, 2014 03:54PM
2292
August 15, 2014 03:11PM
2098
August 25, 2014 03:00PM
1970
August 26, 2014 02:28PM
2003
August 27, 2014 03:03PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.