BestHub
Sign in
Tagged articles

replication

771 articles · Page 5 of 8
Su San Talks Tech
Su San Talks Tech
Jul 14, 2021 · Databases

Why Is Redis So Fast? Deep Dive into Its Core Architecture and Performance

Redis achieves its remarkable speed through a combination of in‑memory data storage, optimized data structures like SDS, ziplist, quicklist and skiplist, a single‑threaded command model, efficient I/O multiplexing, and sophisticated persistence, replication, Sentinel and Cluster mechanisms that together ensure high performance and reliability.

In-Memory DatabasePersistenceRedis
0 likes · 25 min read
Why Is Redis So Fast? Deep Dive into Its Core Architecture and Performance
Big Data Technology & Architecture
Big Data Technology & Architecture
Jul 9, 2021 · Big Data

Understanding Kafka: Use Cases, Reliability, Storage, Replication, Consumer Assignment, Transactions, and Exactly-Once Semantics

This article explains why Kafka is used, its buffering, decoupling, redundancy and robustness benefits, details the ack reliability levels, storage design, replica synchronization, ISR handling, consumer partition assignment strategies, transaction support, exactly‑once semantics, and why read‑write separation is not provided.

Consumer AssignmentExactly-OnceStreaming
0 likes · 20 min read
Understanding Kafka: Use Cases, Reliability, Storage, Replication, Consumer Assignment, Transactions, and Exactly-Once Semantics
Architect
Architect
Jul 7, 2021 · Big Data

Understanding Kafka High Availability and Resolving Consumer Offset Issues

This article explains Kafka's high‑availability architecture, including multi‑replica design, ISR synchronization, leader election, acks configuration, and how misconfigured __consumer_offset replication can cause consumer outages, offering practical steps to ensure reliable message delivery.

Consumer offsetStreamingdistributed-systems
0 likes · 8 min read
Understanding Kafka High Availability and Resolving Consumer Offset Issues
Tencent Cloud Developer
Tencent Cloud Developer
Jun 30, 2021 · Databases

Redis Architecture Overview: Introduction, Memory Model, Persistence, Replication, and Cluster Modes

Redis is an open‑source, in‑memory key‑value store that uses a compact memory model with SDS strings, offers RDB snapshots and AOF logging for persistence, supports master‑replica replication with full and partial sync, and provides high‑availability Sentinel and scalable sharding Cluster architectures.

AOFPersistenceRDB
0 likes · 28 min read
Redis Architecture Overview: Introduction, Memory Model, Persistence, Replication, and Cluster Modes
Efficient Ops
Efficient Ops
Jun 28, 2021 · Backend Development

Why a Single Kafka Broker Failure Stops All Consumers – Understanding HA

This article explains Kafka's high‑availability mechanisms, covering multi‑replica design, ISR synchronization, leader election, the impact of the request.required.acks setting, and how the default __consumer_offset topic can become a single point of failure, with concrete steps to fix it.

KafkaLeader Electionconsumer-offset
0 likes · 9 min read
Why a Single Kafka Broker Failure Stops All Consumers – Understanding HA
YunZhu Net Technology Team
YunZhu Net Technology Team
Jun 24, 2021 · Databases

Introduction to ClickHouse and Step‑by‑Step Cluster Deployment Guide

This article provides a comprehensive overview of ClickHouse, covering its columnar OLAP architecture, key features such as data compression, vectorized processing, distributed query handling, and SQL support, followed by detailed step‑by‑step instructions for deploying a multi‑node ClickHouse cluster with MergeTree and ReplicatedMergeTree engines, configuration files, and Java MyBatis integration.

ClickHouseCluster DeploymentColumnar Database
0 likes · 10 min read
Introduction to ClickHouse and Step‑by‑Step Cluster Deployment Guide
IT Architects Alliance
IT Architects Alliance
Jun 20, 2021 · Databases

Master‑Slave Replication Pitfalls and Deep Dive into Redis Sentinel

This article examines the limitations of Redis master‑slave replication, such as manual failover and single‑node bottlenecks, and provides an in‑depth exploration of Redis Sentinel’s architecture, configuration parameters, detection mechanisms, automatic failover process, and best‑practice recommendations for achieving high availability.

RedisSentineldatabase
0 likes · 11 min read
Master‑Slave Replication Pitfalls and Deep Dive into Redis Sentinel
Programmer DD
Programmer DD
Jun 19, 2021 · Databases

How Redis Read/Write Separation Boosts Performance and Cuts Costs

This article explains how Redis read/write separation introduces a read‑only replica role, compares star and chain replication architectures, and outlines the transparent compatibility, high availability, and performance benefits that help users reduce costs while handling read‑heavy workloads.

Read-Write Separationdatabase architecturehigh availability
0 likes · 9 min read
How Redis Read/Write Separation Boosts Performance and Cuts Costs
dbaplus Community
dbaplus Community
Jun 9, 2021 · Databases

How to Enable Multi‑Data‑Center Active‑Active Redis with Bidirectional Sync and rLog

This article explains how a company extended native Redis to support bidirectional synchronization across multiple data‑center sites, addressing issues such as lack of master‑master replication, data loops, idempotency, write conflicts, and providing a custom rLog design for efficient breakpoint‑resume and performance.

Active-ActiveDataSyncRedis
0 likes · 16 min read
How to Enable Multi‑Data‑Center Active‑Active Redis with Bidirectional Sync and rLog
Aikesheng Open Source Community
Aikesheng Open Source Community
May 28, 2021 · Databases

Comprehensive MySQL Inspection Checklist and Command Reference

This guide presents a detailed MySQL inspection checklist covering operating‑system metrics, critical MySQL parameters, status queries, replication health, high‑availability components, and useful SQL scripts, enabling DBAs to efficiently monitor performance, detect issues, and maintain reliable database services.

InspectionMySQLPerformance
0 likes · 11 min read
Comprehensive MySQL Inspection Checklist and Command Reference
Efficient Ops
Efficient Ops
May 27, 2021 · Big Data

Why a Kafka Broker Crash Can Halt All Consumers – The Hidden Offset Pitfall

This article explains Kafka’s high‑availability design, including multi‑replica redundancy, ISR synchronization, leader election, and the critical role of the __consumer_offset internal topic, showing why a single broker failure can render the whole cluster unusable and how to configure replication factors and ack settings to prevent it.

Consumer offsetISRacks
0 likes · 9 min read
Why a Kafka Broker Crash Can Halt All Consumers – The Hidden Offset Pitfall
dbaplus Community
dbaplus Community
May 23, 2021 · Databases

Hidden Redis Pitfalls That Can Crash Your System

This article enumerates common Redis pitfalls—including unexpected key expiration loss, command‑induced blocking, memory‑intensive bitmap operations, AOF and RDB persistence issues, and master‑slave replication quirks—explaining their causes, real‑world impact, and practical mitigation steps.

CommandMemoryPerformance
0 likes · 29 min read
Hidden Redis Pitfalls That Can Crash Your System
Full-Stack Internet Architecture
Full-Stack Internet Architecture
May 13, 2021 · Databases

Database High‑Availability Architectures: Master‑Slave, Master‑Master, and Automatic Failover

This article explains common database high‑availability designs—including master‑slave, master‑master, and automatic failover architectures—their topologies, advantages, disadvantages, and practical considerations such as replication lag, manual intervention, and data consistency challenges.

Master‑Slavedatabasefailover
0 likes · 7 min read
Database High‑Availability Architectures: Master‑Slave, Master‑Master, and Automatic Failover
Top Architect
Top Architect
Apr 24, 2021 · Fundamentals

Fundamentals of Distributed Systems: Models, Replication, Consistency, and Core Protocols

This article provides a comprehensive overview of distributed system fundamentals, covering node models, replica concepts, various consistency levels, data distribution strategies, lease-based caching, quorum mechanisms, two‑phase commit, MVCC, Paxos consensus, and the CAP theorem, illustrating each with practical examples and diagrams.

CAP theoremConsensusPaxos
0 likes · 54 min read
Fundamentals of Distributed Systems: Models, Replication, Consistency, and Core Protocols
IT Architects Alliance
IT Architects Alliance
Apr 24, 2021 · Big Data

Kafka Basics and Cluster Architecture Overview

This article explains Kafka's role as a decoupling message buffer, describes topics, partitions, replication, consumer groups, controller coordination with Zookeeper, and performance optimizations such as sequential writes, zero‑copy, log segmentation, and its reactor‑style network design.

Consumer Groupmessagingpartition
0 likes · 10 min read
Kafka Basics and Cluster Architecture Overview
Full-Stack Internet Architecture
Full-Stack Internet Architecture
Apr 13, 2021 · Big Data

Kafka Architecture and Implementation Principles – Theory Part

This article provides a comprehensive, diagram‑driven explanation of Kafka’s architecture, covering producers, consumers, topics, partitions, replication, Zookeeper coordination, controller election, state machines, and the NIO‑based network model, helping readers understand the design philosophy and practical configuration implications.

ControllerZooKeeperarchitecture
0 likes · 15 min read
Kafka Architecture and Implementation Principles – Theory Part
ITPUB
ITPUB
Apr 12, 2021 · Databases

Hidden Redis Pitfalls That Can Crash Your System – How to Spot and Avoid Them

