Overview
Application Scenario
The built-in database for the BI is the HSQLDB database.
HSQLDB database does not support multi-threaded access. In a cluster environment with large amounts of data, the database may become unstable. HSQLDB database is suitable for the local trial of product functionality.
The external database is suitable for the formal use of the platform.
Migration is based on existing old data, and unpredictable problems are held in the migration process of old data. Therefore, you can choose to migrate the old data or directly enable a new database.
Function Description
If an external database is configured for the BI system, the BI system can remain stable in cluster environments or situations with large amounts of data.
You can configure external databases during initialization or on the platform. The two configuration methods require the same configuration via the same procedures.
Configuration Method
The following table describes the supported types and versions of the external databases.
Note: MySQL and Oracle databases are recommended as the external databases.
| Database Type | Supported Database Version | Configuration Method |
|---|---|---|
RDS MySQL | All versions | |
MySQL | 5.1.73/5.5.31/5.5.46/5.5.56/5.6.22/5.6.31 5.6.22/5.6.28/5.6.31/5.6.35/5.6.37/5.6.44 5.7.16/5.7.23/5.7.26/5.7.33 | |
8.0.11/8.0.16/8.0.20/8.0.21/8.2 | ||
Oracle standalone | 10g (10.2)/10.2.0.1.0 11g (11.0.2.1)/11g (11.0.2.4)/11.0.2.4/11.2.0.2.0 12c/12c V12.2/19c | |
Oracle cluster | 11g/12c | |
SQL Server | 2000/2005/2008/2012/2014/2016/2017/2019 | |
Db2 | 8.2/9.7/10.5/11.1 | |
PostgreSQL | 9.2.3/9.4.7/9.5.0/9.5.2/9.6.0/13.0 |
Previous：User Center Plugin Installation Instruction
