How to Handle Stored Procedures in MySQL That Cannot Be Migrated to TiDB?

Translated
1

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

Original topic: mysql中的存储过程，在tidb迁移不来，实际中一般怎么建议呢？

| username: redgame

Stored procedures in MySQL cannot be migrated to TiDB. What is generally recommended in practice?

2
| username: zhanggame1 | Original post link

Either stop using TiDB or implement it at the application layer.

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

Implement it at the application layer.

4
| username: Anna | Original post link

Implementation of the reference layer

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

Implementation at the application level

6
| username: xingzhenxiang | Original post link

At the application level, to put it simply, a stored procedure is just a series of logical operations.

7
| username: xfworld | Original post link

The performance of MySQL stored procedures is not good, it depends on the architecture layer…

Replace it through middleware and processing between layers.
The basic requirements are high availability and scalability…