Bug #105127 MySQL Router loses connectivity with the InnoDB database cluster
Submitted: 5 Oct 2021 8:28 Modified: 26 Oct 2021 10:32
Reporter: Priscilla Wong Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Router Severity:S3 (Non-critical)
Version:8.0.15 OS:Red Hat (7.6 (Maipo))
Assigned to: MySQL Verification Team CPU Architecture:Any
Tags: mysqlrouter

[5 Oct 2021 8:28] Priscilla Wong 
Description:
MySQL Router loses connectivity with the InnoDB database cluster.
3 DB clustering. When this happens, 1 of the DB status will changed to missing. 
1(Master) will be R/W and 1 (Slave) will be RO.

Workaround to resolve the lost of connectivity. Need to boostrap and restart mysql router.

How to repeat:
Unable to repeat. It happens randomly for a few times already.
[7 Oct 2021 13:38] MySQL Verification Team 
Hi,

There were some issues with networking in 8.0.15/16, please retry with 8.0.26

thanks
[26 Oct 2021 10:32] MySQL Verification Team 
You should upgrade to the latest version in your major tree ( 8.0.27 or 5.7.36).

Please reopen the bug if you can reproduce the problem with latest versions of MySQL Server and MySQL Router.

thanks