Shulou(Shulou.com)06/01 Report--

Mysql master-slave synchronization Slave_IO_Running: Connecting problem on the slave library

One. Problems encountered in master-slave synchronization

Slave_IO_Running: Connecting on the database master-slave problem

When doing mysql master-slave synchronization, it is sometimes found that Slave_IO_Running: Connecting on the slave library

Two. the solution is usually five problems:

1. The network is not accessible # Mutual ping machine ip, normal access without packet loss rate, exclusion

two。 Incorrect password # MySQL re-authorize remote user to log in account, reset password, exclude

Incorrect 3.pos # master server, log in to the database to re-view the initial offset show master status, exclude

4.ID problem

# ID problem: default their server-id=1 when installing the mysql database, but set the ID number differently when doing master-slave synchronization. Check the database configuration file cat / etc/my.cnf, which is written differently and excluded.

5. Firewall policy

Check the firewall policy to see whether the service ports iptables-nL of both sides are opened. Finally, it is found that the port of the firewall policy that writes the multi-port firewall policy does not take effect. Solve the problem that the firewall policy opens the port alone, pauses reading from the io of the service and re-writes the following statement from the database of the stop slave;:

Mysql > change master to

-> master_host='192.168.137.36'

-> master_user='root'

-> master_password='abc123'

-> master_port=3307

-> master_log_file='mysql-bin.000001'

-> master_log_pos=848

Query OK, 0 rows affected, 2 warnings (0.05 sec)

Mysql > start slave

Query OK, 0 rows affected (0.02 sec)

Mysql > show slave status\ G

* * 1. Row *

Slave_IO_State: Waiting for master to send event

Master_Host: 192.168.137.36

Master_User: root

Master_Port: 3307

Connect_Retry: 60

Master_Log_File: mysql-bin.000001

Read_Master_Log_Pos: 1298

Relay_Log_File: localhost-relay-bin.000002

Relay_Log_Pos: 770

Relay_Master_Log_File: mysql-bin.000001

Slave_IO_Running: Yes

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: 1298

Relay_Log_Space: 981

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: 0

Master_SSL_Verify_Server_Cert: No

Last_IO_Errno: 0

Last_IO_Error:

Last_SQL_Errno: 0

Last_SQL_Error:

Replicate_Ignore_Server_Ids:

Master_Server_Id: 9

Master_UUID: ad899234-9c81-11e7-99bd-000c29af2bef

Master_Info_File: / data/mysql_data1/master.info

SQL_Delay: 0

SQL_Remaining_Delay: NULL

Slave_SQL_Running_State: Slave has read all relay log; waiting for more updates

Master_Retry_Count: 86400

Master_Bind:

Last_IO_Error_Timestamp:

Last_SQL_Error_Timestamp:

Master_SSL_Crl:

Master_SSL_Crlpath:

Retrieved_Gtid_Set:

Executed_Gtid_Set:

Auto_Position: 0

Replicate_Rewrite_DB:

Channel_Name:

Master_TLS_Version:

1 row in set (0.00 sec)

Note: the two red yes marked are normal.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.