BestHub
Sign in
Tagged articles

replication

737 articles · Page 7 of 8
ITPUB
ITPUB
Nov 8, 2017 · Databases

Achieving Zero Data Loss and High Availability in Finance with PostgreSQL Replication

This article explains how PostgreSQL's streaming replication can provide zero data loss, high availability, and disaster‑recovery for financial institutions, detailing feedback and consistency metrics, architecture simplifications, configuration examples, performance impact, failover rules, flexibility, and cost considerations.

PostgreSQLZero Data Lossfinancial services
0 likes · 10 min read
Achieving Zero Data Loss and High Availability in Finance with PostgreSQL Replication
ITPUB
ITPUB
Nov 6, 2017 · Databases

How to Set Up MySQL Master‑Slave Replication with Docker in Minutes

This guide walks you through building custom MySQL Docker images, configuring master and slave my.cnf files, launching the containers, creating a replication user, and synchronizing the slave using Docker commands and a ready‑made shell script, all with detailed code examples.

DockerMaster‑Slavedatabase
0 likes · 10 min read
How to Set Up MySQL Master‑Slave Replication with Docker in Minutes
Architecture Digest
Architecture Digest
Oct 26, 2017 · Databases

Redis Overview: Architecture, Master‑Slave Replication, Cluster Design, Persistence and Failure Handling

This article provides a comprehensive English overview of Redis, covering its in‑memory key‑value data model, master‑slave replication, cluster topology, installation steps, persistence mechanisms (RDB and AOF), consistency hashing, node failure detection, slave election, and the advantages and drawbacks of using Redis Cluster.

ClusteringIn-Memory DatabasePersistence
0 likes · 16 min read
Redis Overview: Architecture, Master‑Slave Replication, Cluster Design, Persistence and Failure Handling
ITPUB
ITPUB
Oct 22, 2017 · Databases

Mastering Redis: Core Data Structures, Commands, and Performance Tuning

Redis is an open-source, in-memory data store offering versatile structures and commands; this guide explains its fundamentals, key data types, essential commands, practical examples, performance optimization techniques, replication, clustering, and Java client choices to help you design robust, high-performance Redis solutions.

Data StructuresJava ClientPerformance Tuning
0 likes · 29 min read
Mastering Redis: Core Data Structures, Commands, and Performance Tuning
dbaplus Community
dbaplus Community
Sep 6, 2017 · Databases

How to Build a MongoDB Database-as-a-Service Platform: Architecture, Features, and Best Practices

This article explains the concept of Database-as-a-Service (DBaaS), introduces MongoDB’s core capabilities, outlines the essential components such as lifecycle management, disaster recovery, monitoring, and value‑added services, and provides practical guidance on building a production‑grade MongoDB DBaaS platform.

DBaaSDatabase-as-a-ServiceMongoDB
0 likes · 19 min read
How to Build a MongoDB Database-as-a-Service Platform: Architecture, Features, and Best Practices
dbaplus Community
dbaplus Community
Sep 5, 2017 · Big Data

Why Kafka Needs High Availability: Deep Dive into Replication and Leader Election

This article explains why Kafka introduced High Availability in version 0.8, covering the necessity of data replication and leader election, the internal replication and ACK mechanisms, Zookeeper metadata structures, broker failover procedures, and the command‑line tools that help manage and rebalance a Kafka cluster.

High AvailabilityLeader Electionkafka
0 likes · 36 min read
Why Kafka Needs High Availability: Deep Dive into Replication and Leader Election
MaGe Linux Operations
MaGe Linux Operations
Sep 3, 2017 · Databases

Top MySQL Interview Q&A: Replication, InnoDB, Optimization & Backup

This article compiles a comprehensive set of MySQL interview questions covering replication mechanisms, differences between MyISAM and InnoDB, character type nuances, transaction logging, binlog formats, performance tuning, backup strategies, monitoring, consistency checks, and handling large datasets, providing concise answers for each topic.

InnoDBPerformance Tuningbackup
0 likes · 18 min read
Top MySQL Interview Q&A: Replication, InnoDB, Optimization & Backup
21CTO
21CTO
Aug 30, 2017 · Databases

9 Classic MySQL Errors and How to Fix Them

This article presents nine classic MySQL error cases—from connection limits and replication conflicts to installation permission issues, forgotten passwords, auto‑increment resets, character‑set garbling, binlog misconfiguration, timeout problems, and file‑open limits—each accompanied by clear diagnosis steps and practical solutions.

Character SetDatabase Errorsauto_increment
0 likes · 16 min read
9 Classic MySQL Errors and How to Fix Them
dbaplus Community
dbaplus Community
Aug 22, 2017 · Databases

How UDB Supercharges MySQL Replication with Deep Kernel Optimizations

This article details UDB's high‑availability architecture and four kernel‑level optimizations—binlog replication, relay‑log recording, master.info handling, and relay‑log locking—that together improve MySQL semi‑synchronous replication performance and reliability.

High AvailabilitySemi-synchronousUDB
0 likes · 9 min read
How UDB Supercharges MySQL Replication with Deep Kernel Optimizations
21CTO
21CTO
Aug 22, 2017 · Databases

Mastering Redis Replication in Java: How Redis‑Replicator Works and Extends

Redis‑replicator is a lightweight Java library that implements Redis master‑slave synchronization, parses RDB and AOF files, supports Redis 2.6‑4.0 (including modules), and offers extensible command and module hooks, making it suitable for embedding in backend systems.

