BestHub
Sign in
Tagged articles
107 articles
Page 1 of 2
MaGe Linux Operations
MaGe Linux Operations
Apr 2, 2026 · Databases

Mastering MySQL 9.0 Replication: Deep Dive into GTID, Semi‑Sync, and Troubleshooting

This comprehensive guide explores MySQL 9.0's replication architecture, covering core principles, GTID and semi‑synchronous modes, various replication topologies, detailed troubleshooting steps, monitoring scripts, and best‑practice configurations, providing hands‑on examples and scripts to help engineers build and maintain robust, high‑availability database systems.

GTIDReplicationmysql
0 likes · 34 min read
Mastering MySQL 9.0 Replication: Deep Dive into GTID, Semi‑Sync, and Troubleshooting
Aikesheng Open Source Community
Aikesheng Open Source Community
Feb 26, 2026 · Databases

Essential MySQL Replication Best Practices to Keep Your Replicas Stable

This guide presents practical, DBA‑tested MySQL replication best practices—including GTID, row‑based replication, mandatory primary keys, schema consistency, binlog tuning, read‑only protection, dedicated replication users, latency monitoring, parallel workers, and SSL encryption—to ensure reliable, predictable replica behavior.

Database AdministrationGTIDReplication
0 likes · 9 min read
Essential MySQL Replication Best Practices to Keep Your Replicas Stable
Ctrip Technology
Ctrip Technology
Dec 5, 2025 · Databases

How Ctrip’s DRC Enables High‑Performance Cross‑Region MySQL Replication

This article explains the design and implementation of Ctrip's Data Replication Center (DRC), a MySQL‑based high‑availability system that solves cross‑region data loop, progress tracking, concurrency, DDL handling, and conflict resolution to achieve low‑latency, reliable data replication for global travel services.

Distributed SystemsGTIDcross-region
0 likes · 21 min read
How Ctrip’s DRC Enables High‑Performance Cross‑Region MySQL Replication
MaGe Linux Operations
MaGe Linux Operations
Nov 2, 2025 · Databases

Zero Data Loss MySQL Master‑Slave Replication Lag Diagnosis & GTID Failover

This comprehensive guide explains how to diagnose MySQL master‑slave replication lag, enable GTID mode, configure semi‑synchronous replication, optimize multi‑threaded replication, set up monitoring and alerting with Prometheus, and perform zero‑data‑loss failover using tools like Orchestrator and custom scripts.

AutomationGTIDReplication
0 likes · 23 min read
Zero Data Loss MySQL Master‑Slave Replication Lag Diagnosis & GTID Failover
MaGe Linux Operations
MaGe Linux Operations
Aug 3, 2025 · Databases

Why MySQL Replication Lag Can Crash Your System – Binlog, Semi‑Sync & GTID Explained

An experienced DBA recounts a midnight MySQL replication disaster where slave lag exceeded 60 seconds, then dissects the root causes—binlog formats, semi‑synchronous replication, and GTID—offering detailed configurations, performance tweaks, monitoring scripts, and best‑practice recommendations to prevent and resolve such failures.

GTIDReplicationmysql
0 likes · 15 min read
Why MySQL Replication Lag Can Crash Your System – Binlog, Semi‑Sync & GTID Explained
IT Xianyu
IT Xianyu
Apr 19, 2025 · Databases

Step-by-Step Guide to Setting Up MySQL 5.7 Master‑Slave Replication

This tutorial walks through preparing the Linux environment, installing MySQL 5.7, configuring master and slave servers, creating replication users, verifying synchronization, troubleshooting common issues, and applying advanced options such as GTID and semi‑synchronous replication, all with complete command examples.

ConfigurationGTIDLinux
0 likes · 10 min read
Step-by-Step Guide to Setting Up MySQL 5.7 Master‑Slave Replication
Raymond Ops
Raymond Ops
Apr 2, 2025 · Databases

How to Set Up MySQL Master‑Slave Replication (Step‑by‑Step Guide)

This guide walks you through preparing multiple virtual machines, configuring MySQL server IDs, setting up both classic and GTID‑based master‑slave replication, and managing the replication with essential commands, complete with code examples and architecture diagrams.

GTIDMaster‑SlaveReplication
0 likes · 6 min read
How to Set Up MySQL Master‑Slave Replication (Step‑by‑Step Guide)
Aikesheng Open Source Community
Aikesheng Open Source Community
Dec 2, 2024 · Databases

MySQL Replication Filter Expansion: Adding New Databases with Efficient Backup and Restore

This article explains how to extend an existing MySQL master‑slave replication filter to include additional databases by using a low‑cost backup‑restore workflow, detailing two solution options, the chosen approach, and step‑by‑step commands for stopping replication, backing up, setting GTID points, restoring, and updating filter rules.

BackupGTIDReplication
0 likes · 9 min read
MySQL Replication Filter Expansion: Adding New Databases with Efficient Backup and Restore
Aikesheng Open Source Community
Aikesheng Open Source Community
Jul 30, 2024 · Databases

Can a MySQL Replica Omit sync_binlog=1? Experiment and Analysis

This article examines whether a MySQL replica can safely omit setting sync_binlog=1, explains the underlying InnoDB and GTID mechanisms, presents an experiment reproducing power‑loss scenarios, and analyzes how different master_auto_position settings affect data consistency and GTID continuity during recovery.

BinlogGTIDReplication
0 likes · 10 min read
Can a MySQL Replica Omit sync_binlog=1? Experiment and Analysis
Aikesheng Open Source Community
Aikesheng Open Source Community
Jan 22, 2024 · Databases

MySQL 8.3 New Features and Removed Functionality

Version 8.3 of MySQL introduces tagged GTID replication, a selectable JSON EXPLAIN format version, enhanced thread‑pool plugin information, changes to binlog transaction dependency tracking and new CMake options, while removing several C API functions, the FLUSH HOSTS statement, and outdated replication flags.

Feature RemovalGTIDdatabase
0 likes · 6 min read
MySQL 8.3 New Features and Removed Functionality
Aikesheng Open Source Community
Aikesheng Open Source Community
Dec 26, 2023 · Databases

Understanding MySQL 8.0 immediate_commit_timestamp and original_commit_timestamp in Binlog Replication

This article explains the meaning, generation process, and operational impact of the new immediate_commit_timestamp and original_commit_timestamp fields in MySQL 8.0 binlog events, including how they affect replication delay calculations, warning handling, and precise monitoring of transaction commit times.

GTIDmysqltimestamp
0 likes · 9 min read
Understanding MySQL 8.0 immediate_commit_timestamp and original_commit_timestamp in Binlog Replication
Efficient Ops
Efficient Ops
Oct 16, 2023 · Databases

Why Master‑Master MySQL Replication Is Risky and How to Avoid Its Pitfalls

This article explains why the dbops tool does not support MySQL master‑master architecture, describes the two common dual‑master patterns, outlines their drawbacks such as role‑confusion, dirty‑data risk, split‑brain, and update loss, and provides practical workarounds and step‑by‑step deployment instructions to safely implement or avoid dual‑master setups.

GTIDMaster-Master Replicationdbops
0 likes · 17 min read
Why Master‑Master MySQL Replication Is Risky and How to Avoid Its Pitfalls
vivo Internet Technology
vivo Internet Technology
Apr 5, 2023 · Databases

Understanding MySQL Replication: Principles, Mechanisms, and Practical Applications

MySQL replication copies data changes from a primary server to one or more replicas using binlog events—supporting statement, row, or mixed formats and GTID positioning—to provide real‑time backup, read‑write separation, high‑availability failover, and integration pipelines via asynchronous, semi‑synchronous, or centralized binlog services.

BinlogData ReliabilityGTID
0 likes · 30 min read
Understanding MySQL Replication: Principles, Mechanisms, and Practical Applications
ITPUB
ITPUB
Jan 17, 2023 · Databases

Simplify MySQL Replication: Why GTID Beats Position‑Based Sync and How to Monitor Lag

This article examines MySQL’s transition from dual‑master to master‑slave replication, highlights the complexities of position‑based syncing, introduces GTID as a more reliable alternative, and provides practical steps to enable GTID and accurately monitor replication lag using seconds_behind_master, binlog positions, and GTID sets.

BinlogGTIDLag Monitoring
0 likes · 12 min read
Simplify MySQL Replication: Why GTID Beats Position‑Based Sync and How to Monitor Lag
MaGe Linux Operations
MaGe Linux Operations
Dec 22, 2022 · Databases

MySQL 5.7 Parallel Replication: Architecture, Config & Performance Gains

This article explains MySQL 5.7’s enhanced multi‑threaded slave (MTS) parallel replication, contrasting it with the schema‑based approach of MySQL 5.6, detailing its group‑commit mechanism, configuration parameters, GTID handling, performance testing, and practical tuning tips for optimal replication throughput.

