BestHub
Sign in
Tagged articles

replication

771 articles · Page 7 of 8
dbaplus Community
dbaplus Community
Feb 18, 2019 · Databases

How Do Fault‑Tolerant Transactions Work? Exploring Raft, KV Engines, and Concurrency Control

This article examines multiple fault‑tolerant transaction designs—RSM‑based KV, RSM‑based transactions, shared‑storage approaches, high‑availability KV layers, and single‑node engine extensions—comparing their replication strategies, lock handling, and performance trade‑offs while raising open questions about ordering and consistency.

Distributed TransactionsKV storeRaft
0 likes · 15 min read
How Do Fault‑Tolerant Transactions Work? Exploring Raft, KV Engines, and Concurrency Control
dbaplus Community
dbaplus Community
Feb 10, 2019 · Databases

How to Build a Reliable MySQL Master‑Slave Replication Cluster

This guide explains why a single MySQL server is a bottleneck, how to form a clustered master‑slave architecture, the binlog and GTID replication mechanisms, step‑by‑step configuration commands, and the trade‑offs of each approach.

BinlogConfigurationDatabase Clustering
0 likes · 11 min read
How to Build a Reliable MySQL Master‑Slave Replication Cluster
dbaplus Community
dbaplus Community
Dec 17, 2018 · Databases

Exploring MongoDB 4.0 Multi-Document ACID Transactions vs MySQL

MongoDB 4.0 introduces multi‑document ACID transactions with snapshot isolation, supporting replica sets and WiredTiger, and this article explains ACID concepts, outlines limitations, demonstrates session commands, and compares transaction behavior—including conflict detection, repeatable reads, and phantom reads—to MySQL’s implementation.

ACID TransactionsMongoDBMySQL Comparison
0 likes · 10 min read
Exploring MongoDB 4.0 Multi-Document ACID Transactions vs MySQL
Efficient Ops
Efficient Ops
Dec 16, 2018 · Databases

Understanding Redis Data Structures, Persistence, Transactions, and Replication

This article explains Redis's core data types—String, Hash, List, Set, and Sorted Set—its internal object model, persistence options (RDB and AOF) with their pros and cons, transaction characteristics, master‑slave replication mechanisms, and common caching scenarios and design considerations.

CachingData StructuresPersistence
0 likes · 10 min read
Understanding Redis Data Structures, Persistence, Transactions, and Replication
MaGe Linux Operations
MaGe Linux Operations
Dec 15, 2018 · Databases

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

This comprehensive guide explains Redis fundamentals, its rich data structures and common commands, then dives into performance optimization, replication, and clustering, offering practical examples and best‑practice recommendations for building reliable, high‑performance Redis deployments.

Data StructuresRediscluster
0 likes · 32 min read
Mastering Redis: Core Data Structures, Commands, and Performance Tuning
Tencent Cloud Developer
Tencent Cloud Developer
Nov 6, 2018 · Databases

Design and Implementation of High‑Availability MySQL

The talk by Tencent’s senior MySQL engineer explains high‑availability concepts—99.95% uptime, RPO/RTO metrics, backup methods, and replication modes—while comparing single‑node, shared‑storage, and share‑nothing architectures, detailing failover tools (Keepalived, MMM, MHA), cluster solutions (PXC, MGC, Group Replication) and NewSQL examples such as Aurora, PolarDB and CynosDB.

MySQLRPORTO
0 likes · 15 min read
Design and Implementation of High‑Availability MySQL
Full-Stack Internet Architecture
Full-Stack Internet Architecture
Nov 1, 2018 · Databases

How to Set Up MySQL Master‑Slave Replication

This guide explains the complete process of configuring MySQL master‑slave replication on two CentOS machines, covering prerequisite setup, enabling binary logging, creating a replication user, capturing binlog coordinates, configuring the slave, and verifying successful synchronization.

Binary LogCentOSDatabase Configuration
0 likes · 5 min read
How to Set Up MySQL Master‑Slave Replication
ITPUB
ITPUB
Sep 13, 2018 · Databases

Why Redis’s Master‑Slave Terminology Sparks Debate and What Changes Are Planned

The Redis community is urging a rename of the master‑slave replication terminology due to social concerns, but the project's lead highlights significant compatibility costs, outlining short‑term compromises and long‑term redesigns while balancing technical feasibility and community expectations.