AOFDatabase ToolsJava
0 likes · 5 min read
Mastering Redis Replication in Java: How Redis‑Replicator Works and Extends
MaGe Linux Operations
MaGe Linux Operations
Aug 17, 2017 · Databases

Top 10 MySQL Errors Every DBA Should Know and How to Fix Them

This article compiles ten classic MySQL error scenarios—from connection limits and replication conflicts to charset issues and file‑open limits—explaining the root causes, diagnostic commands, and step‑by‑step solutions so beginners and seasoned DBAs can troubleshoot confidently.

CharsetDatabase ErrorsSQL
0 likes · 16 min read
Top 10 MySQL Errors Every DBA Should Know and How to Fix Them
Alibaba Cloud Developer
Alibaba Cloud Developer
Aug 10, 2017 · Big Data

Alibaba’s HBase Innovations: Powering Big Data at Scale – HBaseCon 2017 Asia Insights

At HBaseCon 2017 Asia, Alibaba showcased a series of groundbreaking HBase enhancements—including strong synchronous replication, SQL-on-HBase capabilities, cross‑cluster range data copy, and read/write path optimizations—that dramatically improve performance, reliability, and usability for large‑scale big‑data storage.

Big DataDistributed storageHBase
0 likes · 10 min read
Alibaba’s HBase Innovations: Powering Big Data at Scale – HBaseCon 2017 Asia Insights
Efficient Ops
Efficient Ops
Jul 26, 2017 · Databases

Mastering Redis: Data Structures, Commands, and Performance Tuning

This comprehensive guide introduces Redis fundamentals, explores its rich data structures and essential commands, delves into performance optimization techniques, explains replication and clustering strategies, and compares popular Java clients, providing practical examples and best‑practice recommendations for reliable, high‑performance deployments.

Data StructuresJava ClientRedis
0 likes · 31 min read
Mastering Redis: Data Structures, Commands, and Performance Tuning
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
Architecture Digest
Architecture Digest
Jul 6, 2017 · Fundamentals

PacificA: Microsoft’s General Replication Framework for Large‑Scale Distributed Storage Systems

PacificA is Microsoft’s generic replication framework for large‑scale distributed storage systems that provides strong consistency, separates configuration management from data replication, and uses a primary‑secondary model with lease‑based fault detection to ensure availability, correctness, and efficient operation across heterogeneous nodes.

Distributed storagePacificAconsistency
0 likes · 14 min read
PacificA: Microsoft’s General Replication Framework for Large‑Scale Distributed Storage Systems
ITFLY8 Architecture Home
ITFLY8 Architecture Home
Jul 1, 2017 · Fundamentals

Designing Distributed File Systems: Solving Local FS Limits

Distributed file systems extend traditional local storage by partitioning data across multiple servers, using a master node for metadata and coordination, handling namespace, replication, load balancing, caching, and client interfaces, thereby overcoming file size, quantity, and concurrency constraints of ext3, reiserfs, and similar local filesystems.

CachingDistributed File Systemmetadata management
0 likes · 15 min read
Designing Distributed File Systems: Solving Local FS Limits
ITPUB
ITPUB
Jun 28, 2017 · Databases

Why MySQL Replication Shows ‘Duplicate Primary’ Errors – Binlog, Auto‑Increment & Trigger Insights

During synchronization from MySQL 5.0 to 5.7, a slave worker raised a ‘duplicate primary’ error; the article examines binlog statements, auto‑increment values, and a problematic trigger, walks through various debugging attempts, and concludes that removing the trigger resolves the issue despite unclear root cause.

Duplicate PrimaryTriggersmysql
0 likes · 6 min read
Why MySQL Replication Shows ‘Duplicate Primary’ Errors – Binlog, Auto‑Increment & Trigger Insights
dbaplus Community
dbaplus Community
Jun 12, 2017 · Databases

How to Diagnose and Fix MySQL Replication Errors in UDB

This guide explains how to collect replication status, analyze MySQL error logs and binary logs, compare master and slave configurations, and troubleshoot common replication failures such as GTID mismatches, missing binlogs, and conflicting statements in UDB environments.

GTIDUDBbinary log
0 likes · 20 min read
How to Diagnose and Fix MySQL Replication Errors in UDB
21CTO
21CTO
Jun 11, 2017 · Big Data

How Kafka Guarantees High Reliability – Architecture, Replication & Benchmarks

This article explains Kafka's distributed architecture, topic‑partition model, replication and ISR mechanisms, data durability settings, delivery guarantees, deduplication strategies, and presents benchmark results that illustrate how configuration choices affect throughput and latency in real‑world deployments.

Distributed MessagingHigh reliabilityPerformance Benchmark
0 likes · 33 min read
How Kafka Guarantees High Reliability – Architecture, Replication & Benchmarks
dbaplus Community
dbaplus Community
May 24, 2017 · Databases

Inside Amazon Aurora: Cloud‑Native Architecture, Write/Read Path, and Recovery

This article provides an in‑depth technical analysis of Amazon Aurora’s cloud‑native relational database design, covering its architectural models, log‑as‑database philosophy, optimized write and read paths, fault‑tolerant replication, group commit, and fast recovery mechanisms compared with traditional DBMS.

AuroraDatabase ArchitectureRecovery
0 likes · 27 min read
Inside Amazon Aurora: Cloud‑Native Architecture, Write/Read Path, and Recovery
Qunar Tech Salon
Qunar Tech Salon
May 12, 2017 · Databases

