MySQL

Supported versions

Axway supports MySQL 5.6.x and MySQL 5.7 starting with version 5.6.14.

We recommend the use of MySQL Enterprise Server – Advanced Edition (Commercial) for better performances and durability.

To view the current version information, connect to the MySQL utility and use the status MySQL command.

Note   MySQL usage is allowed for demo purpose only.

Disk space requirements

Below is the minimum disk space needed to set up a MySQL database:

  • Composer – 250 megabytes minimum disk space
  • InterPlay – 200 megabytes minimum disk space
  • Designer – 200 megabytes minimum disk space
  • Datastore Client (demo environment only) – 200 megabytes minimum disk space
  • Datastore Runtime (demo environment only) – 300 megabytes minimum disk space
  • Repository – 200 megabytes minimum disk space
  • Report Server – 200 megabytes minimum disk space
Note   During the product lifecycle, the RAM and disk space requirements may evolve. Monitor the machine resources used to ensure that sufficient resources are always available for your database.

Database information

The database character set must be set to UTF-8.

User information

To install the component correctly, you must have previously created the user or users as specified below.

Grant all privileges to each component user.

Note   The client host is a part of access management and it is mandatory to define a set of permission per user and client host. It is possible to use the '%' character for all computers. Please refer to the MySQL 5.1 documentation for more information.

Composer + AI Enabler – one user

User – Permissions

Composer – All privileges

Composer + AI Enabler – two users

User – Permissions

  • Administrator/Owner – All privileges
  • Functional – select, update, insert, delete, execute

Composer + Sentinel Enabler– one user

User – Permissions

Composer – All privileges

Composer + Sentinel Enabler – two users

User – Permissions

  • Administrator/Owner – All privileges
  • Functional – select, update, insert, delete, execute

InterPlay – one user

User – Permissions

InterPlay – All privileges

InterPlay – two users

User – Permissions

  • InterPlayAdmin – All privileges
  • InterPlay – select, update, insert, delete, execute

Designer

User – Permissions

IPDesigner – All privileges

Datastore Runtime – two users (demo environment only)

User – Permissions

  • DSMAIN – All privileges. Select on MYSQL.PROC
  • DSCACHE – All privileges. Select on MYSQL.PROC system table
  • Execute as root user following statement to grant this permission: grant select on 'mysql'.'proc' to '<DSCACHE_USER>
  • DSVIEW – All privileges.

Datastore Client (demo environment only)

User – Permissions

DSClient – All privileges

Repository

User – Permissions

AISRepository – All privileges

Report Server

User – Permissions

AISuiteReporting – All privileges

Server parameters

The following list shows the mandatory parameters and their values for Axway products (using the MySQL show variables command):

  • Default storage engine – default-storage-engine = INNODB
  • SQL mode – sql-mode = "STRICT_TRANS_TABLES, NO_AUTO_CREATE_USER, NO_ENGINE_SUBSTITUTION"
  • Transaction isolation level – transaction-isolation = READ-COMMITTED
  • innodb flush behavior – innodb_flush_log_at_trx_commit = 1
  • autocommit behavior – init_connect = "set session autocommit=0"init0
  • Function creation mode – log_bin_trust_function_creators = 1
  • Recursivity – max_sp_recursion_depth = 100
  • Table name case management – lower_case_table_names = 1
  • Maximum allowed packet – max_allowed_packet = 16MB

SSL warning message

In MySQL server 5.6.26+ and 5.7.6+, SSL is enabled by default on the server side. However, AI Suite connects to MySQL without SSL.

The following warning message appears in the log:

Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.

To prevent this warning, you must add the parameter ?useSSL=false at the end of each database URL in the following files:

  • context.xml in AIS/Tools/apache-tomcat/contexts/.
  • configuration.properties in [Installation_Path]/InterPlay/extra/Tools/configuration/
  • configuration.properties in [Installation_Path]/AIS/Repository/configuration/

 

Related Links