Bug #116013 Mitigate Performance Fluctuations in MySQL Group Replication

• Submitted: 5 Sep 2024 15:36
• Modified: 23 Oct 2024 12:45
• Reporter: Bin Wang (OCA)
• Status: Verified
• Category: MySQL Server: Group Replication
• Severity: S5 (Performance)
• Version: all versions
• OS: Any
• CPU Architecture: Any
• Tags: Performance Fluctuations

[5 Sep 2024 15:36] Bin Wang

Description:
Performance can fluctuate significantly in many scenarios, such as:
1.Significant throughput fluctuations when a node is killed.
2.Throughput drops to zero at intervals when a node is shut down.
3.Throughput drop of approximately 10 seconds when a node is added.

For more detailed analysis, refer to:
https://advancedmysql.github.io/blogs/group_replication_jitter.html

How to repeat:
During the SysBench read-write test, shutting down replicas, killing nodes, and adding nodes can all be easily reproduced.

[6 Sep 2024 11:33] MySQL Verification Team

Thanks for you effort and the report

[5 Oct 2024 14:25] Bin Wang

Mitigate Performance Fluctuations in MySQL Group Replication

Attachment: group_replication_jitter.pdf (application/pdf, text), 411.80 KiB.

[23 Oct 2024 12:45] Bin Wang

I have open-sourced an improved version based on MySQL 8.0.40. You can use this open-source project as a reference: https://github.com/advancedmysql/mysql.