Note:
This topic has been translated from a Chinese forum by GPT and might contain errors.Original topic: tidb 跨库访问
|
username: ljh_wxy
【TiDB Usage Environment】TiDB feature research environment
【TiDB Version】V5.4.1
【Encountered Problem】Does TiDB support Oracle’s dblink functionality?
【Reproduction Path】None
【Problem Phenomenon and Impact】
None
【Attachment】None
I saw on Baidu that MySQL supports FEDERATED for cross-database operations. Does TiDB support this?
In the SHOW ENGINES output, there is only InnoDB, and it does not support FEDERATED, right?
Not supported, innodb is also a compatible term, not the actual innodb. You can use a compromise method, using DM or CDC to perform real-time synchronization of the required data tables to achieve cross-database operations.
Indeed, this is a remote table on MySQL. I have used it, but TiDB does not have this feature yet.
In that case, I have a request that I’m not sure if I should mention~ Hehehe
The requirement is to implement that MySQL feature, after all, it needs to be compatible with MySQL.
My thought is that things like stored procedures and custom functions were definitely known and considered in the early stages, and after discussion, it was decided not to implement them. The possibility of adding them later is very small. Additionally, remote tables in MySQL are actually used very rarely within MySQL itself. I think the possibility is even smaller.
It is estimated that data interaction with TiDB can only be achieved through PostgreSQL. PostgreSQL has FDW plugins and dblink.
Cross-database access is not supported, but it can be converted through other means.
This topic was automatically closed 1 minute after the last reply. No new replies are allowed.
|
username: 
|
username: 
|
username: 
|
username: 
|
username: 
|
username: 
|
username: 
|
username: 
|
username: 
|
username: 
|
username: 
|
username: