MySQL Dual master hot standby problem processing

1. Slave_io_running:no

Mysql>Show slave status\G*************************** 1.Row***************************Slave_io_state:master_host:192.16. Ten.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
"Method of resolution"
Change the value of the Server-id under/ETC/MY.CNF. Make sure the master and slave server-id are different;

(2) Error reading packet from server:

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

"Resolved method" the primary server gave insufficient replication permissions. Give permission once again.

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

== e.g ==

onto‘root‘@‘192.16.10.21‘     by‘root‘onto‘root‘@‘192.16.10.23‘   by‘root‘;

2. Slave_io_state:

Waiting toReconnect After aFailed Master EventReadMysql> Show Slave status\g***************************1.Row *************************** slave_io_state:waiting toReconnect After aFailed Master EventReadMaster_host:192.16. Ten. 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)

"Method of resolution"

onto‘root‘@‘192.16.10.228‘  by‘root‘onto‘root‘@‘192.16.10.231‘     by‘root‘;> flush privileges;

3.Another MySQL Daemon already running with the same UNIX socket.

Cause multiple MySQL processes use the same socket. Two ways to solve:

The first one is to shut down immediately. Use the command shutdown-h now shutdown, after shutdown on startup. The process is stopped.

The second is to rename the Mysql.sock file directly. can also delete, recommend renaming.

Then you can start MySQL.

The following is the original foreign

To prevent the problem from occurring, you must perform a graceful
Shutdown of the server from the command line rather than powering off
The server.

# shutdown -h now

This would stop the running services before powering down the machine.
Based on Centos, a additional method for getting it back-again when you run into this problem are to move Mysql.sock:

# mv /var/lib/mysql/mysql.sock /var/lib/mysql/mysql.sock.bak# service mysqld start

Restarting the service creates a new entry called Mqsql.sock

Top Picks

• LNMP Environment Construction--nginx Chapter

• Configuring the local Yum source in RHEL6.5

• Installation and use of Zabbix under Ubuntu

• MySQL Dual master hot standby problem processing

• Rsync Sync error Handling
• Fix Elementary Boot Screen (Plymouth)
  After installing Nvidia Drivers
• LNMP Environment Construction--mysql Chapter
• Shell Step by Step (3)--stdin & IF
• Shell Step by Step (4)--cron & Echo

MySQL Dual master hot standby problem processing