MySQL

 1# yaml-language-server: $schema=https://json-schema.axonivy.com/ivy/12.0.11/ivy.json
 2# MySql as System Database
 3# [engineDir]/configuration/ivy.yaml
 4SystemDb:
 5  # Format: jdbc:mysql://<host>[:<port>]/<database name>
 6  Url: jdbc:mysql://localhost:3306/AxonIvySystemDatabase
 7  UserName: root
 8  Password: 1234
 9  DriverProperties:
10    # Very likely to set if not ssl connection is used, to prevent warn logs
11    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.