Database
The following databases are officially supported and tested with Flowable Engage:
Database | Versions |
---|---|
Oracle |
11g, 12c |
PostgreSQL |
10 |
MySQL |
5.7 |
MSSQL |
2017 |
DB2 |
10.x |
Flowable Engage uses a standard JDBC connection and database interfaces so other database implementations may also work but they are not officially supported or tested by Flowable.
The database schema is created by the Flowable Engage on its initial startup via Liquibase. If Liquibase finds an empty database schema it initializes the database by creating all the needed tables, sequences, etc. For this process to work, the application needs schema editing permissions on the database.
The following table shows the recommended virtual memory (VM) specifications per node type of the database servers when files are persisted on a separated file store:
CPU | RAM | Disk (no BLOBs) | |
---|---|---|---|
Minimum |
4 |
16 GB |
100 GB |
Recommended |
8 |
32 GB |
100 GB |
It is also possible to store documents and attachments directly in the database. This approach is NOT RECOMMENDED as it heavily affects performance and maintainability of the overall system.
If files are persisted as BLOBs in the database, the following specifications are applicable:
CPU | RAM | Disk (with BLOBs) | |
---|---|---|---|
Minimum |
8 |
64GB |
1TB |
Recommended |
16 |
128GB |
1TB |