BestHub
Sign in
Tagged articles

Binlog

288 articles · Page 1 of 3
Ops Community
Ops Community
Jun 8, 2026 · Databases

Comparing MySQL Backup Solutions: From Tool Mechanics to Production-Ready Engineering Guide

This article analyzes common MySQL backup pitfalls, explains the three backup dimensions and five types, compares major tools such as mysqldump, mysqlpump, mydumper, XtraBackup and cloud snapshots, and provides practical scripts, sizing recommendations, scheduling, monitoring, recovery procedures, and failure case studies for reliable production backup engineering.

BinlogRecoveryXtraBackup
0 likes · 52 min read
Comparing MySQL Backup Solutions: From Tool Mechanics to Production-Ready Engineering Guide
Architect Chen
Architect Chen
Jun 4, 2026 · Databases

Comprehensive Guide to MySQL Master‑Slave Replication (Principles, Architecture, Implementation)

This article explains MySQL master‑slave replication in detail, covering its role in high‑availability and read/write separation, the core binlog mechanism, typical one‑master‑multiple‑slaves architecture, and the step‑by‑step data flow from write operations on the master to replay on the replicas.

BinlogDatabase ArchitectureMaster‑Slave
0 likes · 4 min read
Comprehensive Guide to MySQL Master‑Slave Replication (Principles, Architecture, Implementation)
Ops Community
Ops Community
May 26, 2026 · Databases

How to Safely Clean Up MySQL Binlog When Disk Space Is Critical

This guide walks through why MySQL binlog can fill disks, explains its structure and formats, and provides a step‑by‑step, risk‑aware process—including preparation, safe PURGE commands, automatic expiration settings, verification, and monitoring—to clean binlog without breaking replication or losing data.

BinlogMonitoringbackup
0 likes · 34 min read
How to Safely Clean Up MySQL Binlog When Disk Space Is Critical
Architect Chen
Architect Chen
May 4, 2026 · Databases

What’s the Difference Between MySQL Redo Log and Binlog? (Interview Insight)

The article explains that MySQL redo log operates at the InnoDB engine layer to ensure transaction durability and crash recovery, while binlog works at the server layer to record logical changes for replication, archiving, and point‑in‑time recovery, highlighting their distinct layers, purposes, content, and write mechanisms.

BinlogCrash recoveryInnoDB
0 likes · 4 min read
What’s the Difference Between MySQL Redo Log and Binlog? (Interview Insight)
Huolala Tech
Huolala Tech
Apr 8, 2026 · Operations

How Real-Time Binlog Monitoring and AI Transform Data Quality Alerting

This article explains the design of a zero‑code, real‑time data quality alert platform that leverages Binlog‑based ingestion, configurable metrics, automated attribution, and LLM‑driven decision making to provide fine‑grained monitoring, rapid response, and measurable operational benefits across marketing workflows.

AI decisionBinlogData Quality
0 likes · 12 min read
How Real-Time Binlog Monitoring and AI Transform Data Quality Alerting
Java Architect Handbook
Java Architect Handbook
Apr 7, 2026 · Databases

Master MySQL’s Redo, Undo, and Binlog: Deep Dive for Interview Success

This article provides a comprehensive interview guide on MySQL’s three core logs—redo log, undo log, and binlog—covering their architecture, roles in crash recovery, MVCC, replication, configuration commands, two‑phase commit workflow, and frequent follow‑up questions to help candidates ace database interview questions.

BinlogDatabase InterviewRedo Log
0 likes · 13 min read
Master MySQL’s Redo, Undo, and Binlog: Deep Dive for Interview Success
Senior Xiao Ying
Senior Xiao Ying
Feb 27, 2026 · Databases

How to Recover Lost MySQL Data: Physical, Logical, and PITR Backup Guide

This article provides a comprehensive MySQL data‑loss recovery guide, covering logical and physical backup methods, their advantages and drawbacks, detailed command‑line examples, XtraBackup installation, full and incremental backups, compression and streaming, and point‑in‑time recovery using binary logs, along with core backup best‑practice principles.

BinlogLogical BackupPITR
0 likes · 12 min read
How to Recover Lost MySQL Data: Physical, Logical, and PITR Backup Guide
Java Tech Enthusiast
Java Tech Enthusiast
Jan 24, 2026 · Backend Development

How to Keep Database and Redis Cache Consistent Under High Concurrency

This article examines the common data‑consistency challenges when writing to both a database and a Redis cache, evaluates four write‑order strategies, and presents the most reliable approach—writing to the database first then deleting the cache—along with retry mechanisms using scheduled jobs, message queues, and binlog listeners.

BinlogCache consistencyElastic-Job
0 likes · 17 min read
How to Keep Database and Redis Cache Consistent Under High Concurrency
Architect's Guide
Architect's Guide
Jan 16, 2026 · Databases

How to Safely Update Billions of MySQL Rows Without Overloading Binlog

This article explains why a naïve full‑table UPDATE on massive MySQL tables can cripple replication, explores deep‑pagination and IN‑clause inefficiencies, and presents a batch‑processing strategy using NO_CACHE, FORCE INDEX, and rate‑controlled scripts to perform safe, high‑performance updates.

Batch ProcessingBinlogFull Table Update
0 likes · 8 min read
How to Safely Update Billions of MySQL Rows Without Overloading Binlog
Java Architect Handbook
Java Architect Handbook
Dec 13, 2025 · Backend Development

Evolving Business Operation Logging: From AOP Annotations to Binlog Time Windows

This article examines the need for comprehensive business operation logging in a central system, outlines the benefits of audit, security, monitoring, and analysis, and walks through three progressive solutions—AOP with annotations, AOP with SpEL, and a Binlog‑based time‑window approach—detailing their implementations, trade‑offs, and architectural considerations.

AOPBinlogJava
0 likes · 20 min read
Evolving Business Operation Logging: From AOP Annotations to Binlog Time Windows
Ray's Galactic Tech
Ray's Galactic Tech
Dec 11, 2025 · Databases

Mastering MySQL Binlog: Complete Guide to Replication, Recovery, and Auditing

An in‑depth guide to MySQL binary logs explains their role in replication, point‑in‑time recovery, auditing, and real‑time data pipelines, covering binlog formats, GTID, encryption, multi‑threaded replication, cleanup strategies, and practical mysqlbinlog commands for monitoring and troubleshooting.

BinlogDatabase AdministrationRecovery
0 likes · 10 min read
Mastering MySQL Binlog: Complete Guide to Replication, Recovery, and Auditing
Xuanwu Backend Tech Stack
Xuanwu Backend Tech Stack
Nov 24, 2025 · Databases

Mastering MySQL’s Three Core Logs: Redo, Undo, and Binlog Explained

This article provides a comprehensive guide to MySQL’s three essential logs—redo, undo, and binlog—detailing their hierarchy, purposes, write mechanisms, configuration parameters, and how they cooperate during transaction processing and replication, while also offering troubleshooting tips for common issues.

BinlogTransactiondatabase
0 likes · 17 min read
Mastering MySQL’s Three Core Logs: Redo, Undo, and Binlog Explained
Ops Community
Ops Community
Nov 23, 2025 · Databases

How to Recover Accidentally Dropped MySQL Data in 48 Hours – A Complete Step‑by‑Step Guide

This guide walks you through a full disaster‑recovery workflow for MySQL, covering emergency read‑only switching, pinpointing the deletion time via binlog, preparing a recovery instance, restoring the latest full backup with Xtrabackup or mysqldump, applying incremental binlog changes, verifying data integrity, and safely switching traffic back to the restored database.

BinlogData RecoveryDisaster Recovery
0 likes · 42 min read
How to Recover Accidentally Dropped MySQL Data in 48 Hours – A Complete Step‑by‑Step Guide
ITPUB
ITPUB
Nov 11, 2025 · Databases

Why Big Tech Switches MySQL Isolation from RR to RC – Benefits & Risks

This article explains the differences between MySQL's RR and RC isolation levels, details master‑slave replication and binlog formats, shows why RR is the default, and why many internet companies now prefer RC for higher concurrency despite its phantom‑read trade‑offs.

BinlogDatabase Performanceconcurrency
0 likes · 10 min read
Why Big Tech Switches MySQL Isolation from RR to RC – Benefits & Risks
IT Services Circle
IT Services Circle
Sep 11, 2025 · Databases

Understanding MySQL Redo Log vs Binlog: How They Ensure Data Safety

This article explains the distinct yet collaborative roles of MySQL's Redo Log and Binlog, covering two‑phase commit, write‑ahead logging, flushing mechanisms, performance trade‑offs, and their use cases in crash recovery, replication, and point‑in‑time restoration.

BinlogRedo LogTransaction
0 likes · 11 min read
Understanding MySQL Redo Log vs Binlog: How They Ensure Data Safety
Top Architect
Top Architect
Sep 7, 2025 · Databases

Mastering MySQL‑Elasticsearch Sync: Strategies, Pros, Cons, and Real‑World Use Cases

This article explores why MySQL alone struggles with large‑scale queries, introduces Elasticsearch as a complementary search engine, and compares several synchronization methods—including synchronous and asynchronous dual‑write, Logstash, binlog‑based, Canal, and Alibaba Cloud DTS—detailing their advantages, drawbacks, and typical application scenarios.

BinlogCanalDTS
0 likes · 18 min read
Mastering MySQL‑Elasticsearch Sync: Strategies, Pros, Cons, and Real‑World Use Cases
dbaplus Community
dbaplus Community
Aug 24, 2025 · Databases

Why Big Tech Chooses RC Over MySQL’s Default RR Isolation Level

This article explains the differences between MySQL’s default REPEATABLE READ (RR) and READ COMMITTED (RC) isolation levels, why large internet firms switch to RC, the mechanics of master‑slave replication, the three binlog formats, and how gap locks affect consistency and performance.

BinlogRCRR
0 likes · 10 min read
Why Big Tech Chooses RC Over MySQL’s Default RR Isolation Level
Architect
Architect
Aug 23, 2025 · Backend Development

How to Build Scalable Business Operation Logging with AOP, SpEL, and Binlog

This article explores a step‑by‑step evolution of business operation logging—from a simple AOP‑annotation approach, through enriched SpEL expressions, to a robust Binlog‑based solution with time‑window aggregation—highlighting benefits, challenges, code examples, and architectural diagrams for backend developers.

AOPBinlogSpEL
0 likes · 18 min read
How to Build Scalable Business Operation Logging with AOP, SpEL, and Binlog
Selected Java Interview Questions
Selected Java Interview Questions
Aug 22, 2025 · Databases

How to Recover Accidentally Deleted MySQL Data Using Binlog

This guide explains how to restore mistakenly deleted MySQL rows by leveraging binary logs, covering binlog activation, mode configuration, locating relevant log files, extracting the original INSERT statements or generating reverse DELETE statements, and using open‑source tools to automate the recovery process.

BinlogData RecoverySQL
0 likes · 17 min read
How to Recover Accidentally Deleted MySQL Data Using Binlog
Senior Tony
Senior Tony
Aug 4, 2025 · Databases

Understanding MySQL Master‑Slave Replication: Core Principles, Modes, and Latency Mitigation

This article provides a comprehensive overview of MySQL master‑slave replication, explaining its core mechanisms, the push‑pull hybrid model, replication modes (asynchronous, full‑sync, semi‑sync), binlog formats, and practical strategies to reduce replication lag caused by large transactions, server load, and network constraints.

AsynchronousBinlogSemi‑Sync
0 likes · 9 min read
Understanding MySQL Master‑Slave Replication: Core Principles, Modes, and Latency Mitigation
Top Architect
Top Architect
Jul 18, 2025 · Databases

Mastering MySQL‑Elasticsearch Synchronization: Strategies, Pros, and Implementation

This article explains why MySQL alone struggles with large‑scale, complex queries, introduces Elasticsearch as a complementary search engine, and compares five practical synchronization approaches—synchronous double‑write, asynchronous double‑write, Logstash, Binlog, and Canal/DTS—detailing their mechanisms, advantages, disadvantages, and typical use cases.

BinlogCanalDTS
0 likes · 17 min read
Mastering MySQL‑Elasticsearch Synchronization: Strategies, Pros, and Implementation
Java Tech Enthusiast
Java Tech Enthusiast
Jul 12, 2025 · Databases

Master MySQL’s Three Logs: Redo, Undo, and Binlog for Data Safety

Learn how MySQL’s three essential logs—Redo Log for durability, Undo Log for transaction rollback, and Binlog for replication—work together, understand their configurations, performance trade‑offs, and practical monitoring and recovery techniques to ensure data integrity in production environments.

BinlogData RecoveryRedo Log
0 likes · 9 min read
Master MySQL’s Three Logs: Redo, Undo, and Binlog for Data Safety
Su San Talks Tech
Su San Talks Tech
Jul 9, 2025 · Databases

Master MySQL’s Three Logs: Redo, Undo, and Binlog for Data Safety

This article explains how MySQL’s three essential logs—redo, undo, and binlog—work together to guarantee data durability, enable crash recovery, support transaction rollback, and power master‑slave replication, while providing practical configuration tips, monitoring queries, and recovery procedures for production environments.

BinlogPerformance TuningRedo Log
0 likes · 10 min read
Master MySQL’s Three Logs: Redo, Undo, and Binlog for Data Safety
Top Architect
Top Architect
Jun 24, 2025 · Backend Development

How to Sync MySQL Data to Elasticsearch: Strategies, Pros & Cons

This article explains why MySQL‑Elasticsearch synchronization is needed in large‑scale projects, compares several sync methods—including synchronous and asynchronous double‑write, Logstash, Binlog, Canal, and Alibaba Cloud DTS—detailing their implementation steps, advantages, disadvantages, and typical application scenarios.

BinlogCanalData synchronization
0 likes · 17 min read
How to Sync MySQL Data to Elasticsearch: Strategies, Pros & Cons
转转QA
转转QA
Apr 27, 2025 · Databases

Design and Implementation of a General Data Synchronization Solution for Online and Offline Databases

This article analyzes the pain points of inconsistent online‑offline configurations, proposes three synchronization schemes—including timed batch sync, automatic real‑time binlog‑MQ sync, and manual selective sync—compares their applicability, risks and performance, and presents practical deployment results across multiple projects using MySQL and TiDB.