This article reveals the most common Redis pitfalls—including unexpected key expiration, command‑induced blocking, data‑persistence hazards, and replication inconsistencies—explains why they happen, and provides concrete steps, code snippets and configuration tips to prevent performance degradation or data loss.

BackendCachingPerformance
0 likes · 31 min read
Hidden Redis Pitfalls That Can Crash Your System – How to Spot and Avoid Them
JavaEdge
JavaEdge
Apr 11, 2021 · Databases

Why Redis Replication Can Lose Data and How to Fix It

This article explains the causes of partial resynchronization failures, master‑slave data inconsistency, latency, dirty data, and data‑safety risks in Redis replication, and provides concrete configuration commands and mitigation strategies to ensure reliable data consistency.

Partial SyncRedisreplication
0 likes · 9 min read
Why Redis Replication Can Lose Data and How to Fix It
Tencent Architect
Tencent Architect
Apr 9, 2021 · Databases

Analysis of Inconsistencies in MySQL Slave Crash Recovery and Sync Master/Relay Log Info

This article analyzes how MySQL slave crashes can cause inconsistencies between master info and relay log positions during sync_master_info and sync_relay_log_info processes, presents case studies of duplicated events, explains the impact of different storage repositories (FILE vs TABLE), and recommends configuration settings to achieve server‑crash‑safe replication.

MySQLRelay LogSlave Crash
0 likes · 15 min read
Analysis of Inconsistencies in MySQL Slave Crash Recovery and Sync Master/Relay Log Info
Laravel Tech Community
Laravel Tech Community
Apr 8, 2021 · Cloud Native

Deploying a MySQL Master‑Slave Cluster on Kubernetes Using StatefulSet and Local Persistent Volumes

This article demonstrates how to build a MySQL master‑slave replication cluster on Kubernetes by leveraging StatefulSet for stateful pod management, local persistent volumes for storage, and a series of YAML manifests and commands to configure storage classes, PVs, ConfigMaps, Secrets, Services, and the StatefulSet itself, while also showing how to verify replication and scale the replica set.

KubernetesLocal Persistent VolumeMySQL
0 likes · 18 min read
Deploying a MySQL Master‑Slave Cluster on Kubernetes Using StatefulSet and Local Persistent Volumes
Programmer DD
Programmer DD
Apr 2, 2021 · Databases

3 Proven Paths to Master MySQL Replication and What the New Book Reveals

Discover three effective strategies for mastering a technology, illustrated with MySQL replication, and learn how the new book 'Deep Understanding of MySQL Master‑Slave Principles' combines code analysis, comparative study, and expert insight to guide readers through GTID, binary‑log events, and high‑availability architectures.

GTIDMySQLhigh availability
0 likes · 7 min read
3 Proven Paths to Master MySQL Replication and What the New Book Reveals
JavaEdge
JavaEdge
Apr 1, 2021 · Databases

Master‑Slave Replication in Redis: Mechanisms, Sync Types, and Configuration Guide

This article explains how Redis master‑slave replication operates, covering the underlying mechanisms such as update propagation, partial and full resynchronization, the characteristics and limitations of replication, common single‑node issues, and step‑by‑step instructions for configuring and executing replication commands.

BackendMaster‑SlavePartial Sync
0 likes · 9 min read
Master‑Slave Replication in Redis: Mechanisms, Sync Types, and Configuration Guide
Senior Brother's Insights
Senior Brother's Insights
Mar 29, 2021 · Backend Development

Why Does a Single Kafka Broker Failure Break All Consumers?

A Kafka broker outage can halt consumer consumption despite remaining brokers, due to replication settings, ISR mechanics, and the internal __consumer_offsets topic’s default replication factor, which this article explains and resolves with practical configuration steps.

ACKBackendConsumer Offsets
0 likes · 11 min read
Why Does a Single Kafka Broker Failure Break All Consumers?
Liangxu Linux
Liangxu Linux
Mar 18, 2021 · Operations

Deploying GlusterFS Distributed Replicated Volumes with NFS‑Ganesha

This guide explains the architecture of GlusterFS, compares its volume types, walks through setting up a multi‑node cluster, configuring NFS‑Ganesha for NFSv4 access, and shows how to mount the storage from clients using both GlusterFS and NFS protocols.

GlusterFSLinuxNFS-Ganesha
0 likes · 12 min read
Deploying GlusterFS Distributed Replicated Volumes with NFS‑Ganesha
Aikesheng Open Source Community
Aikesheng Open Source Community
Mar 18, 2021 · Databases

Impact of Different Replication User Creation Methods on MySQL Master‑Slave Replication

The article experimentally evaluates three ways of creating replication users—only on the master, separately on master and slave with CREATE statements, and separately with GRANT statements—to show how each method affects MySQL 5.7 master‑slave replication, error handling, and compatibility with GTID and MySQL 8.0.

Database AdministrationGTIDGrant
0 likes · 8 min read
Impact of Different Replication User Creation Methods on MySQL Master‑Slave Replication
Full-Stack Internet Architecture
Full-Stack Internet Architecture
Mar 11, 2021 · Databases

Understanding Redis Master‑Slave Replication: Architecture, Setup, and Mechanisms

This article provides a comprehensive guide to Redis high‑availability through master‑slave replication, covering the underlying architecture, step‑by‑step setup, full and partial synchronization processes, buffer management, practical pitfalls, and how the mechanism fits into broader Redis HA solutions.

BufferMaster‑SlavePartial Sync
0 likes · 18 min read
Understanding Redis Master‑Slave Replication: Architecture, Setup, and Mechanisms
Aikesheng Open Source Community
Aikesheng Open Source Community
Mar 4, 2021 · Databases

Troubleshooting MySQL Slave Replication Errors Caused by XtraBackup Kill‑Long‑Query Settings

This article explains how to diagnose and resolve MySQL slave replication failures that occur when XtraBackup’s --kill-long-queries-timeout and --kill-long-query-type options interrupt long‑running queries, detailing steps such as checking performance_schema, reviewing error logs, restarting replication, and adjusting backup parameters.

MySQLPerformancedatabase
0 likes · 4 min read
Troubleshooting MySQL Slave Replication Errors Caused by XtraBackup Kill‑Long‑Query Settings
DataFunTalk
DataFunTalk
Feb 13, 2021 · Databases

Improving HBase Availability and Reducing Latency Spikes with Replication‑Based Multi‑Path Reads and ZGC

This article describes how the Didi HBase team tackled HBase’s weak availability and GC‑induced latency spikes by introducing a replication‑based client multi‑path read mechanism, configuring hedged reads, and adopting the Z Garbage Collector, and presents the resulting performance improvements and remaining challenges.

HBaseMulti-Path ReadPerformance Optimization
0 likes · 11 min read
Improving HBase Availability and Reducing Latency Spikes with Replication‑Based Multi‑Path Reads and ZGC
Liangxu Linux
Liangxu Linux
Jan 31, 2021 · Databases

Why MySQL Replication Lags and How to Eliminate It

This article explains the root causes of MySQL master‑slave replication lag—including random replay, high master concurrency, and lock waits—and presents practical solutions such as parallel replication, reducing master load, and reading from the master to ensure data consistency.

LagMaster‑SlaveMySQL
0 likes · 8 min read
Why MySQL Replication Lags and How to Eliminate It
Code Ape Tech Column
Code Ape Tech Column
Jan 29, 2021 · Fundamentals

Fundamentals of Distributed Systems: Concepts, Replication, Consistency, and Protocols

This article provides a comprehensive overview of distributed system fundamentals, covering core concepts such as nodes, replicas, consistency models, data distribution strategies, lease and quorum mechanisms, two‑phase commit, MVCC, Paxos, and the CAP theorem, along with practical considerations for designing robust, scalable services.

CAP theoremConsensusMVCC
0 likes · 53 min read
Fundamentals of Distributed Systems: Concepts, Replication, Consistency, and Protocols
Open Source Linux
Open Source Linux
Jan 27, 2021 · Fundamentals

Unlocking Ceph: A Deep Dive into Distributed Storage Architecture and Features

This article provides a comprehensive overview of Red Hat Ceph’s distributed object‑storage architecture, covering storage pools, authentication, placement groups, the CRUSH algorithm, replication, erasure coding, internal operations, high‑availability mechanisms, client interfaces, and encryption, illustrated with diagrams and practical details.

CRUSHCepherasure-coding
0 likes · 40 min read
Unlocking Ceph: A Deep Dive into Distributed Storage Architecture and Features
Aikesheng Open Source Community
Aikesheng Open Source Community
Jan 19, 2021 · Databases

MySQL 8.0.23 New Features Overview

The article reviews MySQL 8.0.23's maintenance release, detailing new features such as invisible columns, query attributes, security enhancements, InnoDB auto‑extend size, replication terminology changes, X protocol improvements, and various deprecations, providing code examples and links to official documentation.

8.0.23InnoDBInvisible Columns
0 likes · 10 min read
MySQL 8.0.23 New Features Overview
Practical DevOps Architecture
Practical DevOps Architecture
Jan 16, 2021 · Databases

Redis Configuration Guide: redis.conf Settings, Slowlog, Advanced Options, Replication, and Persistence

This comprehensive guide details the essential redis.conf parameters—including daemonization, networking, memory limits, logging, slowlog, advanced data structure encodings, replication options, and persistence settings—providing clear explanations and recommended values for optimal Redis deployment.

PerformancePersistenceRedis
0 likes · 8 min read
Redis Configuration Guide: redis.conf Settings, Slowlog, Advanced Options, Replication, and Persistence
ITPUB
ITPUB
Jan 11, 2021 · Databases

How Redis Replication Works: From Sync Process to Asynchronous Copy

This article explains Redis replication in depth, covering the step‑by‑step replication process, data synchronization mechanisms, full and partial sync workflows, heartbeat design, and asynchronous replication, while highlighting key commands, offsets, and performance considerations.

FullSyncPSYNCPartialSync
0 likes · 13 min read
How Redis Replication Works: From Sync Process to Asynchronous Copy
ITPUB
ITPUB
Jan 10, 2021 · Databases

Redis Replication Deep Dive: Full Sync, Partial Sync, Heartbeat & Async Copy

This article explains Redis's replication mechanism in detail, covering the step-by-step copy process, data synchronization via PSYNC, full and partial synchronization workflows, heartbeat management, and asynchronous replication, while highlighting key commands, offsets, run IDs, and performance considerations.

Partial Syncasynchronousfull sync
0 likes · 13 min read
Redis Replication Deep Dive: Full Sync, Partial Sync, Heartbeat & Async Copy
Architecture Digest
Architecture Digest
Jan 9, 2021 · Databases

MySQL Replication Overview, Configuration, and Common Issues

This article explains MySQL's built‑in replication mechanism, covering its purpose, supported replication formats, step‑by‑step master‑slave configuration, common topologies, troubleshooting techniques, and practical SQL commands for setting up and maintaining reliable data distribution and high availability.

Binary LogConfigurationMaster‑Slave
0 likes · 24 min read
MySQL Replication Overview, Configuration, and Common Issues
Top Architect
Top Architect
Jan 8, 2021 · Databases

MySQL Master‑Slave Replication Setup Guide

This article provides a step‑by‑step tutorial on configuring MySQL master‑slave replication, covering the underlying principles, master and slave configuration files, user creation, data backup, log synchronization, and verification with example commands and code snippets.

Master‑SlaveSQLreplication
0 likes · 8 min read
MySQL Master‑Slave Replication Setup Guide
ITPUB
ITPUB
Jan 5, 2021 · Databases

Master‑Slave MySQL Replication: Full Setup, Types, and Troubleshooting

This guide explains MySQL's built‑in replication, covering statement‑, row‑, and mixed‑mode replication, step‑by‑step master‑slave configuration, user creation, binary‑log settings, topology options, cloning methods, common error scenarios, and practical troubleshooting commands.

ConfigurationMaster‑SlaveMySQL
0 likes · 28 min read
Master‑Slave MySQL Replication: Full Setup, Types, and Troubleshooting
Code Ape Tech Column
Code Ape Tech Column
Dec 30, 2020 · Industry Insights

Why Does a Single Kafka Broker Failure Bring Down Your Consumers?

The article explains Kafka's high‑availability architecture, covering multi‑replica redundancy, ISR mechanisms, producer acknowledgment settings, and a real‑world case where a broker crash halted consumption due to the __consumer_offsets topic's replication factor, then offers concrete remediation steps.

Consumer OffsetsISRKafka
0 likes · 10 min read
Why Does a Single Kafka Broker Failure Bring Down Your Consumers?
Selected Java Interview Questions
Selected Java Interview Questions
Dec 27, 2020 · Operations

Kafka Outage and High Availability Mechanisms

This article examines a Kafka outage scenario in a fintech company, explains Kafka’s multi-replica redundancy design, leader‑follower architecture, ISR mechanism, and how misconfiguration of the __consumer_offset topic can cause cluster-wide consumer failures, and provides solutions to ensure true high availability.

ACKConsumer offsetISR
0 likes · 10 min read
Kafka Outage and High Availability Mechanisms
Didi Tech
Didi Tech
Dec 21, 2020 · Big Data

HBase Availability and Latency Optimizations: Replication‑Based Multi‑Read and ZGC Adoption

To overcome HBase’s weak availability and GC‑induced latency spikes, the DiDi team introduced a replication‑based client multi‑read (hedged‑read) mechanism and migrated to the Z Garbage Collector, which together dramatically cut maximum and 99.9th‑percentile latencies while keeping services online during region disruptions.

HBaseMulti-ReadZGC
0 likes · 12 min read
HBase Availability and Latency Optimizations: Replication‑Based Multi‑Read and ZGC Adoption
Aikesheng Open Source Community
Aikesheng Open Source Community
Dec 18, 2020 · Databases

Analyzing MySQL Replication Heartbeat Incompatibility Caused by Large Binlog Transactions

