Mysql> Show Slave Status\g
1. Row ***************************
Slave_io_state:
master_host:10.172.167.30
Master_user:rsync
master_port:3306
Connect_retry:60
master_log_file:mysql-bin.000002
read_master_log_pos:53607519
relay_log_file:iz256m7ohdrz-relay-bin.000001
Relay_log_pos:4
relay_master_log_file:mysql-bin.000002
Slave_io_running:no
Slave_sql_running:yes
replicate_do_db:
replicate_ignore_db:
Replicate_do_table:
Replicate_ignore_table:
Replicate_wild_do_table:
Replicate_wild_ignore_table:
last_errno:0
Last_error:
skip_counter:0
exec_master_log_pos:53607519
relay_log_space:120
Until_condition:none
Until_log_file:
until_log_pos:0
Master_ssl_allowed:no
Master_ssl_ca_file:
Master_ssl_ca_path:
Master_ssl_cert:
Master_ssl_cipher:
Master_ssl_key:
Seconds_behind_master:null
Master_ssl_verify_server_cert:no
last_io_errno:1593
last_io_error: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 is used on slave, this does n OT always make sense; Please check the manual before using it).
last_sql_errno:0
Last_sql_error:
Replicate_ignore_server_ids:
Master_server_id:1
Master_uuid:
Master_info_file:/home/mysql/data/master.info
sql_delay:0
Sql_remaining_delay:null
Slave_sql_running_state:slave have read all relay log; Waiting for the slave I/O thread to update it
master_retry_count:86400
Master_bind:
last_io_error_timestamp:160428 21:24:27
Last_sql_error_timestamp:
MASTER_SSL_CRL:
Master_ssl_crlpath:
Retrieved_gtid_set:
Executed_gtid_set:
auto_position:0
1 row in Set (0.00 sec)
MySQL server Server-id Duplicate, modify the MY.CNF can.
This article is from "every show." "Blog, be sure to keep this provenance http://xiaofengmo.blog.51cto.com/10116365/1768783
MySQL master-Slave synchronization problems (1)