High Availability Solutions for MySQL and UDB: Techniques and Case Study

The article explains high‑availability concepts, compares typical MySQL HA architectures—including replication, clustering, and Paxos‑based solutions—and presents UDB’s dual‑master semi‑synchronous design with a Proxy layer that ensures automatic failover, data consistency, and operational resilience.

High AvailabilityUDBdatabase
0 likes · 12 min read
High Availability Solutions for MySQL and UDB: Techniques and Case Study
ITFLY8 Architecture Home
ITFLY8 Architecture Home
May 8, 2017 · Fundamentals

Designing Scalable Distributed File Systems: Architecture, Challenges, and Solutions

This article explains how distributed file systems overcome the limitations of traditional local file systems by using a master‑metadata server, multiple data nodes, and client interfaces, and it details the key architectural components, common problems, and practical engineering solutions such as replication, load balancing, and caching.

Distributed File Systemarchitecturemetadata management
0 likes · 15 min read
Designing Scalable Distributed File Systems: Architecture, Challenges, and Solutions
Ctrip Technology
Ctrip Technology
Apr 20, 2017 · Backend Development

XPipe: Multi‑Data‑Center Redis Replication, High Availability and Disaster‑Recovery Switching

This article introduces XPipe, a framework designed by Ctrip to enable Redis multi‑data‑center replication, ensure high availability through keeper and MetaServer components, and provide reliable disaster‑recovery (DR) switching while maintaining low latency and data consistency.

Disaster RecoveryHigh AvailabilityMulti-Data Center
0 likes · 9 min read
XPipe: Multi‑Data‑Center Redis Replication, High Availability and Disaster‑Recovery Switching
ITPUB
ITPUB
Apr 17, 2017 · Databases

How to Build a Multi‑Master to Single‑Slave MySQL 5.7 Replication Setup

This guide walks through preparing three CentOS 6.7 machines, installing MySQL 5.7.17, configuring my.cnf, disabling firewalls and SELinux, creating replication users, exporting databases, setting up multi‑source replication with GTID, and verifying data consistency across two masters and one slave.

CentOSGTIDdatabase
0 likes · 10 min read
How to Build a Multi‑Master to Single‑Slave MySQL 5.7 Replication Setup
ITFLY8 Architecture Home
ITFLY8 Architecture Home
Apr 11, 2017 · Databases

Why High Availability Triggers a Consistency‑Performance Trade‑off in Distributed Databases

The article explains how achieving high availability through data redundancy introduces consistency challenges that in turn affect performance, and it reviews partitioning, mirroring, consistency models, replication architectures, and two/three‑phase commit protocols in distributed systems.

Data ConsistencyHigh Availabilitydistributed systems
0 likes · 18 min read
Why High Availability Triggers a Consistency‑Performance Trade‑off in Distributed Databases
dbaplus Community
dbaplus Community
Apr 9, 2017 · Databases

Recovering MySQL Replication After a Massive Binlog Overflow

This article explains why a large‑transaction update caused a binlog overflow and slave I/O failure in a remote MySQL master‑slave setup, and provides step‑by‑step commands and a stored‑procedure solution to restore replication safely.

GTIDStored Proceduremysql
0 likes · 7 min read
Recovering MySQL Replication After a Massive Binlog Overflow
Alibaba Cloud Developer
Alibaba Cloud Developer
Apr 1, 2017 · Databases

Alibaba’s HBase Scaling Secrets: High‑Availability, Replication, Performance

This article details how Alibaba has evolved HBase from an internal storage solution to a cloud service, covering its architecture, high‑availability design, asynchronous and synchronous replication, multi‑link data flows, cost‑effective redundancy, performance optimizations, and future development directions.

Distributed storageHBasereplication
0 likes · 28 min read
Alibaba’s HBase Scaling Secrets: High‑Availability, Replication, Performance
Architecture Digest
Architecture Digest
Mar 25, 2017 · Databases

Design, Optimization, and Future Directions of Alibaba HBase for Large‑Scale Data Storage

This article describes Alibaba's extensive use of HBase, covering its architecture, high‑availability replication strategies, multi‑link data flow, synchronous and asynchronous replication, performance optimizations, data export pipelines, and future development plans for the distributed NoSQL database.

big-datadata-pipelinedistributed-storage
0 likes · 27 min read
Design, Optimization, and Future Directions of Alibaba HBase for Large‑Scale Data Storage
Alibaba Cloud Developer
Alibaba Cloud Developer
Mar 24, 2017 · Databases

Alibaba’s Secrets to Scaling HBase for PB‑Level Big Data

This article explains how Alibaba built, customized, and operated a massive HBase platform—covering its architecture, high‑availability design, asynchronous and synchronous replication, multi‑link data flow, cost‑aware redundancy, cross‑cluster migration, performance optimizations, and future directions for the distributed NoSQL database.

AlibabaHBasedistributed database
0 likes · 29 min read
Alibaba’s Secrets to Scaling HBase for PB‑Level Big Data
ITPUB
ITPUB
Mar 19, 2017 · Databases

Diagnosing and Fixing MySQL 5.7 Memory Leak in Thread/sql/slave_sql

This article walks through a real‑world MySQL 5.7 memory‑leak case, showing how to use performance_schema, pmap, and thread analysis to identify runaway threads and fix the issue by closing unclosed cursors.

