Xugu Database Integration Guide

HAP Server uses MySQL as its default relational database. Since v5.4.2, it also supports Xugu. For environments with domestic technology requirements, you can use this database instead of MySQL.
Follow these integration steps:
-
Deploy Xugu V11 or V12 in standalone, primary-standby (active-active), or distributed mode.
For HAP standalone deployments or simplified clusters, choose standalone mode. For standard or professional clusters, choose primary-standby (active-active) or distributed mode.
-
After deploying Xugu, download the HAP database initialization scripts and upload them to the Xugu environment.
-
Initialize the data
Connect to Xugu using
xgconsole. See the Console Tool User Guide. Adjust the username, password, IP address and port for your environment.xgconsoleis located under BIN in the installation directory, for example:BIN/xgconsole-linux-x64 nssl 127.0.0.1 5138 SYSTEM SYSDBA SYSDBARun the initialization scripts (adjust the
/usr/local/init_xugu/path for your environment).EXECFILE2 /usr/local/init_xugu/1_Database.sqlEXECFILE2 /usr/local/init_xugu/2_MDProject.sqlEXECFILE2 /usr/local/init_xugu/3_MDStructure.sqlEXECFILE2 /usr/local/init_xugu/4_MDApplication.sqlEXECFILE2 /usr/local/init_xugu/5_MDCalendar.sqlEXECFILE2 /usr/local/init_xugu/6_MDLog.sqlEXECFILE2 /usr/local/init_xugu/7_Data_MDProject.sqlEXECFILE2 /usr/local/init_xugu/8_Data_MDApplication.sql -
Initialize HAP services
Before initializing services, add the following environment variables (replace connection parameter values with actual values):
ENV_RDB_TYPE: "5"ENV_RDB_URI_MDPROJECT: "IP=127.0.0.1;DB=MDPROJECT;User=SYSDBA;PWD=SYSDBA;Port=5138;AUTO_COMMIT=on;CHAR_SET=UTF8;KEYWORD_FILTER=NUMBER,INTERVAL"ENV_RDB_URI_MDLOG: "IP=127.0.0.1;DB=MDLOG;User=SYSDBA;PWD=SYSDBA;Port=5138;AUTO_COMMIT=on;CHAR_SET=UTF8;KEYWORD_FILTER=NUMBER,INTERVAL"ENV_RDB_URI_MDSTRUCTURE: "IP=127.0.0.1;DB=MDSTRUCTURE;User=SYSDBA;PWD=SYSDBA;Port=5138;AUTO_COMMIT=on;CHAR_SET=UTF8;KEYWORD_FILTER=NUMBER,INTERVAL"ENV_RDB_URI_MDCALENDAR: "IP=127.0.0.1;DB=MDCALENDAR;User=SYSDBA;PWD=SYSDBA;Port=5138;AUTO_COMMIT=on;CHAR_SET=UTF8;KEYWORD_FILTER=NUMBER,INTERVAL"ENV_RDB_URI_MDAPPLICATION: "IP=127.0.0.1;DB=MDAPPLICATION;User=SYSDBA;PWD=SYSDBA;Port=5138;AUTO_COMMIT=on;CHAR_SET=UTF8;KEYWORD_FILTER=NUMBER,INTERVAL"ENV_STANDALONE_DISABLE_SERVICES: "mysql" -
Complete the remaining system initialization steps.