ConfigurationDatabase PerformanceGTID
0 likes · 14 min read
MySQL 5.7 Parallel Replication: Architecture, Config & Performance Gains
Aikesheng Open Source Community
Aikesheng Open Source Community
Nov 24, 2022 · Databases

Understanding Orchestrator's RegroupReplicasGTID and Candidate Replica Selection in MySQL Failover

This article explains how Orchestrator selects a candidate replica during MySQL master failover, detailing the GetCandidateReplica and RegroupReplicasGTID functions, their sorting logic, promotion rules, GTID-based regrouping, and differences from MHA, while highlighting potential data loss issues and related bugs.

GTIDOrchestratorReplication
0 likes · 22 min read
Understanding Orchestrator's RegroupReplicasGTID and Candidate Replica Selection in MySQL Failover
ITPUB
ITPUB
Nov 6, 2022 · Databases

Why Can’t You Read Your Recent Write? Understanding Master‑Slave Lag and Fixes in MySQL

The article explains why a recent write may be invisible when reading from a MySQL replica, analyzes the replication threads and latency causes, and presents practical solutions such as forcing master reads, lag detection, semi‑sync mode, and GTID‑based waiting, with examples from Sharding‑JDBC, MyCat and MaxScale.

Database MiddlewareGTIDMaster‑Slave
0 likes · 10 min read
Why Can’t You Read Your Recent Write? Understanding Master‑Slave Lag and Fixes in MySQL
ITPUB
ITPUB
Oct 23, 2022 · Databases

Why Your Read Returns Stale Data After a Write in MySQL Replication and How to Fix It

After a write to the MySQL master, reads from a slave can return old or missing data due to replication lag, and this article explains the underlying asynchronous replication mechanisms, the involved threads, and presents practical solutions such as forcing master reads, delay detection, semi‑sync mode, GTID waiting, and middleware implementations like Sharding‑JDBC, MyCat, and MaxScale.

GTIDLagRead-Write Split
0 likes · 11 min read
Why Your Read Returns Stale Data After a Write in MySQL Replication and How to Fix It
Aikesheng Open Source Community
Aikesheng Open Source Community
Aug 25, 2022 · Databases

Understanding Data Consistency in MySQL Semi‑Synchronous Replication and HA Failover

This article explains the principles of MySQL semi‑synchronous replication, analyzes how data consistency is maintained during high‑availability failover, presents detailed step‑by‑step transaction flow, discusses scenarios causing GTID divergence, and offers testing methods and remediation techniques for DBA practitioners.

DBAGTIDSemi-sync replication
0 likes · 14 min read
Understanding Data Consistency in MySQL Semi‑Synchronous Replication and HA Failover
Aikesheng Open Source Community
Aikesheng Open Source Community
Jul 20, 2022 · Databases

Using ProxySQL Binlog Reader to Monitor MySQL GTID Replication

This article introduces the ProxySQL Binlog Reader component, explains its background in read/write splitting and GTID‑based consistency, demonstrates how to configure MySQL servers, create a dedicated user, start the reader on master and replica, and verify its operation through logs and session information.

Binlog ReaderGTIDProxySQL
0 likes · 9 min read
Using ProxySQL Binlog Reader to Monitor MySQL GTID Replication
Aikesheng Open Source Community
Aikesheng Open Source Community
Jul 13, 2022 · Databases

Bypassing GTID Restrictions on CREATE TABLE … SELECT and Temporary Tables in MySQL 5.6/5.7 and Their Removal in MySQL 8.0

The article explains the strict GTID‑based replication limits on CREATE TABLE … SELECT and temporary‑table statements in MySQL 5.6/5.7, demonstrates practical work‑arounds such as splitting statements or using CREATE TABLE LIKE, and shows how MySQL 8.0’s native DDL atomicity eliminates these constraints.

DDLGTIDMySQL8.0
0 likes · 12 min read
Bypassing GTID Restrictions on CREATE TABLE … SELECT and Temporary Tables in MySQL 5.6/5.7 and Their Removal in MySQL 8.0
Aikesheng Open Source Community
Aikesheng Open Source Community
Jun 30, 2022 · Databases

Handling Replication Anomalies in MySQL Slave IO Thread

This article analyzes MySQL replication anomalies caused by master failures or network interruptions that lead to incomplete transaction replay on slaves, demonstrates a reproducible experiment using network delay and iptables, and provides practical guidance for both recovering and permanently handling stalled slave IO threads.

