BestHub
Sign in
Tagged articles
722 articles
Page 3 of 8
vivo Internet Technology
vivo Internet Technology
Apr 5, 2023 · Databases

Understanding MySQL Replication: Principles, Mechanisms, and Practical Applications

MySQL replication copies data changes from a primary server to one or more replicas using binlog events—supporting statement, row, or mixed formats and GTID positioning—to provide real‑time backup, read‑write separation, high‑availability failover, and integration pipelines via asynchronous, semi‑synchronous, or centralized binlog services.

BinlogData ReliabilityGTID
0 likes · 30 min read
Understanding MySQL Replication: Principles, Mechanisms, and Practical Applications
ITPUB
ITPUB
Apr 4, 2023 · Databases

Mastering MySQL Replication: Principles, Lag Fixes, and Failover Strategies

This article explains MySQL master‑slave replication fundamentals, the binlog‑based data flow, common consistency and latency problems, practical solutions such as row or mixed binlog formats, caching and query routing, and the trade‑offs of one‑master‑one‑slave versus one‑master‑many‑slaves architectures.

Database PerformanceMaster‑SlaveReplication
0 likes · 11 min read
Mastering MySQL Replication: Principles, Lag Fixes, and Failover Strategies
IT Services Circle
IT Services Circle
Apr 2, 2023 · Databases

Understanding MySQL Master‑Slave Replication: Principles, Lag, and Failover

This article explains MySQL master‑slave replication, covering its architecture, binlog‑based replication process, causes and mitigation of replication lag, and strategies for master‑slave failover, helping readers grasp why and how to use replication for read/write separation, high availability, and backup.

Master‑SlaveReplicationdatabase
0 likes · 12 min read
Understanding MySQL Master‑Slave Replication: Principles, Lag, and Failover
IT Architects Alliance
IT Architects Alliance
Mar 28, 2023 · Big Data

Kafka Core Concepts, Architecture, Performance Optimization, and Production Deployment Guide

This comprehensive guide explains Kafka's core value as a message queue, its fundamental concepts, cluster architecture, high‑performance data handling, resource planning for large‑scale deployments, operational tools, consumer‑group mechanics, offset management, rebalance strategies, and custom partitioner implementation.

DeploymentReplicationStreaming
0 likes · 29 min read
Kafka Core Concepts, Architecture, Performance Optimization, and Production Deployment Guide
ITPUB
ITPUB
Mar 26, 2023 · Databases

Why a Missing mysql-bin.index Crashed MySQL HA and How to Recover It

A detailed post‑mortem of a MySQL dual‑master cluster failure caused by a missing mysql-bin.index file, showing step‑by‑step diagnostics, container logs, replication position fixes, and preventive measures for high‑availability deployments.

Replicationbinary logkeepalived
0 likes · 8 min read
Why a Missing mysql-bin.index Crashed MySQL HA and How to Recover It
Aikesheng Open Source Community
Aikesheng Open Source Community
Mar 21, 2023 · Databases

MySQL 8.0 New Features: Performance, Security, Optimizer, and Other Enhancements

This article provides a comprehensive overview of MySQL 8.0 enhancements, covering performance improvements such as contention‑aware scheduling and hash joins, security upgrades including authentication plugins and password policies, optimizer refinements, and various other features like persistent variables, GIS support, and binlog expiration handling.

Hash JoinJSONReplication
0 likes · 16 min read
MySQL 8.0 New Features: Performance, Security, Optimizer, and Other Enhancements
dbaplus Community
dbaplus Community
Mar 15, 2023 · Backend Development

How to Prevent Message Loss in Kafka: Practical Tips and Configurations

This guide explains why message queues are introduced for decoupling and traffic control, identifies three key areas where message loss can occur—in producers, brokers, and consumers—and provides concrete Kafka configurations, monitoring practices, and operational steps to ensure reliable, loss‑free message delivery.

Consumer MonitoringKafkaMessage Loss
0 likes · 12 min read
How to Prevent Message Loss in Kafka: Practical Tips and Configurations
Aikesheng Open Source Community
Aikesheng Open Source Community
Mar 14, 2023 · Databases

Understanding Redis Master‑Slave Replication Storm and Mitigation Strategies

The article explains Redis master‑slave asynchronous replication, describes how repeated full‑sync requests from slaves can cause a replication storm that overloads CPU, memory and network, and offers practical solutions such as limiting data size, adjusting buffer limits, and redesigning deployment topology.

Master‑SlaveReplicationReplication Storm
0 likes · 6 min read
Understanding Redis Master‑Slave Replication Storm and Mitigation Strategies
ITPUB
ITPUB
Mar 8, 2023 · Databases

Mastering Redis Cluster: Deep Dive into Sharding, Failover, and Scaling

This article provides a comprehensive guide to Redis Cluster, covering its sharding mechanism, hash slot mapping, replication and automatic failover, client data location, slot reassignment, MOVED/ASK redirection, communication overhead, and practical tuning tips for large‑scale deployments.

ClusterGossip ProtocolReplication
0 likes · 20 min read
Mastering Redis Cluster: Deep Dive into Sharding, Failover, and Scaling
DevOps Operations Practice
DevOps Operations Practice
Feb 28, 2023 · Databases

Understanding Redis: NoSQL Basics, Data Types, Persistence, Replication, Sentinel and Cache Issues