The article investigates why MySQL replication reports the error “heartbeat is not compatible with local info” when large transactions exceed the 4 GB limit of the binlog's next_position field, reproduces the issue with a controlled experiment, analyzes packet structures, and proposes practical mitigation strategies.

Large TransactionsMySQLheartbeat
0 likes · 7 min read
Analyzing MySQL Replication Heartbeat Incompatibility Caused by Large Binlog Transactions
360 Tech Engineering
360 Tech Engineering
Dec 4, 2020 · Databases

Practical Experience and Tips with TiDB Data Migration (DM) Tool

This article shares a comprehensive overview of TiDB Data Migration (DM), covering its architecture, configuration, online DDL support, common pitfalls such as duplicate‑key errors, large‑scale import tuning, version limits, and cleanup recommendations to help DBAs efficiently migrate MySQL/MariaDB workloads to TiDB.

DMMySQLOnline DDL
0 likes · 16 min read
Practical Experience and Tips with TiDB Data Migration (DM) Tool
360 Zhihui Cloud Developer
360 Zhihui Cloud Developer
Dec 2, 2020 · Databases

How Pika’s Native Distributed Cluster Overcomes Redis Capacity Limits

This article explains Pika’s native distributed cluster architecture, detailing its deployment structure, data distribution with tables and slots, request processing flow, both non‑consistent and Raft‑based log replication, and the enhanced metadata management that enables scalable, high‑availability storage beyond single‑node Redis limitations.

Pikacluster architecturedistributed database
0 likes · 10 min read
How Pika’s Native Distributed Cluster Overcomes Redis Capacity Limits
Full-Stack Internet Architecture
Full-Stack Internet Architecture
Dec 1, 2020 · Databases

Analysis of Redis Master‑Slave Replication and Cluster Working Principles

This article explains the mechanisms of Redis master‑slave data synchronization—including full and partial resynchronization—details the internal workings of Redis clustering, slot assignment, automatic node detection, and failover recovery, and provides practical insights for building reliable Redis deployments.

Redisclusterdata synchronization
0 likes · 12 min read
Analysis of Redis Master‑Slave Replication and Cluster Working Principles
Practical DevOps Architecture
Practical DevOps Architecture
Nov 28, 2020 · Databases

Features, Fault Detection, Limitations, and Deployment Scripts for MySQL Group Replication (MGR)

This article outlines MySQL Group Replication’s key features, fault-detection mechanism, limitations, required environment, and step-by-step deployment scripts, providing a practical guide for setting up a high-availability MySQL cluster on CentOS using the provided shell scripts and configuration files.

Group ReplicationMGRMySQL
0 likes · 6 min read
Features, Fault Detection, Limitations, and Deployment Scripts for MySQL Group Replication (MGR)
360 Tech Engineering
360 Tech Engineering
Nov 24, 2020 · Databases

Architecture and Design of Pika Native Distributed Cluster

The article explains the background, architecture, data distribution, processing flow, replication mechanisms, and management features of Pika's native distributed cluster, detailing how Etcd, LVS, and RocksDB are used to achieve scalable, persistent Redis-compatible storage with table isolation and flexible slot replication.

PikaRedis CompatibilityRocksDB
0 likes · 8 min read
Architecture and Design of Pika Native Distributed Cluster
Qunar Tech Salon
Qunar Tech Salon
Nov 24, 2020 · Databases

Analysis of Galera GTID vs MySQL GTID Issues During Percona XtraDB Cluster Split at Qunar

This article examines how differences between Galera GTID and MySQL GTID caused replication interruptions during a Percona XtraDB Cluster (PXC) split at Qunar, details the migration procedure, reproduces the problem with step‑by‑step commands, explains GTID concepts, and proposes operational improvements to avoid data inconsistency.

GTIDGaleraMySQL
0 likes · 17 min read
Analysis of Galera GTID vs MySQL GTID Issues During Percona XtraDB Cluster Split at Qunar
Architects' Tech Alliance
Architects' Tech Alliance
Nov 22, 2020 · Databases

Database High Availability: HADR, HACMP, Data Replication, Storage DR, and DPF Solutions

This article provides a comprehensive overview of database high‑availability techniques—including DB2 HADR, HACMP clustering, SQL and Q replication, storage‑layer disaster recovery, and DPF considerations—explaining their features, suitable scenarios, and how they can be combined to achieve robust end‑to‑end resilience.

DB2HADRdatabase
0 likes · 11 min read
Database High Availability: HADR, HACMP, Data Replication, Storage DR, and DPF Solutions
macrozheng
macrozheng
Nov 20, 2020 · Operations

How Redis Achieves High Availability: A Story of Replication and Failover