GTIDReplicationdatabase
0 likes · 6 min read
Handling Replication Anomalies in MySQL Slave IO Thread
Aikesheng Open Source Community
Aikesheng Open Source Community
May 10, 2022 · Databases

Analysis and Reproduction of MySQL Binlog Replication Error 1236 (Could Not Open Log File)

This article analyzes a MySQL replication failure where the slave reports error 1236 "Could not open log file", explains the root cause involving duplicate entries in the binlog index after manual deletion of active binlog files, and provides step‑by‑step reproduction procedures and preventive recommendations.

BinlogGTIDerror-1236
0 likes · 8 min read
Analysis and Reproduction of MySQL Binlog Replication Error 1236 (Could Not Open Log File)
Aikesheng Open Source Community
Aikesheng Open Source Community
Mar 21, 2022 · Databases

MySQL‑to‑DBLE Data Synchronization Using DTLE: Full and GTID‑Based Incremental Sync Guide

This article provides a step‑by‑step tutorial on deploying a DBLE cluster, configuring sharding.xml, db.xml and user.xml, creating test tables, installing DTLE, performing full MySQL‑to‑DBLE data migration, then switching to GTID‑based incremental synchronization with detailed troubleshooting tips and best‑practice recommendations.

DBLEDTLEDatabase Synchronization
0 likes · 15 min read
MySQL‑to‑DBLE Data Synchronization Using DTLE: Full and GTID‑Based Incremental Sync Guide
dbaplus Community
dbaplus Community
Mar 1, 2022 · Databases

MHA Re-Edition: Modern MySQL HA with GTID Failover and Auto Switch

The MHA Re-Edition tool revives the discontinued MHA manager for MySQL, adding GTID‑based failover, password‑only SSH authentication, lightweight binaries, VIP migration, WeChat alerts, remote‑card reboot, and detailed configuration options, with step‑by‑step deployment instructions and sample app1.cnf parameters for high‑availability clusters.

GTIDMHAdatabase
0 likes · 11 min read
MHA Re-Edition: Modern MySQL HA with GTID Failover and Auto Switch
Tencent Database Technology
Tencent Database Technology
Feb 22, 2022 · Databases

Analysis of Relay Log Recovery and Crash Safety in MySQL GTID‑Based and Binary‑Log‑File‑Position Replication

This article examines how MySQL slaves recover their replication state in GTID‑based and binary‑log‑file‑position scenarios, identifies unsafe factors that can cause crash‑unsafe behavior, and explains how enabling relay_log_recovery=on mitigates these risks while outlining remaining limitations.

Crash SafetyGTIDMTS
0 likes · 14 min read
Analysis of Relay Log Recovery and Crash Safety in MySQL GTID‑Based and Binary‑Log‑File‑Position Replication
Aikesheng Open Source Community
Aikesheng Open Source Community
Dec 23, 2021 · Databases

Common MySQL binlog Commands and Usage Tips

This article provides a practical guide to using mysqlbinlog for parsing and replaying MySQL binlog files, covering options for time, position, and GTID ranges, as well as important parameters such as --no-defaults, -v, --base64-output, and --skip-gtids.

BinlogGTIDmysql
0 likes · 7 min read
Common MySQL binlog Commands and Usage Tips
ZhiKe AI
ZhiKe AI
Sep 24, 2021 · Databases

How to Manually Re‑Add a Detached MySQL MGR Cluster Node

This guide walks through exporting business databases, re‑initializing the MySQL instance, importing data, extracting GTID information, creating replication and monitoring accounts with helper functions, resetting logs, and finally re‑joining the node to a MySQL Group Replication cluster.

Database RecoveryGTIDGroup Replication
0 likes · 8 min read
How to Manually Re‑Add a Detached MySQL MGR Cluster Node
Aikesheng Open Source Community
Aikesheng Open Source Community
Sep 2, 2021 · Databases

Understanding and Calculating QPS and TPS in MySQL

This article explains the definitions of QPS (queries per second) and TPS (transactions per second) in MySQL, compares the various calculation methods—including Queries‑per‑second, Questions‑per‑second, and GTID‑based approaches—and recommends the most reliable ways to measure database load and transaction throughput.

GTIDQPSTPS
0 likes · 13 min read
Understanding and Calculating QPS and TPS in MySQL
Java Interview Crash Guide
Java Interview Crash Guide
Jul 16, 2021 · Databases

