BestHub
Sign in
Tagged articles
722 articles
Page 7 of 8
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.

BackendMaster‑SlaveReplication
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.

ConsistencyDistributed SystemsPacificA
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.

Distributed File SystemReplicationcaching
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 PrimaryReplicationTriggers
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.

GTIDReplicationUDB
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 MessagingKafkaReplication
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.

ProxyReplicationUDB
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 SystemReplicationarchitecture
0 likes · 15 min read
Designing Scalable Distributed File Systems: Architecture, Challenges, and Solutions
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.

CentOSGTIDReplication
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 ConsistencyDistributed SystemsReplication
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.

GTIDReplicationStored Procedure
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.

HBaseReplicationdistributed storage
0 likes · 28 min read
Alibaba’s HBase Scaling Secrets: High‑Availability, Replication, Performance
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.

AlibabaHBaseReplication
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 SchemaReplication
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.

BackupDatabase OptimizationReplication
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.

DBAInnoDBReplication
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
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.

ClusterConfigurationGroup Replication
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.

MariaDBReplicationStorage Engine
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.

BackupCrash SafetyGTID
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.

BackupDualMasterMasterFailure
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.

ClusterMongoDBReplication
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.

CReplicationSQL 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 ArchitecturePerformance TestingReplication
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.

MongoDBNoSQLReplication
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 SeparationReplicationdatabase
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.

BackupInstance MigrationRDS
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.

BackendPartial SyncReplication
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.

BackupDatabase OptimizationReplication
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.

PaxosReplicationdatabase 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 DatabaseReplication
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 XtraBackupReplicationSystemTap
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.

CacheExpirationReplication
0 likes · 9 min read
Why Redis Replicas Return Expired Keys and How to Prevent It
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.

RAIDReplicationdata 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 TipsReplicationSQL
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_GTIDSGTIDReplication
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.

GISInnoDBJSON
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 SeparationReplicationbinary log
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.

Master‑SlaveReplicationdatabase
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.

Replicationdatabase-consistencymysql
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.

ClusterHAReplication
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.

Flow ControlOperationsReplication
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 TuningMariaDBPercona
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 TipsReplicationSQL
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 MatchingReplicationUser Authentication
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.

Database BackupReplicationSlave Setup
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 DataKafkaReplication
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.

Replicationdistributed databasehigh availability
0 likes · 17 min read
Architecture and Design of TDSQL: A Distributed MySQL‑Based SQL System for High‑Consistency Billing
21CTO
21CTO
Feb 25, 2016 · Databases

Inside MySQL 5.6 Parallel Replication: Code Walkthrough and Design

This article explains how MySQL 5.6 introduced parallel replication to overcome the bottleneck of a single SQL thread, detailing the underlying binlog events, configuration parameters, key data structures, worker coordination, checkpoint mechanisms, and potential limitations, all from a source‑code perspective.

MTSReplicationmysql
0 likes · 20 min read
Inside MySQL 5.6 Parallel Replication: Code Walkthrough and Design
Qunar Tech Salon
Qunar Tech Salon
Feb 25, 2016 · Databases

Scaling MySQL Master‑Slave Replication with Binlog Server: Architecture, Benefits, and Use Cases

This article explains how Booking.com solved MySQL master‑to‑hundreds‑of‑slaves bandwidth limits by introducing a Binlog Server component, detailing its design, advantages over traditional relay‑master setups, and multiple deployment scenarios for high‑availability and cross‑region replication.

Binlog ServerDatabase ArchitectureReplication
0 likes · 9 min read
Scaling MySQL Master‑Slave Replication with Binlog Server: Architecture, Benefits, and Use Cases
Architect
Architect
Feb 23, 2016 · Big Data

Kafka High Availability Design: Data Replication and Leader Election

This article explains why Kafka introduced high‑availability features after version 0.8, detailing the necessity of data replication and leader election, describing Kafka’s replica distribution algorithm, replication mechanics, acknowledgment requirements, leader‑election strategies, Zookeeper structures, and the broker failover process.

KafkaReplicationZooKeeper
0 likes · 19 min read
Kafka High Availability Design: Data Replication and Leader Election
Java High-Performance Architecture
Java High-Performance Architecture
Feb 21, 2016 · Databases

Boost MySQL Master‑Slave Replication: Key Master & Slave Settings Explained

Understanding MySQL master‑slave replication hinges on optimizing binlog size; by configuring master parameters like Binlog_Do_DB and Binlog_Ignore_DB and slave filters such as Replicate_Do_DB, Replicate_Ignore_DB, Replicate_Do_Table, and wildcard options, you can reduce I/O, network load, and replication errors.

