I have 2 MySql nodes with Master-Master Replication set-up.
MySql1 has read and write access and is in current state.
MySql2 has only read access and stopped working due to space issue.
How can I fix this issue and resync it.
MySQL Master-Master Replication – Out of Sync Issues
master-master-replicationMySQLmysqldump
Best Answer
Given the 'Could not find first log file name' error means Mysql1 has rotated away its binary logs.
You will need to reinitialize Mysql2 as if it where a new replica.
RESET SLAVE ALL
on Mysql1 to ensure it forgets about its MySQL2 before beginning.