This section contains information that is specific to the database type MySQL and its open-source variant MariaDB. If using with MariaDB, you can just select MySQL from the Database profile and it will be compatible.
Supported Functions
The MySQL and MariaDB database can be used with:
...
Warning | ||
---|---|---|
| ||
SQL Loader Agent does not support MariaDB. |
Properties
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 or MariaDB database from.
...
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 EC/ECSAs for the change to take effect.
...
Code Block | ||||
---|---|---|---|---|
| ||||
$ mzsh topo set topo://container:<container>/pico:<pico name>/val:config.properties.mysql.connectionpool.maxlimit 45 |
Scroll ignore | ||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||||||||