This article narrates how Redis, personified as a character, synchronizes data between master and slave nodes through command propagation, adopts improved sync strategies, and uses Sentinel's INFO and PING checks to detect failures and automatically trigger failover, illustrating a practical high‑availability cache service.

RedisSentinelfailover
0 likes · 4 min read
How Redis Achieves High Availability: A Story of Replication and Failover
ITPUB
ITPUB
Nov 10, 2020 · Databases

Essential SQL Server Cheat Sheet: 80+ Queries for Administration and Monitoring

This comprehensive cheat sheet gathers over eighty practical T‑SQL statements covering instance properties, configuration, system views, lock monitoring, backup progress, replication, Always On, FILESTREAM, job management, index maintenance, and security, providing DBAs with ready‑to‑run commands for everyday SQL Server administration and troubleshooting.

Database AdministrationSQL ServerT-SQL
0 likes · 29 min read
Essential SQL Server Cheat Sheet: 80+ Queries for Administration and Monitoring
Aikesheng Open Source Community
Aikesheng Open Source Community
Oct 20, 2020 · Databases

MySQL 8.0.22 Release Highlights and New Features

MySQL 8.0.22 introduces prepared‑statement improvements, a new SHOW PROCESSLIST implementation via Performance Schema, UTC timestamp handling, read‑only schemas, error‑log access through Performance Schema, user‑management enhancements, optimizer push‑down, replication auto‑failover, Router scalability upgrades, and several deprecations and removals.

8.0.22MySQLPrepared Statements
0 likes · 9 min read
MySQL 8.0.22 Release Highlights and New Features
vivo Internet Technology
vivo Internet Technology
Oct 14, 2020 · Databases

MySQL Clone Plugin – Installation, Usage, Progress Monitoring, Implementation Details, Limitations, and Comparison with XtraBackup

The MySQL Clone Plugin, added in 8.0.17, enables fast local or remote cloning of InnoDB data by installing the plugin, issuing CLONE commands, monitoring progress via performance_schema tables, and using the resulting GTID or binlog coordinates to build replicas, while observing limitations such as DDL restrictions and single‑instance operation, and offering advantages over XtraBackup through an extra page‑copy stage and simplified GTID handling.

Clone PluginInnoDBMySQL
0 likes · 22 min read
MySQL Clone Plugin – Installation, Usage, Progress Monitoring, Implementation Details, Limitations, and Comparison with XtraBackup
Top Architect
Top Architect
Oct 10, 2020 · Databases

Redis Interview Guide: Core Concepts, Caching with Spring Boot, Persistence, Replication, Sentinel and Performance

This comprehensive guide explains what Redis is, its data structures and features, demonstrates how to use Redis as a cache in Spring Boot applications, discusses cache eviction policies, persistence mechanisms, replication, Sentinel high‑availability, and performance characteristics while also covering common interview questions such as cache snowball, penetration and breakdown.

PerformancePersistenceSentinel
0 likes · 30 min read
Redis Interview Guide: Core Concepts, Caching with Spring Boot, Persistence, Replication, Sentinel and Performance
Programmer DD
Programmer DD
Sep 27, 2020 · Databases

How Redis Sentinel Guarantees Automatic Failover and High Availability

This article explains how Redis Sentinel provides automatic failover and high availability by using master‑slave replication, multiple Sentinel nodes, consensus‑based leader election, and client notification mechanisms to ensure continuous service despite node failures.

RedisSentineldatabase
0 likes · 11 min read
How Redis Sentinel Guarantees Automatic Failover and High Availability
Efficient Ops
Efficient Ops
Sep 22, 2020 · Databases

Mastering MySQL Master‑Slave Replication: A Step‑by‑Step Guide

This article explains what MySQL master‑slave replication is, outlines its benefits, details the underlying mechanisms and event types, and provides a comprehensive, command‑line tutorial for configuring both master and slave servers, complete with code snippets and illustrative diagrams.

Binary LogMaster‑SlaveMySQL
0 likes · 9 min read
Mastering MySQL Master‑Slave Replication: A Step‑by‑Step Guide
IT Xianyu
IT Xianyu
Sep 15, 2020 · Databases

Understanding MySQL Log Files: Redo Log, Undo Log, and Binary Log

This article explains MySQL’s six log files, focusing on the redo log, undo log, and binary log, detailing their purposes, contents, generation and release timing, associated physical files, configuration parameters, and their roles in transaction durability and replication.

Binary LogMySQLlog
0 likes · 11 min read
Understanding MySQL Log Files: Redo Log, Undo Log, and Binary Log
Programmer DD
Programmer DD
Sep 12, 2020 · Databases

Mastering SQL Server: Essential Commands, Tips, and Advanced Techniques

