MySQL Bugs: #106786: MySQL innodb cluster replication lag

Bug #106786	MySQL innodb cluster replication lag
Submitted:	21 Mar 2022 11:12	Modified:	21 Mar 2022 14:02
Reporter:	Sarath Reddy	Email Updates:
Status:	Unsupported	Impact on me:	None
Category:	MySQL Server: InnoDB storage engine	Severity:	S3 (Non-critical)
Version:	8.0.19	OS:	Red Hat (Red Hat Enterprise Linux Server release 7.7 (Maipo))
Assigned to:		CPU Architecture:	Other (x86_64)

Description:
In our performance environment we are facing replication lag from Master to Slaves.
In Master replication lag showing as null, but in slaves it is showing the time how much they are behind the master.

Same applications has been deployed in prod but not seeing any replication lag in Prod environment.

We tried many ways by changing the configurations, re-configuring the innodb cluster. Tried doing from scratch. Still replication lag issue is not solved. 

How to repeat:
Still the issue is reproducible and not solved.

Suggested fix:
NA

Hi Mr. Reddy,

Thank you very much for your bug report.

Do note that you are using an ancient release of the version 8.0. Between the release that you are using and current release, there are ten releases with thousands of bugs being fixed. We can not explore your problem in order to find an already fixed bugs.

Hence, you should upgrade to 8.0.28 (or 8.0.29 when it comes out) and see if the issue is still there.

Next, you are writing about replication, but also about InnoDB Cluster. Hence, we do not know which one are you actually using.

If you still have problems with latest 8.0 release, please try to configure the replication and make sure that all servers have the same number of threads running, including the slave threads.

Unsupported.