BestHub
Sign in
Tag

MySQL replication

1 views collected around this technical thread.

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 replicationRead-Write SplittingShardingSphere
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.

ClickHouseMaterializeMySQLMySQL replication
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.

CDBCloud DatabaseDatabase Audit
0 likes · 10 min read
TXSQL Internals@2018: Tencent MySQL Architecture and Optimization
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 RDSDatabase Scaling
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.

AtlasHigh AvailabilityKeepalived
0 likes · 16 min read
Design and Implementation of a Two‑Node High Availability Architecture Using Keepalived, Nginx, MySQL, and Atlas
Art of Distributed System Architecture Design
Art of Distributed System Architecture Design
Jul 1, 2015 · Operations

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

This article provides a comprehensive guide to Ansible, covering its purpose, installation via pip, ad‑hoc command usage, MySQL replication with the mysql_replication module, role‑based playbook structure, sample YAML files, execution output, and a comparison with other configuration‑management tools.

AnsibleAutomationConfiguration Management
0 likes · 18 min read
An Introduction to Ansible: Installation, Basic Usage, and MySQL Replication with Playbooks