Geek Answers Handbook

Mysql Replication - Master-bin log files not updated

I am new to Mysql Replication,

My problem: when I give the SHOW SLAVE STATUS command in Slave, the Master-bin-log files are not updated, I reset and update the Master-bin-log file with the CHANGE MASTER TO MASTER command, still the master-bin-log files are not updated when I am checking the SHOW SLAVE STATUS command.

Addition to this, on the corresponding path, Master-bin-log log files are generated, but not updated.

Please help me out of this problem ...

Thanks in advance!!!!

Iddhi

+4
source share
1 answer

From what you are saying, I assume that you want binary logging on the slave.

I think the problem is related to something that has bitten me many times.

Add this to /etc/my.cnf in the slave:

[mysqld] log-slave-updates

Without this, data is updated from the relay logs, but the transaction is not written to the slave binary logs.

Adding this is crucial, especially if you plan on using a subordinate as a master someday.

+5
source

More articles:


All Articles