OceanBase Database Integration Guide

HAP Server uses MySQL as its default relational database. Since v4.8.1, it also supports OceanBase. For environments with domestic technology requirements, you can use this database instead of MySQL.
Follow these integration steps:
-
Provision an OB Cloud database cluster instance.
-
When creating a tenant, note these two requirements:
-
Select MySQL as the tenant mode.
-
Select utf8mb4_general_ci as the character set.
-
-
After creating the tenant, download the HAP database initialization scripts.
-
Initialize the data
Use a MySQL client such as DBeaver or mysql. The following example uses the mysql command-line client:
Run the initialization scripts (adjust the IP address, port, username, password and SQL file paths for your environment).
mysql -h xxx.oceanbase.aliyuncs.com -P 3306 -uroot -p****** --default-character-set=utf8mb4 < /usr/local/init_ob/1_MDProject.sqlmysql -h xxx.oceanbase.aliyuncs.com -P 3306 -uroot -p****** --default-character-set=utf8mb4 < /usr/local/init_ob/2_MDStructure.sqlmysql -h xxx.oceanbase.aliyuncs.com -P 3306 -uroot -p****** --default-character-set=utf8mb4 < /usr/local/init_ob/3_MDApplication.sqlmysql -h xxx.oceanbase.aliyuncs.com -P 3306 -uroot -p****** --default-character-set=utf8mb4 < /usr/local/init_ob/4_MDCalendar.sqlmysql -h xxx.oceanbase.aliyuncs.com -P 3306 -uroot -p****** --default-character-set=utf8mb4 < /usr/local/init_ob/5_MDLog.sqlmysql -h xxx.oceanbase.aliyuncs.com -P 3306 -uroot -p****** --default-character-set=utf8mb4 < /usr/local/init_ob/6_Data_MDProject.sqlmysql -h xxx.oceanbase.aliyuncs.com -P 3306 -uroot -p****** --default-character-set=utf8mb4 < /usr/local/init_ob/7_Data_MDApplication.sql -
Initialize HAP services
Before initializing services, add the following environment variables (replace connection parameter values with actual values):
ENV_RDB_TYPE: "2"ENV_RDB_URI_MDPROJECT: "Server=xxx.oceanbase.aliyuncs.com;Port=3306;Database=MDProject;uid=root;password=******;"ENV_RDB_URI_MDLOG: "Server=xxx.oceanbase.aliyuncs.com;Port=3306;Database=MDLog;uid=root;password=******;"ENV_RDB_URI_MDSTRUCTURE: "Server=xxx.oceanbase.aliyuncs.com;Port=3306;Database=MDStructure;uid=root;password=******;"ENV_RDB_URI_MDCALENDAR: "Server=xxx.oceanbase.aliyuncs.com;Port=3306;Database=MDCalendar;uid=root;password=******;"ENV_RDB_URI_MDAPPLICATION: "Server=xxx.oceanbase.aliyuncs.com;Port=3306;Database=MDApplication;uid=root;password=******;"ENV_STANDALONE_DISABLE_SERVICES: "mysql" -
Complete the remaining system initialization steps.