BestHub
Sign in
Tagged articles
16 articles
Page 1 of 1
Xiao Liu Lab
Xiao Liu Lab
Nov 16, 2025 · Backend Development

Master Web Architecture: Load Balancing, Static/Dynamic Separation, and MySQL Replication Explained

This article provides interview‑ready, step‑by‑step explanations of how Nginx works with Tomcat, the benefits of static‑dynamic separation, essential Nginx modules and load‑balancing algorithms, plus detailed MySQL master‑slave replication, failover, backup strategies, and related database concepts.

Backend DevelopmentMySQL replicationNginx
0 likes · 13 min read
Master Web Architecture: Load Balancing, Static/Dynamic Separation, and MySQL Replication Explained
Alibaba Cloud Developer
Alibaba Cloud Developer
Oct 17, 2025 · Databases

Explore PolarDB‑X v2.4.2: New Proxy, Multi‑Language Connectors, and High‑Performance Features

PolarDB‑X version 2.4.2 introduces a Java‑based proxy, multi‑language client drivers, enhanced HA switching, MySQL‑compatible replication, performance testing results, and the open‑source MCP server for AI integration, providing a comprehensive overview of the latest distributed database capabilities.

ConnectorMCP ServerMySQL replication
0 likes · 19 min read
Explore PolarDB‑X v2.4.2: New Proxy, Multi‑Language Connectors, and High‑Performance Features
Senior Tony
Senior Tony
Aug 26, 2025 · Databases

CAP vs BASE: Picking the Right Consistency Model for MySQL, Redis & Elasticsearch

This article explains the CAP and BASE theorems, compares consistency, availability and partition tolerance, and analyzes how MySQL replication modes, Redis Cluster, and Elasticsearch clusters fit into CP, AP or BASE models to help you choose the appropriate consistency strategy for distributed systems.

BASE theoremCAP theoremElasticsearch
0 likes · 9 min read
CAP vs BASE: Picking the Right Consistency Model for MySQL, Redis & Elasticsearch
Java High-Performance Architecture
Java High-Performance Architecture
Sep 4, 2022 · Databases

Unlock Sharding-JDBC: Guide to Sharding, Replication & Distributed Databases

This comprehensive tutorial walks through the evolution of Sharding-JDBC into ShardingSphere, explains core concepts like sharding, data nodes, and algorithms, demonstrates MySQL master‑slave setup with Docker, and provides step‑by‑step code examples for implementing read‑write separation, horizontal and vertical sharding, and distributed primary keys.

MySQL replicationSharding-JDBCSpring Boot
0 likes · 39 min read
Unlock Sharding-JDBC: Guide to Sharding, Replication & Distributed Databases
Ctrip Technology
Ctrip Technology
Aug 11, 2022 · Databases

Design and Implementation of Ctrip's Data Replicate Center (DRC) for Database Cloud Migration

This article details Ctrip's Data Replicate Center (DRC) architecture, challenges, and solutions for migrating MySQL databases to the cloud, covering read‑only and read‑write scenarios, cost analysis, proxy modules, transaction‑table replication, data isolation, filtering, deployment workflow, and achieved performance and cost benefits.

CtripDRCDatabase Replication
0 likes · 16 min read
Design and Implementation of Ctrip's Data Replicate Center (DRC) for Database Cloud Migration
Aikesheng Open Source Community
Aikesheng Open Source Community
Dec 22, 2021 · Databases

Configuring ProxySQL with MySQL Replication and Group Replication for Read/Write Splitting and Automatic Failover

This guide demonstrates how to deploy a ProxySQL instance alongside six MySQL servers (three for traditional replication and three for MySQL Group Replication), configure users, set up read/write splitting rules, and enable automatic failover for both replication topologies.

Database HAGroup ReplicationMySQL replication
0 likes · 14 min read
Configuring ProxySQL with MySQL Replication and Group Replication for Read/Write Splitting and Automatic Failover
Top Architect
Top Architect
Aug 12, 2021 · Databases

Comprehensive Guide to ShardingSphere-Jdbc, MySQL Master‑Slave Replication, and Sharding Strategies

This article provides a detailed walkthrough of ShardingSphere‑Jdbc read/write splitting, MySQL master‑slave replication setup with Docker, the differences between redo log and binlog, two‑phase commit, and practical sharding configurations using inline strategies and distributed primary keys in a Spring Boot project.

MySQL replicationShardingSphereSpring Boot
0 likes · 23 min read
Comprehensive Guide to ShardingSphere-Jdbc, MySQL Master‑Slave Replication, and Sharding Strategies
Efficient Ops
Efficient Ops
Aug 9, 2020 · Databases

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

