Multi-Source Replication

Aikesheng Open Source Community

Mar 12, 2021 · Databases

Practical Guide to MySQL Database Migration, Backup, and Multi‑Source Replication

This article summarizes a real‑world MySQL database migration project, detailing pre‑migration preparation, backup and import commands, replication setup—including multi‑source replication for merging databases—and post‑migration verification steps, while sharing practical tips and pitfalls.

Database MigrationMulti-Source ReplicationMySQL

0 likes · 8 min read

Practical Guide to MySQL Database Migration, Backup, and Multi‑Source Replication

Aikesheng Open Source Community

Nov 3, 2020 · Databases

Using GTID for Multi‑Source Replication in MySQL

This article explains why GTID‑based replication is preferred for synchronizing data from four regional factories to an IDC, and provides a step‑by‑step guide—including data export, GTID configuration, master‑slave channel setup, adding a new slave, and important precautions—for successful multi‑source MySQL replication.

DatabaseGTIDMulti-Source Replication

0 likes · 8 min read

Using GTID for Multi‑Source Replication in MySQL

Aikesheng Open Source Community

Nov 4, 2019 · Databases

Using MySQL Multi‑Source Replication to Aggregate Data from Multiple Servers

The article explains how MySQL multi‑source replication can be employed to back up, horizontally or vertically partition, and merge data from several servers into a single target database, illustrating three typical scenarios and providing example SQL for data consolidation.

Multi-Source ReplicationMySQLVertical Partitioning

0 likes · 5 min read

Using MySQL Multi‑Source Replication to Aggregate Data from Multiple Servers

Aikesheng Open Source Community

Mar 5, 2019 · Databases

Guide to MySQL Transportable Tablespaces and Multi‑Source Replication Using XtraBackup

This article explains how to use MySQL's transportable tablespaces together with Percona XtraBackup to efficiently initialize data for multi‑source replication, covering prerequisites, the basic export/import workflow, detailed command‑line steps, and the configuration of replication channels.

Multi-Source ReplicationMySQLReplication

0 likes · 11 min read

Guide to MySQL Transportable Tablespaces and Multi‑Source Replication Using XtraBackup