Master‑Slave MySQL Replication: Core Principles, Common Pitfalls, and Advanced Strategies

This article explains MySQL master‑slave replication fundamentals, including basic synchronization, circular replication issues, lag handling, failover strategies, parallel replication techniques, GTID usage, and read‑write splitting, providing practical guidance for reliable high‑availability database deployments.

GTIDMaster‑SlaveReplication
0 likes · 33 min read
Master‑Slave MySQL Replication: Core Principles, Common Pitfalls, and Advanced Strategies
Selected Java Interview Questions
Selected Java Interview Questions
Jul 15, 2021 · Databases

Fundamentals and Advanced Strategies of MySQL Master‑Slave Replication

This article explains the basic principles of MySQL master‑slave architecture, the role of read‑only replicas, loop‑replication problems, master‑slave delay measurement, various failover strategies, parallel replication mechanisms across MySQL versions and MariaDB, GTID usage, and read‑write splitting techniques, providing practical commands and diagrams for each concept.

Database LagGTIDMaster‑Slave
0 likes · 31 min read
Fundamentals and Advanced Strategies of MySQL Master‑Slave Replication
Qingyun Technology Community
Qingyun Technology Community
Jun 7, 2021 · Databases

Why Xenon Is the Modern MySQL HA Alternative to MHA

This article compares the legacy MHA solution with the modern open‑source Xenon tool, explaining Xenon's Raft‑based architecture, automatic leader election, GTID integration, and enterprise‑grade features that make it a superior high‑availability option for MySQL deployments.

GTIDMHARaft
0 likes · 7 min read
Why Xenon Is the Modern MySQL HA Alternative to MHA
Programmer DD
Programmer DD
Apr 2, 2021 · Databases

3 Proven Paths to Master MySQL Replication and What the New Book Reveals

Discover three effective strategies for mastering a technology, illustrated with MySQL replication, and learn how the new book 'Deep Understanding of MySQL Master‑Slave Principles' combines code analysis, comparative study, and expert insight to guide readers through GTID, binary‑log events, and high‑availability architectures.

GTIDReplicationhigh availability
0 likes · 7 min read
3 Proven Paths to Master MySQL Replication and What the New Book Reveals
Aikesheng Open Source Community
Aikesheng Open Source Community
Mar 18, 2021 · Databases

Impact of Different Replication User Creation Methods on MySQL Master‑Slave Replication

The article experimentally evaluates three ways of creating replication users—only on the master, separately on master and slave with CREATE statements, and separately with GRANT statements—to show how each method affects MySQL 5.7 master‑slave replication, error handling, and compatibility with GTID and MySQL 8.0.

Database AdministrationGTIDGrant
0 likes · 8 min read
Impact of Different Replication User Creation Methods on MySQL Master‑Slave Replication
Practical DevOps Architecture
Practical DevOps Architecture
Dec 28, 2020 · Databases

MySQL Binlog Configuration and Usage Guide

This guide explains how to enable and configure MySQL binary logging, examine its parameters, understand event formats, view and filter binlog contents, and extract logs using positions, timestamps, or GTIDs for backup, replication, and troubleshooting purposes.

BinlogGTIDmysql
0 likes · 6 min read
MySQL Binlog Configuration and Usage Guide
Qunar Tech Salon
Qunar Tech Salon
Nov 24, 2020 · Databases

Analysis of Galera GTID vs MySQL GTID Issues During Percona XtraDB Cluster Split at Qunar

This article examines how differences between Galera GTID and MySQL GTID caused replication interruptions during a Percona XtraDB Cluster (PXC) split at Qunar, details the migration procedure, reproduces the problem with step‑by‑step commands, explains GTID concepts, and proposes operational improvements to avoid data inconsistency.

Database operationsGTIDGalera
0 likes · 17 min read
Analysis of Galera GTID vs MySQL GTID Issues During Percona XtraDB Cluster Split at Qunar
Aikesheng Open Source Community
Aikesheng Open Source Community
Nov 3, 2020 · Databases

Using GTID for Multi‑Source Replication in MySQL

This article explains why GTID‑based replication is preferred for synchronizing data from four regional factories to an IDC, and provides a step‑by‑step guide—including data export, GTID configuration, master‑slave channel setup, adding a new slave, and important precautions—for successful multi‑source MySQL replication.