BinlogData synchronizationReal-time Sync
0 likes · 14 min read
Design and Implementation of a General Data Synchronization Solution for Online and Offline Databases
Aikesheng Open Source Community
Aikesheng Open Source Community
Apr 8, 2025 · Databases

Using MySQL Flashback Tools to Roll Back DML Mistakes

This article explains how to use MySQL flashback utilities such as binlog2sql, my2sql, and MyFlash to recover from accidental DML operations, covering supported SQL types, required binlog settings, tool features, command‑line usage examples, and best‑practice recommendations for preventing future data loss.

BinlogDMLData Recovery
0 likes · 14 min read
Using MySQL Flashback Tools to Roll Back DML Mistakes
Java Backend Technology
Java Backend Technology
Mar 17, 2025 · Backend Development

Mastering Business Operation Logging: From AOP to Binlog with Spring

This article explores comprehensive strategies for capturing business operation logs in a Spring‑based system, comparing three solutions—from a simple AOP‑annotation approach, through an enhanced AOP + SpEL method, to a robust Binlog‑plus‑time‑window architecture—while weighing their advantages, drawbacks, and implementation details.

AOPBinlogSpEL
0 likes · 16 min read
Mastering Business Operation Logging: From AOP to Binlog with Spring
Aikesheng Open Source Community
Aikesheng Open Source Community
Mar 4, 2025 · Databases

Troubleshooting Incremental Data Sync Failure in OceanBase OBLogProxy Binlog Mode

This article details the background, configuration, and step‑by‑step troubleshooting process for a data pipeline that replaces a MySQL source with OceanBase using OBLogProxy in binlog mode, explains why downstream reads missed incremental data, and provides conclusions and optimization measures.

BinlogData synchronizationDatabase Troubleshooting
0 likes · 12 min read
Troubleshooting Incremental Data Sync Failure in OceanBase OBLogProxy Binlog Mode
MaGe Linux Operations
MaGe Linux Operations
Feb 9, 2025 · Databases

How to Recover Accidentally Deleted MySQL Tables: Real Enterprise Cases

This article presents two real‑world MySQL recovery scenarios—full backup restoration after an accidental table deletion and incremental recovery using XtraBackup—detailing backup strategies, binlog extraction, step‑by‑step commands, and validation procedures to safely restore production databases.

BinlogDatabase RecoveryEnterprise
0 likes · 10 min read
How to Recover Accidentally Deleted MySQL Tables: Real Enterprise Cases
Architect
Architect
Jan 14, 2025 · Databases

How MySQL Guarantees ACID: Deep Dive into Undo, Redo, and Binlog

This article provides a comprehensive analysis of MySQL’s internal architecture, detailing the four-layer design, the server service layer’s parsing, optimization and execution components, and the critical roles of Undo Log, Redo Log, and Binlog in ensuring ACID transaction properties.

ACIDBinlogDatabase Architecture
0 likes · 29 min read
How MySQL Guarantees ACID: Deep Dive into Undo, Redo, and Binlog
Java Tech Enthusiast
Java Tech Enthusiast
Jan 8, 2025 · Databases

Recovering Accidentally Deleted MySQL Data Using Binlog

To recover accidentally deleted MySQL rows, ensure binary logging is enabled and set to ROW mode, locate the appropriate binlog files, use mysqlbinlog (or tools like binlog2sql) to extract the original INSERT events within a time window, and replay or reconstruct them to restore the data.

BinlogData RecoverySQL
0 likes · 16 min read
Recovering Accidentally Deleted MySQL Data Using Binlog
Architect
Architect
Jan 2, 2025 · Databases

Data Synchronization Strategies Between MySQL and Elasticsearch

This article explains why MySQL alone struggles with large‑scale queries, introduces Elasticsearch as a complementary search engine, and compares several synchronization approaches—including synchronous and asynchronous dual‑write, Logstash, Binlog, Canal, and Alibaba Cloud DTS—detailing their implementations, advantages, disadvantages, and suitable use cases.

BinlogCanalDTS
0 likes · 16 min read
Data Synchronization Strategies Between MySQL and Elasticsearch
Top Architect
Top Architect
Dec 19, 2024 · Databases

MySQL to Elasticsearch Data Synchronization Strategies and Tools

This article examines various methods for synchronizing MySQL data with Elasticsearch, including synchronous and asynchronous dual writes, Logstash pipelines, binlog streaming, and Alibaba Cloud DTS, outlining implementation approaches, advantages, disadvantages, and suitable application scenarios for each solution.

BinlogCanalDTS
0 likes · 15 min read
MySQL to Elasticsearch Data Synchronization Strategies and Tools
Zhuanzhuan Tech
Zhuanzhuan Tech
Dec 13, 2024 · Databases