This comprehensive guide covers SQL Server fundamentals and advanced operations, including database creation, table manipulation, indexing, view management, backup and restore procedures, performance tuning, replication setup, linked servers, and a collection of practical code snippets for everyday database tasks.

Database ManagementSQL ServerSQL commands
0 likes · 25 min read
Mastering SQL Server: Essential Commands, Tips, and Advanced Techniques
JavaEdge
JavaEdge
Sep 5, 2020 · Databases

Master‑Slave Replication in Redis: How It Works, Configurations, and Pitfalls

This article explains Redis's asynchronous master‑slave replication, covering the three core mechanisms, partial and full resynchronization processes, configuration methods, diskless sync, key expiration handling, replication IDs and offsets, and safety considerations when disabling persistence.

BacklogDisklessMaster‑Slave
0 likes · 16 min read
Master‑Slave Replication in Redis: How It Works, Configurations, and Pitfalls
Architects Research Society
Architects Research Society
Sep 2, 2020 · Databases

Scaling PostgreSQL for Multi‑Terabyte Databases: Indexes, Partitioning, Tablespaces, Parallelism, and Replication

This article explains how to extract maximum performance and scalability from PostgreSQL for multi‑terabyte workloads by leveraging specialized indexes, declarative partitioning, tablespaces, parallel query execution, read‑only replica load‑balancing, and foreign‑table sharding techniques.

Database ScalingParallelismPartitioning
0 likes · 10 min read
Scaling PostgreSQL for Multi‑Terabyte Databases: Indexes, Partitioning, Tablespaces, Parallelism, and Replication
iQIYI Technical Product Team
iQIYI Technical Product Team
Aug 28, 2020 · Databases

iQIYI's Custom MySQL High‑Availability Architecture

iQIYI’s custom MySQL HA solution replaces the single‑point‑failure MHA manager with a Raft‑based trio of HA Masters and HA Agents that continuously monitor instances, automatically perform same‑DC, cross‑DC, or cross‑region failovers, reconcile diff binlogs, ensure data consistency, and integrate with CMDB, tracing and chaos‑engineering platforms.

HA ArchitectureMHAMySQL
0 likes · 10 min read
iQIYI's Custom MySQL High‑Availability Architecture
Aikesheng Open Source Community
Aikesheng Open Source Community
Aug 26, 2020 · Databases

Deep Dive into MySQL Seconds_Behind_Master Calculation in Dual‑Master Replication

This article investigates why the Seconds_Behind_Master metric fluctuates in a dual‑master MySQL setup, explains the underlying replication logic, reproduces the issue, and analyses the handling of ROTATE_EVENT and other binlog events in both parallel and non‑parallel replication modes using source code excerpts.

BinaryLogDatabasePerformanceMySQL
0 likes · 27 min read
Deep Dive into MySQL Seconds_Behind_Master Calculation in Dual‑Master Replication
Architects Research Society
Architects Research Society
Aug 15, 2020 · Databases

Interview with Apache CouchDB Project Leaders on Features, Use Cases, and Future Directions

In this interview, Apache CouchDB project leaders Adam Kocoloski and Jan Lehnardt discuss the database's unique replication model, strengths and weaknesses, notable real‑world deployments, upcoming 3.0 and 4.0 releases, Kubernetes deployment advice, and guidance for newcomers to Erlang and the CouchDB community.

CouchDBKubernetesNoSQL
0 likes · 17 min read
Interview with Apache CouchDB Project Leaders on Features, Use Cases, and Future Directions
Aikesheng Open Source Community
Aikesheng Open Source Community
Aug 11, 2020 · Databases

Understanding MySQL Row‑Based Replication: RelayLog Replay, binlog_row_image, and slave_rows_search_algorithms

This article analyzes MySQL data‑update loss caused by writes on master‑slave pairs, explains BEFORE and AFTER IMAGE handling in row‑based binlogs, examines the binlog_row_image and slave_rows_search_algorithms parameters, and details the implementation of hash, index, and table scans during slave replay.

HashScanMySQLindex
0 likes · 18 min read
Understanding MySQL Row‑Based Replication: RelayLog Replay, binlog_row_image, and slave_rows_search_algorithms
ITPUB
ITPUB
Aug 7, 2020 · Databases

How Changing the COMPATIBLE Parameter Fixed ORA-600 Errors on Oracle Standby

A single‑instance Oracle 11.2.0.4 primary‑standby setup on Windows encountered ORA‑600 errors on archived logs 17620 and 17621 after manual file deletions, and the detailed troubleshooting revealed a mismatched COMPATIBLE parameter that was corrected, allowing the standby to apply the missing logs and resume synchronization.

COMPATIBLEORA-600Oracle
0 likes · 9 min read
How Changing the COMPATIBLE Parameter Fixed ORA-600 Errors on Oracle Standby