Tagged articles

Replication

767 articles · Page 2 of 8
Mike Chen's Internet Architecture
Mike Chen's Internet Architecture
Sep 8, 2025 · Databases

Redis Million‑Level Concurrency: Memory, Data Structures & Replication

Redis achieves million‑level concurrency by storing all data in memory, leveraging ultra‑fast read/write speeds, employing optimized data structures such as strings, hashes, lists, sets and sorted sets, using I/O multiplexing to handle many connections in a single thread, and scaling through master‑slave replication for high availability.

Data StructuresI/O multiplexingIn-Memory Database
0 likes · 4 min read
Redis Million‑Level Concurrency: Memory, Data Structures & Replication
MaGe Linux Operations
MaGe Linux Operations
Sep 6, 2025 · Databases

How to Build a High‑Availability MySQL Master‑Slave Cluster and Automate Failover

This guide walks through the reasons for MySQL master‑slave replication, explains its core mechanisms, details step‑by‑step environment planning, configuration, data initialization, replication setup, monitoring, failover with MHA, read‑write splitting using ProxySQL, performance tuning, troubleshooting, and best‑practice recommendations for enterprise‑grade high availability.

FailoverHigh AvailabilityMySQL
0 likes · 27 min read
How to Build a High‑Availability MySQL Master‑Slave Cluster and Automate Failover
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.

DatabaseIsolation LevelMySQL
0 likes · 10 min read
Why Big Tech Chooses RC Over MySQL’s Default RR Isolation Level
Big Data Technology Tribe
Big Data Technology Tribe
Aug 22, 2025 · Backend Development

How StarRocks Keeps Metadata Consistent Across FE Nodes

This article explains the roles of StarRocks FE and BE nodes, details the metadata stored in FE, describes the leader‑follower‑observer architecture, and shows how BDB JE replication, journal logs, and checkpoint mechanisms ensure metadata synchronization and durability even after node failures.

BDB JEDistributed SystemsMetadata
0 likes · 17 min read
How StarRocks Keeps Metadata Consistent Across FE Nodes

How Single-Leader Replication Handles Write Conflicts: Strategies and Insights

This article examines write conflicts in single-leader replication, comparing exclusive and shared data, exploring uniqueness constraints, async replication delays, and various conflict‑resolution techniques such as unique indexes, bitmap mapping, LWW ordering, and multi‑version control for collaborative editing.

DatabaseDistributed SystemsReplication
0 likes · 9 min read
How Single-Leader Replication Handles Write Conflicts: Strategies and Insights
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.

AsynchronousMySQLPerformance
0 likes · 9 min read
Understanding MySQL Master‑Slave Replication: Core Principles, Modes, and Latency Mitigation
MaGe Linux Operations
MaGe Linux Operations
Aug 3, 2025 · Databases

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

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

GTIDMySQLPerformance Tuning
0 likes · 15 min read
Why MySQL Replication Lag Can Crash Your System – Binlog, Semi‑Sync & GTID Explained
Xiaokun's Architecture Exploration Notes
Xiaokun's Architecture Exploration Notes
Aug 3, 2025 · Fundamentals

Understanding Causal Consistency: Order Guarantees, Lamport Timestamps, and Total Order Broadcast

This article explains the challenges of implementing causal consistency, compares it with linear and sequential consistency, describes how order guarantees are enforced in leader‑based replication, introduces Lamport timestamps and total‑order broadcast, and outlines practical approaches for achieving causal consistency in distributed systems.

Distributed SystemsLamport timestampReplication
0 likes · 14 min read
Understanding Causal Consistency: Order Guarantees, Lamport Timestamps, and Total Order Broadcast
Xiaokun's Architecture Exploration Notes
Xiaokun's Architecture Exploration Notes
Jul 27, 2025 · Fundamentals

Can Multi-Leader and Leaderless Replication Achieve Linear Consistency?

This article examines why multi‑leader and leaderless replication models struggle to provide linear consistency, explores write‑conflict handling, quorum‑based NWR mechanisms, sloppy quorum and hinted‑handoff techniques, and summarizes the trade‑offs involved in achieving strong consistency across distributed data centers.

Distributed SystemsMulti-LeaderReplication
0 likes · 15 min read
Can Multi-Leader and Leaderless Replication Achieve Linear Consistency?
MaGe Linux Operations
MaGe Linux Operations
Jul 25, 2025 · Databases

Master MySQL Ops: From Config Tuning to Query Performance Boost

This comprehensive guide walks you through a real production incident and then details MySQL configuration tuning, memory and thread settings, InnoDB core parameters, index design, query optimization cases, slow‑query analysis, read‑write splitting, monitoring scripts, sharding strategies, fault diagnosis, backup and recovery best practices, and high‑availability deployment, providing actionable tips and code examples for robust database performance.

MySQLPerformance TuningReplication
0 likes · 12 min read
Master MySQL Ops: From Config Tuning to Query Performance Boost

How to Achieve Linear Consistency in Single-Leader Replication: Challenges and Solutions

This article examines eventual and linear consistency in leader‑based replication, explains read‑your‑writes and shared‑data scenarios, discusses replication lag, failover trade‑offs, multi‑data‑center risks, and shows how consensus systems like ZooKeeper and etcd implement true linear consistency.

DatabasesDistributed SystemsEventual Consistency
0 likes · 13 min read
How to Achieve Linear Consistency in Single-Leader Replication: Challenges and Solutions
IT Xianyu
IT Xianyu
May 23, 2025 · Databases

Step‑by‑Step Guide to Setting Up MySQL Master‑Slave Replication with Docker

This article provides a comprehensive, step‑by‑step tutorial on deploying a MySQL master‑slave replication architecture using Docker containers, covering prerequisite checks, container setup, configuration files, replication user creation, master‑slave linking, testing data sync, and troubleshooting common issues.

DBADockerMySQL
0 likes · 8 min read
Step‑by‑Step Guide to Setting Up MySQL Master‑Slave Replication with Docker
MaGe Linux Operations
MaGe Linux Operations
May 17, 2025 · Databases

Master MySQL: Full Guide to Theory, Commands & Real-World Practices

This comprehensive MySQL tutorial covers everything from core concepts and architecture to practical CRUD operations, advanced queries, indexing, transaction control, stored procedures, triggers, replication, performance tuning, backup strategies, and real-world use cases, providing a complete roadmap for developers and DBAs.

BackupDatabaseIndexing
0 likes · 25 min read
Master MySQL: Full Guide to Theory, Commands & Real-World Practices
IT Services Circle
IT Services Circle
May 16, 2025 · Databases

Internship Guidance, ByteDance Three‑Round Interview Experience, MySQL Replication Mechanics, and I/O Model Overview

The article combines practical advice for fresh graduates seeking internships and interview tips, shares a detailed ByteDance three‑round backend interview experience, explains MySQL master‑slave replication stages, binlog formats, and compares blocking, non‑blocking, multiplexed, and asynchronous I/O models.

DatabasesI/OMySQL
0 likes · 15 min read
Internship Guidance, ByteDance Three‑Round Interview Experience, MySQL Replication Mechanics, and I/O Model Overview
dbaplus Community
dbaplus Community
Apr 30, 2025 · Databases

Top 10 MySQL Errors and How to Fix Them: Practical Solutions for DBAs

This article compiles the ten most common MySQL error scenarios—from connection limits and replication conflicts to installation failures, password resets, truncate side‑effects, configuration pitfalls, charset issues, binlog formats, timeout problems, and file‑handle limits—offering clear diagnostic steps and concrete commands to resolve each case.

Database ErrorsMySQLReplication
0 likes · 16 min read
Top 10 MySQL Errors and How to Fix Them: Practical Solutions for DBAs
IT Xianyu
IT Xianyu
Apr 19, 2025 · Databases

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

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

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

Step-by-Step Guide to Installing MySQL 5.7 on ARM (Aarch64) Linux

This tutorial walks you through checking the OS architecture, preparing the environment, downloading and extracting the MySQL 5.7 ARM package, configuring my.cnf, setting up auto‑start and environment variables, initializing the server, securing the root account, and configuring master‑slave replication on Linux.

ARMDatabaseInstallation
0 likes · 13 min read
Step-by-Step Guide to Installing MySQL 5.7 on ARM (Aarch64) Linux
Ma Wei Says
Ma Wei Says
Apr 8, 2025 · Operations

Mastering High Availability: 4 Failover Patterns Explained

Understanding high‑availability architectures involves mastering replication and fail‑over, balancing RTO and RPO, and choosing among four patterns—Active‑Standby, Active‑Active, Cold Standby, and Hot Standby—each with distinct synchronization, load‑balancing, and cost considerations for reliable system design.

Active-ActiveFailoverHigh Availability
0 likes · 9 min read
Mastering High Availability: 4 Failover Patterns Explained
Raymond Ops
Raymond Ops
Apr 2, 2025 · Databases

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

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

DatabaseGTIDMaster‑Slave
0 likes · 6 min read
How to Set Up MySQL Master‑Slave Replication (Step‑by‑Step Guide)
Cognitive Technology Team
Cognitive Technology Team
Mar 24, 2025 · Databases

Understanding MySQL Replication: Architecture, Binlog Formats, Use Cases, and Best Practices

This article explains MySQL's replication mechanism, detailing master‑slave architecture, key threads, binlog formats (statement, row, mixed), common application scenarios such as backup, read/write splitting, and data migration, and highlights important considerations like network latency, consistency, delay, and security.

DatabaseMySQLReplication
0 likes · 7 min read
Understanding MySQL Replication: Architecture, Binlog Formats, Use Cases, and Best Practices
Aikesheng Open Source Community
Aikesheng Open Source Community
Mar 19, 2025 · Databases

Why MySQL 5.7 Seconds_Behind_Master Is Unreliable and How pt‑heartbeat Provides Accurate Replication Lag Measurement

The article explains why the built‑in MySQL 5.7 Seconds_Behind_Master metric often misrepresents replication delay, analyzes its design flaws, and demonstrates how the Percona Toolkit's pt‑heartbeat tool can reliably measure master‑slave lag with real‑time precision.

Database MonitoringMySQLReplication
0 likes · 10 min read
Why MySQL 5.7 Seconds_Behind_Master Is Unreliable and How pt‑heartbeat Provides Accurate Replication Lag Measurement
Aikesheng Open Source Community
Aikesheng Open Source Community
Mar 10, 2025 · Databases

Using pt‑slave‑repair to Automatically Fix MySQL Master‑Slave Replication Errors 1032 and 1062

This article introduces the pt‑slave‑repair tool, explains the root causes of MySQL master‑slave replication errors 1032 and 1062, details its working principle, preparation steps, and provides concrete command‑line examples for automatically repairing these errors with minimal manual effort.

Error 1032Error 1062MySQL
0 likes · 15 min read
Using pt‑slave‑repair to Automatically Fix MySQL Master‑Slave Replication Errors 1032 and 1062
Raymond Ops
Raymond Ops
Feb 6, 2025 · Databases

Master MongoDB Config: System Log, Network, Security & More

This article provides a comprehensive overview of MongoDB's configuration file, detailing system log options, process management, network settings, security parameters, storage engine configurations, slow query profiling, replication, sharding, and mongos-specific settings, with explanations of each option and recommended defaults.

DatabaseMongoDBReplication
0 likes · 12 min read
Master MongoDB Config: System Log, Network, Security & More
Raymond Ops
Raymond Ops
Jan 25, 2025 · Databases

Master MongoDB Replication Sets and Sharding: Step‑by‑Step Guide

This comprehensive guide walks you through MongoDB replica set fundamentals, member roles, architecture, and configuration commands, then dives into sharding concepts, cluster components, chunk management, shard key selection, deployment steps, balancing operations, and practical troubleshooting tips, all illustrated with clear code examples and diagrams.

DatabaseMongoDBReplication
0 likes · 34 min read
Master MongoDB Replication Sets and Sharding: Step‑by‑Step Guide
JD Tech
JD Tech
Jan 9, 2025 · Databases

Challenges and Practices of Distributed Data Systems: Master‑Slave Replication, Partitioning, and High‑Availability Strategies

This article examines the core challenges of distributed data systems—including consistency, availability, and partition tolerance—then details master‑slave replication mechanisms for MySQL and Redis, various replication modes and binlog formats, and explores data partitioning, sharding, and hot‑key mitigation techniques for scalable, high‑availability deployments.

DatabasesHigh AvailabilityMySQL
0 likes · 23 min read
Challenges and Practices of Distributed Data Systems: Master‑Slave Replication, Partitioning, and High‑Availability Strategies
ITPUB
ITPUB
Jan 3, 2025 · Databases

Why ClickHouse Sharded Table Queries Return Inconsistent Row Counts—and How to Fix It

A ClickHouse cluster showed wildly varying row counts when querying sharded tables, while local tables behaved correctly; the article analyses the root cause in the cluster and table configuration, explains why the inconsistency occurs, and provides a step‑by‑step fix by switching to replicated tables.

ClickHouseDatabaseQuery Inconsistency
0 likes · 7 min read
Why ClickHouse Sharded Table Queries Return Inconsistent Row Counts—and How to Fix It
BirdNest Tech Talk
BirdNest Tech Talk
Dec 29, 2024 · Fundamentals

Unlocking Distributed System Design: 20 Core Patterns Explained

This article distills the key design patterns behind distributed systems—covering replication, partitioning, consensus, and fault‑tolerance—by presenting each pattern’s problem statement, concrete solution, trade‑offs, and technical considerations, all illustrated with real‑world examples from projects like Kafka and Cassandra.

ConsensusDesign PatternsDistributed Systems
0 likes · 18 min read
Unlocking Distributed System Design: 20 Core Patterns Explained
Aikesheng Open Source Community
Aikesheng Open Source Community
Dec 2, 2024 · Databases

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

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

BackupDatabaseGTID
0 likes · 9 min read
MySQL Replication Filter Expansion: Adding New Databases with Efficient Backup and Restore
Su San Talks Tech
Su San Talks Tech
Oct 21, 2024 · Databases

How to Diagnose and Fix MySQL Master‑Slave Replication Lag

This article explains why MySQL master‑slave replication can become delayed in high‑traffic order systems, describes the underlying binlog synchronization mechanism, and provides practical steps—including network upgrades, server tuning, transaction reduction, version updates, and slave count limits—to eliminate the lag.

Master‑SlaveMySQLPerformance Tuning
0 likes · 7 min read
How to Diagnose and Fix MySQL Master‑Slave Replication Lag
ITPUB
ITPUB
Oct 15, 2024 · Databases

8 Essential MongoDB Admin Scripts to Master Database Management

This guide presents eight practical MongoDB shell scripts—covering database size analysis, connection monitoring, long‑running query termination, table‑scan detection, replica‑set health checks, and slow‑query profiling—plus usage tips and cautions for reliable administration.

Database AdministrationMongoDBReplication
0 likes · 15 min read
8 Essential MongoDB Admin Scripts to Master Database Management
Programmer1970
Programmer1970
Oct 2, 2024 · Databases

A Deep Dive into MongoDB’s Technical Architecture

This article outlines MongoDB’s core features, its layered technical architecture—including storage, data model, query language, indexing, replication, sharding, and transactions—and explains the three cluster deployment modes with detailed roles and request flow for sharded clusters.

Database ArchitectureIndexingMongoDB
0 likes · 10 min read
A Deep Dive into MongoDB’s Technical Architecture
Open Source Linux
Open Source Linux
Sep 20, 2024 · Databases

Redis Master‑Slave Replication and Sentinel: How They Work and Scale

This article explains Redis master‑slave replication, synchronization steps, handling of network partitions, and how Sentinel provides automatic failover through monitoring, leader election, and notification, offering strategies to reduce master load and ensure high availability.

DatabaseFailoverHigh Availability
0 likes · 9 min read
Redis Master‑Slave Replication and Sentinel: How They Work and Scale
Selected Java Interview Questions
Selected Java Interview Questions
Aug 30, 2024 · Databases

Redis Mastery: Deep Dive into Architecture, Data Structures, Persistence, Replication, and Sentinel

This article introduces the Redis in‑memory database, highlights the new "Redis Mastery" book that blends theory with practical examples, and explains core concepts such as SDS string structures, RDB/AOF persistence, master‑slave replication, and Sentinel high‑availability mechanisms.

Data StructuresIn-Memory DatabasePersistence
0 likes · 11 min read
Redis Mastery: Deep Dive into Architecture, Data Structures, Persistence, Replication, and Sentinel
MaGe Linux Operations
MaGe Linux Operations
Aug 25, 2024 · Databases

How to Install and Configure MySQL 5.7 on ARM (Aarch64) with Master‑Slave Replication

This guide walks through checking the OS architecture, preparing the environment, downloading the appropriate MySQL 5.7 packages for ARM, installing and configuring MySQL, setting up automatic startup and environment variables, initializing the server, securing the root account, and finally configuring master‑slave replication between two servers.

ARMDatabaseLinux
0 likes · 15 min read
How to Install and Configure MySQL 5.7 on ARM (Aarch64) with Master‑Slave Replication
vivo Internet Technology
vivo Internet Technology
Aug 7, 2024 · Databases

MySQL 5.7 DDL vs GH-OST: A Comprehensive Comparison of Online Schema Change Tools

While MySQL 5.7 native DDL methods (copy, inplace rebuild, index build, metadata‑only) vary in speed, space use, lock impact, and binlog output, GH‑OST consistently offers the fastest execution, lowest lock blocking, real‑time replication, albeit at roughly double storage cost, making it ideal for risk‑averse online schema changes.

DDLDatabase MigrationInnoDB
0 likes · 11 min read
MySQL 5.7 DDL vs GH-OST: A Comprehensive Comparison of Online Schema Change Tools
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.

DatabaseGTIDMySQL
0 likes · 10 min read
Can a MySQL Replica Omit sync_binlog=1? Experiment and Analysis
Big Data Technology & Architecture
Big Data Technology & Architecture
Jul 26, 2024 · Databases

Apache Doris Architecture and Common Q&A: Read/Write Flow, Replication Consistency, Storage, and High Availability

This article provides a comprehensive overview of Apache Doris, explaining its frontend and backend nodes, storage structures such as tablets, rowsets, and segments, replication mechanisms, partitioning versus bucketing, indexing types, compaction processes, and high‑availability strategies through a detailed Q&A format.

Apache DorisDatabase ArchitectureIndexing
0 likes · 22 min read
Apache Doris Architecture and Common Q&A: Read/Write Flow, Replication Consistency, Storage, and High Availability
Architect
Architect
Jul 5, 2024 · Databases

Step-by-Step Guide to Deploy PostgreSQL Master‑Slave Replication

This article provides a comprehensive, hands‑on tutorial for planning, installing, configuring, and verifying a PostgreSQL master‑slave (streaming replication) setup on two Linux nodes, including user creation, remote connection settings, data export/import, and troubleshooting tips.

ConfigurationDatabaseLinux
0 likes · 14 min read
Step-by-Step Guide to Deploy PostgreSQL Master‑Slave Replication
Laravel Tech Community
Laravel Tech Community
May 21, 2024 · Databases

MongoDB Replication Set and Sharding Configuration Guide

This article provides a comprehensive step‑by‑step guide to setting up MongoDB replica sets and sharded clusters, explaining the architecture, member roles, configuration files, initialization commands, and operational procedures for ensuring data redundancy, high availability, and horizontal scaling.

ClusterDatabaseHigh Availability
0 likes · 29 min read
MongoDB Replication Set and Sharding Configuration Guide
MaGe Linux Operations
MaGe Linux Operations
May 10, 2024 · Databases

MongoDB Config Guide: System Log, Network, Security, and Storage Settings

This article provides a comprehensive walkthrough of MongoDB's configuration file, detailing system log options, process management, network parameters, security settings, storage engine configurations, slow query profiling, replication, sharding, and mongos parameters, along with explanations of each option and recommended defaults.

ConfigurationDatabaseMongoDB
0 likes · 12 min read
MongoDB Config Guide: System Log, Network, Security, and Storage Settings
Programmer XiaoFu
Programmer XiaoFu
May 10, 2024 · Databases

From Single Node to Tank: 20 Diagrams of Redis Architecture Evolution

This article walks through Redis's architectural journey—from a lone instance to a high‑availability, high‑performance cluster—covering persistence (RDB, AOF, hybrid), master‑slave replication, Sentinel automatic failover, sharding strategies, and the modern Redis Cluster design.

ClusterHigh AvailabilityPersistence
0 likes · 19 min read
From Single Node to Tank: 20 Diagrams of Redis Architecture Evolution
Sanyou's Java Diary
Sanyou's Java Diary
May 9, 2024 · Databases

From Single Node to Cluster: Mastering Redis Architecture Evolution

This article walks you through Redis’s architectural journey—from a simple single‑node setup, through persistence mechanisms, master‑slave replication, Sentinel‑driven automatic failover, and finally sharding with Redis Cluster—explaining each component’s purpose, trade‑offs, and how they collectively boost performance and reliability.

ClusterHigh AvailabilityPersistence
0 likes · 18 min read
From Single Node to Cluster: Mastering Redis Architecture Evolution
FunTester
FunTester
Apr 28, 2024 · Backend Development

Tackling Data Consistency: Master‑Slave, Master‑Master & Leaderless Architectures

The article examines why distributed systems inevitably face data‑consistency challenges and breaks down three common service‑architecture patterns—master‑slave, master‑master, and leaderless—detailing their replication mechanisms, advantages, drawbacks, and practical solutions such as synchronous, semi‑synchronous, asynchronous replication, quorum handling, node‑failure recovery, and conflict resolution strategies.

Data ConsistencyDistributed SystemsMaster‑Slave
0 likes · 14 min read
Tackling Data Consistency: Master‑Slave, Master‑Master & Leaderless Architectures
Architect's Guide
Architect's Guide
Apr 24, 2024 · Databases

Redis Overview: Features, Data Types, Caching Strategies, Performance, Eviction Policies, Persistence, Replication, and Sentinel

This article provides a comprehensive introduction to Redis, covering its core features, supported data types, common caching use cases in Spring Boot, typical cache‑related problems such as consistency, avalanche, penetration and breakdown, as well as performance reasons, eviction policies, persistence mechanisms, master‑slave replication, and Sentinel high‑availability architecture.

CachingDatabasePerformance
0 likes · 12 min read
Redis Overview: Features, Data Types, Caching Strategies, Performance, Eviction Policies, Persistence, Replication, and Sentinel
Rare Earth Juejin Tech Community
Rare Earth Juejin Tech Community
Apr 6, 2024 · Big Data

Deep Dive into Kafka’s Underlying Mechanisms: Sequential Writes, Sparse Indexing, Segment Storage, and Replication

This article explores Apache Kafka’s core storage architecture, explaining how sequential append‑only writes, sparse indexing, segmented log files, and a leader‑based replication mechanism together enable high‑throughput, reliable, and scalable event streaming for massive data workloads.

Event StreamingKafkaReplication
0 likes · 11 min read
Deep Dive into Kafka’s Underlying Mechanisms: Sequential Writes, Sparse Indexing, Segment Storage, and Replication
Tencent Cloud Developer
Tencent Cloud Developer
Mar 26, 2024 · Databases

Data Consistency in Distributed Systems: Master‑Slave, Master‑Master, and Leaderless Architectures

The article compares master‑slave, master‑master, and leaderless distributed architectures, explaining how synchronous, semi‑synchronous, and asynchronous replication affect consistency, latency and scalability, and showing that each pattern trades write throughput, conflict‑resolution complexity, and availability against strong data correctness.

Data ConsistencyDistributed SystemsMaster‑Slave
0 likes · 15 min read
Data Consistency in Distributed Systems: Master‑Slave, Master‑Master, and Leaderless Architectures
Linux Cloud Computing Practice
Linux Cloud Computing Practice
Mar 13, 2024 · Databases

Unlocking Redis: Architecture, High Availability, and Persistence Explained

This article provides a comprehensive overview of Redis, covering its core concepts, deployment architectures—including single instance, high‑availability, Sentinel, and cluster setups—its replication mechanisms, gossip protocol, and the various persistence options such as RDB, AOF, and fork‑based snapshots.

ClusterHigh AvailabilityIn-Memory Database
0 likes · 17 min read
Unlocking Redis: Architecture, High Availability, and Persistence Explained
Su San Talks Tech
Su San Talks Tech
Feb 23, 2024 · Databases

Mastering Redis Master‑Slave Replication: How It Works and Why It Matters

This article explains Redis high‑availability through master‑slave replication, covering the architecture, read‑write separation benefits, the three‑stage initial sync process, incremental synchronization, and practical considerations for scaling and fault tolerance in production environments.

DatabaseMaster‑SlaveReplication
0 likes · 12 min read
Mastering Redis Master‑Slave Replication: How It Works and Why It Matters
Aikesheng Open Source Community
Aikesheng Open Source Community
Feb 7, 2024 · Databases

Accelerating MySQL Data Recovery with Xtrabackup: Scenarios and Techniques

This article explains how DBA engineers can speed up MySQL data recovery using Xtrabackup by covering three scenarios—full backup with binlog, single-database restore, and single-table restore—detailing steps such as SQL thread replay, parallel replication, and transportable tablespace techniques with practical command examples.

BackupMySQLRecovery
0 likes · 21 min read
Accelerating MySQL Data Recovery with Xtrabackup: Scenarios and Techniques
Java Architect Essentials
Java Architect Essentials
Feb 2, 2024 · Databases

Understanding KeyDB: Multithreaded Architecture, Connection Management, Fastlock, and Active‑Replica

This article introduces KeyDB, a high‑performance multithreaded fork of Redis, explaining its architecture, thread model, connection management, fastlock mechanism, and active‑replica features, while providing code examples and performance comparisons, and highlighting their impact on throughput and latency.

DatabaseKeyDBLock
0 likes · 10 min read
Understanding KeyDB: Multithreaded Architecture, Connection Management, Fastlock, and Active‑Replica
dbaplus Community
dbaplus Community
Jan 16, 2024 · Databases

Mastering MariaDB ColumnStore: Installation, Migration, Replication, and Performance Insights

This guide explains MariaDB ColumnStore’s columnar architecture, key advantages, step‑by‑step installation, field and SQL limitations, how to migrate InnoDB data, configure multi‑source replication, compare performance with InnoDB, and achieve high availability and dynamic scaling for analytical workloads.

ColumnstoreData MigrationInstallation
0 likes · 17 min read
Mastering MariaDB ColumnStore: Installation, Migration, Replication, and Performance Insights
ITPUB
ITPUB
Dec 30, 2023 · Databases

Why MySQL 5.6 → 5.7 Upgrades Fail and How to Prevent Rollbacks

The article recounts a legacy project that relied on MySQL 5.6, explains common pitfalls of that version such as replication lag, heavy performance_schema overhead, binlog issues, and memory limits, then details why an upgrade to 5.7 was rolled back due to syntax changes, case‑sensitivity differences, and unresolved configuration problems.

Case SensitivityDatabase MigrationMySQL
0 likes · 9 min read
Why MySQL 5.6 → 5.7 Upgrades Fail and How to Prevent Rollbacks
dbaplus Community
dbaplus Community
Dec 19, 2023 · Databases

How GitHub Upgraded 1,200 MySQL Servers from 5.7 to 8.0 Without Downtime

GitHub detailed a year‑long, multi‑team effort to upgrade over 1,200 MySQL hosts from version 5.7 to 8.0, describing the motivations, infrastructure scale, preparation steps, a staged rollout plan, rollback strategies, challenges faced, and key lessons learned for large‑scale database migrations.

AutomationDatabase UpgradeGitHub
0 likes · 16 min read
How GitHub Upgraded 1,200 MySQL Servers from 5.7 to 8.0 Without Downtime
21CTO
21CTO
Dec 15, 2023 · Databases

How GitHub Upgraded 1,200 MySQL Servers to 8.0 Without Downtime

GitHub’s engineering team detailed a year‑long, multi‑team effort to upgrade over 1,200 MySQL hosts from 5.7 to 8.0, preserving high availability, SLO compliance, and rollback capability while introducing new features and performance improvements.

Database MigrationGitHubHigh Availability
0 likes · 17 min read
How GitHub Upgraded 1,200 MySQL Servers to 8.0 Without Downtime
MaGe Linux Operations
MaGe Linux Operations
Nov 27, 2023 · Databases

Why Does MySQL Master‑Slave Replication Lag? Causes and Fixes

This article explains why MySQL master‑slave replication can become delayed, outlines the differences between DDL and DML, shows how to diagnose lag with show slave status, and provides architectural, hardware, and configuration solutions—including semi‑synchronous replication and tuning parameters—to reduce latency.

DatabaseMaster‑SlaveMySQL
0 likes · 9 min read
Why Does MySQL Master‑Slave Replication Lag? Causes and Fixes
Aikesheng Open Source Community
Aikesheng Open Source Community
Oct 31, 2023 · Databases

MySQL Disaster Recovery: Multi‑Region Three‑Center Replication and RTO/RPO Optimization

This article explains the principles of disaster recovery for MySQL, covering RTO/RPO metrics, national backup level standards, common master‑slave topologies, a comparative analysis of high‑availability solutions, and a detailed three‑center multi‑region replication design with code patches to avoid replication loops.

DatabaseHigh AvailabilityMySQL
0 likes · 17 min read
MySQL Disaster Recovery: Multi‑Region Three‑Center Replication and RTO/RPO Optimization
LouZai
LouZai
Oct 30, 2023 · Databases

How to Diagnose and Fix MySQL Master‑Slave Replication Lag

The article explains what MySQL master‑slave replication lag is, analyzes why it occurs—especially during relay‑log replay and large DDL/DML operations—and provides concrete configuration, hardware, and architectural solutions to reduce or eliminate the delay.

ConfigurationLagMaster‑Slave
0 likes · 8 min read
How to Diagnose and Fix MySQL Master‑Slave Replication Lag
JD Cloud Developers
JD Cloud Developers
Oct 25, 2023 · Backend Development

Master Kafka: Core Concepts, Architecture, and Practical Tips

This article explains Kafka's fundamentals, including topics, partitions, brokers, replication, producer‑consumer workflow, consumer groups, offset management, and common exception handling, while providing code examples and diagrams to help developers understand and effectively use this distributed messaging system.

Distributed SystemsJavaKafka
0 likes · 21 min read
Master Kafka: Core Concepts, Architecture, and Practical Tips