Monitoring PluginPerformance SchemaThread analysis
0 likes · 6 min read
Diagnosing and Fixing MySQL 5.7 Memory Leak in Thread/sql/slave_sql
ITPUB
ITPUB
Mar 15, 2017 · Databases

From Table Design to Scalable MySQL: A Complete Optimization Roadmap

This article outlines the five evolutionary stages of a MySQL deployment—table design, deployment, performance tuning, architecture scaling, and maintenance—detailing practical configuration tweaks, kernel and hardware optimizations, replication strategies, caching, sharding, partitioning, and essential monitoring and backup techniques.

Performance TuningShardingbackup
0 likes · 18 min read
From Table Design to Scalable MySQL: A Complete Optimization Roadmap
dbaplus Community
dbaplus Community
Mar 13, 2017 · Databases

MySQL 5.7 FAQ Highlights: NDB Cluster, Stored Routines, Replication & Encryption

This curated excerpt from the MySQL 5.7 FAQ provides concise answers on NDB Cluster versions and deployment, network and hardware requirements, memory sizing formulas, virtual machine support, common error causes, user management, replication setup and limitations, trigger behavior, and InnoDB tablespace encryption details, linking to official documentation for deeper reference.

FAQInnoDB EncryptionNDB Cluster
0 likes · 23 min read
MySQL 5.7 FAQ Highlights: NDB Cluster, Stored Routines, Replication & Encryption
Qunar Tech Salon
Qunar Tech Salon
Mar 9, 2017 · Databases

MySQL DBA Interview Guidance and Insights

This article offers comprehensive advice on MySQL DBA interview preparation, covering the book’s positioning, essential technical topics such as replication and InnoDB internals, desired personal qualities, interview strategies, and practical tips for both interviewers and candidates.

DBAInnoDBinterview
0 likes · 8 min read
MySQL DBA Interview Guidance and Insights
Architects' Tech Alliance
Architects' Tech Alliance
Feb 18, 2017 · Databases

Oracle TimesTen In-Memory Database: Architecture, Features, and Replication

Oracle TimesTen In-Memory Database, acquired by Oracle, offers a memory-optimized relational database with shared libraries, checkpointing, logging, and advanced replication options such as synchronous and asynchronous data replication, cache integration, and broad OS/CPU compatibility, positioning it as a high‑performance alternative to traditional RDBMS.

Cache ConnectDatabase ArchitectureIn-Memory Database
0 likes · 11 min read
Oracle TimesTen In-Memory Database: Architecture, Features, and Replication
MaGe Linux Operations
MaGe Linux Operations
Jan 12, 2017 · Databases

Mastering Redis: Persistence, Replication, and Sentinel for High Availability

This article explains Redis fundamentals, its key‑value storage model, advanced data structures, persistence mechanisms (RDB and AOF), replication architecture, and how Sentinel provides automated failover and high‑availability management, complemented by practical configuration examples and performance considerations.

AOFHigh AvailabilityPersistence
0 likes · 12 min read
Mastering Redis: Persistence, Replication, and Sentinel for High Availability
dbaplus Community
dbaplus Community
Jan 12, 2017 · Databases

Mastering MySQL Group Replication: Full‑Sync Architecture, Benefits, and Step‑by‑Step Setup

This article explains MySQL's asynchronous, semi‑synchronous, and Group Replication mechanisms, compares their trade‑offs, details Group Replication’s certification‑based full‑sync workflow, lists its features and limitations, and provides a complete configuration and maintenance guide for a three‑node cluster.

ConfigurationGroup ReplicationHigh Availability
0 likes · 13 min read
Mastering MySQL Group Replication: Full‑Sync Architecture, Benefits, and Step‑by‑Step Setup
dbaplus Community
dbaplus Community
Dec 16, 2016 · Databases

Why MariaDB Beats MySQL: Features, Compatibility, and Performance Insights

This article explains how MariaDB, a community‑driven fork of MySQL, maintains full compatibility while adding new storage engines, advanced replication, performance‑boosting features like XtraDB and thread pools, and why many organizations consider it a superior replacement for Oracle‑owned MySQL.

MariaDBStorage Enginedatabase
0 likes · 9 min read
Why MariaDB Beats MySQL: Features, Compatibility, and Performance Insights
dbaplus Community
dbaplus Community
Dec 12, 2016 · Databases

Mastering MySQL GTID: From Basics to Advanced Replication and Recovery

This comprehensive guide explains MySQL GTID fundamentals, its syntax, how to view and generate GTIDs, configure GTID‑based replication, troubleshoot replication errors, integrate GTID with backup/restore, MHA failover, and ensure crash‑safe slaves while discussing performance trade‑offs.

Crash SafetyGTIDMHA
0 likes · 24 min read
Mastering MySQL GTID: From Basics to Advanced Replication and Recovery
dbaplus Community
dbaplus Community
Dec 5, 2016 · Databases

Master‑Slave Replication, Backup & Recovery in MySQL – A Complete Step‑by‑Step Guide

This article provides a comprehensive, hands‑on guide to MySQL master‑slave replication, covering configuration changes, creating replication users, backing up the master, restoring to slaves, setting up read/write splitting, handling master failures, implementing dual‑master setups, and performing full and incremental backups and restores.

DualMasterMasterFailureReadWriteSplit
0 likes · 17 min read
Master‑Slave Replication, Backup & Recovery in MySQL – A Complete Step‑by‑Step Guide
MaGe Linux Operations
MaGe Linux Operations
Nov 26, 2016 · Databases

