This section contains information that is specific to the database type MySQL.
...
When selecting the MySQL database type, you can configure the following property using the Properties tab in the Database profile:
mysql.connectionpool.maxlimit
Preparations
The MySQL driver has to be downloaded to the Platform in order to connect to a MySQL database from .
You must proceed as follows:
Go to the MySQL web page and download Connector/J from MySQL Connectors:
https://dev.mysql.com/downloads/connector/j/Note title Note! For supported versions, see Database Types.
You may have to disable any popup blockers you have activated in order to find it.
- Place the downloaded jar file in the
$MZ_HOME/3pp directory. - Restart the Platform and ECs for the change to take effect.
In addition, you must carry out the following preparations before attempting to connect to a MySQL database. The next step is to set the necessary transaction isolation levels. Edit the mysqld configuration files by adding this line:
| Code Block | ||
|---|---|---|
| ||
transaction-isolation = READ-COMMITTED |
To decrease re-connection overhead, database connections are saved in a connection pool. To set the connection pool size, set the Execution Context property mysql.connectionpool.maxlimit in the relevant <pico>.conf file:
| Code Block | ||||
|---|---|---|---|---|
| ||||
$ mzsh topo set topo://container:<container>/pico:<pico name>/val:config.properties.mysql.connectionpool.maxlimit 45 |