GoldenDB Database Integration Guide
HAP Server uses MySQL as its default relational database. Since v7.3.4, it also supports GoldenDB. For environments with domestic technology requirements, you can use this database instead of MySQL.
Follow these integration steps:
-
Deploy GoldenDB in centralized mode.
-
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
/usr/local/init_goldendb/path for your environment).mysql -h 127.0.0.1 -P 4000 -uroot -p****** < /usr/local/init_goldendb/1_MDProject.sqlmysql -h 127.0.0.1 -P 4000 -uroot -p****** < /usr/local/init_goldendb/2_MDStructure.sqlmysql -h 127.0.0.1 -P 4000 -uroot -p****** < /usr/local/init_goldendb/3_MDApplication.sqlmysql -h 127.0.0.1 -P 4000 -uroot -p****** < /usr/local/init_goldendb/4_MDCalendar.sqlmysql -h 127.0.0.1 -P 4000 -uroot -p****** < /usr/local/init_goldendb/5_MDLog.sqlmysql -h 127.0.0.1 -P 4000 -uroot -p****** < /usr/local/init_goldendb/6_Data_MDProject.sqlmysql -h 127.0.0.1 -P 4000 -uroot -p****** < /usr/local/init_goldendb/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=127.0.0.1;Port=8880;Database=mdproject;uid=mingdao;password=******;"ENV_RDB_URI_MDLOG: "Server=127.0.0.1;Port=8880;Database=mdlog;uid=mingdao;password=******;"ENV_RDB_URI_MDSTRUCTURE: "Server=127.0.0.1;Port=8880;Database=mdstructure;uid=mingdao;password=******;"ENV_RDB_URI_MDCALENDAR: "Server=127.0.0.1;Port=8880;Database=mdcalendar;uid=mingdao;password=******;"ENV_RDB_URI_MDAPPLICATION: "Server=127.0.0.1;Port=8880;Database=mdapplication;uid=mingdao;password=******;"ENV_STANDALONE_DISABLE_SERVICES: "mysql" -
Complete the remaining system initialization steps.