RedisTerminologycompatibility
0 likes · 4 min read
Why Redis’s Master‑Slave Terminology Sparks Debate and What Changes Are Planned
ITPUB
ITPUB
Sep 12, 2018 · Databases

MySQL vs PostgreSQL: In‑Depth Feature Comparison and Choosing the Right Database

This article compares MySQL and PostgreSQL across open‑source licensing, ACID compliance, SQL standard support, replication modes, concurrency control, performance characteristics, high‑availability solutions, external data source integration, and storage models, helping readers decide which database best fits their workloads.

MySQLPerformancePostgreSQL
0 likes · 12 min read
MySQL vs PostgreSQL: In‑Depth Feature Comparison and Choosing the Right Database
ITPUB
ITPUB
Sep 8, 2018 · Databases

Why Uber Switched from Postgres to MySQL: Scaling Lessons from a Real‑World Migration

Uber’s engineering team explains how Postgres’s immutable rows, write‑ahead logging, and replication design caused write amplification, upgrade pain, and data‑corruption risks, leading them to adopt a MySQL‑based Schemaless sharding layer that offers better buffering, connection handling, and replication semantics for massive scale.

MySQLPostgreSQLUber
0 likes · 23 min read
Why Uber Switched from Postgres to MySQL: Scaling Lessons from a Real‑World Migration
Architects' Tech Alliance
Architects' Tech Alliance
Sep 5, 2018 · Fundamentals

Red Hat Ceph Storage Architecture Overview and Key Components

This article provides a comprehensive English translation of the Red Hat Ceph Storage Architecture Guide, covering Ceph's distributed object storage concepts, cluster architecture, storage pools, CRUSH algorithm, replication and erasure‑coding I/O, internal operations, high‑availability mechanisms, client interfaces, and encryption considerations for cloud environments.

CRUSHCephCloud Infrastructure
0 likes · 40 min read
Red Hat Ceph Storage Architecture Overview and Key Components
ITFLY8 Architecture Home
ITFLY8 Architecture Home
Aug 21, 2018 · Databases

Mastering MySQL: Keys, Transactions, Indexes, Joins, and Optimization Essentials

This article explains fundamental MySQL concepts including primary, candidate, super and foreign keys, transaction ACID properties, view creation, differences among DROP, DELETE and TRUNCATE, index structures and types, join variations, normalization forms, optimization techniques, replication mechanisms, engine distinctions, and logging formats.

MySQLSQLTransactions
0 likes · 29 min read
Mastering MySQL: Keys, Transactions, Indexes, Joins, and Optimization Essentials
dbaplus Community
dbaplus Community
Aug 19, 2018 · Databases

Redis Deployment Options: Pros & Cons of Single, Replication, Sentinel, Cluster, and Custom Solutions

This article examines five common Redis deployment patterns—single instance, master‑slave replication, Sentinel, Cluster, and custom high‑availability solutions—detailing their architectures, advantages, drawbacks, and practical configuration tips to help engineers choose the most suitable setup for their workloads.

PerformanceRedisSentinel
0 likes · 12 min read
Redis Deployment Options: Pros & Cons of Single, Replication, Sentinel, Cluster, and Custom Solutions
AntTech
AntTech
Jul 31, 2018 · Databases

High Availability and Disaster Recovery Strategies for OceanBase Distributed Database

This article reviews traditional database high‑availability techniques, explains the advantages of distributed multi‑replica consistency (Paxos/Raft) used by OceanBase, and compares various deployment topologies—from single‑site three‑replica to multi‑city five‑replica designs—highlighting their trade‑offs and best‑practice recommendations.

OceanBasePaxosdisaster recovery
0 likes · 23 min read
High Availability and Disaster Recovery Strategies for OceanBase Distributed Database
Efficient Ops
Efficient Ops
Jul 18, 2018 · Databases

Mastering Redis: Advanced Types, Replication, Persistence, and Real-World Design

This article explores Redis’s advanced features—including data types, master‑slave, sentinel, and cluster architectures, transaction handling, RDB/AOF persistence, pub/sub messaging, and a practical e‑commerce search case study—providing design insights and best‑practice configurations for high‑availability and performance.

PersistenceRedisdatabase
0 likes · 10 min read
Mastering Redis: Advanced Types, Replication, Persistence, and Real-World Design
Ctrip Technology
Ctrip Technology
Jul 10, 2018 · Databases

Designing Real‑Time Sharding Index and Replication with Elasticsearch for High‑Performance Order Queries

This article describes how Ctrip's hotel R&D team tackled growing order‑volume challenges by sharding the database, building a real‑time Elasticsearch index, implementing a custom replication pipeline, and applying various write‑ and read‑optimizations to achieve low latency and stable performance.

ElasticsearchPerformance OptimizationSQL Server
0 likes · 10 min read
Designing Real‑Time Sharding Index and Replication with Elasticsearch for High‑Performance Order Queries
ITPUB
ITPUB
Jun 17, 2018 · Databases

MySQL 8 vs PostgreSQL 10: Which Database Wins the Showdown?

An in‑depth comparison of MySQL 8 and PostgreSQL 10 examines feature parity, storage architecture, indexing, memory usage, replication, update overhead, and garbage collection, highlighting how recent improvements narrow the gap and offering guidance on choosing the right database for specific workloads.

MySQLPerformancePostgreSQL
0 likes · 12 min read
MySQL 8 vs PostgreSQL 10: Which Database Wins the Showdown?
Ops Development Stories
Ops Development Stories
May 11, 2018 · Databases

How to Set Up MySQL Master‑Slave Replication with Docker

This guide walks through configuring MySQL master‑slave replication inside Docker containers, covering environment setup, container creation, MySQL configuration changes, replication user creation, synchronization commands, troubleshooting tips, and verification of data replication between the master and slave instances.

DockerMaster‑SlaveMySQL
0 likes · 4 min read
How to Set Up MySQL Master‑Slave Replication with Docker
dbaplus Community
dbaplus Community
May 6, 2018 · Databases

NewSQL Explained: Storage Engines, Sharding, and Distributed Transactions

This article examines the core technologies behind NewSQL databases for OLTP workloads, contrasting them with NoSQL and traditional relational systems by exploring storage engines such as B‑Tree and LSM‑Tree, sharding strategies, replication models, and distributed transaction mechanisms like two‑phase commit.

NewSQLStorage Enginesdistributed databases
0 likes · 20 min read
NewSQL Explained: Storage Engines, Sharding, and Distributed Transactions
360 Zhihui Cloud Developer
360 Zhihui Cloud Developer
Apr 24, 2018 · Databases

How Dynamo Achieves High‑Availability in Distributed Key‑Value Stores

This article explains Dynamo, the decentralized key‑value storage system, covering its design goals, consistent‑hashing partitioning with virtual nodes, replication strategies, quorum‑based consistency, conflict resolution with vector clocks, hinted handoff, Merkle‑tree synchronization, and gossip‑based failure detection.

Dynamoconsistent hashingdistributed storage
0 likes · 9 min read
How Dynamo Achieves High‑Availability in Distributed Key‑Value Stores
Architecture Digest
Architecture Digest
Apr 10, 2018 · Fundamentals

Reliability, Scalability, and Maintainability in Distributed System Design

This article examines core distributed system design principles—reliability, scalability, and maintainability—explaining how techniques such as replication, partitioning, consensus algorithms, and transactions address hardware, software, and human failures, and discusses vertical and horizontal scaling strategies to achieve robust, extensible, and maintainable architectures.

Consensusdistributed systemsmaintainability
0 likes · 8 min read
Reliability, Scalability, and Maintainability in Distributed System Design
ITPUB
ITPUB
Mar 30, 2018 · Databases

Step‑by‑Step Oracle Multi‑Master Replication Setup with Full SQL Scripts

This guide walks through configuring Oracle multi‑master data replication, covering site creation, group objects, propagator and receiver setup, purge scheduling, database link creation, replication group definition, table registration, conflict handling, and finally resuming replication, all illustrated with complete SQL code examples.

OracleSQLdatabase
0 likes · 7 min read
Step‑by‑Step Oracle Multi‑Master Replication Setup with Full SQL Scripts
Architecture Digest
Architecture Digest
Feb 15, 2018 · Databases

Design and Architecture of Zeppelin Distributed Block Storage System

This article presents an in‑depth overview of Zeppelin, a high‑availability, high‑performance block storage service, covering its motivation, online vs offline storage distinctions, data distribution strategies, centralized meta‑server design, replication policies, RocksDB‑based storage engine, Raft‑based consistency protocol, threading model, client request flow, and fault‑handling mechanisms.

Hash PartitioningRaftRocksDB
0 likes · 19 min read
Design and Architecture of Zeppelin Distributed Block Storage System
ITPUB
ITPUB
Feb 2, 2018 · Databases