Master MongoDB Sharding: Step-by-Step Setup and Verification

This guide walks through the reasons for sharding in MongoDB, explains the sharding architecture, and provides detailed commands to configure config servers, shard servers, and mongos, add shards, enable sharding on databases and collections, insert test data, and verify successful data distribution across shards.

MongoDBShardingcluster
0 likes · 8 min read
Master MongoDB Sharding: Step-by-Step Setup and Verification
dbaplus Community
dbaplus Community
Nov 22, 2016 · Databases

How to Add a ‘STOP ALL SLAVES’ Command to MySQL 5.6 Source Code

This guide walks through extending MySQL 5.6.32 by adding a new SQLCOM_STOP_SLAVES command that stops all replication slaves, detailing modifications to lex.h, sql_cmd.h, sql_yacc.yy, sql_parse.cc, and mysqld.cc, along with compilation tips and troubleshooting steps.

C#High AvailabilitySQL Command
0 likes · 7 min read
How to Add a ‘STOP ALL SLAVES’ Command to MySQL 5.6 Source Code
dbaplus Community
dbaplus Community
Nov 7, 2016 · Databases

Master‑Slave MySQL Replication: Multi‑Source and Parallel Techniques Explained

This article explains MySQL replication fundamentals, explores multi‑source master‑slave architectures, details step‑by‑step configuration for both basic 1‑master‑1‑slave and multi‑source setups, introduces parallel replication to boost performance, and presents Sysbench‑based testing results that demonstrate the efficiency gains.

Database Architecturemulti-sourcemysql
0 likes · 13 min read
Master‑Slave MySQL Replication: Multi‑Source and Parallel Techniques Explained
ITPUB
ITPUB
Oct 23, 2016 · Databases

Essential MongoDB Interview Questions & Answers You Need to Master

This comprehensive guide presents the most common MongoDB interview questions, covering NoSQL fundamentals, replication, sharding, transactions, profiling, storage nuances, and operational details, providing concise yet thorough answers to help candidates confidently tackle technical interviews.

MongoDBNoSQLSharding
0 likes · 11 min read
Essential MongoDB Interview Questions & Answers You Need to Master
ITPUB
ITPUB
Oct 8, 2016 · Databases

Mastering Database Sharding, Replication, and High‑Availability Strategies

This article explains core database concepts such as sharding, replication, routing strategies, and high‑availability designs, detailing how to achieve read/write separation, cache integration, and consistency handling in a master‑slave architecture for large‑scale systems.

Read‑Write SeparationRoutingSharding
0 likes · 8 min read
Mastering Database Sharding, Replication, and High‑Availability Strategies
dbaplus Community
dbaplus Community
Sep 30, 2016 · Databases

How NetEase Hive RDS Enables Fast, Reliable MySQL Instance Migration

This article explains NetEase Hive RDS's instance migration feature, covering use cases, technical challenges such as consistent backup, business impact, data import speed, incremental sync, and the solutions implemented—including multi‑threaded logical backup with mydumper, load‑aware throttling, parallel import with myloader, and filtered replication—to achieve efficient and safe MySQL migrations.

Instance MigrationRDSbackup
0 likes · 16 min read
How NetEase Hive RDS Enables Fast, Reliable MySQL Instance Migration
ITPUB
ITPUB
Sep 25, 2016 · Databases

How Redis 2.8 Introduces Partial Replication to Avoid Full Sync on Network Glitches

This article explains Redis’s master‑slave replication mechanism, compares the full‑copy process of Redis 2.4.16 with the partial‑copy improvements introduced in Redis 2.8, details the state machine, replication‑cron workflow, repl_backlog buffer, run‑id handling, and configuration options for optimizing partial synchronization during network interruptions.

Partial SyncRedisbackend
0 likes · 11 min read
How Redis 2.8 Introduces Partial Replication to Avoid Full Sync on Network Glitches
ITPUB
ITPUB
Sep 10, 2016 · Databases

How to Set Up MySQL Master‑Slave Replication on Linux: Step‑by‑Step Guide

This guide walks you through configuring a MySQL master‑slave cluster on two Linux servers, covering MySQL configuration files, service restarts, replication user creation, master status capture, slave setup, start‑up, verification, testing data sync, and troubleshooting common issues.

ConfigurationLinuxMaster‑Slave
0 likes · 6 min read
How to Set Up MySQL Master‑Slave Replication on Linux: Step‑by‑Step Guide
Practical DevOps Architecture
Practical DevOps Architecture
Sep 8, 2016 · Databases

MySQL Database Architecture Evolution, Design, Deployment, Optimization, and Maintenance Guide

This article outlines the lifecycle of a mature MySQL database architecture, covering table design, deployment, performance tuning, scaling strategies such as replication, sharding and partitioning, as well as maintenance tasks like monitoring, backup, and repair, with practical configuration examples.

Performance Tuningbackupdatabase optimization
0 likes · 17 min read
MySQL Database Architecture Evolution, Design, Deployment, Optimization, and Maintenance Guide
WeChat Backend Team
WeChat Backend Team
Aug 30, 2016 · Databases

How PhxSQL Achieves MySQL‑Compatible High Availability with Paxos‑Based Replication

