When my colleague called the master node yesterday, the slave database reported the following error:
Got fatal error 1236 from master when reading data from binary log: 'misconfigured master-server id was not set'
Slave database collection: root @ localhost Fri May 23 14:18:59 2014 14:18:59 [(none)]> show variables like '% server_id % '; + --------------- + ------- + | Variable_name | Value | + --------------- + ------- + | server_id | 2 | + --------------- + ------- + master database collection: mysql> show variables like '% server % '; + servers + ----------------- + | Variable_name | Value | + servers + ------------------- + | character_set_server | latin1 | collation_server | latin1_swedish_ci | server_id | 1 | + servers +
Because the business is used to store hadoop metadata, MySQL version was earlier, and my colleagues used slave higher than the master version, this was the reason, but on the MySQL bug list, we found:
This discovery denies our previous judgment. After testing by a colleague, it is indeed the bug :-)