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 InnoDB as storage engine. If database will be created by the
Axon Ivy Engine the charset is set to utf8
and collation is set to
utf8_unicode_ci
.
Warning
The newer charset utf8mb4
is not supported.
The creation of the system database tables will fail if you use utf8mb4
charset.
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.