mysql主從伺服器

標籤：ror   host   using   ase   code   top   伺服器   his   cat   

#mysql主從伺服器

mysql-bin.003673 | 106

查看錯誤記錄檔
show variables like ‘%log_error%‘;

replicate-do-table=testmysql

change master to master_host=‘182.61.28.4‘,master_user=‘mysync‘,
master_password=‘123456‘,master_log_file=‘mysql-bin.003673‘,master_log_pos=511;
Slave I/O: Fatal error: The slave I/O thread stops because master and slave have equal MySQL server ids; these ids must be different for replication to work (or the --replicate-same-server-id option must be used on slave but this does not always make sense; please check the manual before using it). Error_code: 1593
180607 10:04:08 [Note] Slave I/O thread exiting, read up to log ‘mysql-bin.003673‘, position 511

mysql主從伺服器