BackupGTIDMulti-Source Replication
0 likes · 8 min read
Using GTID for Multi‑Source Replication in MySQL
Architect's Alchemy Furnace
Architect's Alchemy Furnace
Jul 6, 2020 · Databases

Mastering MySQL HA: Step‑by‑Step MHA Setup and Failover Guide

This article walks through preparing a four‑node MySQL environment, configuring password‑less SSH, setting up master‑slave replication with GTID, installing and configuring MHA, testing connectivity, running the manager, verifying automatic failover, and highlighting the key advantages of using MHA for high availability.

Database operationsGTIDMHA
0 likes · 24 min read
Mastering MySQL HA: Step‑by‑Step MHA Setup and Failover Guide
Ctrip Technology
Ctrip Technology
May 28, 2020 · Databases

Design and Implementation of Ctrip's Data Replicate Center (DRC) for MySQL Multi‑Active Replication

The article describes Ctrip's Data Replicate Center (DRC), a MySQL middleware that enables real‑time bidirectional replication across data‑center clusters, detailing its architecture, low‑latency optimizations, consistency mechanisms, DDL handling, monitoring, and future high‑availability improvements.

DRCDatabase MiddlewareGTID
0 likes · 16 min read
Design and Implementation of Ctrip's Data Replicate Center (DRC) for MySQL Multi‑Active Replication
Aikesheng Open Source Community
Aikesheng Open Source Community
Mar 9, 2020 · Databases

Why Xtrabackup’s GTID Mismatch Happens: Deep Dive into MySQL 5.7 & 8.0 Backups

This article analyses why the GTID information recorded by Xtrabackup’s xtrabackup_binlog_info file can differ from the GTID shown by SHOW MASTER STATUS after a restore, comparing the behavior of Xtrabackup 2.4 on MySQL 5.7 and Xtrabackup 8.0 on MySQL 8.0, and explains the underlying backup processes and MySQL internals that cause the discrepancy.

BackupBinlogDatabase Replication
0 likes · 14 min read
Why Xtrabackup’s GTID Mismatch Happens: Deep Dive into MySQL 5.7 & 8.0 Backups
Aikesheng Open Source Community
Aikesheng Open Source Community
Mar 4, 2020 · Databases

Improved MySQL 8 Replication Lag Monitoring Using GTID Timestamps and Performance Schema

The article explains the shortcomings of traditional MySQL replication lag measurement, introduces the community heartbeat‑table approach and its limitations, and then details MySQL 8 enhancements (WL#7319, WL#7374) that embed transaction timestamps in binlog events and expose new performance_schema tables, providing precise SQL queries to monitor lag at various stages of the replication pipeline.

GTIDLag MonitoringPerformance Schema
0 likes · 8 min read
Improved MySQL 8 Replication Lag Monitoring Using GTID Timestamps and Performance Schema
Aikesheng Open Source Community
Aikesheng Open Source Community
Mar 2, 2020 · Databases

Guide to Deploying and Managing MySQL InnoDB ReplicaSet with MySQL Shell and Router

This tutorial explains how to create and operate a MySQL InnoDB ReplicaSet—deploying sandbox instances, configuring a replica set with primary and secondary roles, adding nodes, performing manual primary switches and failure recovery, and using MySQL Router to provide an automatic read/write endpoint, while highlighting current limitations.

DatabaseReplicationGTIDInnoDB
0 likes · 8 min read
Guide to Deploying and Managing MySQL InnoDB ReplicaSet with MySQL Shell and Router
Aikesheng Open Source Community
Aikesheng Open Source Community
Aug 22, 2019 · Databases

Analysis of Large Transaction Binlog Behavior in MySQL 5.6/5.7

This article analyzes why a large MySQL transaction can occupy an entire binlog file without triggering a binlog switch, why the final transaction appears small, and why the commit timestamps of the large and small transactions can differ by up to fifteen minutes, providing detailed explanations, test procedures, and code examples.

GTIDlarge transactionmysql
0 likes · 11 min read
Analysis of Large Transaction Binlog Behavior in MySQL 5.6/5.7
dbaplus Community
dbaplus Community
Jul 2, 2019 · Databases

Mastering Multi-Active Data Centers: Solving MySQL Data Sync Loops

This article explains the concepts of unitization and multi‑active data centers, analyzes the drawbacks of single‑IDC deployments, and provides a detailed guide on implementing MySQL binlog synchronization while addressing common challenges such as data loops, duplicate inserts, unique‑index conflicts, and DDL handling, including practical solutions like GTID and auxiliary tables.

BinlogDatabase ArchitectureGTID
0 likes · 24 min read
Mastering Multi-Active Data Centers: Solving MySQL Data Sync Loops
Youzan Coder
Youzan Coder
Mar 27, 2019 · Databases

MySQL Slave Crash-Safe Feature Analysis

The article examines MySQL 5.6’s crash‑safe slave replication, explaining how earlier versions’ unsafe relay‑log handling could corrupt position data, describing the atomic update of mysql.slave_relay_log_info via table‑based relay‑log info and transaction coordination, and covering configuration options, recovery behavior, GTID implications, performance trade‑offs, and implementation guidance.

BinlogCrash SafeGTID
0 likes · 9 min read
MySQL Slave Crash-Safe Feature Analysis
Aikesheng Open Source Community
Aikesheng Open Source Community
Mar 20, 2019 · Databases

Analysis of MySQL Group Replication Data Inconsistency Caused by GTID Mismatch and Paxos Proposal Conflict

This article examines a real‑world MySQL Group Replication failure where network jitter caused a primary INSERT not to replicate, leading to GTID divergence, a secondary node leaving the cluster, and explains the underlying Paxos‑based proposal conflict with detailed code examples.

Database HAGTIDGroup Replication
0 likes · 11 min read
Analysis of MySQL Group Replication Data Inconsistency Caused by GTID Mismatch and Paxos Proposal Conflict
Zhongtong Tech
Zhongtong Tech
Aug 31, 2018 · Databases

How Aries Uses MySQL GTID Binlog to Power Real‑Time Data Sync at Scale

Aries, an internally built MySQL incremental log distribution platform, leverages GTID‑based binlog dumping to achieve stable, consistent, and real‑time data synchronization across heterogeneous systems, supporting use cases such as Elasticsearch sync, cache updates, archiving, and live statistics.

Data IntegrationGTIDdatabase
0 likes · 7 min read
How Aries Uses MySQL GTID Binlog to Power Real‑Time Data Sync at Scale
UCloud Tech
UCloud Tech
Jan 12, 2018 · Databases

How to Diagnose and Resolve MySQL Replication Errors in High‑Availability Environments

This article explains step‑by‑step how to collect replication status, examine MySQL error logs and binary logs, understand common replication failures such as duplicate databases or missing binlog files, and apply GTID and configuration best practices to troubleshoot and fix MySQL replication problems in high‑availability setups.

Error TroubleshootingGTIDReplication
0 likes · 25 min read
How to Diagnose and Resolve MySQL Replication Errors in High‑Availability Environments
dbaplus Community
dbaplus Community
Jun 12, 2017 · Databases

How to Diagnose and Fix MySQL Replication Errors in UDB

This guide explains how to collect replication status, analyze MySQL error logs and binary logs, compare master and slave configurations, and troubleshoot common replication failures such as GTID mismatches, missing binlogs, and conflicting statements in UDB environments.

GTIDReplicationUDB
0 likes · 20 min read
How to Diagnose and Fix MySQL Replication Errors in UDB
ITPUB
ITPUB
Apr 17, 2017 · Databases

How to Build a Multi‑Master to Single‑Slave MySQL 5.7 Replication Setup

This guide walks through preparing three CentOS 6.7 machines, installing MySQL 5.7.17, configuring my.cnf, disabling firewalls and SELinux, creating replication users, exporting databases, setting up multi‑source replication with GTID, and verifying data consistency across two masters and one slave.

CentOSGTIDReplication
0 likes · 10 min read
How to Build a Multi‑Master to Single‑Slave MySQL 5.7 Replication Setup
dbaplus Community
dbaplus Community
Apr 9, 2017 · Databases

Recovering MySQL Replication After a Massive Binlog Overflow

This article explains why a large‑transaction update caused a binlog overflow and slave I/O failure in a remote MySQL master‑slave setup, and provides step‑by‑step commands and a stored‑procedure solution to restore replication safely.

GTIDReplicationStored Procedure
0 likes · 7 min read
Recovering MySQL Replication After a Massive Binlog Overflow
Qunar Tech Salon
Qunar Tech Salon
Apr 6, 2017 · Databases

Understanding Timestamp and exec_time in MySQL Binlog Events

This article explains how MySQL binlog timestamps are derived from the THD start_time, why all events in a transaction share the same timestamp, how exec_time is calculated, and demonstrates the effect of autocommit and manual commit on binlog timing through concrete examples and source code analysis.

BinlogGTIDdatabase
0 likes · 10 min read
Understanding Timestamp and exec_time in MySQL Binlog Events
dbaplus Community
dbaplus Community
Dec 12, 2016 · Databases

Mastering MySQL GTID: From Basics to Advanced Replication and Recovery

This comprehensive guide explains MySQL GTID fundamentals, its syntax, how to view and generate GTIDs, configure GTID‑based replication, troubleshoot replication errors, integrate GTID with backup/restore, MHA failover, and ensure crash‑safe slaves while discussing performance trade‑offs.

BackupCrash SafetyGTID
0 likes · 24 min read
Mastering MySQL GTID: From Basics to Advanced Replication and Recovery
Java High-Performance Architecture
Java High-Performance Architecture
Oct 5, 2016 · Databases

Mastering MySQL GTID Replication: Benefits, Drawbacks, and Step‑by‑Step Setup

This guide explains what MySQL GTID is, compares its advantages and disadvantages to traditional binlog‑position replication, and provides a detailed, step‑by‑step procedure for configuring GTID‑based master‑slave replication, including server‑UUID handling, configuration files, data export, user creation, and verification.

ConfigurationGTIDMaster‑Slave
0 likes · 5 min read
Mastering MySQL GTID Replication: Benefits, Drawbacks, and Step‑by‑Step Setup
ITPUB
ITPUB
Sep 8, 2016 · Databases

Why Does CHANGE MASTER Trigger Traffic Spikes in MySQL GTID Replication?

After switching a MySQL master’s IP, the author observed unusually high traffic between master and slave, investigated the role of GTID, semi‑sync and the CHANGE MASTER command, and demonstrated that executing CHANGE MASTER on a lagging replica can clear the relay‑log and cause a temporary traffic surge as the missing binlog entries are re‑fetched.

Change MasterGTIDRelay Log
0 likes · 7 min read
Why Does CHANGE MASTER Trigger Traffic Spikes in MySQL GTID Replication?
dbaplus Community
dbaplus Community
Aug 24, 2016 · Databases

Choosing the Right MySQL HA Architecture: Master‑Slave, Dual‑Master, Heartbeat+DRBD, and GTID

This article examines common MySQL high‑availability designs—including single master‑slave, dual‑master with multiple slaves, Heartbeat + DRBD, MySQL Cluster, semi‑synchronous replication, and GTID—explaining their benefits, drawbacks, and practical considerations for reliable failover and scalability.

DRBDDatabase ArchitectureGTID
0 likes · 9 min read
Choosing the Right MySQL HA Architecture: Master‑Slave, Dual‑Master, Heartbeat+DRBD, and GTID
ITPUB
ITPUB
Jul 11, 2016 · Databases

Why Does MySQL Replication Throw ER_MASTER_HAS_PURGED_REQUIRED_GTIDS and How to Fix It?

In a MySQL 5.7 GTID setup with dual masters, a network glitch caused the slave to switch masters, leading to the ER_MASTER_HAS_PURGED_REQUIRED_GTIDS error because the new master had purged GTIDs the slave still needed, and the article explains the root cause and step‑by‑step fix.

ER_MASTER_HAS_PURGED_REQUIRED_GTIDSGTIDReplication
0 likes · 6 min read
Why Does MySQL Replication Throw ER_MASTER_HAS_PURGED_REQUIRED_GTIDS and How to Fix It?
ITPUB
ITPUB
May 9, 2016 · Databases

Why Does CHANGE MASTER Trigger Traffic Spikes in MySQL GTID Replication?

After switching a MySQL master’s IP, the author observed extreme master‑to‑slave traffic and investigated whether using CHANGE MASTER with auto_position=1 forces the replica to re‑fetch already executed binlogs, especially when the replica is lagging.

Change MasterGTIDRelay Log
0 likes · 7 min read
Why Does CHANGE MASTER Trigger Traffic Spikes in MySQL GTID Replication?
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
Mar 11, 2016 · Databases

How to Build Reliable MySQL HA: Replication, Monitoring, and Failover Strategies

This article explores practical MySQL high‑availability solutions, covering asynchronous and semi‑synchronous replication, monitoring with keepalived or Zookeeper, failover decision criteria, GTID and pseudo‑GTID techniques, and lessons learned from real‑world deployments.

GTIDHAPseudo GTID
0 likes · 13 min read
How to Build Reliable MySQL HA: Replication, Monitoring, and Failover Strategies
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