Bug #116200 Employing Paxos log persistence for Group Replication single-primary mode
Submitted: 23 Sep 2024 11:52 Modified: 24 Sep 2024 13:01
Reporter: Bin Wang (OCA) Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: Group Replication Severity:S4 (Feature request)
Version: OS:Any
Assigned to: CPU Architecture:Any
Tags: Paxos log persistence

[23 Sep 2024 11:52] Bin Wang 
Description:
Based on the results of the various tests, it can be concluded that, under current SSD hardware conditions, employing Paxos log persistence is a viable solution.

The purpose of employing Paxos log persistence is to replace the after mechanism in order to achieve better performance and ensure no data loss.

For detailed explanations, refer to: https://advancedmysql.github.io/blogs/paxos_log.html

How to repeat:
Under current SSD hardware conditions, employing Paxos log persistence is a viable solution.

Suggested fix:
Add a Paxos log persistence option for Group Replication single-primary mode.
[23 Sep 2024 19:23] MySQL Verification Team 
Is the algorithm for the creation and maintenance of the Paxos logs system public?

Feature request is verified.
[24 Sep 2024 13:01] Bin Wang 
It is not difficult for your official implementation. I have only demonstrated the feasibility, and Meta has also proven its viability.
[5 Oct 2024 14:29] Bin Wang 
Employing Paxos log persistence for Group Replication single-primary mode

Attachment: paxos_log.pdf (application/pdf, text), 98.22 KiB.