Is migrating an Oracle database to TiDB a significant change? Are there any good reference solutions?

Translated
1

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

Original topic: Oracle数据库迁移TiDB改动很大吧？有没有较好的参考方案

| username: alfred

【TiDB Usage Environment】Production\Test Environment\POC
【TiDB Version】
【Encountered Issues】
【Reproduction Path】What operations were performed that led to the issue
【Issue Phenomenon and Impact】
【Attachments】

  • Relevant logs, configuration files, Grafana monitoring (https://metricstool.pingcap.com/)
  • TiUP Cluster Display information
  • TiUP Cluster Edit config information
  • TiDB-Overview monitoring
  • Corresponding module’s Grafana monitoring (if any, such as BR, TiDB-binlog, TiCDC, etc.)
  • Corresponding module logs (including logs from 1 hour before and after the issue)

If the question is related to performance optimization or troubleshooting, please download the script and run it. Please select all the terminal output and copy-paste it for upload.

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

You can use OGG, refer to this document

3
| username: alfred | Original post link

Yes, using OGG synchronization is a better choice, but TiDB does not support some stored procedures and stored functions, so they can only be implemented in the business code, right?

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

Yes, TiDB does not support stored procedures, so some code modifications are necessary.

5
| username: alfred | Original post link

The entire process still needs to be handled with caution, thank you.

6
| username: system | Original post link

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