Skip to main content

TiDB Database Integration Guide

HAP Server uses MySQL as its default relational database. Since v6.0.2, it also supports TiDB. For environments with domestic technology requirements, you can use this database instead of MySQL.

Follow these integration steps:

  1. Deploy TiDB Enterprise Edition in standalone or cluster mode.

    For HAP standalone deployments or simplified clusters, choose standalone mode. For standard or professional clusters, choose cluster mode.

  2. Download the HAP database initialization scripts.

  3. 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 /usr/local/init_tidb/ path for your environment).

    mysql -h 127.0.0.1 -P 4000 -uroot -p****** < /usr/local/init_tidb/1_MDProject.sql
    mysql -h 127.0.0.1 -P 4000 -uroot -p****** < /usr/local/init_tidb/2_MDStructure.sql
    mysql -h 127.0.0.1 -P 4000 -uroot -p****** < /usr/local/init_tidb/3_MDApplication.sql
    mysql -h 127.0.0.1 -P 4000 -uroot -p****** < /usr/local/init_tidb/4_MDCalendar.sql
    mysql -h 127.0.0.1 -P 4000 -uroot -p****** < /usr/local/init_tidb/5_MDLog.sql
    mysql -h 127.0.0.1 -P 4000 -uroot -p****** < /usr/local/init_tidb/6_Data_MDProject.sql
    mysql -h 127.0.0.1 -P 4000 -uroot -p****** < /usr/local/init_tidb/7_Data_MDApplication.sql
  4. 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=127.0.0.1;Port=4000;Database=MDProject;uid=root;password=******;"
    ENV_RDB_URI_MDLOG: "Server=127.0.0.1;Port=4000;Database=MDLog;uid=root;password=******;"
    ENV_RDB_URI_MDSTRUCTURE: "Server=127.0.0.1;Port=4000;Database=MDStructure;uid=root;password=******;"
    ENV_RDB_URI_MDCALENDAR: "Server=127.0.0.1;Port=4000;Database=MDCalendar;uid=root;password=******;"
    ENV_RDB_URI_MDAPPLICATION: "Server=127.0.0.1;Port=4000;Database=MDApplication;uid=root;password=******;"
    ENV_STANDALONE_DISABLE_SERVICES: "mysql"
  5. Complete the remaining system initialization steps.