MariaDB

 1# MariaDb as System Database
 2# [engineDir]/configuration/ivy.yaml
 3SystemDb:
 4  # Format: jdbc:mariadb://<host>[:<port>]/<database name>
 5  Url: jdbc:mariadb://localhost:3306/AxonIvySystemDatabase
 6  UserName: root
 7  Password: 1234
 8  DriverProperties:
 9    # Very likely to set if not ssl connection is used, to prevent warn logs
10    useSSL: false

We only support the storage engine InnoDB. If database is created by the Axon Ivy Engine, the character set utf8mb4 is used and the collation is set to utf8mb4_unicode_520_ci.

Tip

If you experience bad query performance in Portal, then try to increase the setting innodb-buffer-pool-size in the my.cnf configuration file of the database.