This article explains how ClickHouse can act as a MySQL replica, covering full and incremental synchronization, supported MySQL versions, DDL compatibility, handling of DELETE/UPDATE events, the underlying binlog mechanism, and provides complete code examples to set up both MySQL master and ClickHouse slave.

BinlogClickHouseMaterializeMySQL
0 likes · 11 min read
How ClickHouse Replicates MySQL in Real-Time: A Step‑by‑Step Guide
Tencent Cloud Developer
Tencent Cloud Developer
Oct 22, 2018 · Databases

TXSQL Internals@2018: Tencent MySQL Architecture and Optimization

The article details Tencent’s TXSQL (Tencent MySQL) architecture and optimizations—including asynchronous table deletion, DDL NO_WAIT/WAIT, MDL visibility, lock splitting, parallel replication, query push‑down, read‑view enhancements, low‑overhead auditing and KMS‑integrated encryption—highlighting its role as the core engine powering CDB for diverse industries such as gaming, finance, e‑commerce and internal services like WeChat and QQ.

CDBDatabase OptimizationInnoDB
0 likes · 10 min read
TXSQL Internals@2018: Tencent MySQL Architecture and Optimization
UCloud Tech
UCloud Tech
Aug 24, 2017 · Databases

How UDB Achieves High Availability: Deep MySQL Replication Optimizations

This article explains UDB's high‑availability architecture, detailing its dual‑node design with virtual IP and HAProxy, and describes the kernel‑level optimizations applied to MySQL's native semi‑synchronous replication, relay log handling, master.info management, and lock contention to boost stability and performance.

Database OptimizationMySQL replicationUDB
0 likes · 7 min read
How UDB Achieves High Availability: Deep MySQL Replication Optimizations
Meituan Technology Team
Meituan Technology Team
Dec 27, 2016 · Backend Development

Ensuring Data Consistency in Meituan Hotel Direct Connection Platform

To keep its rapidly expanding hotel‑direct platform consistent despite unstable supplier interfaces, Meituan evolved from full‑batch pulls to segmented fetching, predictive trigger‑based updates, and finally supplier‑initiated pushes, creating a hybrid pull‑push architecture that ensures low‑latency, reliable product and inventory data.

Backend DevelopmentData ConsistencyMySQL replication
0 likes · 18 min read
Ensuring Data Consistency in Meituan Hotel Direct Connection Platform
MaGe Linux Operations
MaGe Linux Operations
Jun 24, 2016 · Operations

Build a Scalable, High‑Availability Web Architecture with HAProxy, MySQL Replication & CDN

Learn how to construct a robust web infrastructure by deploying HAProxy as a reverse proxy, implementing high‑availability with Keepalived, balancing loads across DNS, setting up dynamic and static servers, configuring MySQL master‑slave replication, integrating caching layers, and leveraging CDN, monitoring, and automation tools for optimal performance.

CDNHAProxyMySQL replication
0 likes · 17 min read
Build a Scalable, High‑Availability Web Architecture with HAProxy, MySQL Replication & CDN
Art of Distributed System Architecture Design
Art of Distributed System Architecture Design
May 25, 2016 · Operations

An Introduction to Ansible: Installation, Configuration, and MySQL Replication with Playbooks

This article introduces Ansible, a Python‑based configuration management and deployment tool, explains its installation prerequisites, demonstrates basic ad‑hoc commands, and provides a comprehensive guide to managing MySQL master‑slave replication using Ansible modules, playbooks, and role‑based directory structures.

AnsibleAutomationConfiguration Management
0 likes · 19 min read
An Introduction to Ansible: Installation, Configuration, and MySQL Replication with Playbooks
Art of Distributed System Architecture Design
Art of Distributed System Architecture Design
Nov 6, 2015 · Databases

Airbnb’s Database Scaling Using MySQL Replication and Vertical Sharding

Airbnb tackled rapid data growth by vertically partitioning tables across multiple MySQL databases using Amazon RDS replication, minimizing downtime through read‑replica promotion, and implementing a staged migration that reduced primary database writes by 33%, cut size by 20%, and improved stability and scalability.

AirbnbAmazon RDSMySQL replication
0 likes · 12 min read
Airbnb’s Database Scaling Using MySQL Replication and Vertical Sharding
Art of Distributed System Architecture Design
Art of Distributed System Architecture Design
Jul 6, 2015 · Operations

Design and Implementation of a Two‑Node High Availability Architecture Using Keepalived, Nginx, MySQL, and Atlas

This article describes a complete two‑machine high‑availability solution that uses keepalived to manage virtual IPs, Nginx for load‑balancing, MySQL GTID replication with Atlas as a proxy, and detailed configuration and fail‑over testing steps to ensure seamless service continuity.

AtlasLinuxMySQL replication
0 likes · 16 min read
Design and Implementation of a Two‑Node High Availability Architecture Using Keepalived, Nginx, MySQL, and Atlas