PhxSQL is an open‑source, MySQL‑compatible relational database cluster that uses a Paxos‑based log store and a three‑layer architecture (Phxbinlogsvr, Phxsqlproxy, Phxsync) to provide automatic master failover, strong data consistency, and improved write performance compared to MySQL semi‑synchronous replication.

High AvailabilityPaxosdatabase clustering
0 likes · 10 min read
How PhxSQL Achieves MySQL‑Compatible High Availability with Paxos‑Based Replication
dbaplus Community
dbaplus Community
Aug 24, 2016 · Databases

Choosing the Right MySQL HA Architecture: Master‑Slave, Dual‑Master, Heartbeat+DRBD, and GTID

This article examines common MySQL high‑availability designs—including single master‑slave, dual‑master with multiple slaves, Heartbeat + DRBD, MySQL Cluster, semi‑synchronous replication, and GTID—explaining their benefits, drawbacks, and practical considerations for reliable failover and scalability.

DRBDDatabase ArchitectureGTID
0 likes · 9 min read
Choosing the Right MySQL HA Architecture: Master‑Slave, Dual‑Master, Heartbeat+DRBD, and GTID
Architecture Digest
Architecture Digest
Aug 16, 2016 · Databases

Redis Guide: Installation, Configuration, Data Structures, Persistence, and Advanced Features

This comprehensive Redis guide explains the in‑memory key‑value store’s installation, basic commands, configuration options, supported data structures, persistence mechanisms, replication, transactions, pub/sub, performance testing, connection handling, pipelining, and partitioning, providing practical examples for developers.

Data StructuresIn-Memory DatabasePub-Sub
0 likes · 27 min read
Redis Guide: Installation, Configuration, Data Structures, Persistence, and Advanced Features
ITPUB
ITPUB
Aug 15, 2016 · Databases

Why Percona XtraBackup Can Deadlock MySQL 5.6 Replicas and How to Fix It

This article analyzes two deadlock cases that occur when running Percona‑XtraBackup on a MySQL 5.6 replica, explains the underlying lock interactions, shows how to reproduce the issue with SystemTap, and provides safe remediation steps for operators.

Percona XtraBackupSystemTapmysql
0 likes · 11 min read
Why Percona XtraBackup Can Deadlock MySQL 5.6 Replicas and How to Fix It
360 Zhihui Cloud Developer
360 Zhihui Cloud Developer
Aug 12, 2016 · Databases

Why Redis Replicas Return Expired Keys and How to Prevent It

The article explains how Redis replicas can return keys that should have expired due to the master‑only expiration process, describes the three expiration strategies (lazy, periodic, active), and offers practical solutions such as using SCAN or upgrading to Redis 3.2 to avoid stale reads.

CacheExpirationRedis
0 likes · 9 min read
Why Redis Replicas Return Expired Keys and How to Prevent It
Java High-Performance Architecture
Java High-Performance Architecture
Aug 11, 2016 · Databases

Understanding MHA: Master High Availability for MySQL Clusters

MHA (Master High Availability) ensures MySQL cluster resilience by monitoring the master, automatically promoting the most up‑to‑date slave as a new master during failures, offering fast failover, strong data safety, easy extensibility, and multi‑cluster management, while noting its limitations.

Database FailoverHigh AvailabilityMHA
0 likes · 4 min read
Understanding MHA: Master High Availability for MySQL Clusters
Efficient Ops
Efficient Ops
Aug 10, 2016 · Operations

How RAID and Replication Shape Distributed Storage Architecture

This article explores RAID and replication strategies in distributed storage, detailing stripe concepts, RAID0/1/10/5/6 configurations, the typical three‑node architecture with metadata and data servers, performance bottlenecks, reconstruction experiments, and practical mitigation techniques to ensure data integrity and high availability.

Distributed storageRAIDdata reconstruction
0 likes · 25 min read
How RAID and Replication Shape Distributed Storage Architecture
Efficient Ops
Efficient Ops
Aug 1, 2016 · Databases

Why Uber’s MySQL Switch Misrepresents PostgreSQL: A Deep Technical Dive

This article critically examines Uber’s claim that MySQL outperforms PostgreSQL by dissecting the alleged PostgreSQL limitations, presenting detailed performance tests, and clarifying the true costs of write amplification, replication, and upgrade processes for both databases.

Database PerformanceMVCCPostgreSQL
0 likes · 20 min read
Why Uber’s MySQL Switch Misrepresents PostgreSQL: A Deep Technical Dive
ITPUB
ITPUB
Jul 23, 2016 · Databases

Hidden MySQL Tricks You Probably Missed

This article compiles a series of lesser‑known MySQL details—from case‑insensitive column names and fuzzy LIKE patterns to REPLACE INTO, INSERT … ON DUPLICATE KEY UPDATE, EXPLAIN usage, index length limits, replication methods, partitioning, slow‑query monitoring, binlog importance, advanced objects like views and stored procedures, and recommended client tools—helping developers avoid common pitfalls and write more efficient queries.

Database TipsSQLmysql
0 likes · 7 min read
Hidden MySQL Tricks You Probably Missed
ITPUB
ITPUB
Jul 11, 2016 · Databases

Why Does MySQL Replication Throw ER_MASTER_HAS_PURGED_REQUIRED_GTIDS and How to Fix It?

In a MySQL 5.7 GTID setup with dual masters, a network glitch caused the slave to switch masters, leading to the ER_MASTER_HAS_PURGED_REQUIRED_GTIDS error because the new master had purged GTIDs the slave still needed, and the article explains the root cause and step‑by‑step fix.