This article provides a comprehensive overview of Redis as a NoSQL in‑memory database, covering its core data structures, special types, transaction model, RDB and AOF persistence, publish/subscribe, master‑slave replication, Sentinel failover, and common cache pitfalls such as penetration, breakdown and avalanche, with practical mitigation strategies.

NoSQLPersistenceReplication
0 likes · 45 min read
Understanding Redis: NoSQL Basics, Data Types, Persistence, Replication, Sentinel and Cache Issues
dbaplus Community
dbaplus Community
Feb 26, 2023 · Backend Development

Why Redis Is More Than a Cache: Architecture, Persistence, and Scaling Explained

This article provides a comprehensive overview of Redis, covering its role as an in‑memory data‑structure server, various deployment topologies such as single instances, high‑availability, Sentinel, replication, and clustering, as well as its persistence mechanisms including RDB, AOF, and fork‑based snapshots.

ClusterIn-Memory DatabasePersistence
0 likes · 17 min read
Why Redis Is More Than a Cache: Architecture, Persistence, and Scaling Explained
ITPUB
ITPUB
Feb 18, 2023 · Databases

Why MySQL Unique Index Fails with unique_checks=0 and How to Resolve It

In MySQL 5.7 replication, disabling unique_checks can cause duplicate‑key errors on a unique index that is not a primary key, leading to replication stalls, and this guide explains the root cause, temporary and permanent fixes, and step‑by‑step reproduction instructions.

ReplicationUnique Indexbug
0 likes · 7 min read
Why MySQL Unique Index Fails with unique_checks=0 and How to Resolve It
Tencent Cloud Developer
Tencent Cloud Developer
Feb 15, 2023 · Databases

How to Build a Stable, High‑Performance Redis Cluster: Persistence, Replication, Sentinel and Sharding

This guide walks developers through transforming a single‑node Redis cache into a stable, high‑performance cluster by explaining data persistence options (RDB, AOF, hybrid), master‑slave replication, Sentinel‑driven automatic failover, and both client‑side and proxy‑based sharding for horizontal scalability.

ClusterPersistenceReplication
0 likes · 17 min read
How to Build a Stable, High‑Performance Redis Cluster: Persistence, Replication, Sentinel and Sharding
JD Tech
JD Tech
Feb 9, 2023 · Databases

Understanding MySQL Master‑Slave Replication: Overview, Benefits, Mechanisms, and Consistency Solutions

This article explains MySQL master‑slave replication, covering its basic concepts, the advantages of read‑write separation, data backup and high availability, the underlying binlog‑based mechanism, the four replication modes (full, asynchronous, semi‑synchronous, enhanced semi‑synchronous), common consistency challenges, and practical ways to mitigate them.

Data ConsistencyMaster‑SlaveRead-Write Separation
0 likes · 18 min read
Understanding MySQL Master‑Slave Replication: Overview, Benefits, Mechanisms, and Consistency Solutions
Top Architect
Top Architect
Jan 12, 2023 · Databases

MySQL Master‑Slave Replication, Binlog/Redo Log Basics, and Sharding‑JDBC Read‑Write Splitting & Sharding Implementation

This article provides a comprehensive tutorial on configuring MySQL master‑slave replication with Docker, explains the roles of binlog and redo log, describes two‑phase commit, and demonstrates how to use Sharding‑JDBC (ShardingSphere) for read‑write splitting and horizontal sharding in a Spring Boot application, complete with configuration files and code examples.

ReplicationShardingSphereSpringBoot
0 likes · 24 min read
MySQL Master‑Slave Replication, Binlog/Redo Log Basics, and Sharding‑JDBC Read‑Write Splitting & Sharding Implementation
Efficient Ops
Efficient Ops
Jan 10, 2023 · Big Data

Why a Single Kafka Broker Failure Can Halt All Consumers – Deep Dive into HA

This article explains Kafka's multi‑replica design, ISR mechanism, leader election rules, and producer acknowledgment settings, then shows how the built‑in __consumer_offset topic with a single replica can cause a whole cluster to become unavailable when one broker crashes, and offers practical fixes.

Consumer OffsetsISRKafka
0 likes · 9 min read
Why a Single Kafka Broker Failure Can Halt All Consumers – Deep Dive into HA
Top Architect
Top Architect
Jan 8, 2023 · Databases

Understanding Redis: Architecture, Deployment Options, Persistence Models, and High Availability

This article provides a comprehensive overview of Redis, covering its definition as an in‑memory data structure server, various deployment topologies such as single instance, high‑availability, Sentinel, and Cluster, as well as detailed explanations of persistence mechanisms, forking, replication, and practical considerations for scaling and reliability.

ClusterPersistenceReplication
0 likes · 18 min read
Understanding Redis: Architecture, Deployment Options, Persistence Models, and High Availability
Aikesheng Open Source Community
Aikesheng Open Source Community
Dec 26, 2022 · Databases

MySQL Replication Delay Analysis and Troubleshooting for Large Transactions

The article describes a MySQL 5.7.31 replication delay where Seconds_Behind_Master fluctuates between 0 and over 10,000 seconds, analyzes root causes such as single‑threaded replication, large or long‑running transactions, and provides preventive, diagnostic, and remediation steps including enabling parallel replication and using the infobin tool.