Understanding MySQL Architecture and Log Mechanisms for ACID Transactions

This article provides a comprehensive overview of MySQL's layered architecture, the functions and core components of the server layer, and detailed explanations of Undo Log, Redo Log, and Binlog mechanisms that together ensure the ACID properties of transactions, including practical execution flows for queries and updates.

ACIDBinlogDatabase Architecture
0 likes · 29 min read
Understanding MySQL Architecture and Log Mechanisms for ACID Transactions
Spring Full-Stack Practical Cases
Spring Full-Stack Practical Cases
Nov 22, 2024 · Backend Development

How to Sync MySQL to Redis in Real-Time with Spring Boot 3 and mysql-binlog-connector-java

This article demonstrates how to achieve real‑time synchronization of MySQL data to Redis using Spring Boot 3, the open‑source mysql‑binlog‑connector‑java library, and optional JMX exposure, providing step‑by‑step setup, code examples for parsing binlog events, listening to changes, and configuring Maven dependencies.

BinlogReal-time SyncRedis
0 likes · 10 min read
How to Sync MySQL to Redis in Real-Time with Spring Boot 3 and mysql-binlog-connector-java
Top Architect
Top Architect
Nov 17, 2024 · Databases

Data Synchronization Strategies Between MySQL and Elasticsearch

This article explains why MySQL alone may struggle with large‑scale, complex queries, introduces Elasticsearch as a high‑performance search engine, and compares several synchronization approaches—including synchronous and asynchronous dual‑write, Logstash, Binlog, Canal, and Alibaba Cloud DTS—detailing their advantages, disadvantages, and suitable scenarios.

BinlogCanalDTS
0 likes · 14 min read
Data Synchronization Strategies Between MySQL and Elasticsearch
Mingyi World Elasticsearch
Mingyi World Elasticsearch
Nov 3, 2024 · Big Data

How to Build a Scalable Business Operation Log System with Canal and Elasticsearch

This article walks through the design and implementation of a decoupled, high‑performance business operation log solution that captures MySQL binlog changes via Canal, streams them through Kafka, and stores and queries them in Elasticsearch, addressing challenges such as batch operations, multi‑table transactions, and non‑business data filtering.

BinlogCanalElasticsearch
0 likes · 13 min read
How to Build a Scalable Business Operation Log System with Canal and Elasticsearch
dbaplus Community
dbaplus Community
Oct 15, 2024 · Databases

How to Safely Perform Full-Table Updates on Billion-Row MySQL Tables

Updating billions of rows in a MySQL table can overwhelm binlog replication and cause deep‑pagination inefficiencies, so this article explains the pitfalls of direct UPDATE, explores limit‑based and IN‑based approaches, and presents a production‑ready batch update strategy using NO_CACHE and forced primary‑key indexing.

Batch ProcessingBinlogFull Table Update
0 likes · 7 min read
How to Safely Perform Full-Table Updates on Billion-Row MySQL Tables
Architect's Guide
Architect's Guide
Oct 1, 2024 · Databases

Efficient Full‑Table Updates in MySQL: Handling Row‑Based Binlog, Deep Pagination, and Batch Processing

The article explains why executing a full‑table UPDATE on large MySQL tables using row‑based binlog can overload replication, discusses the inefficiencies of deep pagination and IN clauses, and presents a batch‑processing strategy that leverages SQL_NO_CACHE and FORCE INDEX to safely and efficiently migrate data.

BinlogFull Table UpdatePerformance Optimization
0 likes · 8 min read
Efficient Full‑Table Updates in MySQL: Handling Row‑Based Binlog, Deep Pagination, and Batch Processing
Java Backend Technology
Java Backend Technology
Sep 25, 2024 · Databases

How to Safely Update Billion‑Row MySQL Tables Without Overloading Binlog

This article explains why a simple full‑table UPDATE on massive MySQL tables can cripple master‑slave replication, analyzes deep‑pagination inefficiencies, and presents a step‑by‑step batch‑update strategy using NO_CACHE and FORCE INDEX to keep binlog size and buffer‑pool impact under control.

BinlogFull Table UpdatePerformance Optimization
0 likes · 9 min read
How to Safely Update Billion‑Row MySQL Tables Without Overloading Binlog
Liangxu Linux
Liangxu Linux
Sep 12, 2024 · Databases

Master MySQL Redo Log & Binlog: 15 Essential Interview Questions Explained

Explore 15 classic MySQL log interview questions covering redo log, WAL, binlog, undo log, two‑phase commit, write‑ahead logging, crash‑safe mechanisms, log flushing settings, and recovery procedures, with detailed explanations, execution flow diagrams, and configuration parameters to help you ace database engineering interviews.

BinlogDatabase RecoveryRedo Log
0 likes · 16 min read
Master MySQL Redo Log & Binlog: 15 Essential Interview Questions Explained
360 Zhihui Cloud Developer
360 Zhihui Cloud Developer
Sep 11, 2024 · Databases

