MySQL Group Replication with Paxos: A Decade-Long Dead EndMySQL Group Replication based on the Paxos algorithm has essentially reached a dead end. After a decade of improvements, it hasn’t gotten…Oct 26, 2024Oct 26, 2024
How 300 Lines of TCPCopy Code Relieved My Online Anxiety and ChallengesOnce, I developed an ad delivery system to replace Google DoubleClick. The architecture was straightforward: the frontend used NGINX with…Oct 25, 2024Oct 25, 2024
Logical Reasoning in Network ProblemsMany software professionals lack in-depth knowledge of TCP/IP logic reasoning, which often leads to misidentifying problems as mysterious…Sep 5, 2024Sep 5, 2024
The Significant Differences Between BenchmarkSQL and SysBenchUsing the case of optimizing lock-sys as an example, this section evaluates the significant differences between the SysBench tool and…Sep 5, 2024Sep 5, 2024
How to explain why Repeatable Read surprisingly outperforms Read Committed?Transaction isolation is fundamental to database processing, represented by the ‘I’ in the ACID acronym. The isolation level determines the…Sep 5, 2024Sep 5, 2024
How PGO Enhances MySQL Performance?Profile-guided optimization (PGO) typically improves program execution efficiency. The following figure illustrates how PGO improves the…Sep 5, 2024Sep 5, 2024
From Civil Engineering to Computer Science: My 20-Year Journey to Tech ExpertiseIn 2004, I transitioned from civil engineering to computer science. Despite a weak foundation and a challenging learning process, I…Sep 5, 2024Sep 5, 2024
