I database newbie, recently due to the need to study business mysql master-slave configuration, met a lot of posts that easily but I can't solve the problem, I use two virtual machine virtualBox configuration (the system for centos6.5), is exactly the same version of the installation of mysql (version for 5.5.23), using a master from the configuration of the basic configuration is not clear, need to baidu, configuration is complete, prompt the following error:
Last_IO_Errno: 1593
Last_IO_Error: Fatal error: The slave I/O thread stops because The master and slave have equal MySQL server ids. These ids must be the company for the replication to work (or the - replicate - same - server - id option must be 2 on slave but this does not always make sense; Both please check the manual before using it).
Meaning is very simple, host and from machine server_id repeat, but I am the host and from machine server_id respectively:

Can see from the picture, is obviously different, often explain to my online. The CNF master-slave configuration is the same, I do not apply here, the problem about me more than a week, beg ace under great god help solve

CodePudding user response:

Datadir under the data directory has an auto. The CNF file, delete it, then try to restart the mysql

CodePudding user response:

Have met once, also is the id is not the same, but the tip is the same, the method of processing is performed on the slave
Reset slave all
And then restart the master + slave, it is good to reconfigure the

CodePudding user response:

My mysql data directory and Linux under the whole system have searched no auto CNF

CodePudding user response:

# @ ZJCXC - personal WeChat public I met another virtual machine temporarily with the same problem,