Upgrade Pika to 3.5.x: Key New Features, Migration Guide & Rollback Tips

This article introduces Pika 3.5.x’s major enhancements—including a new sync mechanism, expanded Redis command support, RocksDB upgrades, BlobDB, containerization, observability tools, ACL and transaction support—while providing a step‑by‑step upgrade procedure, optional data synchronization, and two rollback strategies for safe migration.

BinlogDatabase UpgradePika
0 likes · 17 min read
Upgrade Pika to 3.5.x: Key New Features, Migration Guide & Rollback Tips
Liangxu Linux
Liangxu Linux
Sep 2, 2024 · Databases

Master MySQL Logs: Redo, Binlog, Undo & Crash‑Safe Mechanisms Explained

This article compiles 15 classic MySQL log interview questions and provides detailed explanations of redo log, WAL, binlog, undo log, two‑phase commit, crash‑safe mechanisms, and related configuration parameters, helping readers understand database recovery and replication fundamentals.

BinlogCrash SafeDatabase Recovery
0 likes · 17 min read
Master MySQL Logs: Redo, Binlog, Undo & Crash‑Safe Mechanisms Explained
Selected Java Interview Questions
Selected Java Interview Questions
Sep 2, 2024 · Databases

Optimizing Full‑Table Updates in MySQL with Row‑Based Binlog: Strategies and Best Practices

This article explains the challenges of executing full‑table UPDATE statements on large MySQL tables using row‑based binlog replication, analyzes deep pagination issues, and presents a batch‑processing strategy with FORCE INDEX, SQL_NO_CACHE and controlled rate limiting to safely migrate data at scale.

BinlogFull Table UpdatePerformance Optimization
0 likes · 8 min read
Optimizing Full‑Table Updates in MySQL with Row‑Based Binlog: Strategies and Best Practices
macrozheng
macrozheng
Aug 29, 2024 · Databases

How to Safely Perform Billion-Row MySQL Updates Without Overloading Replication

This article explains why a direct full‑table UPDATE on a massive MySQL table can overwhelm binlog replication, explores the pitfalls of deep pagination and IN‑clauses, and presents a batch‑processing strategy using NO_CACHE and FORCE INDEX to achieve efficient, low‑impact updates.

Batch UpdateBinlogdatabase optimization
0 likes · 8 min read
How to Safely Perform Billion-Row MySQL Updates Without Overloading Replication
Top Architect
Top Architect
Aug 6, 2024 · Databases

MySQL to Elasticsearch Data Synchronization Strategies and Tools

This article explains various methods for synchronizing MySQL data to Elasticsearch, including synchronous and asynchronous double‑write, Logstash pipelines, binlog‑based real‑time sync, Canal, and Alibaba Cloud DTS, comparing their advantages, disadvantages, and suitable scenarios.

BinlogCanalDTS
0 likes · 16 min read
MySQL to Elasticsearch Data Synchronization Strategies and Tools
Open Source Tech Hub
Open Source Tech Hub
Aug 1, 2024 · Databases

How to Sync MySQL Data to Elasticsearch: Strategies, Pros, and Pitfalls

This article explains why MySQL‑Elasticsearch synchronization is needed, compares six practical approaches—including sync write, async write, Logstash, binlog, Canal, and Alibaba Cloud DTS—detailing their implementation methods, advantages, disadvantages, and suitable use cases for large‑scale data environments.

BinlogCanalDTS
0 likes · 13 min read
How to Sync MySQL Data to Elasticsearch: Strategies, Pros, and Pitfalls
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.

BinlogGTIDdatabase
0 likes · 10 min read
Can a MySQL Replica Omit sync_binlog=1? Experiment and Analysis
Su San Talks Tech
Su San Talks Tech
Jul 26, 2024 · Databases

Mastering MySQL‑to‑Elasticsearch Sync: 4 Strategies & Top Migration Tools

This guide compares four MySQL‑to‑Elasticsearch synchronization methods—synchronous dual‑write, asynchronous MQ‑based dual‑write, timer‑driven SQL extraction, and real‑time Binlog replication—and reviews popular CDC tools such as Canal, Alibaba Cloud DTS, Databus, and others to help you choose the right solution.

BinlogCDCCanal
0 likes · 13 min read
Mastering MySQL‑to‑Elasticsearch Sync: 4 Strategies & Top Migration Tools
IT Services Circle
IT Services Circle
Jun 12, 2024 · Databases

MySQL to Elasticsearch Data Synchronization: Strategies and Tool Selection

This article reviews four common MySQL‑to‑Elasticsearch synchronization methods—synchronous dual‑write, asynchronous dual‑write via MQ, timer‑based SQL extraction, and real‑time Binlog replication—evaluates their pros and cons, and compares popular migration tools such as Canal, Alibaba DTS, Databus and others.

BinlogCDCData Migration Tools
0 likes · 11 min read
MySQL to Elasticsearch Data Synchronization: Strategies and Tool Selection
Su San Talks Tech
Su San Talks Tech
Jun 10, 2024 · Databases

Mastering MySQL‑to‑Elasticsearch Sync: 4 Strategies & Top Migration Tools

This article compares four MySQL‑to‑Elasticsearch synchronization methods—synchronous dual‑write, asynchronous dual‑write, SQL extraction, and Binlog‑based real‑time sync—evaluates their pros and cons, and reviews popular migration tools such as Canal, Alibaba DTS, Databus, Flink, CloudCanal, Maxwell, and DRDS.

BinlogCDCData synchronization
0 likes · 14 min read
Mastering MySQL‑to‑Elasticsearch Sync: 4 Strategies & Top Migration Tools
Java Tech Enthusiast
Java Tech Enthusiast
May 3, 2024 · Databases

MySQL Data Recovery: Strategies for Handling Accidental Deletion

The article explains how to respond to accidental MySQL data deletion by analyzing loss causes, choosing recovery methods such as mysqldump backups, binary‑log point‑in‑time restores, or Percona’s InnoDB tool, provides step‑by‑step commands, and recommends preventive practices like regular backups, transactions, and strict permissions.

BinlogData RecoveryDatabase Security
0 likes · 3 min read
MySQL Data Recovery: Strategies for Handling Accidental Deletion
macrozheng
macrozheng
Apr 29, 2024 · Databases

How to Recover Accidentally Deleted MySQL Data: A Step-by-Step Guide

This guide explains how to answer MySQL accidental deletion interview questions and outlines practical recovery methods—including backup restoration, binlog usage, third‑party tools—and essential preventive practices such as regular backups, transaction handling, and permission management.

BinlogData Recoverybackup
0 likes · 5 min read
How to Recover Accidentally Deleted MySQL Data: A Step-by-Step Guide
Aikesheng Open Source Community
Aikesheng Open Source Community
Apr 24, 2024 · Databases

Summary of the MySQL Transaction Module Series

This article reviews the 14-part series on MySQL's transaction module, covering initialization, transaction types, two‑phase commit, binlog handling, savepoints, and full rollback, and provides links to each detailed post, including discussions on BEGIN statements, read‑only transactions, and the internal mechanisms of InnoDB.

BinlogInnoDBSavepoint
0 likes · 5 min read
Summary of the MySQL Transaction Module Series
Selected Java Interview Questions
Selected Java Interview Questions
Mar 15, 2024 · Backend Development

Ensuring Data Consistency Between MySQL and Redis in High‑Concurrency Scenarios

The article explains why data inconsistency occurs between MySQL and Redis under high concurrency, analyzes cache‑delete timing issues, and presents two solutions—delayed double‑delete and asynchronous cache updates via MySQL binlog—detailing implementation steps, advantages, drawbacks, and practical considerations.

Async UpdateBinlogCache consistency
0 likes · 8 min read
Ensuring Data Consistency Between MySQL and Redis in High‑Concurrency Scenarios
Top Architect
Top Architect
Feb 18, 2024 · Backend Development

Designing Business Operation Logging: From AOP Annotations to Binlog‑Based Solutions

This article explores the motivations, benefits, and step‑by‑step implementations of business operation logging, starting with a simple AOP‑annotation approach, advancing to AOP combined with Spring Expression Language for richer context, and finally leveraging MySQL binlog and time‑window techniques for low‑level, reliable change capture.

AOPBinlogLogging
0 likes · 18 min read
Designing Business Operation Logging: From AOP Annotations to Binlog‑Based Solutions
Architect
Architect
Feb 8, 2024 · Backend Development

From AOP Annotations to Binlog: Evolving Business Operation Logging Strategies

This article examines the progressive design of business operation logging—from a basic AOP‑annotation approach, through an AOP‑SpEL enhancement, to a binlog‑based time‑window solution—detailing each method's implementation steps, trade‑offs, and practical considerations for robust audit and monitoring in enterprise systems.

AOPBinlogLogging
0 likes · 19 min read
From AOP Annotations to Binlog: Evolving Business Operation Logging Strategies
Selected Java Interview Questions
Selected Java Interview Questions
Feb 5, 2024 · Backend Development

Designing Business Operation Logging with AOP, SpEL, and Binlog: From Basic to Advanced Solutions

This article explores the evolution of business operation logging in a Java backend, starting from a simple AOP‑annotation approach, advancing to AOP combined with Spring Expression Language for richer context, and finally leveraging MySQL binlog with time‑window processing to achieve comprehensive, low‑intrusion audit trails.

AOPBinlogJava
0 likes · 15 min read
Designing Business Operation Logging with AOP, SpEL, and Binlog: From Basic to Advanced Solutions
JD Retail Technology
JD Retail Technology
Jan 31, 2024 · Databases

Low‑Cost Database Stability Improvement and Lightweight Table Partitioning Using MyBatis Interceptor

This article explains how to use a MyBatis interceptor to cheaply improve database stability for high‑growth tables, compares common archiving and sharding solutions, and provides a complete, code‑driven implementation of date‑based horizontal sharding with binlog‑driven double‑write to handle critical‑point data continuity.

BinlogJavaMyBatis
0 likes · 11 min read
Low‑Cost Database Stability Improvement and Lightweight Table Partitioning Using MyBatis Interceptor
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 CommitPerformance Benchmark
0 likes · 19 min read
Understanding MySQL Parallel Replication: From Lag to Group Commit
Sohu Tech Products
Sohu Tech Products
Sep 20, 2023 · Big Data

Using Canal to Sync MySQL Incremental Data to Elasticsearch via RocketMQ

This tutorial walks through configuring Canal in cluster mode to capture MySQL row‑based binlog events, publish them to a RocketMQ topic, and consume the ordered messages to update an Elasticsearch index, covering MySQL, RocketMQ, Elasticsearch mappings, and the required Canal properties.

BinlogCanalElasticsearch
0 likes · 8 min read
Using Canal to Sync MySQL Incremental Data to Elasticsearch via RocketMQ
Architect
Architect
Aug 19, 2023 · Databases

Deep Dive into MySQL Replication: Mechanisms, Performance, and Real‑World Optimizations

This article thoroughly examines MySQL replication, detailing binlog formats, event types, replication workflows, semi‑synchronous and parallel replication techniques, performance benchmarks, and practical implementation steps such as fake‑slave registration and connection‑pool enhancements, while illustrating each concept with concrete examples and code snippets.

BinlogHigh AvailabilityPerformance Optimization
0 likes · 30 min read
Deep Dive into MySQL Replication: Mechanisms, Performance, and Real‑World Optimizations
Architect
Architect
Jul 28, 2023 · Databases

Which MySQL‑to‑Elasticsearch Sync Method Wins? 4 Solutions & Tool Picks

The article compares four MySQL‑to‑Elasticsearch synchronization approaches—synchronous dual‑write, asynchronous dual‑write via MQ, timer‑based SQL extraction, and binlog‑based real‑time sync—evaluates their trade‑offs, and recommends practical tools such as Canal, DTS, and Databus for implementation.

BinlogCanalDTS
0 likes · 13 min read
Which MySQL‑to‑Elasticsearch Sync Method Wins? 4 Solutions & Tool Picks
Su San Talks Tech
Su San Talks Tech
Jul 28, 2023 · Databases

Master‑Slave Replication in MySQL: Binlog Mechanics, Parallel Replication & Lag Reduction

This article explains why a single MySQL instance is insufficient for production, introduces binlog concepts and formats, details the master‑slave replication threads and workflow, explores parallel replication mechanisms, analyzes causes of replication lag, and provides practical strategies to minimize that delay.

BinlogDatabase LagMaster‑Slave
0 likes · 14 min read
Master‑Slave Replication in MySQL: Binlog Mechanics, Parallel Replication & Lag Reduction
MaGe Linux Operations
MaGe Linux Operations
Jul 23, 2023 · Databases

MySQL Redo, Bin, and Undo Logs Explained: Roles, Differences & Tips

This article introduces MySQL’s three primary logs—redo log, binlog, and undo log—explaining their purposes, how they ensure durability and recovery, the mechanisms for flushing them to disk, and the key differences among them, along with practical configuration recommendations.

BinlogDatabase LoggingInnoDB
0 likes · 6 min read
MySQL Redo, Bin, and Undo Logs Explained: Roles, Differences & Tips
dbaplus Community
dbaplus Community
Jul 18, 2023 · Databases

Recover MySQL Data by Parsing Binlogs with reverse_sql

reverse_sql is an open‑source utility that parses MySQL binary logs in ROW format, generates both original and reverse SQL statements, and helps recover data from accidental DML operations using multithreaded processing and flexible filtering options.

BinlogData RecoverySQL
0 likes · 9 min read
Recover MySQL Data by Parsing Binlogs with reverse_sql
Sanyou's Java Diary
Sanyou's Java Diary
Jul 3, 2023 · Databases

Master MySQL Internals: Architecture, Logs, and Recovery Explained

This article walks through MySQL's three‑layer logical architecture, explains the roles of redo, undo, bin, and relay logs, shows how they ensure crash‑safety and point‑in‑time recovery, and provides practical commands for inspecting and configuring these logs.

BinlogDatabase LogsInnoDB
0 likes · 18 min read
Master MySQL Internals: Architecture, Logs, and Recovery Explained