MySQL

 1# MySql as System Database
 2# [engineDir]/configuration/ivy.yaml
 3SystemDb:
 4  # Format: jdbc:mysql://<host>[:<port>]/<database name>
 5  Url: jdbc:mysql://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 storage engine InnoDB. If database will be created by the Axon Ivy Engine the charset is set to utf8mb4 and 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.