MySQL Dual master hot standby problem processing

1. Slave_io_running:no

Mysql>Show slave status\G*************************** 1.Row***************************Slave_io_state:master_host:172.16. 1.Master_user:cahms Master_port:3306Connect_retry: -Master_log_file:mysql-bin. 000003Read_master_log_pos:20398Relay_log_file:mysqld-relay-bin. 000001Relay_log_pos:4Relay_master_log_file:mysql-bin. 000003Slave_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:0Last_error:skip_counter:0Exec_master_log_pos:20398Relay_log_space:106Until_condition:NoneUntil_log_file:until_log_pos:0Master_ssl_allowed:no Master_SSL_CA_File:Master_SSL_CA_Path:Master_SSL_Cert: Master_SSL_Cipher:Master_SSL_Key:Seconds_Behind_Master:NULLMaster_ssl_verify_server_cert:no Last_io_errno:1593Last_io_error:fatal error:the slave I/OThreadStops because master andSlave has equal MySQL server IDs; These IDs must is different for replication toWork (orThe--Replicate-same-server-idoption must be used onSlave but this does notAlways make sense; Please check the manual before using it).Last_sql_errno:0Last_sql_error:1Rowinch Set(0.00Sec

(1) master and slave have equal MySQL server IDs
"Solution"
Modify the value of Server-id under/ETC/MY.CNF to make sure that the Server-id of master and slave are different;

(2) Error reading packet from server:

Access denied; You need the REPLICATION SLAVE privilege for this operation (server_errno=1227)

"Workaround" The primary server gave insufficient replication permissions to re-grant permissions.

onto‘uname‘@‘对端ip‘by‘password‘；> flush privileges；

== e.g ==

onto‘root‘@‘172.16.1.21‘by‘amtium‘;

Grant replication Slave on . to ' root ' @ ' 172.16.1.23 ' identified by ' amtium ';

**2Slave_IO_State:**

Waiting toReconnect After aFailed Master EventReadMysql> Show Slave status\g***************************1.Row *************************** slave_io_state:waiting toReconnect After aFailed Master EventReadMaster_host:172.16. 1. 231Master_user:cahms Master_port:3306Connect_retry: -Master_log_file:mysql-bin. 000003Read_master_log_pos:106Relay_log_file:mysqld-relay-bin. 000001Relay_log_pos:4Relay_master_log_file:mysql-bin. 000003Slave_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:0Last_error:skip_counter:0Exec_master_log_pos:106Relay_log_space:106Until_condition:none Until_log_file:until_log_pos:0Master_ssl_allowed:no Master_SSL_CA_File:Master_SSL_CA_Path:Master_SSL_Cert: Master_SSL_Cipher:Master_SSL_Key:Seconds_Behind_Master:NULLMaster_ssl_verify_server_cert:no Last_io_errno:0Last_io_error:last_sql_errno:0Last_sql_error:1Rowinch Set(0.00 sec)

"Solution"

onto   ‘root‘@‘172.16.1.228‘by‘amtium‘onto  ‘root‘@‘172.16.1.231‘by‘amtium‘;> flush privileges;

MySQL Dual master hot standby problem processing