BestHub
Sign in
Tagged articles

Replication

767 articles · Page 1 of 8
Mike Chen Rui
Mike Chen Rui
Aug 20, 2026 · Databases

Complete MySQL Master‑Slave Replication: Principles, Architecture, and Setup

MySQL master‑slave replication separates writes to the master and reads to one or more replicas, using binary logs to record changes; the article explains its core concepts, typical scenarios like read‑write splitting and high‑availability, and provides a step‑by‑step configuration guide covering server IDs, binlog settings, replication accounts, data initialization, GTID options, and status verification.

Binary LogDatabase ArchitectureGTID
0 likes · 5 min read
Complete MySQL Master‑Slave Replication: Principles, Architecture, and Setup
MaGe Linux Operations
MaGe Linux Operations
Aug 18, 2026 · Databases

Common Causes and Fix Steps for MySQL Master‑Slave Replication Lag

This guide walks through why MySQL master‑slave replication lag occurs, the key metrics to monitor, a step‑by‑step troubleshooting flow, ten typical root causes, concrete remediation actions, verification methods, rollback plans, and production‑grade best practices for keeping replication latency near zero.

DiskIOLagMySQL
0 likes · 29 min read
Common Causes and Fix Steps for MySQL Master‑Slave Replication Lag
Cloud Architecture
Cloud Architecture
Aug 10, 2026 · Databases

Master‑Slave Replication in Redis: Core Mechanics Explained and Production Deployment

This article provides a comprehensive, production‑focused analysis of Redis master‑slave replication, covering its internal state machine, full and partial sync processes, configuration pitfalls, performance bottlenecks, consistency trade‑offs, and practical deployment patterns with Docker, Kubernetes, and Spring Boot.

Docker ComposeHigh AvailabilityKubernetes
0 likes · 38 min read
Master‑Slave Replication in Redis: Core Mechanics Explained and Production Deployment
Cloud Architecture
Cloud Architecture
Aug 7, 2026 · Backend Development

Building a Trillion‑Message Queue: Kafka‑Level Architecture and Implementation

This article explains why and how to build a Kafka‑grade message‑queue kernel from scratch, detailing functional and non‑functional goals, core design principles, storage layout, replication, consumer‑group coordination, performance optimizations, deployment on Kubernetes, and a step‑by‑step roadmap to production‑grade reliability.

Distributed LogHigh throughputJava
0 likes · 40 min read
Building a Trillion‑Message Queue: Kafka‑Level Architecture and Implementation
liandk
liandk
Aug 5, 2026 · Databases

Mastering Redis High Availability: Replication, Sentinel, and Cluster Explained

The article explains why Redis must be highly available and walks through three progressive architectures—master‑slave replication, Sentinel automatic failover, and Redis Cluster—detailing their mechanisms, advantages, drawbacks, and when to choose each for small, medium, or large‑scale production systems.

ClusterDatabase ScalingHigh Availability
0 likes · 7 min read
Mastering Redis High Availability: Replication, Sentinel, and Cluster Explained
Lobster Programming
Lobster Programming
Aug 3, 2026 · Databases

How to Eliminate MySQL Master‑Slave Lag: Parallel Replication, Read‑Routing, and Redis Marking

To address MySQL master‑slave replication lag, the article explains enabling parallel replication (setting slave_parallel_workers), routing reads to the master for latency‑sensitive operations, and using a Redis short‑term marker to direct recent writes to the master, while outlining configuration steps and trade‑offs.

Database LagMySQLParallel Replication
0 likes · 6 min read
How to Eliminate MySQL Master‑Slave Lag: Parallel Replication, Read‑Routing, and Redis Marking
MaGe Linux Operations
MaGe Linux Operations
Aug 1, 2026 · Databases

MySQL Replication Lag Soars to 10 seconds? Three Parallel‑Replication Tricks to Fix It

When MySQL replication latency jumps from milliseconds to 10 seconds, blindly raising replica_parallel_workers won’t help; the article walks through diagnosing the delay, then applies three concrete parallel‑replication optimizations—enabling WRITESET on the source, configuring LOGICAL_CLOCK with appropriate applier workers, and optionally preserving commit order—while showing the required SQL commands, monitoring queries, and rollback steps.

GTIDLOGICAL_CLOCKMySQL
0 likes · 21 min read
MySQL Replication Lag Soars to 10 seconds? Three Parallel‑Replication Tricks to Fix It
dbaplus Community
dbaplus Community
Jul 28, 2026 · Operations

PostgreSQL Ops Checklist: 13 Pitfalls to Avoid (2026 Edition)

The article provides a comprehensive PostgreSQL operational self‑checklist covering CPU, memory, generic plans, idle connections, autovacuum, checkpoint and bgwriter tuning, AI workload handling, index building, replication, migration, partition management, and observability, with concrete examples, benchmarks, and practical commands.

IndexingMemoryPerformance
0 likes · 39 min read
PostgreSQL Ops Checklist: 13 Pitfalls to Avoid (2026 Edition)
Raymond Ops
Raymond Ops
Jul 28, 2026 · Databases

MySQL Disk Space Explodes: How Binary Logs Become the Hidden Culprit

MySQL servers can trigger alarming disk‑space warnings even when the data directory is small, because unchecked binary logs rapidly consume storage; this article explains the log’s purpose, why it grows, how to diagnose the issue, and provides step‑by‑step cleanup, configuration, replication, monitoring, and recovery best practices.

