This section contains information that is specific to the database type MySQL.

Supported Functions

The MySQL database can be used with:

Database Bulk Lookup Functions (APL)
Database Table Related Functions (APL)
Event Notifications
Prepared Statements (APL)
SQL Collection/Forwarding Agents
SQL Loader Agent
Task Workflows Agents (SQL)

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 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!

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:

mysqld Configuration File

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:

$ mzsh topo set topo://container:<container>/pico:<pico name>/val:config.properties.mysql.connectionpool.maxlimit 45