Configuring a MySQL Community Server Version 5.7 Database
You can use MySQL Community Server version 5.7 as the database for JDBC connection pools.
To configure MySQL Community Server version 5.7
1. Install MySQL Community Server version 5.7.
2. Configure the database driver for MySQL Community Server version 5.7 as described in webMethods Integration Server Administrator’s Guide.
3. If your ActiveTransfer Server and MySQL databases are in different time zones, set the following parameters when you configure the MySQL JDBC pools for ActiveTransfer:
useLegacyDatetimeCode=falseserverTimezone=MySQL Server Time Zone For example, if your ActiveTransfer time zone is Eastern Standard Time (EST) and your MySQL Server time zone is Central Standard Time(CST), the JDBC Pool URL should be:
jdbc:mysql://<myhost>:3306/<my database>?useLegacyDatetimeCode=false&serverTimezone=IST
For a list of supported time zones, see the MySQL JDBC connector documentation.