BackupBinary LogMySQL
0 likes · 26 min read
MySQL Disk Space Explodes: How Binary Logs Become the Hidden Culprit
Subtle Storm
Subtle Storm
Jul 20, 2026 · Databases

How Database Disaster Recovery Solutions Evolve: From Tape Backups to Multi-Active Geo-Replication

The article explains why disaster‑recovery is essential for architects, defines backup versus DR, introduces RPO/RTO, examines key pitfalls such as sync‑async trade‑offs and split‑brain, compares cold, warm, hot and active‑active setups, and traces the technical evolution from manual tape copies to modern consensus‑based multi‑active geo‑replication.

DatabaseHigh AvailabilityMulti-Active
0 likes · 8 min read
How Database Disaster Recovery Solutions Evolve: From Tape Backups to Multi-Active Geo-Replication
dbaplus Community
dbaplus Community
Jul 19, 2026 · Databases

When Does MySQL Skip Writing to the Binlog? A Deep Dive into ROW‑Mode Logic and Controls

The article explains how MySQL determines whether a statement should be recorded in the binary log under ROW format, detailing the check_table_binlog_row_based function, the cached_row_logging_check flag, OPTION_BIN_LOG, and various scenarios—such as temporary tables, replication filters, no‑replicate tables, session settings, and internal operations—where binlog entries are omitted.

Binary LogMySQLROW format
0 likes · 11 min read
When Does MySQL Skip Writing to the Binlog? A Deep Dive into ROW‑Mode Logic and Controls
Raymond Ops
Raymond Ops
Jul 18, 2026 · Databases

MySQL Master‑Slave Replication: Core Architecture, GTID Setup, and Common Troubleshooting

This article provides a comprehensive, hands‑on guide to MySQL master‑slave replication, covering the underlying architecture, binlog formats, GTID and semi‑synchronous modes, detailed configuration steps, thread workflows, common failure scenarios with step‑by‑step diagnostics, and practical monitoring and failover scripts.

FailoverGTIDMySQL
0 likes · 38 min read
MySQL Master‑Slave Replication: Core Architecture, GTID Setup, and Common Troubleshooting
Ops Community
Ops Community
Jul 12, 2026 · Databases

Which MySQL Files Can Be Safely Deleted When Disk Space Is Low?

When MySQL runs out of disk space, the safest approach is to identify the full filesystem, examine data, binlog, temporary and log directories, and use SQL‑based cleanup commands like PURGE BINARY LOGS while never manually removing critical files such as ibdata1, ib_logfile* or active binlogs.

BackupInnoDBMySQL
0 likes · 16 min read
Which MySQL Files Can Be Safely Deleted When Disk Space Is Low?
Yumin Fish Harvest
Yumin Fish Harvest
Jul 7, 2026 · Databases

Redis High‑Availability Deep Dive: Master‑Slave Replication, Sentinel, and Split‑Brain Protection

This article explains why a single‑node Redis deployment is a single‑point‑of‑failure and walks through building a highly available Redis cluster using master‑slave replication, Sentinel monitoring and automatic failover, split‑brain prevention, production deployment guidelines, common pitfalls, and client‑side connection strategies.

ConfigurationDatabaseFailover
0 likes · 36 min read
Redis High‑Availability Deep Dive: Master‑Slave Replication, Sentinel, and Split‑Brain Protection
Yumin Fish Harvest
Yumin Fish Harvest
Jul 7, 2026 · Databases

Understanding Redis Persistence: RDB, AOF, Hybrid Persistence and Redis 7 Multi‑Part AOF

A power outage once erased all cached sessions, counters and leaderboards in Redis, exposing the inherent risk of in‑memory data loss and prompting a deep dive into Redis persistence mechanisms—RDB snapshots, AOF command logging, their trade‑offs, hybrid persistence, and the new Redis 7 Multi‑Part AOF design—so you can choose the right strategy for your workload.

AOFConfigurationPersistence
0 likes · 37 min read
Understanding Redis Persistence: RDB, AOF, Hybrid Persistence and Redis 7 Multi‑Part AOF
Yumin Fish Harvest
Yumin Fish Harvest
Jul 7, 2026 · Databases

Step-by-Step Redis Setup from Scratch: Docker, Docker Compose, Master‑Slave, Sentinel, and Cluster

This tutorial walks a complete beginner through launching a Redis server with Docker, managing it with Docker Compose, adding master‑slave replication, configuring Sentinel for automatic failover, building a 3‑master‑3‑replica Redis Cluster, and provides production‑grade configuration templates and an online‑deployment checklist.

BackupClusterDocker
0 likes · 40 min read
Step-by-Step Redis Setup from Scratch: Docker, Docker Compose, Master‑Slave, Sentinel, and Cluster
FunTester
FunTester
Jul 1, 2026 · Operations

When One Timeout Triggers a Platform‑Wide Outage

The article explains how unbounded retries, replication fan‑out, and naïve autoscaling can amplify a single timeout into a cascade of failures, and it proposes bounded retry policies, load‑aware scaling, and layered persistence as safeguards for reliable API‑centric systems.

AutoscalingDistributed SystemsReplication
0 likes · 12 min read
When One Timeout Triggers a Platform‑Wide Outage
Raymond Ops
Raymond Ops
Jun 28, 2026 · Databases

Comprehensive MySQL Replication Lag Troubleshooting Beyond Seconds_Behind_Master

This guide walks through a complete MySQL master‑slave lag diagnosis process, explaining why relying solely on Seconds_Behind_Master is insufficient and showing how to separate IO and SQL thread issues, examine relay logs, detect long transactions, DDL locks, and apply best‑practice configurations and monitoring.

BackupLagMySQL
0 likes · 17 min read
Comprehensive MySQL Replication Lag Troubleshooting Beyond Seconds_Behind_Master
Ops Community
Ops Community
Jun 27, 2026 · Databases

MySQL Replication Lag Too High? 3 Quick Solutions to Restore Sync

The article explains why MySQL master‑slave replication lag occurs, lists common causes, provides a five‑level troubleshooting framework, and offers three concrete recovery methods—from emergency error skipping to multi‑threaded replication and long‑term architecture improvements—plus commands, configurations, and monitoring tips.

GTIDMTSMySQL
0 likes · 27 min read
MySQL Replication Lag Too High? 3 Quick Solutions to Restore Sync
Cloud Architecture
Cloud Architecture
Jun 26, 2026 · Databases

PostgreSQL Backup & Replication Guide: WAL Basics to Production‑Ready HA, DR, and Recovery

This comprehensive guide walks through PostgreSQL's backup and replication architecture, explaining WAL fundamentals, the distinction between backup, high‑availability, disaster‑recovery and CDC, and provides step‑by‑step configurations, performance trade‑offs, monitoring queries, Kubernetes deployment tips, and practical recovery‑drill procedures for production environments.

BackupCDCHA
0 likes · 40 min read
PostgreSQL Backup & Replication Guide: WAL Basics to Production‑Ready HA, DR, and Recovery
Architect's Guide
Architect's Guide
Jun 24, 2026 · Databases

Nine Essential Aspects of Redis: A Comprehensive Technical Guide

This article provides an in‑depth technical overview of Redis, covering its single‑threaded model, core data structures, persistence options, master‑slave replication, Sentinel and cluster architectures, eviction policies, progressive rehash, skiplist implementation, bitmap usage for massive active‑user counting, and strategies for handling MySQL‑Redis write‑through consistency.

BitMapClusterData Structures
0 likes · 30 min read
Nine Essential Aspects of Redis: A Comprehensive Technical Guide
Cloud Architecture
Cloud Architecture
Jun 22, 2026 · Databases

Opening the Hood of PostgreSQL WAL: From Transaction Logs to Production‑Grade HA, Replication, and Performance Tuning

This article dissects PostgreSQL's Write‑Ahead Logging (WAL), explaining how it underpins transaction durability, replication, CDC, point‑in‑time recovery, and commit latency, and provides a step‑by‑step guide to architecture design, parameter tuning, troubleshooting, containerization, backup strategies, and operational checklists for production‑grade deployments.

BackupCDCHigh Availability
0 likes · 37 min read
Opening the Hood of PostgreSQL WAL: From Transaction Logs to Production‑Grade HA, Replication, and Performance Tuning
Architect Chen
Architect Chen
Jun 10, 2026 · Databases

12 Essential MySQL Online Commands Every DBA Should Know

This guide lists the most frequently used MySQL commands for checking version, connections, process lists, killing queries, global status, configuration variables, lock waits, slow‑query settings, table sizes, index information, execution plans, and replication status, each with practical usage scenarios.

DBADatabase AdministrationMySQL
0 likes · 5 min read
12 Essential MySQL Online Commands Every DBA Should Know
Cloud Architecture
Cloud Architecture
Jun 4, 2026 · Databases

PostgreSQL vs MySQL: The Ultimate Engineering Guide to Database Selection

This comprehensive guide compares PostgreSQL and MySQL from an engineering perspective, covering business models, transaction semantics, concurrency, replication, scalability, operational costs, real‑world case studies, and a decision matrix to help teams choose the database that minimizes long‑term complexity and cost.

MySQLPostgreSQLReplication
0 likes · 38 min read
PostgreSQL vs MySQL: The Ultimate Engineering Guide to Database Selection
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.

Database ArchitectureMaster‑SlaveMySQL
0 likes · 4 min read
Comprehensive Guide to MySQL Master‑Slave Replication (Principles, Architecture, Implementation)
Cloud Architecture
Cloud Architecture
Jun 2, 2026 · Databases

Advanced MySQL Production Practices: From Kernel Principles to High‑Concurrency Implementation

This guide presents a production‑grade MySQL playbook for senior developers, architects, and DB engineers, covering kernel internals, architecture governance, connection‑pool sizing, InnoDB tuning, index design, transaction and lock handling, replication, sharding, distributed transactions, change management, observability, security, cloud‑native deployment, and a complete best‑practice checklist.

InnoDBMySQLPerformance Tuning
0 likes · 42 min read
Advanced MySQL Production Practices: From Kernel Principles to High‑Concurrency Implementation
MaGe Linux Operations
MaGe Linux Operations
May 30, 2026 · Databases

How Ops Engineers Fix MySQL Slow Queries: A Step‑by‑Step Guide

This article walks through the entire MySQL performance troubleshooting workflow from an operations perspective, covering architecture basics, slow‑query‑log configuration, analysis with mysqldumpslow and pt‑query‑digest, EXPLAIN interpretation, index design and optimization, configuration tuning, replication monitoring, real‑time diagnostic commands, risk mitigation, rollback procedures, and backup strategies.

ConfigurationIndexingMySQL
0 likes · 40 min read
How Ops Engineers Fix MySQL Slow Queries: A Step‑by‑Step Guide
JD Tech
JD Tech
May 27, 2026 · Databases

DongSQL V1.2.0: Dual Performance and Stability Gains for Retail Databases

DongSQL V1.2.0 introduces a suite of kernel upgrades—including group‑commit unicast, semi‑sync replication tweaks, plan‑cache, single‑point query enhancements, massive‑table fast startup, SIMD acceleration, hotspot‑row updates and high‑volume testing support—delivering significant performance and stability improvements across diverse retail workloads.

Database PerformanceDongSQLHigh‑Volume Testing
0 likes · 24 min read
DongSQL V1.2.0: Dual Performance and Stability Gains for Retail Databases
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.

BackupMySQLReplication
0 likes · 34 min read
How to Safely Clean Up MySQL Binlog When Disk Space Is Critical
MaGe Linux Operations
MaGe Linux Operations
May 23, 2026 · Databases

Why MySQL Replication Lag Isn’t Just a Network Issue

The article explains MySQL master‑slave replication fundamentals, shows how to monitor replication status, enumerates common delay causes such as network latency, master write pressure, SQL thread bottlenecks, large transactions, missing primary keys, slave overload, replication conflicts and GTID quirks, and provides scripts, configuration tips, and real‑world case studies for troubleshooting and prevention.

ConfigurationLagMySQL
0 likes · 28 min read
Why MySQL Replication Lag Isn’t Just a Network Issue
samdeepthink
samdeepthink
May 8, 2026 · Backend Development

Understanding RocketMQ’s Three Reliability Checkpoints

The article breaks down RocketMQ’s end‑to‑end reliability design into three checkpoints—producer to broker, broker persistence, and consumer acknowledgment—explaining each mechanism, configuration options, common pitfalls, and practical recommendations for production deployments.

BrokerConsumerMessage Queue
0 likes · 16 min read
Understanding RocketMQ’s Three Reliability Checkpoints
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.

Crash RecoveryInnoDBMySQL
0 likes · 4 min read
What’s the Difference Between MySQL Redo Log and Binlog? (Interview Insight)
SpringMeng
SpringMeng
May 3, 2026 · Databases

Why Choose MySQL Over PostgreSQL? Key Technical Drawbacks Explained

The article compares PostgreSQL and MySQL, highlighting PostgreSQL's richer data types, extensible ecosystem, advanced replication and monitoring features, while exposing MySQL's limitations in data modeling, sequence support, tooling, and replication, and concludes that the best choice depends on specific workload requirements.

Data TypesDatabase ComparisonMVCC
0 likes · 8 min read
Why Choose MySQL Over PostgreSQL? Key Technical Drawbacks Explained
Architect Chen
Architect Chen
Apr 29, 2026 · Backend Development

The Ultimate Redis Guide: In‑Depth Overview of Architecture, Data Types, and Advanced Features

This comprehensive Redis guide covers its role as a core component in large‑scale architectures, explains common use cases, walks through installation and configuration options, details all primary data structures with commands and examples, and explores persistence, transactions, Lua scripting, replication, Sentinel, and cluster modes.

ClusterData StructuresLua Scripting
0 likes · 18 min read
The Ultimate Redis Guide: In‑Depth Overview of Architecture, Data Types, and Advanced Features
Raymond Ops
Raymond Ops
Apr 25, 2026 · Databases

How to Reduce MySQL Master‑Slave Replication Lag from 30 seconds to Milliseconds

This article walks through the root causes of MySQL master‑slave replication delay, demonstrates step‑by‑step diagnostics using SHOW SLAVE STATUS, pt‑heartbeat, and binlog comparisons, and provides concrete configuration changes, query rewrites, hardware upgrades, and monitoring scripts that can shrink lag from dozens of seconds to sub‑millisecond levels.

MySQLParallel ReplicationReplication
0 likes · 23 min read
How to Reduce MySQL Master‑Slave Replication Lag from 30 seconds to Milliseconds
IoT Full-Stack Technology
IoT Full-Stack Technology
Apr 24, 2026 · Databases

Why Choose PostgreSQL Over MySQL Despite MySQL’s Popularity?

The article compares PostgreSQL and MySQL across data types, native sequences, extensions, monitoring tools, replication mechanisms, licensing, community governance, and MVCC implementation, showing why many Chinese tech giants favor PostgreSQL for complex, high‑consistency workloads while acknowledging MySQL’s strengths in simple web scenarios.

Database ComparisonMVCCMySQL
0 likes · 9 min read
Why Choose PostgreSQL Over MySQL Despite MySQL’s Popularity?
Cloud Architecture
Cloud Architecture
Apr 17, 2026 · Databases

From Crashing Databases to Zero Data Loss: MySQL Replication Evolution

The article examines common MySQL replication failures, explains why traditional position‑based replication is insufficient, and walks through a step‑by‑step evolution from file/position to GTID, asynchronous to semi‑synchronous, single‑threaded to parallel apply, culminating in a production‑grade architecture that achieves near‑zero data loss.

BackupGTIDHigh Availability
0 likes · 35 min read
From Crashing Databases to Zero Data Loss: MySQL Replication Evolution
MaGe Linux Operations
MaGe Linux Operations
Apr 15, 2026 · Databases

Why MySQL Binary Logs Fill Up Disk Space and How to Fix It

This article explains how MySQL binary logs can rapidly consume disk space, analyzes the root causes such as log format and workload, provides step‑by‑step diagnostics, and offers practical cleanup, configuration, replication, monitoring, and recovery strategies to prevent and resolve the issue.

BackupBinary LogMySQL
0 likes · 21 min read
Why MySQL Binary Logs Fill Up Disk Space and How to Fix It
Cloud Architecture
Cloud Architecture
Apr 9, 2026 · Databases

Redis Cluster Deep Dive: Sharding, Replication, Failover & Smart Client

This article provides a comprehensive technical analysis of Redis Cluster, covering its data sharding via 16,384 hash slots, master‑slave replication, automated failover mechanisms, and the essential role of smart clients in routing, along with practical engineering guidelines and production‑grade code examples.

ClusterFailoverRedis
0 likes · 41 min read
Redis Cluster Deep Dive: Sharding, Replication, Failover & Smart Client
Cloud Architecture
Cloud Architecture
Apr 7, 2026 · Databases

MySQL Read‑Write Splitting: From Replication Basics to Production‑Ready Architecture

The article explains why simple SQL routing is insufficient for MySQL read‑write separation, details replication mechanisms, consistency challenges, and presents a comprehensive upgrade path—including static, dynamic, middleware, and hybrid routing strategies, configuration guidelines, monitoring, and high‑availability practices—to build a production‑grade, high‑concurrency architecture.

ArchitectureMySQLReplication
0 likes · 44 min read
MySQL Read‑Write Splitting: From Replication Basics to Production‑Ready Architecture
java1234
java1234
Apr 7, 2026 · Databases

Why Choose PostgreSQL Over MySQL? A Technical Comparison of Their Strengths

The article analyzes why many Chinese cloud providers and enterprises prefer PostgreSQL to MySQL, detailing PostgreSQL's richer data types, native sequence support, extensible ecosystem, advanced monitoring, robust replication, open licensing, and MVCC implementation, while acknowledging MySQL's remaining advantages in specific scenarios.

Database ComparisonLicensingMVCC
0 likes · 10 min read
Why Choose PostgreSQL Over MySQL? A Technical Comparison of Their Strengths
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.

GTIDMySQLPerformance
0 likes · 34 min read
Mastering MySQL 9.0 Replication: Deep Dive into GTID, Semi‑Sync, and Troubleshooting
Architect's Guide
Architect's Guide
Mar 29, 2026 · Databases

Why Top Chinese Tech Giants Choose PostgreSQL Over MySQL

Amid China's push for independent, cloud‑native databases, leading firms like Tencent, Alibaba, Huawei and others have built PostgreSQL‑based solutions, and this article analyzes why PostgreSQL’s richer data types, true sequence objects, extensible ecosystem, advanced replication and licensing advantages make it a preferred choice over MySQL.

Database ComparisonMySQLPostgreSQL
0 likes · 9 min read
Why Top Chinese Tech Giants Choose PostgreSQL Over MySQL
Alibaba Cloud Developer
Alibaba Cloud Developer
Mar 25, 2026 · Databases

How AliSQL AI Diagnoses and Eliminates MySQL Replication Lag

This article analyzes the severe replication‑delay issues in MySQL master‑slave setups, identifies four typical workload patterns that cause lag, demonstrates how AliSQL's AI assistant pinpoints the root causes, and explains the kernel‑level optimizations that completely remove the delay.

AI DiagnosisAliSQLDatabase
0 likes · 13 min read
How AliSQL AI Diagnoses and Eliminates MySQL Replication Lag
MaGe Linux Operations
MaGe Linux Operations
Mar 9, 2026 · Databases

How to Diagnose and Fix MySQL Replication Lag in Production

This guide explains why MySQL replication lag spikes, how to distinguish IO‑thread pull problems from SQL‑thread apply bottlenecks, provides step‑by‑step commands, configuration examples, real‑world case studies, best‑practice recommendations, and monitoring setups to reliably troubleshoot and prevent replication delays.

DatabaseLagMySQL
0 likes · 16 min read
How to Diagnose and Fix MySQL Replication Lag in Production
Ops Community
Ops Community
Mar 8, 2026 · Databases

How to Diagnose and Fix MySQL Production Performance Drops

This comprehensive guide walks you through identifying the root causes of MySQL performance degradation in production, from gathering baseline metrics and analyzing slow‑query logs to examining execution plans, tuning parameters, applying configuration changes, and verifying improvements with concrete monitoring and backup strategies.

BackupMySQLPerformance Tuning
0 likes · 30 min read
How to Diagnose and Fix MySQL Production Performance Drops
Ops Community
Ops Community
Mar 3, 2026 · Databases

Master PostgreSQL 17: Installation, Backup, Recovery, and Performance Tuning

This comprehensive guide walks you through PostgreSQL 17 deployment, explains its multi‑process architecture and MVCC model, details environment requirements, shows essential configuration parameters, provides step‑by‑step backup and PITR procedures, demonstrates streaming replication setup, and shares best‑practice tuning, security, and monitoring tips for reliable production use.

BackupDatabase AdministrationHA
0 likes · 24 min read
Master PostgreSQL 17: Installation, Backup, Recovery, and Performance Tuning
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 AdministrationGTIDMySQL
0 likes · 9 min read
Essential MySQL Replication Best Practices to Keep Your Replicas Stable
SpringMeng
SpringMeng
Feb 26, 2026 · Databases

Why Choose MySQL When PostgreSQL Offers So Many Advantages?

The article analyzes why many leading Chinese tech firms adopt PostgreSQL despite MySQL’s popularity, detailing PostgreSQL’s richer data types, native sequence support, extensible ecosystem, advanced monitoring tools, robust replication, open‑source licensing, and MVCC implementation, while also acknowledging MySQL’s strengths in simple deployment and read‑heavy workloads.

Database ComparisonMVCCMySQL
0 likes · 9 min read
Why Choose MySQL When PostgreSQL Offers So Many Advantages?
macrozheng
macrozheng
Jan 27, 2026 · Databases

Why Leading Companies Choose PostgreSQL Over MySQL: A Technical Comparison

This article compares PostgreSQL and MySQL, highlighting PostgreSQL's richer data types, native sequences, extensible ecosystem, advanced monitoring, robust replication, open licensing, and MVCC implementation, while also acknowledging MySQL's strengths in simplicity and read‑heavy web workloads.

PostgreSQLReplicationcomparison
0 likes · 9 min read
Why Leading Companies Choose PostgreSQL Over MySQL: A Technical Comparison
Ray's Galactic Tech
Ray's Galactic Tech
Jan 23, 2026 · Backend Development

How to Build a Kafka‑Level High‑Performance Message Queue from Scratch

This article presents a step‑by‑step guide to designing and implementing a Kafka‑class distributed log‑based message queue kernel, covering architecture, sequential writes, sparse indexing, zero‑copy I/O, partitioning, replication, consumer‑group metadata, batch pipelines, crash recovery, and performance benchmarks.

IndexingKafkaMessage Queue
0 likes · 7 min read
How to Build a Kafka‑Level High‑Performance Message Queue from Scratch
Ray's Galactic Tech
Ray's Galactic Tech
Jan 20, 2026 · Databases

Mastering Redis High Availability: Replication, Sentinel, and Cluster Deep Dive

This guide walks through Redis's evolution from single‑node replication to Sentinel and native Cluster, explaining each architecture's principles, configuration steps, advantages, drawbacks, performance trade‑offs, and practical deployment recommendations for building highly available and scalable caching systems.

ClusterHigh AvailabilityRedis
0 likes · 11 min read
Mastering Redis High Availability: Replication, Sentinel, and Cluster Deep Dive
java1234
java1234
Jan 20, 2026 · Databases

Why Do Some Projects Still Choose MySQL Over PostgreSQL?

The article compares PostgreSQL and MySQL, detailing PostgreSQL’s richer data types, true sequence support, extensible ecosystem, advanced monitoring and replication features, while also acknowledging MySQL’s simplicity and strong points, to help readers decide which database fits their workload best.

Database ComparisonMVCCMySQL
0 likes · 9 min read
Why Do Some Projects Still Choose MySQL Over PostgreSQL?
Architect's Tech Stack
Architect's Tech Stack
Jan 19, 2026 · Databases

Why Leading Tech Giants Prefer PostgreSQL Over MySQL: A Deep Technical Comparison

The article examines why major Chinese cloud providers and enterprises are building PostgreSQL‑based distributed, cloud‑native databases instead of MySQL, detailing PostgreSQL's richer data types, native sequence support, extensible ecosystem, advanced replication, licensing advantages, and MVCC implementation, while also noting MySQL's remaining strengths.

Data TypesDatabase ComparisonMySQL
0 likes · 10 min read
Why Leading Tech Giants Prefer PostgreSQL Over MySQL: A Deep Technical Comparison
Java Companion
Java Companion
Jan 18, 2026 · Databases

Why Choose MySQL When PostgreSQL Offers So Many Advantages?

The article compares PostgreSQL and MySQL, highlighting PostgreSQL's richer data types, true sequence support, powerful extensions, built‑in monitoring, advanced replication, open‑source licensing, and MVCC implementation, while acknowledging MySQL's strengths in quick deployment and read‑heavy workloads.

Database ComparisonMVCCMySQL
0 likes · 10 min read
Why Choose MySQL When PostgreSQL Offers So Many Advantages?
Ray's Galactic Tech
Ray's Galactic Tech
Dec 29, 2025 · Databases

Mastering PostgreSQL Backup & Replication: A Complete Enterprise Guide

An in‑depth enterprise guide explains why backup and replication are critical for PostgreSQL, compares physical, logical, and logical replication methods, provides step‑by‑step command examples, outlines high‑availability architectures, automation scripts, disaster‑recovery procedures, monitoring queries, and common pitfalls to ensure robust data protection.

High AvailabilityPostgreSQLReplication
0 likes · 8 min read
Mastering PostgreSQL Backup & Replication: A Complete Enterprise Guide
Mike Chen's Internet Architecture
Mike Chen's Internet Architecture
Dec 27, 2025 · Backend Development

Why Kafka Messages Duplicate and How to Prevent It

The article explains the main causes of duplicate Kafka messages—including producer retries, consumer offset handling, partition leader changes, and lack of idempotence—and provides practical configuration and design solutions to achieve exactly‑once delivery.

Consumer offsetMessage DuplicationReplication
0 likes · 5 min read
Why Kafka Messages Duplicate and How to Prevent It
Ray's Galactic Tech
Ray's Galactic Tech
Dec 26, 2025 · Databases

Master PostgreSQL WAL: The Ultimate Guide for DBAs and Production Ops

This comprehensive guide explains PostgreSQL's Write-Ahead Logging (WAL) fundamentals, its role in durability, crash recovery, PITR and streaming replication, details the checkpoint mechanism, essential monitoring queries, production‑grade configuration recommendations, backup and recovery procedures, and practical DBA checklists for reliable operations.

Database AdministrationPostgreSQLReplication
0 likes · 7 min read
Master PostgreSQL WAL: The Ultimate Guide for DBAs and Production Ops
Xiao Liu Lab
Xiao Liu Lab
Dec 23, 2025 · Databases

Mastering Redis Master‑Slave Replication: Core Concepts, Workflow, and Configuration

This article explains how Redis master‑slave replication provides hot backup, read‑write separation, high availability, and horizontal scaling by detailing its three‑stage workflow, full and partial synchronization mechanisms, key configuration options, and practical analogies for clear understanding.

Data synchronizationDatabaseHigh Availability
0 likes · 11 min read
Mastering Redis Master‑Slave Replication: Core Concepts, Workflow, and Configuration
Mike Chen's Internet Architecture
Mike Chen's Internet Architecture
Dec 21, 2025 · Backend Development

How Elasticsearch Scales to Billions of Queries: Sharding, Inverted Index, Distributed Execution, and Replication

Elasticsearch achieves billion‑scale search performance by combining horizontal sharding, immutable inverted‑index segments, a two‑stage distributed Query/FETCH model, and multiple replicas with a coordinator node to ensure high concurrency, scalability, and availability.

Distributed QueryElasticsearchReplication
0 likes · 4 min read
How Elasticsearch Scales to Billions of Queries: Sharding, Inverted Index, Distributed Execution, and Replication
Architect
Architect
Dec 19, 2025 · Databases

Why Leading Chinese Tech Giants Prefer PostgreSQL Over MySQL – Key Advantages Explained

The article compares PostgreSQL and MySQL, highlighting PostgreSQL's richer data types, native sequence support, powerful extensions, superior monitoring and replication features, and open‑source licensing, while also noting MySQL's simplicity and ecosystem strengths, to explain why many Chinese enterprises choose PostgreSQL for their core databases.

Database ComparisonMySQLPostgreSQL
0 likes · 9 min read
Why Leading Chinese Tech Giants Prefer PostgreSQL Over MySQL – Key Advantages Explained
Java Companion
Java Companion
Dec 16, 2025 · Databases

Why Choose PostgreSQL Over MySQL? A Detailed Feature Comparison

The article compares PostgreSQL and MySQL across data types, sequence handling, extensions, monitoring tools, replication, licensing, and MVCC implementation, showing why many Chinese tech giants prefer PostgreSQL for complex, high‑availability workloads while acknowledging MySQL’s strengths in simple web scenarios.

Database ComparisonFeature analysisMVCC
0 likes · 8 min read
Why Choose PostgreSQL Over MySQL? A Detailed Feature Comparison
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.

Database AdministrationMySQLRecovery
0 likes · 10 min read
Mastering MySQL Binlog: Complete Guide to Replication, Recovery, and Auditing
Tech Freedom Circle
Tech Freedom Circle
Nov 15, 2025 · Databases

How to Prevent Order Loss in a 100k TPS Flash Sale When the Master DB Crashes – 5 Practical Solutions

The article dissects a high‑traffic flash‑sale interview question—how to guarantee zero order loss at 100,000 TPS when the master MySQL instance fails—by explaining the underlying performance‑consistency conflict, the three skills interviewers assess, and presenting five concrete, code‑driven solutions ranging from MySQL parameter tuning to semi‑sync replication, local message tables, group replication, and Redis‑Kafka traffic shaping.

Data ConsistencyGroup ReplicationKafka
0 likes · 28 min read
How to Prevent Order Loss in a 100k TPS Flash Sale When the Master DB Crashes – 5 Practical Solutions
Ray's Galactic Tech
Ray's Galactic Tech
Nov 14, 2025 · Databases

Mastering MySQL Master‑Slave Read/Write Splitting: 4 Strategies and Real‑World Practices

This article explains MySQL master‑slave replication, why read/write splitting is essential, four practical read‑distribution strategies, the main causes of replication lag, four solutions for write‑after‑read consistency, multi‑slave allocation methods, replication modes, and a real‑world e‑commerce decision matrix, ending with a golden architecture recommendation.

Database ArchitectureMySQLReplication
0 likes · 11 min read
Mastering MySQL Master‑Slave Read/Write Splitting: 4 Strategies and Real‑World Practices
Ops Community
Ops Community
Nov 5, 2025 · Databases

Mastering PostgreSQL Replication: Diagnose Lag, Split‑Brain, and Fix Common Issues

This comprehensive guide walks you through troubleshooting PostgreSQL physical (stream) replication, covering environment prerequisites, anti‑pattern warnings, step‑by‑step diagnostics for replication lag, split‑brain scenarios, replication slot problems, monitoring setup with Prometheus, and best‑practice recommendations to keep your primary‑standby cluster healthy.

PostgreSQLReplicationTroubleshooting
0 likes · 35 min read
Mastering PostgreSQL Replication: Diagnose Lag, Split‑Brain, and Fix Common Issues
MaGe Linux Operations
MaGe Linux Operations
Nov 5, 2025 · Databases

Deploy Redis Sentinel for High Availability in 30 Minutes – Step‑by‑Step Guide

Learn how to set up Redis Sentinel for high‑availability caching, covering prerequisites, anti‑patterns, detailed configuration of master, replicas and Sentinel nodes, firewall rules, monitoring, failover testing, troubleshooting, performance tuning, backup, rollback and best practices—all achievable within a 30‑minute deployment.

FailoverHigh AvailabilityLinux
0 likes · 38 min read
Deploy Redis Sentinel for High Availability in 30 Minutes – Step‑by‑Step Guide
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.

AutomationFailoverGTID
0 likes · 23 min read
Zero Data Loss MySQL Master‑Slave Replication Lag Diagnosis & GTID Failover
Ray's Galactic Tech
Ray's Galactic Tech
Oct 29, 2025 · Databases

Master‑Slave Consistency in MySQL: 4 Proven Strategies to Eliminate Replication Lag

This article explains why MySQL master‑slave replication can fall behind, outlines common causes of data inconsistency, and presents four comprehensive solutions—including architecture tweaks, multi‑threaded replication, configuration tuning, and Percona Toolkit verification—to achieve fast, stable, and accurate data synchronization.

Database PerformanceLagMySQL
0 likes · 9 min read
Master‑Slave Consistency in MySQL: 4 Proven Strategies to Eliminate Replication Lag
DevOps Coach
DevOps Coach
Oct 11, 2025 · Databases

Uber’s PostgreSQL‑to‑MySQL Switch: Solving Index Bloat & Write Amplification

Uber migrated its core database from PostgreSQL to MySQL because PostgreSQL suffered from index bloat, write amplification, high replication overhead, and limited MVCC support, prompting a detailed analysis of each issue, the improvements in newer PostgreSQL releases, and how MySQL’s architecture addresses these challenges.

Database MigrationIndex BloatMySQL
0 likes · 12 min read
Uber’s PostgreSQL‑to‑MySQL Switch: Solving Index Bloat & Write Amplification
Mike Chen's Internet Architecture
Mike Chen's Internet Architecture
Oct 8, 2025 · Databases

Master MySQL Replication: Async, Semi‑Sync, and Full‑Sync Architectures Explained

This article outlines MySQL’s three primary replication architectures—async, semi‑sync, and full‑sync—detailing their mechanisms, typical topologies, performance trade‑offs, and suitable scenarios such as read‑heavy web services, high‑availability setups, and strict consistency requirements like financial transactions.

AsynchronousDatabase ArchitectureMySQL
0 likes · 4 min read
Master MySQL Replication: Async, Semi‑Sync, and Full‑Sync Architectures Explained
Xiaokun's Architecture Exploration Notes
Xiaokun's Architecture Exploration Notes
Sep 27, 2025 · Databases

How Version Vectors Resolve Conflicts in Multi‑Leader and Leaderless Replication

This article explains why version vectors are needed in multi‑leader and leaderless replication, describes their implementation and comparison rules, and presents practical conflict‑resolution strategies—including custom resolvers, last‑write‑wins, read‑repair, and request rejection—supported by Java pseudocode and diagrams.

Conflict ResolutionDistributed SystemsMulti-Leader
0 likes · 16 min read
How Version Vectors Resolve Conflicts in Multi‑Leader and Leaderless Replication
Raymond Ops
Raymond Ops
Sep 22, 2025 · Databases

Master‑Slave, Sentinel, and Sharding: Complete Guide to Redis Cluster Architectures

This article explains Redis’s three clustering options—master‑slave replication, Sentinel high‑availability, and sharding—detailing their architectures, setup steps, synchronization mechanisms, advantages, drawbacks, and common interview questions, helping readers choose and implement the right solution for high‑performance, scalable data storage.

ClusterHigh AvailabilityRedis
0 likes · 18 min read
Master‑Slave, Sentinel, and Sharding: Complete Guide to Redis Cluster Architectures
Raymond Ops
Raymond Ops
Sep 19, 2025 · Cloud Native

Master MySQL Replication with Kubernetes StatefulSets: A Hands‑On Guide

This tutorial walks through building a MySQL master‑slave cluster on Kubernetes using StatefulSets, covering local persistent volumes, storage classes, ConfigMaps, Secrets, Services for read‑write splitting, and step‑by‑step YAML manifests with verification commands to ensure proper replication and scaling.

MySQLReplicationlocal storage
0 likes · 18 min read
Master MySQL Replication with Kubernetes StatefulSets: A Hands‑On Guide
Architect's Guide
Architect's Guide
Sep 12, 2025 · Databases

Mastering Redis: From Basics to Advanced Caching Strategies

This article provides a comprehensive overview of Redis, covering its core concepts, features, data types, caching patterns in Spring Boot, common cache pitfalls and solutions, performance reasons, eviction policies, persistence options, replication, and Sentinel high‑availability mechanisms.

In-Memory DatabasePerformanceRedis
0 likes · 12 min read
Mastering Redis: From Basics to Advanced Caching Strategies
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.

MySQLRedo LogReplication
0 likes · 11 min read
Understanding MySQL Redo Log vs Binlog: How They Ensure Data Safety