Large TransactionsReplicationdatabase
0 likes · 10 min read
MySQL Replication Delay Analysis and Troubleshooting for Large Transactions
Efficient Ops
Efficient Ops
Dec 13, 2022 · Databases

How ClickHouse Replicates MySQL in Real-Time: A Step-by-Step Guide

This article explains how to configure ClickHouse as a MySQL replica using the MaterializeMySQL engine, covering code acquisition, MySQL master setup, ClickHouse slave configuration, handling of delete and update operations, and the underlying replication mechanism with practical code examples.

Database SyncMaterializeMySQLReal-Time
0 likes · 10 min read
How ClickHouse Replicates MySQL in Real-Time: A Step-by-Step Guide
Aikesheng Open Source Community
Aikesheng Open Source Community
Nov 24, 2022 · Databases

Understanding Orchestrator's RegroupReplicasGTID and Candidate Replica Selection in MySQL Failover

This article explains how Orchestrator selects a candidate replica during MySQL master failover, detailing the GetCandidateReplica and RegroupReplicasGTID functions, their sorting logic, promotion rules, GTID-based regrouping, and differences from MHA, while highlighting potential data loss issues and related bugs.

GTIDOrchestratorReplication
0 likes · 22 min read
Understanding Orchestrator's RegroupReplicasGTID and Candidate Replica Selection in MySQL Failover
Aikesheng Open Source Community
Aikesheng Open Source Community
Nov 17, 2022 · Databases

DeadMaster Recovery Process in Orchestrator

This article explains the complete DeadMaster recovery workflow of Orchestrator, detailing how the system selects the appropriate check‑and‑recover function, handles emergency grace periods, reads topology information, registers recovery attempts, validates promotion constraints, executes the actual failover, and runs post‑recovery hooks, with extensive Go code examples.

GoOrchestratorRecovery
0 likes · 18 min read
DeadMaster Recovery Process in Orchestrator
Tencent Cloud Developer
Tencent Cloud Developer
Nov 11, 2022 · Databases

How KeeWiDB Solves Redis’s Memory Cost with Tiered Storage & Async I/O

KeeWiDB, a next‑generation distributed KV store from Tencent Cloud, combines a proxy layer, multi‑node service layer, tiered hot‑cold data placement, multi‑threaded and coroutine‑based processing, persistent memory caching, direct I/O, and enhanced replication to address Redis’s memory cost, scalability, and latency challenges.

Async IOKV StoreReplication
0 likes · 18 min read
How KeeWiDB Solves Redis’s Memory Cost with Tiered Storage & Async I/O
Aikesheng Open Source Community
Aikesheng Open Source Community
Nov 7, 2022 · Databases

Orchestrator Failover Process Source Code Analysis – Simulating Faults and Understanding ContinuousDiscovery

This article walks through a simulated MySQL 3307 cluster failure, examines Orchestrator's source code to explain the ContinuousDiscovery loop, discovery queues, health ticks, caretaking tasks, raft coordination, topology snapshots, and the logic distinguishing UnreachableMaster from DeadMaster states.

ContinuousDiscoveryDatabase HAGo
0 likes · 20 min read
Orchestrator Failover Process Source Code Analysis – Simulating Faults and Understanding ContinuousDiscovery
DeWu Technology
DeWu Technology
Oct 31, 2022 · Databases

Analysis of Order Query Failures Caused by MySQL Master‑Slave Replication Lag and Mitigation Strategies

The e‑commerce platform’s order‑query alerts were caused by MySQL master‑slave replication lag—specifically, delayed redo‑log flushing let the slave receive binlog events before the master committed—so queries returned empty, a condition mitigated by retry logic, delayed MQ delivery, or emitting post‑commit business events.

BinlogMaster‑SlaveReplication
0 likes · 10 min read
Analysis of Order Query Failures Caused by MySQL Master‑Slave Replication Lag and Mitigation Strategies
Top Architect
Top Architect
Oct 19, 2022 · Databases

MySQL Replication, High Availability, and Sharding: Concepts and Solutions

This article explains the evolution from single‑node MySQL databases to master‑slave replication, various replication modes, high‑availability strategies, and both vertical and horizontal sharding techniques, while discussing the associated challenges such as distributed transactions, routing, and operational complexity.

Distributed TransactionsReplicationdatabase scaling
0 likes · 11 min read
MySQL Replication, High Availability, and Sharding: Concepts and Solutions
Architect's Guide
Architect's Guide
Oct 19, 2022 · Databases

Database Scaling, Replication, High Availability, and Sharding Overview

This article explains why single‑node databases cannot keep up with rapid business growth and describes MySQL replication methods, high‑availability solutions such as MHA and MGR, and the challenges and techniques of vertical and horizontal sharding for large‑scale systems.

Replicationdatabase scalinghigh availability
0 likes · 11 min read
Database Scaling, Replication, High Availability, and Sharding Overview
Tencent Cloud Developer
Tencent Cloud Developer
Sep 26, 2022 · Big Data

Kafka Architecture Overview and Core Concepts

Kafka’s architecture consists of brokers forming clusters, producers publishing to topics split into partitions with replicas, consumers organized in groups pulling messages by offset, ZooKeeper managing metadata, and log‑based storage using append‑only files, indexes, and zero‑copy, while configurable acknowledgment, batching, and replication ensure high throughput and fault‑tolerant reliability.