BinlogMaster‑SlaveReplication
0 likes · 4 min read
Boost MySQL Master‑Slave Replication: Key Master & Slave Settings Explained
dbaplus Community
dbaplus Community
Feb 2, 2016 · Databases

Redis Deep Dive: Features, Architecture, and Cluster Management

This article provides a comprehensive overview of Redis, covering its primary use cases, internal network and memory models, data consistency, supported data types, client libraries, replication mechanisms, read‑write separation, eviction policies, cluster architecture, node communication, redirection handling, online reconfiguration, and fault‑tolerance strategies.

ClusterData EvictionDistributed Systems
0 likes · 26 min read
Redis Deep Dive: Features, Architecture, and Cluster Management
High Availability Architecture
High Availability Architecture
Jan 20, 2016 · Databases

MongoDB Storage Engine Evolution, Replication Enhancements, and New Features

The article reviews MongoDB's storage engine developments—including MMAP, WiredTiger, RocksDB, and Memory engines—highlights replication protocol improvements, automatic sharding changes, and introduces new features such as batch and partial indexes, document validation, and join capabilities, while providing performance test results and a Q&A section.

MongoDBReplicationStorage Engine
0 likes · 14 min read
MongoDB Storage Engine Evolution, Replication Enhancements, and New Features
dbaplus Community
dbaplus Community
Dec 30, 2015 · Databases

Mastering MySQL: Practical DBA Optimization Techniques and Best Practices

This article presents a comprehensive guide to MySQL optimization, covering its strengths and weaknesses, daily DBA tasks, development and operational standards, sharding strategies, backup solutions, performance tuning, replication options, InnoDB configuration, system-level tweaks, and future improvement directions.

BackupDBAInnoDB
0 likes · 14 min read
Mastering MySQL: Practical DBA Optimization Techniques and Best Practices
ITPUB
ITPUB
Dec 30, 2015 · Databases

Essential MySQL DBA Interview Guide: Key Topics & Evaluation Checklist

This guide outlines a structured MySQL DBA interview process, covering self‑introduction, resume deep‑dive, career‑development questions, fundamental knowledge such as index types, core technical skills like backup, replication and performance troubleshooting, and broader potential areas including Linux and programming language proficiency.

DBAReplicationdatabase
0 likes · 8 min read
Essential MySQL DBA Interview Guide: Key Topics & Evaluation Checklist
MaGe Linux Operations
MaGe Linux Operations
Dec 16, 2015 · Databases

Mastering MySQL Replication: Concepts, Architectures, and Advanced Strategies

This article explains MySQL replication fundamentals, detailing master‑slave and multi‑master architectures, thread roles, configuration parameters, read‑write splitting, multi‑source setups, and advanced scenarios such as multi‑level and circular replication, while highlighting common pitfalls and performance considerations.

Database ArchitectureMaster‑SlaveReplication
0 likes · 7 min read
Mastering MySQL Replication: Concepts, Architectures, and Advanced Strategies
21CTO
21CTO
Dec 14, 2015 · Databases

MongoDB Master Russell Smith’s Essential Best‑Practice Checklist

This article compiles Russell Smith’s comprehensive MongoDB best‑practice guide, covering architecture choices, file limits, write safety, schema design, replication, sharding, security, and performance tuning to help engineers avoid common pitfalls and optimize production deployments.

MongoDBReplicationSecurity
0 likes · 16 min read
MongoDB Master Russell Smith’s Essential Best‑Practice Checklist
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.

ConfigurationMaster‑SlaveReplication
0 likes · 10 min read
Understanding Redis Master‑Slave Replication and Its Configuration
ITPUB
ITPUB
Dec 11, 2015 · Databases

Why MySQL Replication Lags During Long ALTERs and MyISAM Locks—and How to Fix It

The article examines two common MySQL master‑slave delay scenarios—slow ALTER operations and MyISAM table‑level locks—explains why they cause replication lag, and offers practical mitigation steps such as scheduling problematic SQL, isolating lagging slaves, and tuning binlog write settings.

ALTERMaster‑SlaveMyISAM
0 likes · 3 min read
Why MySQL Replication Lags During Long ALTERs and MyISAM Locks—and How to Fix It
21CTO
21CTO
Dec 11, 2015 · Databases

How Amazon Dynamo Ensures High Availability with Consistent Hashing

The article explains Amazon’s Dynamo distributed key‑value store architecture, covering its decentralized design, consistent hashing with virtual nodes, replication strategies, quorum‑based read/write parameters, vector‑clock versioning, failure detection, hinted handoff, scaling mechanisms, and how these techniques together provide high availability, scalability, and reliability.

ConsistencyReplicationkey-value store
0 likes · 19 min read
How Amazon Dynamo Ensures High Availability with Consistent Hashing