Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Drainer: Support TiDB to Oracle Replication #1110

Open
cartersz opened this issue Dec 27, 2021 · 0 comments
Open

Drainer: Support TiDB to Oracle Replication #1110

cartersz opened this issue Dec 27, 2021 · 0 comments
Labels
feature-request This issue is a feature request

Comments

@cartersz
Copy link
Contributor

When users migrate their Oracle databases to TiDB, they need a way back, a survival plan that escapes from the failed TiDB, thus we need a solid solution of TiDB to Oracle data replication.
Currently there's no solution of TiDB to Oracle replication (T2O). Some of the customers deployed an unstable setup - T2M2O, which uses MySQL as a relay, the problem is TiDB and MySQL are not compatible, plus this replication chain is too long.

This enhancement of drainer could directly replicate from TiDB to Oracle, the replication chain is short, which means it's more stable than T2M2O solution. And there's no other MySQL involved which is a bottleneck of the performence.

  1. dml data migrate to oracle. see: replicate dml statements in binlog to oracle #1094
  2. 'truncate table' ddl statement to oracle. see: replicate ddl data in binlog to oracle #1095
  3. saving check point to oracle. see adaptation to oracle checkpoint #1097
  4. relay log for oracle. see relay log for oracle #1104
@cartersz cartersz added the feature-request This issue is a feature request label Dec 27, 2021
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
feature-request This issue is a feature request
Projects
None yet
Development

No branches or pull requests

1 participant