ConsumerKafkaProducer
0 likes · 18 min read
Kafka Architecture Overview and Core Concepts
Tencent Cloud Developer
Tencent Cloud Developer
Sep 22, 2022 · Databases

Redis Fundamentals: Data Structures, Persistence, Replication, and Clustering

The article explains Redis’s core concepts—including its in‑memory key‑value store, six low‑level data structures, single‑threaded execution, AOF and RDB persistence options, master‑replica replication with Sentinel failover, and horizontal scaling via Cluster’s hash‑slot sharding and rebalancing.

Data StructuresPersistenceReplication
0 likes · 26 min read
Redis Fundamentals: Data Structures, Persistence, Replication, and Clustering
Top Architect
Top Architect
Sep 15, 2022 · Databases

Understanding Redis Master‑Slave Replication: Principles, Configuration, Workflow, and Common Pitfalls

This article explains the CAP theorem, details how Redis implements master‑slave replication—including its asynchronous nature, configuration methods, three‑phase workflow, heartbeat mechanism, and common operational issues—providing practical guidance for building highly available Redis deployments.

CAP theoryMaster‑SlaveReplication
0 likes · 16 min read
Understanding Redis Master‑Slave Replication: Principles, Configuration, Workflow, and Common Pitfalls
ITFLY8 Architecture Home
ITFLY8 Architecture Home
Sep 14, 2022 · Databases

Master MySQL: 3 Normal Forms, Engine Differences, Indexing, Transactions & More

This comprehensive guide covers MySQL fundamentals such as the three normal forms, differences between MyISAM and InnoDB, redo log versus binlog, when queries bypass indexes, join types, various index structures, covering indexes, back‑row lookups, transaction properties and isolation levels, common performance bottlenecks, replication mechanics, lag mitigation, storage behavior after deletes, VARCHAR limits, lock types, systematic SQL tuning steps, the purpose and trade‑offs of indexes, B+‑tree advantages, MVCC internals, and the Snowflake distributed ID algorithm.

ReplicationTransactionsindexing
0 likes · 24 min read
Master MySQL: 3 Normal Forms, Engine Differences, Indexing, Transactions & More
Java Backend Technology
Java Backend Technology
Sep 13, 2022 · Databases

Master‑Slave MySQL Replication & Read‑Write Splitting with ShardingJDBC: A Step‑by‑Step Guide

This article explains why a single MySQL instance can become a bottleneck, introduces asynchronous master‑slave replication using binary logs, provides detailed configuration commands for both master and slave servers, and shows how to achieve read‑write splitting in Java projects with ShardingJDBC, including dependency setup, YAML configuration, and testing procedures.

ReplicationShardingJDBCdatabase
0 likes · 11 min read
Master‑Slave MySQL Replication & Read‑Write Splitting with ShardingJDBC: A Step‑by‑Step Guide
Architecture Digest
Architecture Digest
Sep 9, 2022 · Databases

MySQL Replication, High Availability, and Sharding Strategies

This article explains the evolution from single‑node MySQL to master‑slave replication, various replication modes, high‑availability solutions such as MHA and MGR, and the challenges and techniques of vertical and horizontal sharding for scaling large‑scale internet applications.

Distributed TransactionsReplicationdatabase scaling
0 likes · 12 min read
MySQL Replication, High Availability, and Sharding Strategies
IT Architects Alliance
IT Architects Alliance
Sep 4, 2022 · Databases

Mastering MySQL: From Replication to High Availability and Sharding Strategies

This article examines why single-node databases no longer meet modern internet workloads, explores MySQL replication models (master‑slave, asynchronous, semi‑synchronous, group replication), discusses high‑availability solutions such as MHA, MGR and Orchestrator, and outlines vertical and horizontal sharding techniques along with their trade‑offs.

Database ArchitectureMGRMHA
0 likes · 13 min read
Mastering MySQL: From Replication to High Availability and Sharding Strategies
Programmer DD
Programmer DD
Sep 2, 2022 · Databases

Unlock MySQL Binlog: Powering Replication and Real‑World Business Use Cases

This article explains MySQL’s binlog, how it enables master‑slave replication, and explores three practical business uses—data heterogeneity, cache synchronization, and task dispatch—showing how a middleware that pretends to be a slave can leverage binlog events to improve system architecture and performance.

BinlogReplicationcaching
0 likes · 7 min read
Unlock MySQL Binlog: Powering Replication and Real‑World Business Use Cases
dbaplus Community
dbaplus Community
Aug 24, 2022 · Databases

Mastering SQL Server: Essential Commands, Advanced Queries, and Maintenance Techniques

This guide compiles fundamental SQL Server commands for creating, modifying, and deleting databases and tables, advanced query operators, join strategies, pagination, data synchronization, performance tuning, backup and restore procedures, and useful built‑in functions, providing a comprehensive reference for database professionals.

BackupReplicationSQL Commands
0 likes · 27 min read
Mastering SQL Server: Essential Commands, Advanced Queries, and Maintenance Techniques
Top Architect
Top Architect
Aug 20, 2022 · Databases

Comprehensive SQL Server Cheat Sheet: Commands, Queries, and Administration Tips

An extensive collection of SQL Server commands, queries, and administrative procedures covering database creation, table manipulation, indexing, backup, security, replication, and performance tuning, presented with code examples and practical tips for developers and DBAs seeking a handy reference guide.

