[TiDB Community Wisdom Collection] [Best Practices] TiDB Synchronization & Migration Practical Guide (From MySQL/Oracle/PostgreSQL/MongoDB to TiDB)

Note:
This topic has been translated from a Chinese forum by GPT and might contain errors.

Original topic: 【TiDB 社区智慧合集】【最佳实践】TiDB 同步&迁移实战 (从 MySQL/Oracle/PostgreSQL/MongoDB 到 TiDB )

| username: Billmay表妹

MySQL to TiDB

Why do we need to migrate from MySQL to TiDB?

What should be noted when migrating business from MySQL to TiDB?

Here’s a trick to safely switch from MySQL to TiDB

Differences between TiDB’s pessimistic transaction mode and MySQL’s appearance

Ticmp - Faster migration from MySQL to TiDB

Small test of using DM to migrate MySQL data to TiDB

Migrating SQL Server 2012 database to TiDB 5.0 using MySQL Workbench

Compilation of issues related to migrating MySQL cluster to TiDB

TiCDC migration - TiDB to MySQL test

Why we abandoned MongoDB and MySQL and chose TiDB

TiDB as MySQL Slave for real-time data synchronization

5 minutes to complete data synchronization from MySQL to TiDB

Best practices for using Canal to synchronize MySQL data to TiDB

Beike Jinfu’s practice of online cross-data center migration with TiDB

Thanks to @BraveChen @CuteRay @zzw6776 @luyayao @田键一夫 @sunxiaoguang @kylin @黄东旭 @TiDBer_Clougence for their contributions.

MongoDB to TiDB

Using Gravity to achieve data replication from MongoDB to TiDB

Online migration of MongoDB data to TiDB by Banyu Database

Why we abandoned MongoDB and MySQL and chose TiDB

Thanks to @Hacker_ubN7WXjw @kylin for their contributions.

PostgreSQL to TiDB

What are the methods to migrate data from PostgreSQL to TiDB?

TiDB for PostgreSQL—A small trial

TiDB for PostgreSQL learning guide

Thanks to @caiyfc @alexshen for their contributions.

Oracle to TiDB

A simple process of offline data migration from Oracle to TiDB

How to migrate data from Oracle to TiDB

Connecting Oracle and TiDB using ODBC

Oracle to TiDB (OGG)

The journey of de-O for Lufax’s financial core scenario database

Recommended reading:

TiDB Binlog supports Oracle target database function user manual

Comparison of functions and syntax differences between Oracle and TiDB

Thanks to @hey-hoho @PINO @cartersz for their contributions.

SQL Server to TiDB

Practical scenarios of migrating SQL Server to TiDB

The heterogeneous migration of Autohome from SQL Server to TiDB

Thanks to @gloria_cy for their contributions.

AWS to TiDB

Migrating AWS S3 data to TiDB Cloud cluster

Thanks to @这道题我不会 for their contributions.

Other Synchronization/Migration Practices

Beike Jinfu’s practice of online cross-data center migration with TiDB

Using Gravity to achieve data replication from MongoDB to TiDB

Have you learned this awesome migration plan from NetEase? [DDB migration TiDB plan design]

TiDB migration practice of Japan’s large mobile payment software PayPay

Migration practice from TiSpark 2.4.1 (Spark 2.4.5) to TiSpark 2.5.0 (Spark 3.0.X/3.1.X)

Recording the process of migrating TiDB v5.2.3 to v6.1.0

“Data Migration” - Single Database Migration

TiDB at Pinterest丨From HBase to TiDB: How we achieved zero-downtime online data migration

Migrating AWS S3 data to TiDB Cloud cluster

AskTUG forum migration practice: Discourse from PostgreSQL to MySQL to TiDB

“Data Migration” - Single Database Migration

Experience TiDB v6.0.0’s data migration tool DM - WebUI

Thanks to @数据小黑 @gary @Ming @hooopo @边城元元 for their contributions.

Welcome other partners to continue to supplement.

| username: 边城元元 | Original post link

Full of valuable information.