ER_MASTER_HAS_PURGED_REQUIRED_GTIDSGTIDbinary log
0 likes · 6 min read
Why Does MySQL Replication Throw ER_MASTER_HAS_PURGED_REQUIRED_GTIDS and How to Fix It?
Java High-Performance Architecture
Java High-Performance Architecture
Jun 9, 2016 · Databases

Discover MySQL 5.7: 9 Powerful New Features You Must Know

MySQL 5.7 introduces major enhancements such as native JSON support, an expanded Performance Schema, a new SYS Schema for health monitoring, improved security, advanced GIS capabilities, three‑fold query throughput gains, InnoDB optimizations, multi‑source replication, and a smarter optimizer with dynamic costing.

GISInnoDBdatabase
0 likes · 3 min read
Discover MySQL 5.7: 9 Powerful New Features You Must Know
dbaplus Community
dbaplus Community
Jun 1, 2016 · Databases

Unlocking MySQL Replication: What, Why, and How Explained

This article uses the Golden Circle framework to explore MySQL replication, detailing its definition, benefits such as scaling and fault tolerance, the underlying mechanisms involving binary logs and IO/SQL threads, and addressing common practical questions through a self‑Q&A format.

Read‑Write Separationbinary logdatabase scaling
0 likes · 13 min read
Unlocking MySQL Replication: What, Why, and How Explained
ITPUB
ITPUB
May 25, 2016 · Databases

Mastering Redis Replication: Features, Mechanics, and Deployment Guide

Redis replication offers high‑availability through master‑slave syncing, supporting multiple slaves, cascading replication, non‑blocking data transfer, read‑write separation, and optional disk‑less sync, with detailed steps for configuration, safety considerations, partial resynchronization, and practical deployment examples.

High AvailabilityMaster‑SlaveRedis
0 likes · 8 min read
Mastering Redis Replication: Features, Mechanics, and Deployment Guide
MaGe Linux Operations
MaGe Linux Operations
May 9, 2016 · Databases

Fix MySQL Replication Inconsistencies with pt‑table‑checksum & sync

Learn how to diagnose MySQL master‑slave data drift using Percona Toolkit’s pt‑table‑checksum, configure necessary replication parameters, and automatically reconcile differences with pt‑table‑sync, including installation steps, command syntax, required privileges, and troubleshooting common errors for reliable database consistency.

database-consistencymysqlpercona-toolkit
0 likes · 13 min read
Fix MySQL Replication Inconsistencies with pt‑table‑checksum & sync
ITPUB
ITPUB
May 9, 2016 · Databases

Why Does CHANGE MASTER Trigger Traffic Spikes in MySQL GTID Replication?

After switching a MySQL master’s IP, the author observed extreme master‑to‑slave traffic and investigated whether using CHANGE MASTER with auto_position=1 forces the replica to re‑fetch already executed binlogs, especially when the replica is lagging.

Change MasterGTIDRelay Log
0 likes · 7 min read
Why Does CHANGE MASTER Trigger Traffic Spikes in MySQL GTID Replication?
Architecture Digest
Architecture Digest
May 8, 2016 · Databases

MySQL High Availability Architectures: Overview of Common Solutions

This article reviews the main MySQL high‑availability architectures—including shared‑storage SAN, DRBD disk replication, keepalived/heartbeat, MHA, ZooKeeper‑based HA, Galera/PXC clustering, and middleware proxy solutions—detailing their principles, advantages, limitations, and suitability for different business scenarios.

HAclusterdatabase
0 likes · 17 min read
MySQL High Availability Architectures: Overview of Common Solutions
Baidu Intelligent Testing
Baidu Intelligent Testing
May 5, 2016 · Operations

Preventing Avalanche Effect in Distributed Storage Systems: Replication Strategies, Flow Control, and Safety Mode

The article analyzes distributed storage replication methods, explains how large‑scale replica recovery can trigger an avalanche effect, and proposes operational safeguards such as cross‑rack replica selection, flow‑control mechanisms, predictive fault handling, and a safety mode to maintain system stability.

Distributed storageFlow ControlOperations
0 likes · 15 min read
Preventing Avalanche Effect in Distributed Storage Systems: Replication Strategies, Flow Control, and Safety Mode
dbaplus Community
dbaplus Community
May 4, 2016 · Databases

Choosing Percona, MariaDB or MySQL and Proven MySQL Tuning & HA Strategies

This guide compares Percona Server, MariaDB, and MySQL, outlines practical MySQL performance tuning steps across hardware, storage, filesystem, and server parameters, and presents several high‑availability architectures such as master‑slave replication, MMM/MHA, Heartbeat/SAN, and Heartbeat/DRBD with real‑world deployment examples.

Database TuningHigh AvailabilityMariaDB
0 likes · 9 min read
Choosing Percona, MariaDB or MySQL and Proven MySQL Tuning & HA Strategies
ITPUB
ITPUB
Apr 21, 2016 · Databases

13 MySQL Tips You Probably Missed: From Case Sensitivity to Binlog

This article highlights thirteen often‑overlooked MySQL details—including case‑insensitive column names, LIKE pattern rules, REPLACE and INSERT ON DUPLICATE KEY syntax, EXPLAIN usage, index limits, replication methods, partitioning, slow‑query logging, binlog, advanced objects, and useful client tools.