BackupDatabase AdministrationReplication
0 likes · 24 min read
Comprehensive SQL Server Cheat Sheet: Commands, Queries, and Administration Tips
Java Architect Essentials
Java Architect Essentials
Aug 3, 2022 · Databases

Comprehensive SQL Server Database Operations and Replication Guide

This article provides an extensive collection of SQL Server commands and techniques covering basic database creation, table manipulation, advanced queries, backup and maintenance, as well as detailed steps for setting up linked servers, snapshot replication, and synchronization procedures between servers.

BackupLinked ServerReplication
0 likes · 23 min read
Comprehensive SQL Server Database Operations and Replication Guide
Aikesheng Open Source Community
Aikesheng Open Source Community
Aug 2, 2022 · Databases

Using Generated Invisible Primary Keys (GIPK) in MySQL 8.0.30

This article explains the new MySQL 8.0.30 feature that automatically generates invisible primary keys for InnoDB tables without explicit primary keys, demonstrates how to enable and use it, discusses DDL and replication implications, and outlines related limitations and backup considerations.

GIPKInnoDBInvisible Primary Key
0 likes · 12 min read
Using Generated Invisible Primary Keys (GIPK) in MySQL 8.0.30
Top Architect
Top Architect
Jul 21, 2022 · Big Data

Kafka Components and Architecture Explained

This article provides a comprehensive overview of Kafka's core components—including brokers, topics, partitions, producers, and consumers—explaining their roles, relationships, replication strategies, and how they work together within a Kafka cluster to ensure reliable, scalable message streaming.

BrokerConsumerDistributed
0 likes · 8 min read
Kafka Components and Architecture Explained
Aikesheng Open Source Community
Aikesheng Open Source Community
Jul 20, 2022 · Databases

Using ProxySQL Binlog Reader to Monitor MySQL GTID Replication

This article introduces the ProxySQL Binlog Reader component, explains its background in read/write splitting and GTID‑based consistency, demonstrates how to configure MySQL servers, create a dedicated user, start the reader on master and replica, and verify its operation through logs and session information.

Binlog ReaderGTIDProxySQL
0 likes · 9 min read
Using ProxySQL Binlog Reader to Monitor MySQL GTID Replication
Selected Java Interview Questions
Selected Java Interview Questions
Jul 5, 2022 · Big Data

Understanding Elasticsearch: Core Concepts, Architecture, Indexing Mechanics and Performance Optimization

This article explains the fundamentals of structured and unstructured data, introduces Lucene's inverted index, describes Elasticsearch's distributed cluster architecture, node roles, sharding and replication mechanisms, indexing workflow with refresh and translog, storage segment model, and provides practical performance‑tuning recommendations.

ClusterElasticsearchReplication
0 likes · 36 min read
Understanding Elasticsearch: Core Concepts, Architecture, Indexing Mechanics and Performance Optimization
Tencent Cloud Developer
Tencent Cloud Developer
Jun 30, 2022 · Databases

Redis Overview: Architecture, Persistence, Replication, Sentinel, and Cluster

Redis is a single‑threaded, in‑memory data store offering rich structures, configurable expiration, multiple eviction policies, asynchronous master‑slave replication with Sentinel failover, durable RDB snapshots plus AOF logging, and native clustering that shards data across many masters for horizontal scalability and high availability.

CacheClusterPersistence
0 likes · 18 min read
Redis Overview: Architecture, Persistence, Replication, Sentinel, and Cluster
Aikesheng Open Source Community
Aikesheng Open Source Community
Jun 30, 2022 · Databases

Handling Replication Anomalies in MySQL Slave IO Thread

This article analyzes MySQL replication anomalies caused by master failures or network interruptions that lead to incomplete transaction replay on slaves, demonstrates a reproducible experiment using network delay and iptables, and provides practical guidance for both recovering and permanently handling stalled slave IO threads.

GTIDReplicationdatabase
0 likes · 6 min read
Handling Replication Anomalies in MySQL Slave IO Thread
php Courses
php Courses
Jun 24, 2022 · Databases

Comprehensive List of MySQL Interview Questions

This article compiles 66 MySQL interview questions covering fundamentals such as joins, data types, indexes, storage engines, transaction properties, locking mechanisms, replication, sharding, performance tuning, and high‑availability concepts for interview preparation.

Replicationdatabaseindexing
0 likes · 3 min read
Comprehensive List of MySQL Interview Questions
IT Services Circle
IT Services Circle
Jun 21, 2022 · Databases

MySQL High‑Availability Incident Review and Resolution in a Dual‑Master Setup with Keepalived

This article recounts a MySQL high‑availability incident in a dual‑master environment, explains how missing binary‑log index files caused replication failures, and details step‑by‑step troubleshooting, directory recreation, binlog position correction, and configuration improvements to restore reliable database operation.

Replicationdatabaseshigh availability
0 likes · 8 min read
MySQL High‑Availability Incident Review and Resolution in a Dual‑Master Setup with Keepalived
Tencent Cloud Developer
Tencent Cloud Developer
Jun 7, 2022 · Databases

Mastering MongoDB: From Basics to Advanced Performance Tuning

This comprehensive guide explores MongoDB’s core features—including schema flexibility, high availability, sharding, storage engine internals, indexing, and performance tuning—while providing practical examples, configuration tips, and best‑practice recommendations for developers and architects seeking to efficiently deploy and operate MongoDB in production environments.

MongoDBReplicationWiredTiger
0 likes · 40 min read
Mastering MongoDB: From Basics to Advanced Performance Tuning
Java High-Performance Architecture
Java High-Performance Architecture
May 19, 2022 · Databases

Mastering MySQL Replication: From Basics to Advanced Configurations

This article explains MySQL replication fundamentals, binary log mechanics, master‑slave roles, configuration steps, and the various replication types—including asynchronous, semi‑synchronous, multi‑source, and delayed replication—while providing practical commands and code examples for reliable high‑availability setups.

Delayed ReplicationReplicationSemi‑Sync
0 likes · 14 min read
Mastering MySQL Replication: From Basics to Advanced Configurations
Bilibili Tech
Bilibili Tech
May 17, 2022 · Cloud Computing

Bilibili Object Storage Service (BOSS) Design: Building a Large-Scale Distributed Storage System in 13 Days

In just 13 days Bilibili transformed a simple MySQL‑based S3 prototype into the BOSS distributed object storage system by separating metadata and data, adding an RPC abstraction layer, implementing two‑level sharding, switching to RocksDB, and deploying a three‑replica, multi‑zone high‑availability architecture.

ReplicationRocksDBS3 protocol
0 likes · 15 min read
Bilibili Object Storage Service (BOSS) Design: Building a Large-Scale Distributed Storage System in 13 Days
HelloTech
HelloTech
May 13, 2022 · Backend Development

Redis Dual-Active Architecture: Hot-Standby, Dual-Write, and Bidirectional Synchronization Comparison

This article compares Redis dual‑active designs—hot‑standby, various dual‑write models, and bidirectional synchronization—showing hot‑standby’s high cost, dual‑write’s latency or consistency trade‑offs, and arguing that a middleware‑driven bidirectional sync, using replication protocols and fixed‑prefix keys to avoid loops, offers the most practical solution.

ClusterDual-Active ArchitectureReplication
0 likes · 14 min read
Redis Dual-Active Architecture: Hot-Standby, Dual-Write, and Bidirectional Synchronization Comparison
Laravel Tech Community
Laravel Tech Community
Apr 27, 2022 · Databases

Common MySQL Errors and Their Solutions: Password Reset, Case Sensitivity, Service Startup, Export/Import, Connection Limits, Binlog Management, and Replication Issues

This article compiles eight classic MySQL error scenarios—including forgotten passwords, case‑sensitivity mismatches, Windows service startup failures, export/import restrictions, excessive connections, full binary logs, and primary‑key replication conflicts—along with detailed troubleshooting steps, configuration tweaks, and command‑line solutions to help database practitioners resolve them efficiently.

Case SensitivityDatabase ErrorsExport Import
0 likes · 10 min read
Common MySQL Errors and Their Solutions: Password Reset, Case Sensitivity, Service Startup, Export/Import, Connection Limits, Binlog Management, and Replication Issues
Code Ape Tech Column
Code Ape Tech Column
Apr 23, 2022 · Big Data

Kafka Fundamentals: Architecture, Replication, Partitioning, and Performance

This article provides a comprehensive overview of Kafka, covering its role as a message middleware, core concepts, architecture, replication management, partition handling, producer sending modes, partition assignment strategies, load balancing, reliability mechanisms, consumer models, controller election, and factors that affect its high throughput and potential message loss scenarios.

Distributed SystemsKafkaMessage Queue
0 likes · 29 min read
Kafka Fundamentals: Architecture, Replication, Partitioning, and Performance
Laravel Tech Community
Laravel Tech Community
Apr 20, 2022 · Databases

Redis Overview: Features, Data Types, Caching Issues, Performance, Persistence, Replication, and Sentinel

This article provides a comprehensive overview of Redis, covering its core characteristics, supported data types, common caching challenges such as consistency, avalanche, penetration and breakdown, as well as its high performance mechanisms, eviction policies, persistence options, master‑slave replication, and Sentinel high‑availability architecture.

In-Memory DatabasePersistenceReplication
0 likes · 11 min read
Redis Overview: Features, Data Types, Caching Issues, Performance, Persistence, Replication, and Sentinel
Architect
Architect
Apr 19, 2022 · Databases

Redis Overview: Features, Data Types, Caching Strategies, Common Pitfalls, Performance, Persistence, Replication, and Sentinel

This article provides a comprehensive introduction to Redis, covering its core characteristics, supported data types, caching usage patterns, typical issues such as consistency, avalanche, penetration and breakdown, performance reasons, eviction policies, persistence options, master‑slave replication, and Sentinel high‑availability mechanisms.

NoSQLPersistenceReplication
0 likes · 11 min read
Redis Overview: Features, Data Types, Caching Strategies, Common Pitfalls, Performance, Persistence, Replication, and Sentinel
IT Architects Alliance
IT Architects Alliance
Apr 17, 2022 · Databases

Redis Overview: Features, Data Types, Caching Strategies, Performance, Persistence, Replication, and Sentinel

This article provides a comprehensive introduction to Redis, covering its core characteristics, supported data structures, common caching use‑cases and associated challenges such as consistency, cache avalanche, penetration and breakdown, as well as performance reasons, eviction policies, persistence options, master‑slave replication, and Sentinel high‑availability mechanisms.

