DBLink in MySQL-compatible mode

Read functionality of DBLink in MySQL-compatible mode

OceanBase DBLink provides cross-data-source access, allowing you to access remote database resources as if you were accessing local databases. In the current MySQL-compatible mode, the read functionality of DBLink is used to access data in MySQL-compatible tenants of remote OceanBase clusters from MySQL-compatible tenants of a local OceanBase cluster. The read functionality of DBLink can also be used to access data between MySQL-compatible tenants in the same OceanBase cluster.

MySQL DBLink supports the following data types:

• Numeric types: TINYINT, SMALLINT, MEDIUMINT, INT, BIGINT, FLOAT, DOUBLE, and DECIMAL
• Time types: DATE, TIME, YEAR, DATETIME, and TIMESTAMP
• Character types: CHAR and VARCHAR
• Other types: ENUM and SET

Considerations

Currently, reading data from a native MySQL database through an OceanBase MySQL-compatible tenant is not supported, nor is reading data from an OceanBase MySQL-compatible tenant by a native MySQL database supported.

References

• Access data in a remote database through a DBLink
• View a created DBLink
• Query data through a DBLink
• Create a DBLink
• Delete a DBLink