MySQL

Overview

MySQL is a production capable database server that can be installed locally, or on a network server. It is also available as a fully managed cloud service via Amazon Aurora, Azure Database, and Google Cloud SQL.

Integration Manager is compatible with MySQL version 5.6.51 or later.

Step 1: Install MySQL

• You can find the latest MySQL for Windows download here: https://dev.mysql.com/downloads/installer/
• You can find the latest MySQL for Windows installation instructions here: https://dev.mysql.com/doc/refman/8.0/en/windows-installation.html

Step 2: Verify MySQL Database Service

1. Go to Windows → Services
2. Confirm MySQL Database service is registered and running
3. Open Programs → MySQL → MySQL Workbench to confirm your connection info
4. If you run into problems: https://dev.mysql.com/doc/refman/8.0/en/windows-troubleshooting.html

Step 3: Integration Manager Configuration

• Integration Manager uses the “spring.datasource” prefix properties in the ../conf/application.properties file to create a database connection
• Note that any application.properties change requires a restart of the Integration Manager Service
• Note that Integration Manager will initialize all required database tables at the initial startup
• Example properties to connect Integration Manager to a MySQL database:

  spring.datasource.driver-class-name=com.mysql.jdbc.Driver
  spring.datasource.url=jdbc:mysql://DB_HOSTNAME:3306/datacloud_db?useSSL=false&createDatabaseIfNotExist=true
  spring.datasource.username=DB_USERNAME
  spring.datasource.password=DB_PASSWORD
  spring.datasource.initialize=false
  spring.datasource.continue-on-error=false
  spring.jpa.properties.eclipselink.cache.shared.default=false
  spring.liquibase.change-log=classpath:db.changelog-master.xml