In-Memory DatabasePersistenceReplication
0 likes · 11 min read
Redis Overview: Features, Data Types, Caching Strategies, Performance, Persistence, Replication, and Sentinel
Top Architect
Top Architect
Apr 17, 2022 · Databases

Redis Overview: Features, Data Types, Caching Strategies, Performance, Persistence, Replication, and Sentinel

This article provides a comprehensive introduction to Redis, covering its core features, supported data structures, common caching patterns, typical cache‑related problems and mitigation techniques, performance characteristics, eviction policies, persistence options, replication mechanisms, and Sentinel high‑availability architecture.

In-Memory DatabasePersistenceReplication
0 likes · 11 min read
Redis Overview: Features, Data Types, Caching Strategies, Performance, Persistence, Replication, and Sentinel
Ziru Technology
Ziru Technology
Apr 8, 2022 · Databases

How to Diagnose and Prevent Split-Brain Data Loss in Redis Master-Slave Clusters

This article explains why data loss can occur in Redis master‑slave clusters due to split‑brain scenarios, outlines step‑by‑step troubleshooting methods—including checking replication lag, analyzing client logs, and monitoring resource usage—and recommends configuration settings such as min‑slaves‑to‑write and min‑slaves‑max‑lag to prevent the issue.

ConfigurationData lossMaster‑Slave
0 likes · 8 min read
How to Diagnose and Prevent Split-Brain Data Loss in Redis Master-Slave Clusters
Liangxu Linux
Liangxu Linux
Apr 7, 2022 · Databases

Essential MySQL Interview Guide: Normal Forms, Permissions, ACID, Indexes & More

This comprehensive guide covers MySQL fundamentals including the three normal forms, permission tables, ACID properties, index design principles, SQL statement categories, sharding, deadlock resolution, isolation anomalies, view characteristics, SQL lifecycle, primary key choices, performance troubleshooting, replication, GTID, backup tools, and backup planning.

BackupDatabase designReplication
0 likes · 13 min read
Essential MySQL Interview Guide: Normal Forms, Permissions, ACID, Indexes & More
ITPUB
ITPUB
Mar 31, 2022 · Databases

Understanding Redis: Core Data Types, Persistence, Replication, and Common Pitfalls

This comprehensive guide explores Redis fundamentals, including NoSQL concepts, its five primary data structures, internal storage mechanisms, persistence options, replication, sentinel failover, and strategies to prevent cache penetration, breakdown, and avalanche, providing developers with deep insights for building robust, high‑performance applications.

CacheData StructuresNoSQL
0 likes · 53 min read
Understanding Redis: Core Data Types, Persistence, Replication, and Common Pitfalls
Aikesheng Open Source Community
Aikesheng Open Source Community
Mar 28, 2022 · Databases

Testing Safe vs. Forceful MySQL Shutdown in a Semi‑Synchronous Replication Setup

This article presents a detailed experiment comparing graceful and kill‑9 shutdown methods on a MySQL 5.7 semi‑synchronous master‑slave cluster, analyzes their impact on data consistency, and outlines the official shutdown sequence with practical observations and recommendations for production environments.

ReplicationSemi‑SyncShutdown
0 likes · 12 min read
Testing Safe vs. Forceful MySQL Shutdown in a Semi‑Synchronous Replication Setup
Su San Talks Tech
Su San Talks Tech
Mar 27, 2022 · Big Data

Top 10 Advanced Kafka Interview Questions with In‑Depth Answers

This article provides a comprehensive collection of advanced Kafka interview questions covering core architecture, storage mechanisms, replication, leader election, controller responsibilities, consumer group rebalancing, message semantics, partition assignment strategies, performance tuning, and practical tips for handling large message backlogs.

ConsumerGroupKafkaReplication
0 likes · 33 min read
Top 10 Advanced Kafka Interview Questions with In‑Depth Answers
Java Captain
Java Captain
Mar 25, 2022 · Databases

Common MySQL Interview Questions and Answers

This article compiles essential MySQL interview topics, covering normal forms, privilege tables, ACID properties, SQL statement categories, sharding, deadlocks, isolation anomalies, view characteristics, statement lifecycle, primary key choices, CPU troubleshooting, replication, GTID, backup tools, and backup planning strategies.

Database designReplicationinterview-questions
0 likes · 15 min read
Common MySQL Interview Questions and Answers
Top Architect
Top Architect
Mar 15, 2022 · Backend Development

Understanding Apache Kafka Replication Mechanism and Its Design Principles

This article explains Apache Kafka's replication mechanism, covering the benefits of data redundancy, the roles of leader and follower replicas, the In‑Sync Replica (ISR) concept, unclean leader election, and how these design choices affect availability, consistency, and scalability in distributed systems.

ISRKafkaReplication
0 likes · 11 min read
Understanding Apache Kafka Replication Mechanism and Its Design Principles
IT Services Circle
IT Services Circle
Mar 12, 2022 · Databases

Understanding MySQL Master‑Slave Replication and Read/Write Splitting

This article explains the basics of MySQL master‑slave replication, illustrates how read/write splitting works to alleviate performance bottlenecks, and shares practical test results showing reduced latency on the master and improved overall throughput when directing reads to replica servers.

