Using My webMethods Server with a MySQL Database
To use My webMethods Server with MySQL, you must configure the mode of the MySQL database before starting My webMethods Server for the first time. The MySQL modes that My webMethods Server requires are ANSI_QUOTES and PIPES_AS_CONCAT.
When using My webMethods Server with a MySQL database, deploying .war files might fail. If such an issue occurs, increase the values of the following parameters in the MySQL configuration file, and restart the MySQL database server.
innodb_buffer_pool_size = 5G
innodb_log_file_size = 80M
max_allowed_packet = 24M
For more information about configuring MySQL, refer to the MySQL documentation.