Add a MySQL Replica Under a TiDB Cluster

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

Original topic: 在tidb集群下挂个mysql从库

| username: TiDB_C罗

[TiDB Usage Environment] Production Environment / Testing / PoC
[TiDB Version]
[Reproduction Path] What operations were performed that caused the issue
[Encountered Issue: Issue Phenomenon and Impact]
[Resource Configuration]
For data cleaning needs, to avoid affecting normal business operations directly on TiDB, a MySQL replica is attached under TiDB. Dumpling is used to export stock data, and TiCDC is used to synchronize incremental data. How can Lighting import data into MySQL?

| username: 像风一样的男子 | Original post link

You can dump TiDB data into an SQL file and execute it in MySQL.

| username: tidb菜鸟一只 | Original post link

Execute the SQL file directly in MySQL, or load the CSV file.

| username: 啦啦啦啦啦 | Original post link

The logical import mode of Lightning should work.

| username: zhanggame1 | Original post link

How to import lighting into MySQL?

This is simple, install MyDumper and then use the command to import, for example:

myloader -u root -p -d /tmp/test

Dumpling export types such as CSV, SQL, sharded export, etc., can all be restored in this way.

| username: system | Original post link

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.