Mastering Redis: Essential Commands and Practical Examples

This guide introduces Redis as an advanced key‑value store, explains how to start the server and use its CLI tools, and provides detailed command references and demos for strings, lists, sets, sorted sets, hashes, transactions, replication, and pub/sub.

CLIDatabase CommandsRedis
0 likes · 15 min read
Mastering Redis: Essential Commands and Practical Examples
MaGe Linux Operations
MaGe Linux Operations
Jan 25, 2018 · Databases

Master Redis: Data Structures, Commands, and Performance Tuning Explained

This comprehensive guide introduces Redis fundamentals, covering its core data structures and essential commands, then delves into performance optimization, high‑availability setups with replication and Sentinel, and scaling strategies using Redis Cluster, providing practical examples and best‑practice recommendations for robust in‑memory data management.

ClusteringData StructuresRedis
0 likes · 29 min read
Master Redis: Data Structures, Commands, and Performance Tuning Explained
UCloud Tech
UCloud Tech
Jan 12, 2018 · Databases

How to Diagnose and Resolve MySQL Replication Errors in High‑Availability Environments

This article explains step‑by‑step how to collect replication status, examine MySQL error logs and binary logs, understand common replication failures such as duplicate databases or missing binlog files, and apply GTID and configuration best practices to troubleshoot and fix MySQL replication problems in high‑availability setups.

Error TroubleshootingGTIDMySQL
0 likes · 25 min read
How to Diagnose and Resolve MySQL Replication Errors in High‑Availability Environments
dbaplus Community
dbaplus Community
Dec 18, 2017 · Databases

How Aurora Redefines Cloud‑Native Relational Databases: Architecture, Benefits, and Limits

This article interprets the 2017 SIGMOD paper on Amazon Aurora, explaining its cloud‑native architecture, key advantages such as self‑healing storage and reduced network I/O, the challenges it introduces, a comparison with traditional databases and TiDB, and insights into deployment, replication, and recovery mechanisms.

Amazon AuroraCloud-Native DatabaseNewSQL
0 likes · 26 min read
How Aurora Redefines Cloud‑Native Relational Databases: Architecture, Benefits, and Limits
Qunar Tech Salon
Qunar Tech Salon
Nov 16, 2017 · Databases

Why Upgrade PostgreSQL and How to Perform a Major Version Upgrade Using PGQ

This article explains the importance of upgrading PostgreSQL to benefit from new features and security fixes, compares traditional upgrade methods, introduces the PGQ replication system, and provides a detailed step‑by‑step guide for performing a major version upgrade with minimal downtime.

ConfigurationPGQPostgreSQL
0 likes · 11 min read
Why Upgrade PostgreSQL and How to Perform a Major Version Upgrade Using PGQ
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.

Financial ServicesPostgreSQLZero Data Loss
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‑SlaveMySQL
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 ClientRedis
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.

Cloud DatabaseDBaaSDatabase-as-a-Service
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.

KafkaLeader Electionhigh availability
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.

InnoDBMySQLSQL optimization
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.

Database ErrorsMySQLauto-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.

KernelMySQLSemi‑synchronous
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 ToolsRDB
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 ErrorsMySQL
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.

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

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

PacificAconsistencydistributed storage
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 PrimaryMySQLTriggers
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.

Binary LogGTIDMySQL
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 reliabilityKafka
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.

AuroraCloud DatabaseRecovery
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.

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

architecturedistributed file systemmetadata management
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.

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

Transaction Processingdata consistencydistributed 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.

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

HBasedistributed storagereplication
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.

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.

Memory LeakMonitoring PluginMySQL
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.

MySQLbackupdatabase optimization
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 EncryptionMySQL
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.

DBAInnoDBMySQL
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 ConnectIn-Memory DatabaseOracle
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.

ConfigurationGroup ReplicationMySQL
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.

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

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

MongoDBclusterdatabase
0 likes · 8 min read
Master MongoDB Sharding: Step-by-Step Setup and Verification
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.

MySQLParallel Replicationdatabase architecture
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.

MongoDBNoSQLdatabase
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 Separationdatabasereplication
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 MigrationMySQLRDS
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 SyncRedis
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.

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

Database ClusteringMySQLPaxos
0 likes · 10 min read
How PhxSQL Achieves MySQL‑Compatible High Availability with Paxos‑Based Replication
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