BestHub
Sign in
Tagged articles

Replication

767 articles · Page 3 of 8
JD Cloud Developers
JD Cloud Developers
Oct 12, 2023 · Databases

How to Handle MySQL Replication Lag in Read/Write Splitting Architectures

This article explains the reasons for read/write splitting, compares direct‑client and proxy‑based master‑slave setups, and presents five practical strategies—including forcing reads to the master, sleep delays, lag checks, master‑position waiting, and GTID waiting—to mitigate stale reads caused by MySQL replication lag.

Database ArchitectureLag MitigationMaster‑Slave
0 likes · 15 min read
How to Handle MySQL Replication Lag in Read/Write Splitting Architectures
dbaplus Community
dbaplus Community
Oct 11, 2023 · Databases

Detect and Cure MySQL Replication Lag: Step‑by‑Step Guide

This article explains how to identify whether MySQL replication delay originates from the I/O thread or SQL thread, demonstrates diagnostic commands, and provides practical tips, configuration tweaks, and monitoring tools such as pt‑stalk to reduce lag and improve replication performance.

MySQLPerformanceReplication
0 likes · 11 min read
Detect and Cure MySQL Replication Lag: Step‑by‑Step Guide
Aikesheng Open Source Community
Aikesheng Open Source Community
Oct 10, 2023 · Databases

Diagnosing and Resolving MongoDB and Redis Replication Failures: Oplog Issues and Recovery Strategies

This article analyzes a MongoDB replication failure caused by missing oplog entries, compares logical initialization repair methods with Redis replication, and provides practical steps—including oplog size adjustment and snapshot techniques—to restore synchronization and prevent similar issues in production environments.

Database RecoveryLogical InitializationMongoDB
0 likes · 9 min read
Diagnosing and Resolving MongoDB and Redis Replication Failures: Oplog Issues and Recovery Strategies
Selected Java Interview Questions
Selected Java Interview Questions
Sep 27, 2023 · Databases

Understanding MySQL Binlog and Its Business Applications

This article explains MySQL's binlog as a binary log for recording data changes and master‑slave replication, then explores how parsing binlog can enable data heterogeneity, cache consistency, and task distribution, highlighting its role in building middleware solutions for backend systems.

Data synchronizationDatabaseReplication
0 likes · 5 min read
Understanding MySQL Binlog and Its Business Applications
360 Smart Cloud
360 Smart Cloud
Sep 13, 2023 · Backend Development

Introduction to Apache Pulsar Architecture and Features

This article introduces Apache Pulsar, an open‑source cloud‑native distributed messaging platform, detailing its storage‑compute separation architecture, multi‑tenant support, load balancing, fault tolerance, schema handling, functions, IO connectors, tiered storage, cross‑region replication, and operational commands for managing brokers, bookies, and namespaces.

Apache PulsarMessage QueueMulti-Tenancy
0 likes · 20 min read
Introduction to Apache Pulsar Architecture and Features
Efficient Ops
Efficient Ops
Sep 10, 2023 · Backend Development

Why Redis Is So Fast and How to Avoid Common Caching Pitfalls

This article introduces Redis as a high‑performance in‑memory key‑value store, explains its core features, data types, caching usage in Spring Boot, and discusses common cache problems such as consistency, avalanche, penetration, and breakdown along with mitigation strategies, plus details on persistence, replication, and Sentinel.

CachingPerformancePersistence
0 likes · 10 min read
Why Redis Is So Fast and How to Avoid Common Caching Pitfalls
Aikesheng Open Source Community
Aikesheng Open Source Community
Sep 4, 2023 · Databases

Observability of MySQL 8 Replication Using Performance Schema and Sys Schema Views

The article explains how MySQL 8 enhances replication observability by exposing detailed metrics through Performance Schema tables and sys schema views, providing DBAs with richer information such as per‑channel lag, worker thread states, and full replication status beyond the traditional SHOW REPLICA STATUS output.

InnoDB ClusterMySQLObservability
0 likes · 14 min read
Observability of MySQL 8 Replication Using Performance Schema and Sys Schema Views
Su San Talks Tech
Su San Talks Tech
Sep 4, 2023 · Databases

Master MySQL Interview Essentials: 43 Key Topics Explained

This comprehensive guide consolidates 43 essential MySQL interview topics—from normalization, storage engines, and indexing to transaction handling, logging, replication, and performance tuning—providing clear explanations, code examples, and diagrams to help candidates quickly master the core concepts.

Database InterviewMySQLReplication
0 likes · 37 min read
Master MySQL Interview Essentials: 43 Key Topics Explained
dbaplus Community
dbaplus Community
Aug 30, 2023 · Databases

How to Build a Stable, High‑Performance Redis Cluster from Scratch

This guide walks through the evolution of a Redis deployment—from a single‑node cache, through data persistence options, master‑slave replication, Sentinel automatic failover, and finally sharding with Redis Cluster—explaining each technique, its trade‑offs, and practical implementation steps.

ClusteringPersistenceReplication
0 likes · 18 min read
How to Build a Stable, High‑Performance Redis Cluster from Scratch
Aikesheng Open Source Community
Aikesheng Open Source Community
Aug 28, 2023 · Databases

MySQL InnoDB Cluster Read Replicas: Adding, Configuring, and Managing Read‑Only Nodes

This article explains how MySQL InnoDB Cluster 8.1 introduces read‑only replica instances, shows step‑by‑step commands to create and configure them, describes their failover behavior, routing options with MySQL Router, health‑check isolation, replication‑lag handling, and how to hide replicas from traffic.

DatabaseHigh AvailabilityInnoDB Cluster
0 likes · 17 min read
MySQL InnoDB Cluster Read Replicas: Adding, Configuring, and Managing Read‑Only Nodes
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.

High AvailabilityMySQLParallel Replication
0 likes · 30 min read
Deep Dive into MySQL Replication: Mechanisms, Performance, and Real‑World Optimizations
Aikesheng Open Source Community
Aikesheng Open Source Community
Aug 15, 2023 · Databases

Root Cause Analysis of MySQL Replication Error 1590 Caused by INCIDENT_EVENT During Partial Permission Changes

The article analyzes a MySQL 5.7 replication failure where the slave SQL thread stops with error 1590 because the master writes an INCIDENT_EVENT to the binlog when a GRANT or CREATE USER statement partially succeeds due to password‑validation plugin constraints, leading to replication breakage.

DatabaseIncident EventMySQL
0 likes · 11 min read
Root Cause Analysis of MySQL Replication Error 1590 Caused by INCIDENT_EVENT During Partial Permission Changes
Aikesheng Open Source Community
Aikesheng Open Source Community
Aug 1, 2023 · Databases

Comparison of MySQL stop slave/reset slave Commands with OceanBase Equivalents and Experimental Analysis

This article examines the differences between MySQL's stop slave and reset slave all commands and OceanBase's replication controls, presenting experimental results that show how clog synchronization affects cluster availability, data consistency, and the procedures for decoupling standby clusters.

MySQLOceanBaseReplication
0 likes · 8 min read
Comparison of MySQL stop slave/reset slave Commands with OceanBase Equivalents and Experimental Analysis
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.

Database LagMaster‑SlaveMySQL
0 likes · 14 min read
Master‑Slave Replication in MySQL: Binlog Mechanics, Parallel Replication & Lag Reduction
ITPUB
ITPUB
Jul 22, 2023 · Databases

What’s New in MySQL 8.1 and 8.0.34? Key Features, Changes, and Deprecations

MySQL 8.1 and 8.0.34, released on July 18, 2023, introduce a mix of innovative features—such as JSON EXPLAIN INTO, enhanced replication controls, TLS certificate enforcement, and new SHOW PARSE_TREE—while also aligning many adjustments with 8.0.34, adding user‑management options, audit enhancements, binary‑log APIs, and a series of deprecations for future versions.

Database FeaturesMySQLReplication
0 likes · 8 min read
What’s New in MySQL 8.1 and 8.0.34? Key Features, Changes, and Deprecations
dbaplus Community
dbaplus Community
Jul 19, 2023 · Databases

What’s New in MySQL 8.1 & 8.0.34? Key Features and Changes Explained

MySQL 8.1, the first innovation release, and the stable 8.0.34 bring a host of new capabilities—including JSON‑based EXPLAIN INTO, enhanced replication controls, expanded security variables, audit improvements, binary‑log functions, and several deprecations—while also fixing numerous bugs to solidify MySQL’s stability.

MySQLNewFeaturesReplication
0 likes · 9 min read
What’s New in MySQL 8.1 & 8.0.34? Key Features and Changes Explained
Top Architect
Top Architect
Jul 18, 2023 · Fundamentals

Comprehensive Introduction to Elasticsearch: Core Concepts, Architecture, and Practical Usage

This article provides a detailed overview of Elasticsearch, covering its underlying Lucene technology, data types, indexing mechanisms, cluster architecture, shard and replica management, mapping definitions, installation steps, health monitoring, write and storage processes, and performance optimization techniques for production deployments.

ElasticsearchIndexingLucene
0 likes · 36 min read
Comprehensive Introduction to Elasticsearch: Core Concepts, Architecture, and Practical Usage
Architect
Architect
Jul 14, 2023 · Databases

From Single‑Node to Scalable Redis Cluster: A Step‑by‑Step Architecture Guide

This article walks through Redis's evolution from a simple single‑instance cache to a highly available, high‑performance cluster, explaining persistence mechanisms (RDB, AOF, hybrid), master‑slave replication, Sentinel automatic failover, and sharding strategies with concrete examples and trade‑offs.

ClusteringDatabase ArchitectureHigh Availability
0 likes · 20 min read
From Single‑Node to Scalable Redis Cluster: A Step‑by‑Step Architecture Guide
Aikesheng Open Source Community
Aikesheng Open Source Community
Jul 5, 2023 · Databases

Understanding MySQL Event Scheduler and Why Its Connections Cannot Be Killed During Master‑Slave Switch

This article explains the MySQL event_scheduler thread, why killing it during master‑slave failover produces an "Unknown thread id" warning in MySQL 8.0, how to manage events, and the impact of these internal daemon sessions on replication and failover processes.

Database AdministrationEvent SchedulerMaster-Slave Switch
0 likes · 15 min read
Understanding MySQL Event Scheduler and Why Its Connections Cannot Be Killed During Master‑Slave Switch
Alibaba Cloud Native
Alibaba Cloud Native
Jun 26, 2023 · Cloud Native

How RocketMQ Evolved Its High‑Availability Architecture for Cloud‑Native Deployments

This article examines RocketMQ's high‑availability evolution—from early master‑slave and Raft‑based designs to the v5 DLedger fusion model—detailing replica groups, data sharding, election mechanisms, replication strategies, metric trade‑offs, log‑divergence handling, controller roles, heartbeat optimizations, and comparisons with Kafka and Pulsar, all illustrated with diagrams and code snippets.

Cloud NativeDLedgerHigh Availability
0 likes · 36 min read
How RocketMQ Evolved Its High‑Availability Architecture for Cloud‑Native Deployments
JD Tech
JD Tech
Jun 16, 2023 · Big Data

Comprehensive Introduction to Apache Kafka: Architecture, Features, and Best Practices

This article provides a detailed overview of Apache Kafka, covering its distributed streaming architecture, storage mechanisms, replication, consumer groups, compression techniques, exactly‑once semantics, configuration tips, and performance optimizations for building reliable high‑throughput data pipelines.

Big DataDistributed StreamingKafka
0 likes · 19 min read
Comprehensive Introduction to Apache Kafka: Architecture, Features, and Best Practices
FunTester
FunTester
Jun 13, 2023 · Databases

Understanding Redis: Core Concepts, Persistence, Replication, Sentinel Failover, and Cluster Sharding

Redis is an open‑source, in‑memory key‑value store written in C that uses hash tables, various data structures, and a single‑threaded event loop to achieve high performance, and this article explains its basic types, persistence mechanisms (AOF and RDB), replication, sentinel failover, and cluster sharding.

ClusterIn-Memory DatabasePersistence
0 likes · 26 min read
Understanding Redis: Core Concepts, Persistence, Replication, Sentinel Failover, and Cluster Sharding
Ops Development Stories
Ops Development Stories
May 15, 2023 · Databases

Unlocking Redis: Deep Dive into Data Structures, Persistence, and High Availability

This comprehensive guide explains Redis fundamentals, covering NoSQL basics, the five core data types and their internal storage mechanisms, persistence options (RDB and AOF), replication, Sentinel failover, publish/subscribe patterns, and common cache pitfalls such as penetration, breakdown, and avalanche, providing practical insights for developers and architects.

CacheData StructuresNoSQL
0 likes · 54 min read
Unlocking Redis: Deep Dive into Data Structures, Persistence, and High Availability
Architects Research Society
Architects Research Society
May 6, 2023 · Databases

Understanding Eventual Consistency in Apache CouchDB

This article explains how Apache CouchDB achieves eventual consistency through its MVCC architecture, CAP theorem trade‑offs, incremental replication, and document‑level versioning, illustrating concepts such as local consistency, conflict resolution, and practical use‑cases for building scalable distributed systems.

CouchDBMVCCReplication
0 likes · 21 min read
Understanding Eventual Consistency in Apache CouchDB
dbaplus Community
dbaplus Community
May 2, 2023 · Databases

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

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

Group CommitMySQLParallel Replication
0 likes · 17 min read
How MySQL Parallel Replication Cuts Slave Lag: Group Commit, Lock‑Based & WRITESET Explained
21CTO
21CTO
Apr 25, 2023 · Databases

How Baidu’s PegaDB Redefines Redis with Low‑Cost, High‑Capacity KV Storage

This article summarizes Liu Donghui’s presentation at DTCC2022, detailing Baidu Intelligent Cloud’s Redis‑compatible, high‑capacity, low‑cost PegaDB, covering its design goals, architecture, KV storage engine choices, cluster scaling, replication enhancements, performance optimizations, multi‑region active‑active support, and future roadmap.

KV storagePegaDBReplication
0 likes · 17 min read
How Baidu’s PegaDB Redefines Redis with Low‑Cost, High‑Capacity KV Storage
Tencent Cloud Middleware
Tencent Cloud Middleware
Apr 25, 2023 · Big Data

How to Achieve High Availability for Kafka Across Data Centers: Architectures, Trade‑offs, and Solutions

This article explains Kafka's cross‑data‑center high‑availability options, compares stretched and connected cluster designs, outlines typical failure scenarios, and reviews both community and commercial replication solutions, helping architects choose the most suitable deployment for their specific requirements.

Connected ClusterCross‑Data‑CenterHigh Availability
0 likes · 24 min read
How to Achieve High Availability for Kafka Across Data Centers: Architectures, Trade‑offs, and Solutions
Architecture Digest
Architecture Digest
Apr 23, 2023 · Backend Development

Kafka Core Concepts, Architecture, Performance Optimizations, and Production Deployment Guide

This article provides a comprehensive technical overview of Kafka, covering its core message‑queue value, architecture components such as producers, consumers, topics, partitions and replication, high‑performance mechanisms like zero‑copy and OS cache, resource planning for disks, memory, CPU and network, operational tools and commands, consumer‑group management, rebalance strategies, and internal scheduling mechanisms such as the time‑wheel.

Backend ArchitectureKafkaMessage Queue
0 likes · 30 min read
Kafka Core Concepts, Architecture, Performance Optimizations, and Production Deployment Guide
Efficient Ops
Efficient Ops
Apr 18, 2023 · Databases

Mastering MongoDB Clusters: Setup, Monitoring, Migration, and Optimization

This comprehensive guide explains MongoDB cluster architecture, component roles, common use cases, monitoring commands, essential maintenance operations, data migration steps, troubleshooting of typical production issues, and practical optimization recommendations for high‑performance deployments.

ClusterMongoDBMonitoring
0 likes · 20 min read
Mastering MongoDB Clusters: Setup, Monitoring, Migration, and Optimization
Architecture Digest
Architecture Digest
Apr 11, 2023 · Databases

Understanding MySQL Replication: Principles, Mechanisms, and Practical Applications

This article explains MySQL replication’s background, binlog formats, event types, positioning methods, asynchronous and semi‑synchronous workflows, parallel replication techniques, and real‑world deployment strategies such as HA components, middleware, remote binlog copying, and data‑transfer services, providing a comprehensive guide for building highly available and scalable MySQL infrastructures.

DatabaseHigh AvailabilityMySQL
0 likes · 26 min read
Understanding MySQL Replication: Principles, Mechanisms, and Practical Applications
vivo Internet Technology
vivo Internet Technology
Apr 5, 2023 · Databases

Understanding MySQL Replication: Principles, Mechanisms, and Practical Applications

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

Data ReliabilityGTIDMySQL
0 likes · 30 min read
Understanding MySQL Replication: Principles, Mechanisms, and Practical Applications
ITPUB
ITPUB
Apr 4, 2023 · Databases

Mastering MySQL Replication: Principles, Lag Fixes, and Failover Strategies

This article explains MySQL master‑slave replication fundamentals, the binlog‑based data flow, common consistency and latency problems, practical solutions such as row or mixed binlog formats, caching and query routing, and the trade‑offs of one‑master‑one‑slave versus one‑master‑many‑slaves architectures.

Database PerformanceMaster‑SlaveMySQL
0 likes · 11 min read
Mastering MySQL Replication: Principles, Lag Fixes, and Failover Strategies
IT Services Circle
IT Services Circle
Apr 2, 2023 · Databases

Understanding MySQL Master‑Slave Replication: Principles, Lag, and Failover

This article explains MySQL master‑slave replication, covering its architecture, binlog‑based replication process, causes and mitigation of replication lag, and strategies for master‑slave failover, helping readers grasp why and how to use replication for read/write separation, high availability, and backup.

DatabaseHigh AvailabilityMaster‑Slave
0 likes · 12 min read
Understanding MySQL Master‑Slave Replication: Principles, Lag, and Failover
IT Architects Alliance
IT Architects Alliance
Mar 28, 2023 · Big Data

Kafka Core Concepts, Architecture, Performance Optimization, and Production Deployment Guide

This comprehensive guide explains Kafka's core value as a message queue, its fundamental concepts, cluster architecture, high‑performance data handling, resource planning for large‑scale deployments, operational tools, consumer‑group mechanics, offset management, rebalance strategies, and custom partitioner implementation.

PerformanceReplicationStreaming
0 likes · 29 min read
Kafka Core Concepts, Architecture, Performance Optimization, and Production Deployment Guide
ITPUB
ITPUB
Mar 26, 2023 · Databases

Why a Missing mysql-bin.index Crashed MySQL HA and How to Recover It

A detailed post‑mortem of a MySQL dual‑master cluster failure caused by a missing mysql-bin.index file, showing step‑by‑step diagnostics, container logs, replication position fixes, and preventive measures for high‑availability deployments.

Binary LogKeepalivedMySQL
0 likes · 8 min read
Why a Missing mysql-bin.index Crashed MySQL HA and How to Recover It
Aikesheng Open Source Community
Aikesheng Open Source Community
Mar 21, 2023 · Databases

MySQL 8.0 New Features: Performance, Security, Optimizer, and Other Enhancements

This article provides a comprehensive overview of MySQL 8.0 enhancements, covering performance improvements such as contention‑aware scheduling and hash joins, security upgrades including authentication plugins and password policies, optimizer refinements, and various other features like persistent variables, GIS support, and binlog expiration handling.

Hash JoinMySQLOptimizer
0 likes · 16 min read
MySQL 8.0 New Features: Performance, Security, Optimizer, and Other Enhancements
dbaplus Community
dbaplus Community
Mar 15, 2023 · Backend Development

How to Prevent Message Loss in Kafka: Practical Tips and Configurations

This guide explains why message queues are introduced for decoupling and traffic control, identifies three key areas where message loss can occur—in producers, brokers, and consumers—and provides concrete Kafka configurations, monitoring practices, and operational steps to ensure reliable, loss‑free message delivery.

Consumer MonitoringKafkaMessage Loss
0 likes · 12 min read
How to Prevent Message Loss in Kafka: Practical Tips and Configurations
ITPUB
ITPUB
Mar 8, 2023 · Databases

Mastering Redis Cluster: Deep Dive into Sharding, Failover, and Scaling

This article provides a comprehensive guide to Redis Cluster, covering its sharding mechanism, hash slot mapping, replication and automatic failover, client data location, slot reassignment, MOVED/ASK redirection, communication overhead, and practical tuning tips for large‑scale deployments.

ClusterFailoverRedis
0 likes · 20 min read
Mastering Redis Cluster: Deep Dive into Sharding, Failover, and Scaling
DevOps Operations Practice
DevOps Operations Practice
Feb 28, 2023 · Databases

Understanding Redis: NoSQL Basics, Data Types, Persistence, Replication, Sentinel and Cache Issues

This article provides a comprehensive overview of Redis as a NoSQL in‑memory database, covering its core data structures, special types, transaction model, RDB and AOF persistence, publish/subscribe, master‑slave replication, Sentinel failover, and common cache pitfalls such as penetration, breakdown and avalanche, with practical mitigation strategies.

CachingDatabasesNoSQL
0 likes · 45 min read
Understanding Redis: NoSQL Basics, Data Types, Persistence, Replication, Sentinel and Cache Issues
dbaplus Community
dbaplus Community
Feb 26, 2023 · Backend Development

Why Redis Is More Than a Cache: Architecture, Persistence, and Scaling Explained

This article provides a comprehensive overview of Redis, covering its role as an in‑memory data‑structure server, various deployment topologies such as single instances, high‑availability, Sentinel, replication, and clustering, as well as its persistence mechanisms including RDB, AOF, and fork‑based snapshots.

CachingClusterHigh Availability
0 likes · 17 min read
Why Redis Is More Than a Cache: Architecture, Persistence, and Scaling Explained
ITPUB
ITPUB
Feb 18, 2023 · Databases

Why MySQL Unique Index Fails with unique_checks=0 and How to Resolve It

In MySQL 5.7 replication, disabling unique_checks can cause duplicate‑key errors on a unique index that is not a primary key, leading to replication stalls, and this guide explains the root cause, temporary and permanent fixes, and step‑by‑step reproduction instructions.

MySQLReplicationUnique Index
0 likes · 7 min read
Why MySQL Unique Index Fails with unique_checks=0 and How to Resolve It
Tencent Cloud Developer
Tencent Cloud Developer
Feb 15, 2023 · Databases

How to Build a Stable, High‑Performance Redis Cluster: Persistence, Replication, Sentinel and Sharding

This guide walks developers through transforming a single‑node Redis cache into a stable, high‑performance cluster by explaining data persistence options (RDB, AOF, hybrid), master‑slave replication, Sentinel‑driven automatic failover, and both client‑side and proxy‑based sharding for horizontal scalability.

ClusterPersistenceRedis
0 likes · 17 min read
How to Build a Stable, High‑Performance Redis Cluster: Persistence, Replication, Sentinel and Sharding
Shepherd Advanced Notes
Shepherd Advanced Notes
Feb 13, 2023 · Backend Development

Elasticsearch Advanced Guide: Core Concepts and Implementation Principles

This article provides a comprehensive technical overview of Elasticsearch, covering core concepts such as indexes, types, documents, fields, mappings, shards and replicas, the cluster architecture, routing, write and read workflows, segment handling, translog, refresh and flush mechanisms, as well as practical optimization recommendations for hardware, shard strategy, routing, write performance and memory configuration.

Cluster ArchitectureElasticsearchIndexing
0 likes · 36 min read
Elasticsearch Advanced Guide: Core Concepts and Implementation Principles
JD Tech
JD Tech
Feb 9, 2023 · Databases

Understanding MySQL Master‑Slave Replication: Overview, Benefits, Mechanisms, and Consistency Solutions

This article explains MySQL master‑slave replication, covering its basic concepts, the advantages of read‑write separation, data backup and high availability, the underlying binlog‑based mechanism, the four replication modes (full, asynchronous, semi‑synchronous, enhanced semi‑synchronous), common consistency challenges, and practical ways to mitigate them.

Data ConsistencyMaster‑SlaveMySQL
0 likes · 18 min read
Understanding MySQL Master‑Slave Replication: Overview, Benefits, Mechanisms, and Consistency Solutions
Top Architect
Top Architect
Jan 12, 2023 · Databases

MySQL Master‑Slave Replication, Binlog/Redo Log Basics, and Sharding‑JDBC Read‑Write Splitting & Sharding Implementation

This article provides a comprehensive tutorial on configuring MySQL master‑slave replication with Docker, explains the roles of binlog and redo log, describes two‑phase commit, and demonstrates how to use Sharding‑JDBC (ShardingSphere) for read‑write splitting and horizontal sharding in a Spring Boot application, complete with configuration files and code examples.

DatabaseJavaMySQL
0 likes · 24 min read
MySQL Master‑Slave Replication, Binlog/Redo Log Basics, and Sharding‑JDBC Read‑Write Splitting & Sharding Implementation
Efficient Ops
Efficient Ops
Jan 10, 2023 · Big Data

Why a Single Kafka Broker Failure Can Halt All Consumers – Deep Dive into HA

This article explains Kafka's multi‑replica design, ISR mechanism, leader election rules, and producer acknowledgment settings, then shows how the built‑in __consumer_offset topic with a single replica can cause a whole cluster to become unavailable when one broker crashes, and offers practical fixes.

Consumer OffsetsHigh AvailabilityISR
0 likes · 9 min read
Why a Single Kafka Broker Failure Can Halt All Consumers – Deep Dive into HA
Top Architect
Top Architect
Jan 8, 2023 · Databases

Understanding Redis: Architecture, Deployment Options, Persistence Models, and High Availability

This article provides a comprehensive overview of Redis, covering its definition as an in‑memory data structure server, various deployment topologies such as single instance, high‑availability, Sentinel, and Cluster, as well as detailed explanations of persistence mechanisms, forking, replication, and practical considerations for scaling and reliability.

CachingClusterDatabase
0 likes · 18 min read
Understanding Redis: Architecture, Deployment Options, Persistence Models, and High Availability
Aikesheng Open Source Community
Aikesheng Open Source Community
Dec 26, 2022 · Databases

MySQL Replication Delay Analysis and Troubleshooting for Large Transactions

The article describes a MySQL 5.7.31 replication delay where Seconds_Behind_Master fluctuates between 0 and over 10,000 seconds, analyzes root causes such as single‑threaded replication, large or long‑running transactions, and provides preventive, diagnostic, and remediation steps including enabling parallel replication and using the infobin tool.

DatabaseLarge TransactionsMySQL
0 likes · 10 min read
MySQL Replication Delay Analysis and Troubleshooting for Large Transactions
Mike Chen's Internet Architecture
Mike Chen's Internet Architecture
Dec 20, 2022 · Databases

Detailed Explanation of Redis Three Cluster Modes: Master‑Slave Replication, Sentinel, and Cluster

This article explains Redis's three clustering approaches—master‑slave replication, Sentinel, and native Cluster—detailing their architectures, replication mechanisms, advantages, disadvantages, and suitable scenarios for high‑availability and high‑concurrency database deployments.

ClusteringDatabaseHigh Availability
0 likes · 5 min read
Detailed Explanation of Redis Three Cluster Modes: Master‑Slave Replication, Sentinel, and Cluster
Efficient Ops
Efficient Ops
Dec 13, 2022 · Databases

How ClickHouse Replicates MySQL in Real-Time: A Step-by-Step Guide

This article explains how to configure ClickHouse as a MySQL replica using the MaterializeMySQL engine, covering code acquisition, MySQL master setup, ClickHouse slave configuration, handling of delete and update operations, and the underlying replication mechanism with practical code examples.

ClickHouseDatabase SyncMaterializeMySQL
0 likes · 10 min read
How ClickHouse Replicates MySQL in Real-Time: A Step-by-Step Guide
Aikesheng Open Source Community
Aikesheng Open Source Community
Nov 24, 2022 · Databases

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

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

FailoverGTIDMySQL
0 likes · 22 min read
Understanding Orchestrator's RegroupReplicasGTID and Candidate Replica Selection in MySQL Failover
Aikesheng Open Source Community
Aikesheng Open Source Community
Nov 17, 2022 · Databases

DeadMaster Recovery Process in Orchestrator

This article explains the complete DeadMaster recovery workflow of Orchestrator, detailing how the system selects the appropriate check‑and‑recover function, handles emergency grace periods, reads topology information, registers recovery attempts, validates promotion constraints, executes the actual failover, and runs post‑recovery hooks, with extensive Go code examples.

FailoverGoMySQL
0 likes · 18 min read
DeadMaster Recovery Process in Orchestrator
Tencent Cloud Developer
Tencent Cloud Developer
Nov 11, 2022 · Databases

How KeeWiDB Solves Redis’s Memory Cost with Tiered Storage & Async I/O

KeeWiDB, a next‑generation distributed KV store from Tencent Cloud, combines a proxy layer, multi‑node service layer, tiered hot‑cold data placement, multi‑threaded and coroutine‑based processing, persistent memory caching, direct I/O, and enhanced replication to address Redis’s memory cost, scalability, and latency challenges.

Async IOKV storeReplication
0 likes · 18 min read
How KeeWiDB Solves Redis’s Memory Cost with Tiered Storage & Async I/O
Aikesheng Open Source Community
Aikesheng Open Source Community
Nov 7, 2022 · Databases

Orchestrator Failover Process Source Code Analysis – Simulating Faults and Understanding ContinuousDiscovery

This article walks through a simulated MySQL 3307 cluster failure, examines Orchestrator's source code to explain the ContinuousDiscovery loop, discovery queues, health ticks, caretaking tasks, raft coordination, topology snapshots, and the logic distinguishing UnreachableMaster from DeadMaster states.

ContinuousDiscoveryDatabase HAFailover
0 likes · 20 min read
Orchestrator Failover Process Source Code Analysis – Simulating Faults and Understanding ContinuousDiscovery
DeWu Technology
DeWu Technology
Oct 31, 2022 · Databases

Analysis of Order Query Failures Caused by MySQL Master‑Slave Replication Lag and Mitigation Strategies

The e‑commerce platform’s order‑query alerts were caused by MySQL master‑slave replication lag—specifically, delayed redo‑log flushing let the slave receive binlog events before the master committed—so queries returned empty, a condition mitigated by retry logic, delayed MQ delivery, or emitting post‑commit business events.

DatabaseMaster‑SlaveMySQL
0 likes · 10 min read
Analysis of Order Query Failures Caused by MySQL Master‑Slave Replication Lag and Mitigation Strategies
Top Architect
Top Architect
Oct 19, 2022 · Databases

MySQL Replication, High Availability, and Sharding: Concepts and Solutions

This article explains the evolution from single‑node MySQL databases to master‑slave replication, various replication modes, high‑availability strategies, and both vertical and horizontal sharding techniques, while discussing the associated challenges such as distributed transactions, routing, and operational complexity.

Database ScalingDistributed TransactionsHigh Availability
0 likes · 11 min read
MySQL Replication, High Availability, and Sharding: Concepts and Solutions
Architect's Guide
Architect's Guide
Oct 19, 2022 · Databases

Database Scaling, Replication, High Availability, and Sharding Overview

This article explains why single‑node databases cannot keep up with rapid business growth and describes MySQL replication methods, high‑availability solutions such as MHA and MGR, and the challenges and techniques of vertical and horizontal sharding for large‑scale systems.

Database ScalingHigh AvailabilityMySQL
0 likes · 11 min read
Database Scaling, Replication, High Availability, and Sharding Overview
Tencent Cloud Developer
Tencent Cloud Developer
Sep 26, 2022 · Big Data

Kafka Architecture Overview and Core Concepts

Kafka’s architecture consists of brokers forming clusters, producers publishing to topics split into partitions with replicas, consumers organized in groups pulling messages by offset, ZooKeeper managing metadata, and log‑based storage using append‑only files, indexes, and zero‑copy, while configurable acknowledgment, batching, and replication ensure high throughput and fault‑tolerant reliability.

ConsumerKafkaProducer
0 likes · 18 min read
Kafka Architecture Overview and Core Concepts
Top Architect
Top Architect
Sep 15, 2022 · Databases

Understanding Redis Master‑Slave Replication: Principles, Configuration, Workflow, and Common Pitfalls

This article explains the CAP theorem, details how Redis implements master‑slave replication—including its asynchronous nature, configuration methods, three‑phase workflow, heartbeat mechanism, and common operational issues—providing practical guidance for building highly available Redis deployments.

CAP theoryMaster‑SlaveRedis
0 likes · 16 min read
Understanding Redis Master‑Slave Replication: Principles, Configuration, Workflow, and Common Pitfalls
ITFLY8 Architecture Home
ITFLY8 Architecture Home
Sep 14, 2022 · Databases

Master MySQL: 3 Normal Forms, Engine Differences, Indexing, Transactions & More

This comprehensive guide covers MySQL fundamentals such as the three normal forms, differences between MyISAM and InnoDB, redo log versus binlog, when queries bypass indexes, join types, various index structures, covering indexes, back‑row lookups, transaction properties and isolation levels, common performance bottlenecks, replication mechanics, lag mitigation, storage behavior after deletes, VARCHAR limits, lock types, systematic SQL tuning steps, the purpose and trade‑offs of indexes, B+‑tree advantages, MVCC internals, and the Snowflake distributed ID algorithm.

IndexingMySQLReplication
0 likes · 24 min read
Master MySQL: 3 Normal Forms, Engine Differences, Indexing, Transactions & More
Java Backend Technology
Java Backend Technology
Sep 13, 2022 · Databases

Master‑Slave MySQL Replication & Read‑Write Splitting with ShardingJDBC: A Step‑by‑Step Guide

This article explains why a single MySQL instance can become a bottleneck, introduces asynchronous master‑slave replication using binary logs, provides detailed configuration commands for both master and slave servers, and shows how to achieve read‑write splitting in Java projects with ShardingJDBC, including dependency setup, YAML configuration, and testing procedures.

DatabaseMySQLReplication
0 likes · 11 min read
Master‑Slave MySQL Replication & Read‑Write Splitting with ShardingJDBC: A Step‑by‑Step Guide
Architecture Digest
Architecture Digest
Sep 9, 2022 · Databases

MySQL Replication, High Availability, and Sharding Strategies

This article explains the evolution from single‑node MySQL to master‑slave replication, various replication modes, high‑availability solutions such as MHA and MGR, and the challenges and techniques of vertical and horizontal sharding for scaling large‑scale internet applications.

Database ScalingDistributed TransactionsMySQL
0 likes · 12 min read
MySQL Replication, High Availability, and Sharding Strategies
IT Architects Alliance
IT Architects Alliance
Sep 4, 2022 · Databases

Mastering MySQL: From Replication to High Availability and Sharding Strategies

This article examines why single-node databases no longer meet modern internet workloads, explores MySQL replication models (master‑slave, asynchronous, semi‑synchronous, group replication), discusses high‑availability solutions such as MHA, MGR and Orchestrator, and outlines vertical and horizontal sharding techniques along with their trade‑offs.

Database ArchitectureHigh AvailabilityMGR
0 likes · 13 min read
Mastering MySQL: From Replication to High Availability and Sharding Strategies
Programmer DD
Programmer DD
Sep 2, 2022 · Databases

Unlock MySQL Binlog: Powering Replication and Real‑World Business Use Cases

This article explains MySQL’s binlog, how it enables master‑slave replication, and explores three practical business uses—data heterogeneity, cache synchronization, and task dispatch—showing how a middleware that pretends to be a slave can leverage binlog events to improve system architecture and performance.

CachingData synchronizationMiddleware
0 likes · 7 min read
Unlock MySQL Binlog: Powering Replication and Real‑World Business Use Cases
dbaplus Community
dbaplus Community
Aug 24, 2022 · Databases

Mastering SQL Server: Essential Commands, Advanced Queries, and Maintenance Techniques

This guide compiles fundamental SQL Server commands for creating, modifying, and deleting databases and tables, advanced query operators, join strategies, pagination, data synchronization, performance tuning, backup and restore procedures, and useful built‑in functions, providing a comprehensive reference for database professionals.

DatabaseReplicationSQL Commands
0 likes · 27 min read
Mastering SQL Server: Essential Commands, Advanced Queries, and Maintenance Techniques
Top Architect
Top Architect
Aug 20, 2022 · Databases

Comprehensive SQL Server Cheat Sheet: Commands, Queries, and Administration Tips

An extensive collection of SQL Server commands, queries, and administrative procedures covering database creation, table manipulation, indexing, backup, security, replication, and performance tuning, presented with code examples and practical tips for developers and DBAs seeking a handy reference guide.

Database AdministrationReplicationSQL Server
0 likes · 24 min read
Comprehensive SQL Server Cheat Sheet: Commands, Queries, and Administration Tips
Java Architect Essentials
Java Architect Essentials
Aug 3, 2022 · Databases

Comprehensive SQL Server Database Operations and Replication Guide

This article provides an extensive collection of SQL Server commands and techniques covering basic database creation, table manipulation, advanced queries, backup and maintenance, as well as detailed steps for setting up linked servers, snapshot replication, and synchronization procedures between servers.

DatabaseLinked ServerReplication
0 likes · 23 min read
Comprehensive SQL Server Database Operations and Replication Guide
Aikesheng Open Source Community
Aikesheng Open Source Community
Aug 2, 2022 · Databases

Using Generated Invisible Primary Keys (GIPK) in MySQL 8.0.30

This article explains the new MySQL 8.0.30 feature that automatically generates invisible primary keys for InnoDB tables without explicit primary keys, demonstrates how to enable and use it, discusses DDL and replication implications, and outlines related limitations and backup considerations.

GIPKInnoDBInvisible Primary Key
0 likes · 12 min read
Using Generated Invisible Primary Keys (GIPK) in MySQL 8.0.30