Tagged articles
21 articles
Page 1 of 1
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.

DatabaseMaster‑Slavehigh availability
0 likes · 12 min read
Understanding MySQL Master‑Slave Replication: Principles, Lag, and Failover
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.

DatabaseMaster‑Slavebinary 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.

ClusterDeploymentMaster‑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.

CentOSDatabaseMaster‑Slave
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.

DatabaseMaster‑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.

AsynchronousMaster‑Slavebinary log
0 likes · 15 min read
Master MySQL Replication: Step‑by‑Step Guide to Master‑Slave Setup
Architect
Architect
Dec 12, 2015 · Databases

Understanding Redis Master‑Slave Replication and Its Configuration

This article explains how Redis master‑slave replication works, covering asynchronous copying, partial resynchronization, disk‑less replication, safety considerations when persistence is disabled, read‑only slaves, authentication, and configuration options such as slaveof and write‑restriction based on slave count.

DatabaseMaster‑SlaveRedis
0 likes · 10 min read
Understanding Redis Master‑Slave Replication and Its Configuration