Tagged articles
MySQL replication
16 articles · Page 1 of 1
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.
MySQL replicationbackend developmentnginx
0 likes · 13 min read

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.
ConnectorDistributed DatabaseMCP Server
0 likes · 19 min read

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

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

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.
Cloud MigrationCtripDRC
0 likes · 16 min read

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 HAFailoverGroup Replication
0 likes · 14 min read

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

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.
ClickHouseMaterializeMySQLMySQL replication
0 likes · 11 min read

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.
CDBCloud DatabaseInnoDB
0 likes · 10 min read

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.
Cloud DatabaseHigh AvailabilityMySQL replication
0 likes · 7 min read

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.
Data ConsistencyMySQL replicationbackend development
0 likes · 18 min read

This tutorial walks through setting up a Mycat environment, creating required databases and users, installing JDK7 and Mycat, configuring environment variables and MySQL settings, defining sharding rules, and verifying both read/write separation and automatic failover in a master‑slave MySQL cluster.
Database MiddlewareMySQL replicationMycat
0 likes · 9 min read

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.
CDNCachingHAProxy
0 likes · 17 min read

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.
AnsibleConfiguration ManagementDevOps
0 likes · 19 min read

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

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.
AtlasKeepalivedLinux
0 likes · 16 min read
