Database guides

OceanBase

Updated 2026-08-11 · 2 min read

A distributed SQL database. In MySQL mode it speaks the MySQL wire protocol on port 2881, and AddisDB connects with its MySQL driver.

OceanBase is a distributed relational database developed at Ant Group. It runs in one of two compatibility modes, and this entry connects to MySQL mode, where it speaks the MySQL wire protocol and implements MySQL’s SQL surface and information_schema. AddisDB connects with its MySQL driver.

Who it is for

OceanBase targets workloads that need a single database to scale horizontally while staying strongly consistent — it uses Paxos replication and is best known for running Alipay’s transaction processing. It handles both transactional and analytical queries against the same data.

Two details matter when you connect. The port is 2881, not 3306: that is the observer’s direct MySQL port, and the obproxy router in front of a production cluster usually listens on 2883. And the username carries the tenant: in MySQL mode you authenticate as user@tenant, or as user@tenant#cluster through obproxy.

Set up the cluster

  1. Note an observer host, or the obproxy address if your deployment fronts the cluster with one.
  2. Use 2881 for a direct observer connection, or 2883 for obproxy.
  3. Identify the tenant you want. A fresh cluster has a sys tenant for administration and at least one business tenant for your data.
  4. Build the username: root@mytenant for a direct connection, or root@mytenant#mycluster through obproxy.
# The username carries the tenant
mysql -h oceanbase.example.com -P 2881 -u root@mytenant -p -e 'SELECT VERSION();'

Connect from AddisDB

  1. New Connection → OceanBase. Port prefills to 2881 and username to root.
  2. Enter the host, and put the full user@tenant string in the username field.
  3. Enter the tenant password and the database name.
  4. Test, then Save.

What AddisDB gives you

Queries, the schema tree, in-grid editing, the structured create and alter table builders, database-user management and mock data all work — OceanBase implements MySQL’s DDL and grant syntax in MySQL mode.

Query plans use OceanBase’s own EXPLAIN, which returns a text plan rather than MySQL’s JSON, so the plan viewer shows it as text.

The Live Monitor reads the process list and table sizes that OceanBase exposes through information_schema.