OceanBase

OceanBase (MySQL mode) is its own database type in QueryDesk. It speaks the MySQL protocol, so the schema sync, the table structure view, data protection and peer reviews work as they do on MySQL. QueryDesk is tested against OceanBase CE 4.4. Oracle mode is not supported.

Connect a tenant

Add the database as in Connect a database, with these values:

FieldValue
Database typeOceanBase (MySQL mode)
Port2881, OceanBase's default, or the port of the proxy you connect through.
Database nameThe database to query.

Enter the credential's user name the way your tenant takes it, for example app@tenant or app@tenant#cluster through OceanBase's proxy.

A mysql:// connection string pasted under Update with connection string keeps the OceanBase type.

Click Test Connection under the credential to check the connection.

What works differently

  • Timeouts use OceanBase's own ob_query_timeout, set from the database's query timeout on each connection.
  • AI read-only runs an AI query in a read-only transaction that is always rolled back, as on MySQL. OceanBase also refuses a function's write inside it.

Was this page helpful?