MySQL master-Slave synchronization problems (1)

Source: Internet
Author: User

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)

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.