DatabasePerformanceReadWriteSplittingReplication
0 likes · 4 min read
Understanding MySQL Master‑Slave Replication and Read/Write Splitting
Big Data Technology & Architecture
Big Data Technology & Architecture
Mar 10, 2022 · Databases

Understanding ClickHouse Replication Mechanism

This article explains the ClickHouse replication mechanism, covering the Replication engine family, table‑level operation, Zookeeper dependency, data synchronization, insert quorum, and data consistency guarantees, providing practical guidance for configuring and using replicated MergeTree tables.

MergeTreeReplicationclickhouse
0 likes · 7 min read
Understanding ClickHouse Replication Mechanism
Selected Java Interview Questions
Selected Java Interview Questions
Mar 9, 2022 · Big Data

Elasticsearch Overview: Core Concepts, Architecture, and Performance Optimization

This article provides a comprehensive overview of Elasticsearch, covering its data types, Lucene-based inverted index, cluster architecture, sharding and replication mechanisms, mapping definitions, basic usage, health monitoring, storage internals, and practical performance tuning tips for large‑scale search deployments.

ClusterElasticsearchReplication
0 likes · 36 min read
Elasticsearch Overview: Core Concepts, Architecture, and Performance Optimization
Efficient Ops
Efficient Ops
Feb 23, 2022 · Operations

Why a Single Kafka Broker Crash Can Halt All Consumers – The HA Explained

An in‑depth look at Kafka’s high‑availability architecture reveals how multi‑replica redundancy, ISR mechanisms, and the configuration of the __consumer_offset topic interact, explaining why a single broker failure can render the entire cluster unusable and how to properly configure replication and ack settings to prevent it.

ACKConsumer OffsetISR
0 likes · 10 min read
Why a Single Kafka Broker Crash Can Halt All Consumers – The HA Explained
High Availability Architecture
High Availability Architecture
Feb 23, 2022 · Databases

Redis Master‑Slave Replication Memory Consumption and the Shared Replication Buffer Design

This article analyzes the excessive memory usage and blocking issues in Redis master‑slave replication, explains how the upcoming Redis 7.0 shared replication buffer solves these problems, and details the design, implementation, and key considerations of the shared buffer mechanism.

Database InternalsMemory OptimizationReplication
0 likes · 14 min read
Redis Master‑Slave Replication Memory Consumption and the Shared Replication Buffer Design
Ops Development Stories
Ops Development Stories
Feb 17, 2022 · Cloud Native

How to Build a Minimal‑Cost HA Harbor Registry with PostgreSQL Replication on Alibaba Cloud

This guide details a low‑overhead, highly available Harbor deployment on Alibaba Cloud, covering preparation of SLB, ECS, NFS storage, installation of Docker‑Compose, configuration of image mirrors, installation of Harbor 2.3, setup of PostgreSQL 13 master‑slave replication, Redis integration, backup procedures, failover handling, and disaster‑recovery strategies.

Alibaba CloudDockerHarbor
0 likes · 20 min read
How to Build a Minimal‑Cost HA Harbor Registry with PostgreSQL Replication on Alibaba Cloud
QQ Music Frontend Team
QQ Music Frontend Team
Feb 15, 2022 · Databases

Mastering Redis: From Fundamentals to Advanced Features and Real‑World Use Cases

This comprehensive guide walks you through Redis basics, its data structures, commands, installation steps, high‑concurrency principles, persistence mechanisms, replication, caching strategies, Lua scripting, pipelines, distributed locks, and cluster concepts, providing practical examples and best‑practice recommendations for developers and operators.

Data StructuresLuaPersistence
0 likes · 70 min read
Mastering Redis: From Fundamentals to Advanced Features and Real‑World Use Cases
Architecture & Thinking
Architecture & Thinking
Feb 10, 2022 · Databases

Mastering MySQL Master‑Slave Replication: Principles, Challenges & Solutions

This article explains MySQL master‑slave replication fundamentals, why it’s used, the replication workflow, causes of lag, and presents multiple practical solutions—including system tuning, partitioning, caching, multi‑threaded relay log replay, and read‑from‑master strategies—to improve performance and reliability.

Database PerformanceReplicationmysql
0 likes · 12 min read
Mastering MySQL Master‑Slave Replication: Principles, Challenges & Solutions
Su San Talks Tech
Su San Talks Tech
Feb 7, 2022 · Databases

Essential MySQL Interview Q&A: Locks, Indexes, Replication, and Optimization

A comprehensive collection of MySQL interview questions and answers covering storage engines, lock types, gap locks, deadlock avoidance, isolation levels, index types, covering indexes, the left‑most prefix rule, SQL tuning, master‑slave replication, latency handling, sharding challenges, and global ID generation.

Replicationdatabaseindexing
0 likes · 15 min read
Essential MySQL Interview Q&A: Locks, Indexes, Replication, and Optimization
MaGe Linux Operations
MaGe Linux Operations
Jan 28, 2022 · Databases

How to Parse MySQL Binlog with Go: Build a Simple Replication Demo

This article demonstrates how to use Go to parse MySQL binlog events and synchronize data by implementing a lightweight replication client, covering configuration, server module, packet handling, handshake, registration, dump command, and providing complete source code examples with explanations.

BinlogGoReplication
0 likes · 16 min read
How to Parse MySQL Binlog with Go: Build a Simple Replication Demo