Database TipsSQLmysql
0 likes · 7 min read
13 MySQL Tips You Probably Missed: From Case Sensitivity to Binlog
ITPUB
ITPUB
Apr 15, 2016 · Databases

Why MySQL Login Fails: Host/User Sorting Rules and a Real‑World Debugging Case

The article explains MySQL’s user authentication flow, detailing how the server loads and sorts the user table by host and user specificity, and walks through a real‑world replication user login issue that reveals a hidden empty‑user entry causing access denial.

Host MatchingUser Authenticationmysql
0 likes · 9 min read
Why MySQL Login Fails: Host/User Sorting Rules and a Real‑World Debugging Case
Art of Distributed System Architecture Design
Art of Distributed System Architecture Design
Apr 13, 2016 · Databases

MySQL Performance Optimizations and Feature Enhancements: Group Commit, DDL Fast‑Fail, GTID, InnoDB Auto‑Increment Persistence, Replication, and Key Partition Algorithms

This article presents a series of MySQL backend improvements—including Group Commit redesign, DDL fast‑fail handling, GTID allocation refinements, persistent InnoDB auto‑increment values, replication parallelism, and key‑partition hash algorithm changes—detailing motivations, implementation steps, and performance results.

GTIDGroup CommitInnoDB
0 likes · 24 min read
MySQL Performance Optimizations and Feature Enhancements: Group Commit, DDL Fast‑Fail, GTID, InnoDB Auto‑Increment Persistence, Replication, and Key Partition Algorithms
ITPUB
ITPUB
Apr 11, 2016 · Databases

Why a MySQL Replica Core Hits 100% CPU and How Adding a Primary Key Fixes It

A MySQL replica was consuming an entire CPU core due to single‑process replication, and analysis of binlog and InnoDB status revealed heavy row locks on a table without a primary key, which was resolved by adding an auto‑increment ID, dropping CPU usage to 3% and eliminating replication lag.

BinlogCPUInnoDB
0 likes · 5 min read
Why a MySQL Replica Core Hits 100% CPU and How Adding a Primary Key Fixes It
ITPUB
ITPUB
Apr 5, 2016 · Databases

Add a MySQL Slave Without Downtime Using mysqldump or XtraBackup

This guide walks through adding a third MySQL replica to an existing master‑slave setup without restarting the service, comparing a logical mysqldump backup method with the faster physical XtraBackup approach and providing step‑by‑step commands and configuration details.

Slave Setupdatabase backupmysql
0 likes · 11 min read
Add a MySQL Slave Without Downtime Using mysqldump or XtraBackup
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
ITPUB
ITPUB
Mar 19, 2016 · Big Data

Inside HDFS: How NameNode and DataNode Manage Big Data Writes and Reads

This article explains the fundamentals of distributed file systems, focusing on Hadoop’s HDFS architecture, the separation of metadata and data via NameNode and DataNode, and detailed step‑by‑step write and read processes, including replication, fault recovery, and block splitting across nodes.

Big DataDataNodeDistributed File System
0 likes · 8 min read
Inside HDFS: How NameNode and DataNode Manage Big Data Writes and Reads
ITPUB
ITPUB
Mar 17, 2016 · Databases

Why MySQL Relay Log Settings Cause Duplicate Key Errors and How to Fix Them

The article explains how MySQL replication parameters such as expire_logs_days, relay-log-recovery, and relay-log-info-repository affect binlog cleanup, SQL and I/O thread consistency, and why crashes can produce duplicate‑key errors, then offers configuration fixes including the critical relay‑log cleaning option and the super_read_only setting.

BinlogData ConsistencyDatabase Configuration
0 likes · 5 min read
Why MySQL Relay Log Settings Cause Duplicate Key Errors and How to Fix Them
21CTO
21CTO
Mar 11, 2016 · Databases

How to Build Reliable MySQL HA: Replication, Monitoring, and Failover Strategies

This article explores practical MySQL high‑availability solutions, covering asynchronous and semi‑synchronous replication, monitoring with keepalived or Zookeeper, failover decision criteria, GTID and pseudo‑GTID techniques, and lessons learned from real‑world deployments.

GTIDHAPseudo GTID
0 likes · 13 min read
How to Build Reliable MySQL HA: Replication, Monitoring, and Failover Strategies
Architect
Architect
Mar 8, 2016 · Big Data

In‑Depth Analysis of Apache Kafka: Architecture, Core Concepts, and Benchmark

This article provides a comprehensive technical overview of Apache Kafka, covering its architecture, core concepts, design goals, comparison with other message queues, replication, consumer groups, delivery guarantees, and performance benchmarking, making it a valuable resource for big‑data engineers.

Big DataStreamingkafka
0 likes · 30 min read
In‑Depth Analysis of Apache Kafka: Architecture, Core Concepts, and Benchmark
Architecture Digest
Architecture Digest
Feb 27, 2016 · Databases

Architecture and Design of TDSQL: A Distributed MySQL‑Based SQL System for High‑Consistency Billing

The article analyzes the architecture of TDSQL, a MySQL‑based distributed SQL system designed for Tencent’s billing platform, detailing its transition from an in‑memory NoSQL solution to a high‑consistency, auto‑scaling, fault‑tolerant database with sharding, scheduler, agent, and gateway components.

High AvailabilityShardingdistributed database
0 likes · 17 min read
Architecture and Design of TDSQL: A Distributed MySQL‑Based SQL System for High‑Consistency Billing