MySQL

Supported versions

Axway supports MySQL Enterprise Server - Advanced Edition (Commercial) 5.6.x starting with version 5.6.14.

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

Note   MySQL usage for Datastore is allowed for demo purpose only.

Disk space requirements

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

  • Composer + AI Enabler – 250 megabytes minimum disk space
  • Designer – 200 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 has to 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

Designer - one user

User - Permissions

IPDesigner – All privileges

Repository - one user

User - Permissions

AISRepository – All privileges

Repository - two users

User - Permissions

  • AISRepository – select, update, insert, delete, execute
  • AISRepositoryAdmin – All privileges

Report Server - one user

User - Permissions

AISuiteReporting – All privileges

Report Server - two users

User - Permissions

  • axway– select, update, insert, delete, execute
  • AISuiteReporting – All privileges

Use the following commands to create the Administrator and Functional users for Report Server.

Administrator:

  • CREATE USER <ADMIN_USER>'@'%' IDENTIFIED BY '<ADMIN_USER_PASSWORD>
  • Grant all privileges to *.* TO '<ADMIN_USER>'@'%' IDENTIFIED BY '<ADMIN_USER_PASSWORD>' with GRANT option

Functional:

  • Grant SELECT, UPDATE, INSERT, DELETE, EXECUTE in <REPORT_FUNCTIONAL_DATABASE>.* to <FUNCTIONAL_USER>'@'%' IDENTIFIED BY '<FUNCTIONAL_USER_PASSWORD>

Server parameters

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

Parameter – Value

  • Default storage engine – default-storage-engine = INNODB
  • SQL mode – sqlmode = 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
  • init_connect – set session autocommit=0
  • 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

Related Links