BestHub
Sign in
Tagged articles
15 articles
Page 1 of 1
Efficient Ops
Efficient Ops
Nov 13, 2023 · Databases

Understanding MySQL Parallel Replication: From Lag to Group Commit

This article explains why master‑slave lag occurs in MySQL, describes the evolution of parallel replication schemes—including group‑commit, Commit‑Parent‑Based, Lock‑Based, and WRITESET approaches—shows benchmark results, and provides practical configuration steps to enable high‑performance parallel replication.

BinlogGroup CommitWriteSet
0 likes · 19 min read
Understanding MySQL Parallel Replication: From Lag to Group Commit
dbaplus Community
dbaplus Community
May 2, 2023 · Databases

How MySQL Parallel Replication Cuts Slave Lag: Group Commit, Lock‑Based & WRITESET Explained

This article explains why MySQL slave lag is a critical issue, compares the official parallel replication schemes—including Commit‑Parent‑Based, Lock‑Based, and WRITESET—details their internal mechanisms, presents benchmark results, and provides the exact configuration parameters needed to enable high‑performance parallel replication.

Group CommitReplicationWriteSet
0 likes · 17 min read
How MySQL Parallel Replication Cuts Slave Lag: Group Commit, Lock‑Based & WRITESET Explained
Aikesheng Open Source Community
Aikesheng Open Source Community
Jul 2, 2021 · Databases

Observing the Effects of MySQL Group Commit through Experiments

Through a series of experiments using MySQL 8.0, this article demonstrates how group commit reduces I/O operations by consolidating multiple transactions into a single commit group, showing that doubling load increases runtime modestly while transaction count and commit groups rise significantly, highlighting performance benefits.

Group CommitIO optimizationdatabase
0 likes · 4 min read
Observing the Effects of MySQL Group Commit through Experiments
vivo Internet Technology
vivo Internet Technology
May 20, 2020 · Databases

Understanding MySQL Crash‑Safe Mechanism: WAL, Redo/Undo/Binlog, Two‑Phase and Group Commit, and Recovery Process

MySQL achieves crash‑safe durability by employing a write‑ahead log architecture that records changes in redo, undo, and binary logs, coordinates them through two‑phase and group commit to maintain order, and uses a structured recovery process to replay or roll back transactions after any failure.

BinlogCrash SafetyGroup Commit
0 likes · 17 min read
Understanding MySQL Crash‑Safe Mechanism: WAL, Redo/Undo/Binlog, Two‑Phase and Group Commit, and Recovery Process
Aikesheng Open Source Community
Aikesheng Open Source Community
Jul 12, 2019 · Databases

Understanding MySQL MTS (Enhanced Multi‑Threaded Slave) and DTLE Configuration for Parallel Replication

This article explains how MySQL's enhanced multi‑threaded slave (MTS) feature, introduced in 5.6.3 and refined in 5.7, reduces replication lag, describes the DTLE component that enables MTS parallel replay, shows the required configuration parameters, and presents performance test results demonstrating up to six‑fold speed improvement.

DTLEGroup CommitMTS
0 likes · 6 min read
Understanding MySQL MTS (Enhanced Multi‑Threaded Slave) and DTLE Configuration for Parallel Replication
dbaplus Community
dbaplus Community
Jul 7, 2019 · Databases

Master MySQL Locking: Table vs Row Locks, InnoDB Algorithms & Transaction Isolation

This article explains MySQL's locking mechanisms, comparing table‑level and row‑level locks, detailing InnoDB lock types such as shared, exclusive and intention locks, describing lock algorithms like record, gap, next‑key and insert‑intention locks, and covering lock‑related issues, transaction isolation levels, autocommit behavior, and group commit optimization.

Group CommitInnoDBIsolation Levels
0 likes · 43 min read
Master MySQL Locking: Table vs Row Locks, InnoDB Algorithms & Transaction Isolation
Art of Distributed System Architecture Design
Art of Distributed System Architecture Design
Apr 13, 2016 · Databases

MySQL Performance Optimizations and Feature Enhancements: Group Commit, DDL Fast‑Fail, GTID, InnoDB Auto‑Increment Persistence, Replication, and Key Partition Algorithms

This article presents a series of MySQL backend improvements—including Group Commit redesign, DDL fast‑fail handling, GTID allocation refinements, persistent InnoDB auto‑increment values, replication parallelism, and key‑partition hash algorithm changes—detailing motivations, implementation steps, and performance results.

GTIDGroup CommitInnoDB
0 likes · 24 min read
MySQL Performance Optimizations and Feature Enhancements: Group Commit, DDL Fast‑Fail, GTID, InnoDB Auto‑Increment Persistence, Replication, and Key Partition Algorithms
21CTO
21CTO
Nov 28, 2015 · Databases

MySQL Group Commit, DDL Fast Fail, GTID & Auto‑Increment Optimizations Explained

This article details MySQL performance enhancements—including Group Commit redesign, DDL fast‑fail lock handling, GTID allocation refinements, persistent auto‑increment storage, and replication parallelism improvements—illustrating the underlying mechanisms, implementation steps, and benchmark results that demonstrate measurable throughput gains.

DDL Fast FailGTIDGroup Commit
0 likes · 22 min read
MySQL Group Commit, DDL Fast Fail, GTID & Auto‑Increment Optimizations Explained
21CTO
21CTO
Oct 13, 2015 · Databases

How Group Commit, DDL Fast Fail, and GTID Optimizations Boost MySQL Performance

This article explains MySQL's evolution from serialized binlog writes to group commit, introduces DDL fast‑fail and GTID allocation improvements, analyzes InnoDB auto‑increment duplication after restart, and details replication performance gains from multi‑threaded and seqno‑based parallel execution, providing code examples and benchmark results.

DDL Fast FailGTIDGroup Commit
0 likes · 22 min read
How Group Commit, DDL Fast Fail, and GTID Optimizations Boost MySQL Performance
Qunar Tech Salon
Qunar Tech Salon
Jan 18, 2015 · Databases

MySQL Performance Optimizations and Feature Improvements: Group Commit, DDL Fast Fail, GTID, Auto‑Increment Persistence, Replication, and Key Partitioning

This article presents a comprehensive technical overview of MySQL performance tuning and feature enhancements—including group‑commit redesign, DDL fast‑fail, GTID handling, persistent auto‑increment, replication parallelism, and key‑partition hash changes—backed by real‑world test data from Taobao's large‑scale deployment.

DDLGroup CommitInnoDB
0 likes · 27 min read
MySQL Performance Optimizations and Feature Improvements: Group Commit, DDL Fast Fail, GTID, Auto‑Increment Persistence, Replication, and Key Partitioning