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

There is an error in master-slave synchronization:

Slave_IO_Running: Connecting

Slave_SQL_Running: Yes

Solution:

The main reasons why lave_IO_Running is connecting are as follows:

1. The network is not connected.

2. The password is incorrect

3. Pos is wrong.

Two reasons that I'm sure of and rule out

1. Network reason: there is no error in copying the backup files on the main library from the library, so it can be eliminated.

2. POS is incorrect: I can also rule this out, because I recorded POS when I show maste status on the main library, so I also ruled out this reason.

The obvious problem is that it's on password, but I'm executing it from the library.

CHANGE MASTER TO

MASTER_HOST='192.168.223.101'

MASTER_USER='liyao'

MASTER_PASSWORD='liyao'

MASTER_LOG_FILE='mysql-bin.000008'

MASTER_LOG_POS= 261

The 'liyao'' in MASTER_PASSWORD='liyao', is written as' liyao',', which results in Slave_IO_Running: Connecting on the slave library.

Check the status of the slave library after modification. The problem has been solved.

Mysql > show slave status\ G * * 1.row * *

Slave_IO_State: Waiting for master to send event

Master_Host: 192.168.223.101

Master_User: liyao

Master_Port: 3306

Connect_Retry: 60

Master_Log_File: mysql-bin.000008

Read_Master_Log_Pos: 261

Relay_Log_File: template-relay-bin.000002

Relay_Log_Pos: 253

Relay_Master_Log_File: mysql-bin.000008

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

Relay_Log_Space: 412

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

1 row in set (0.00 sec)

It is concluded that we still need to be careful in the process of the experiment to avoid causing unnecessary trouble for our own experimental process.

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.