Skip to content
Tagged articles

GTID

122 articles · Page 2 of 2
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.

Binary LogGTIDMySQL
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.

CentOSGTIDMySQL
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.

GTIDMySQLReplication
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.

GTIDMySQLbinlog
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.

Crash SafetyGTIDMHA
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 MasterGTIDMySQL
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.

Binary LogER_MASTER_HAS_PURGED_REQUIRED_GTIDSGTID
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 MasterGTIDMySQL
0 likes · 7 min read
Why Does CHANGE MASTER Trigger Traffic Spikes in MySQL GTID Replication?

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.

FailoverGTIDHA
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
21CTO
21CTO
Nov 28, 2015 · Databases

Why MySQL Key Partition Queries Fail After Upgrade and How to Fix Them

This article examines several MySQL issues—including key partition hash algorithm changes causing data loss after upgrades, a client crash triggered by misdirected dump output, GTID_PURGED interactions that break AUTO_POSITION replication, and replicate‑do‑db filtering effects on GTID continuity—and provides concrete compatibility fixes and troubleshooting steps.

Database UpgradeGTIDReplication
0 likes · 18 min read
Why MySQL Key Partition Queries Fail After Upgrade and How to Fix Them
Qunar Tech Salon
Qunar Tech Salon
Oct 30, 2015 · Databases

MySQL Partitioning Hash Changes, GTID Replication Bugs, Client Crash, and TokuDB Optimize Table Analysis

This article examines how differing key‑hash algorithms in MySQL 5.1 versus 5.5/5.6 cause data loss in partitioned tables, describes compatibility fixes with ALTER TABLE … ALGORITHM=1, analyzes a MySQL client crash caused by mis‑redirected dump output, explores GTID_PURGED replication issues and replicate‑do‑db filtering gaps, and evaluates the behavior of OPTIMIZE TABLE on TokuDB tables.

BackendGTIDMySQL
0 likes · 18 min read
MySQL Partitioning Hash Changes, GTID Replication Bugs, Client Crash, and TokuDB Optimize Table Analysis
21CTO
21CTO
Oct 20, 2015 · Databases

Deep Dive into MySQL Partitioning, GTID Bugs, and TokuDB Optimize Table Anomalies

This article examines why MySQL 5.5/5.6 fails to retrieve non‑null partitioned rows after a physical upgrade, how the ALTER TABLE … PARTITION BY KEY ALGORITHM=1 fix works, the cause of MySQL client crashes when dump output mixes warnings, GTID_PURGED replication bugs, replicate‑filter side effects, and the behavior of TokuDB’s OPTIMIZE TABLE.

GTIDMySQLPartitioning
0 likes · 19 min read
Deep Dive into MySQL Partitioning, GTID Bugs, and TokuDB Optimize Table Anomalies
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
Architect
Architect
Aug 31, 2015 · Databases

MySQL High Availability: Replication, Monitoring, and Failover Strategies

This article discusses MySQL high‑availability solutions, covering asynchronous and semi‑synchronous replication, monitoring with keepalived, Zookeeper, and custom agents, failover procedures using binlog positions, GTID and pseudo‑GTID techniques, and the author's practical experiences and future plans.

FailoverGTIDMySQL
0 likes · 17 min read
MySQL High Availability: Replication, Monitoring, and Failover Strategies