shocksolution.com March 11, 2019

MySQL replication fails with WSREP error after restart

Scenario

A single Percona MySQL 5.7 server replicates asynchronously with a cluster of Percona MySQL 5.7 servers. After rebooting the single server, replication failed with the following symptoms:

mysql> show slave status \G**************************** 1. row **************                Slave_IO_State: Waiting to reconnect after a failed registration on master                   Master_Host: my-replication-partner                   Master_User: repl                   Master_Port: 3306                 Connect_Retry: 60               Master_Log_File: mysql-bin.000120           Read_Master_Log_Pos: 3848512                Relay_Log_File: my-host-hame-relay-bin.000012                 Relay_Log_Pos: 4         Relay_Master_Log_File: mysql-bin.000120              Slave_IO_Running: Connecting             Slave_SQL_Running: Yes

I checked my MySQL text log (/var/log/mysql.log in my case, but the path may vary, or messages may go to syslog) and found the following error: