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.

Master‑SlaveMySQLdatabase
0 likes · 12 min read
Understanding MySQL Master‑Slave Replication: Principles, Lag, and Failover
Aikesheng Open Source Community
Aikesheng Open Source Community
Mar 14, 2023 · Databases

Understanding Redis Master‑Slave Replication Storm and Mitigation Strategies

The article explains Redis master‑slave asynchronous replication, describes how repeated full‑sync requests from slaves can cause a replication storm that overloads CPU, memory and network, and offers practical solutions such as limiting data size, adjusting buffer limits, and redesigning deployment topology.

Master‑SlaveRedisReplication Storm
0 likes · 6 min read
Understanding Redis Master‑Slave Replication Storm and Mitigation Strategies
ITPUB
ITPUB
Jan 17, 2023 · Databases

Simplify MySQL Replication: Why GTID Beats Position‑Based Sync and How to Monitor Lag

This article examines MySQL’s transition from dual‑master to master‑slave replication, highlights the complexities of position‑based syncing, introduces GTID as a more reliable alternative, and provides practical steps to enable GTID and accurately monitor replication lag using seconds_behind_master, binlog positions, and GTID sets.

GTIDLag MonitoringMaster‑Slave
0 likes · 12 min read
Simplify MySQL Replication: Why GTID Beats Position‑Based Sync and How to Monitor Lag
ITPUB
ITPUB
Nov 6, 2022 · Databases

Master‑Slave, Sentinel, and Cluster: Unlocking Redis High Availability

This guide explains Redis high‑availability mechanisms, covering master‑slave replication, the Sentinel monitoring and automatic failover process, and the Redis Cluster sharding architecture, including hash slots, MOVED/ASK redirection, gossip communication, and practical considerations such as data consistency, network partitions, and slot allocation.

ClusterGossipHash Slots
0 likes · 25 min read
Master‑Slave, Sentinel, and Cluster: Unlocking Redis High Availability
Liangxu Linux
Liangxu Linux
Jan 4, 2021 · Databases

Mastering MySQL Replication: Types, Setup, and Troubleshooting Guide

This article provides a comprehensive guide to MySQL replication, covering built‑in replication types, the three‑step replication workflow, detailed master‑slave configuration commands, topology options, cloning methods, binlog formats, replication files, filtering, and common error scenarios with solutions.

Master‑SlaveMySQLbinary log
0 likes · 28 min read
Mastering MySQL Replication: Types, Setup, and Troubleshooting Guide
Full-Stack Internet Architecture
Full-Stack Internet Architecture
Aug 24, 2020 · Databases

Understanding Redis Deployment Modes: Standalone, Master‑Slave, Sentinel, and Cluster

This article provides a comprehensive guide to Redis deployment, covering standalone, master‑slave replication, Sentinel high‑availability, and cluster sharding modes, detailing their principles, advantages, drawbacks, and step‑by‑step configuration examples with Maven dependencies and Redis configuration files.

ClusterConfigurationMaster‑Slave
0 likes · 28 min read
Understanding Redis Deployment Modes: Standalone, Master‑Slave, Sentinel, and Cluster
Full-Stack Internet Architecture
Full-Stack Internet Architecture
Jul 20, 2020 · Databases

MySQL Master‑Slave Replication: Principles, Setup Guide, and Interview Questions

This article explains MySQL master‑slave replication, covering its concepts, asynchronous replication mechanisms, various synchronization strategies, step‑by‑step installation and configuration on CentOS 7, and includes common interview questions with answers; it also provides practical commands, troubleshooting tips, and performance considerations for read‑write separation in production environments.

CentOSMaster‑SlaveMySQL
0 likes · 15 min read
MySQL Master‑Slave Replication: Principles, Setup Guide, and Interview Questions
ITPUB
ITPUB
Jul 11, 2017 · Databases

Designing a Multi‑Datacenter Redis Master‑Slave Architecture with Automatic Failover

This article outlines a comprehensive Redis multi‑datacenter deployment plan, detailing master‑backup placement, tree‑structured master‑slave topology across three sites, configuration checks, Pull&Push synchronization mechanics, and includes concrete code snippets illustrating connection, RDB generation, and incremental replication processes.

Master‑SlaveRedisbackend
0 likes · 9 min read
Designing a Multi‑Datacenter Redis Master‑Slave Architecture with Automatic Failover
ITPUB
ITPUB
May 19, 2017 · Databases

Optimizing Redis Master‑Slave Performance in Cloud Environments

This article examines common performance and reliability problems encountered in Redis master‑slave deployments—such as AOF and SAVE settings, key count mismatches, client output buffer limits, replication backlog size, and node liveness checks—and provides concrete configuration commands and tuning strategies to improve stability, especially in cloud environments.

ConfigurationMaster‑SlavePerformance Tuning
0 likes · 7 min read
Optimizing Redis Master‑Slave Performance in Cloud Environments
ITPUB
ITPUB
Mar 31, 2016 · Databases

Master MySQL Replication: Step‑by‑Step Guide to Master‑Slave Setup

This article explains MySQL replication fundamentals, compares asynchronous and synchronous modes, walks through configuring a master‑slave environment with binary logs, details statement‑based and row‑based replication, offers recommended settings, and discusses replication lag, semi‑synchronous replication, and heartbeat mechanisms.

AsynchronousConfigurationMaster‑Slave
0 likes · 15 min read
Master MySQL Replication: Step‑by‑Step Guide to Master‑Slave Setup