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 MediationZone.

You must proceed as follows:

1. Go to the MySQL web page and download Connector/J from MySQL Connectors:
   https://dev.mysql.com/downloads/connector/j/
   
   

2. Place the downloaded jar file in the $MZ_HOME/3pp directory.

3. 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

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: