Layer7 API Management

  • 1.  Upgrade CA API Gateway 9.3

    Posted Feb 02, 2018 02:32 AM

    Hi,

    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"

    4. /opt/SecureSpan/Appliance/bin/create_slave.sh

     

    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).



  • 2.  Re: Upgrade CA API Gateway 9.3
    Best Answer

    Posted Feb 02, 2018 03:38 AM

    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.

    https://dev.mysql.com/doc/refman/5.7/en/slave-sql-thread-states.html

     

    2. I have also found some more info(row 3),(List of Replication Normal status)

     

    https://dev.mysql.com/doc/refman/5.7/en/show-processlist.html