MySQL
The MySQL connection uses the MySQL Connector/J JDBC driver to read from and write to MySQL databases.
Installing the MySQL JDBC Driver
Due to licensing restrictions, the MySQL Connector/J driver cannot be redistributed with the Intelligence Hub. To install the driver, do the following.
- Download MySQL Connector/J.
- Select the Platform Independent operating system and download the ZIP or TAR archive.
- This release has been tested with version 9.4.0 of the driver.
- Extract the archive and copy
mysql-connector-j-<version>.jarinto theruntime/libdirectory of the Intelligence Hub installation. - Restart the runtime. The driver is only loaded at startup.
If the connection is used before the driver is installed, the connection fails with an error similar to Failed to connect to SQL database... Cause: No suitable driver found for jdbc:mysql://....
Docker
When running the Intelligence Hub in Docker, bind mount the driver jar into the container’s runtime/lib directory by adding a --mount flag to the docker run command. The driver remains available when the container is recreated, such as when updating to a new image. The example below also mounts the hb_vol volume to persist application data, as described in the Docker setup. Remove that --mount flag if you are not using a volume.
docker run -p 45245:45245 -p 1885:1885 -p 8885:8885 -e ACCEPT_EULA=Y --name highbyte \
--mount source=hb_vol,target=/usr/local/highbyte/appData \
--mount type=bind,source=/path/to/mysql-connector-j-<version>.jar,target=/usr/local/highbyte/runtime/lib/mysql-connector-j-<version>.jar,readonly \
highbyte:X.X.X
runtime/lib hides the libraries included with the Intelligence Hub and prevents the runtime from starting.Alternatively, copy the driver into a running container and restart it. Files copied into a container are lost when the container is recreated, so these steps must be repeated after updating to a new image.
docker cp mysql-connector-j-<version>.jar highbyte:/usr/local/highbyte/runtime/lib/
docker restart highbyte
Connection Settings
Database
Name of the database to connect to.
Username
Username for authentication with the database.
Password
Password for authentication with the database.
Additional JDBC Options
Additional JDBC options to include in the JDBC connection string. This is MySQL specific. Options are entered exactly as they would be if the JDBC connection string was created manually.
Keep Alive
See JDBC Driver Settings for keep alive settings.
Input/Output Settings
See JDBC Driver Settings for input and output settings.