I had upgraded my gateway from 9.2 to 9.3.
But i found replication issue after upgrade.
Please find below status:
Master_UUID: 1686f92c-073d-11e8-8782-0050568ddd82 Master_Info_File: /var/lib/mysql/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:
Please find below steps, I had executed and let me know if you know any solution.
1. [root@host ~]# mysqladmin stop-slave 2. [root@host ~]# mysql -e "reset master"
3.[root@host ~]# mysql -e "reset slave; reset slave all"
From my SQL Log:
While initializing dump thread for slave with UUID <1686f92c-073d-11e8-8782-0050568ddd82>, found a zombie dump thread with the same UUID. Master is killing the zombie dump thread(32).
I got response from CA....actually this is not an issue. Its part of Mysql 5.7 new replication format. For more info, Please see below links
1. Replication status in 5.7 as per below doc.
2. I have also found some more info(row 3),(List of Replication Normal status)