Sync TiDB Data to MySQL

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

Original topic: 同步TIDB数据到Mysql

| username: TiDBer_菜鸟

I would like to ask if any of you have experience synchronizing TiDB data to MySQL on the cloud? What is the solution, and how do you handle incremental synchronization?

| username: Kongdom | Original post link

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

Before version 4.0, use TiDB Binlog; from version 4.0 onwards, use TiCDC.

| username: TiDBer_pkQ5q1l0 | Original post link

Choose TiCDC as the first option.

| username: TiDBer_菜鸟 | Original post link

Thanks for the reply, I’ll give it a try.

| username: TiDBer_菜鸟 | Original post link

Thank you for your reply.

| username: TiDBer_菜鸟 | Original post link

Thank you for the reply. Can this achieve real-time data synchronization, or is it scheduled incremental synchronization?

| username: Raymond | Original post link

Real-time data synchronization

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

Asynchronous, considered quasi-real-time, somewhat similar to MySQL master-slave replication.

| username: Kongdom | Original post link

:handshake: :handshake: :handshake:

| username: TiDBer_菜鸟 | Original post link

Thank you for the expert’s explanation.

| username: 孤君888 | Original post link

We are using version 6.x, and TICDC perfectly solves the issue. Alternatively, using binlog subscription also works.

| username: system | Original post link

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