MySQL Setup
The Boomi Integration Platform can be installed on the MySQL Database versions 4.1 or higher. The Boomi Integration Platform uses specific features of the latest MySQL and cannot be run on MySQL 3.23 or 4.0.
The MySQL server must be configured accordingly in order for the Boomi Integration Platform to run correctly.
- Packet Size – The max_allowed_packet variable must be set to a minimum of 16M.
If the Boomi Integration Platform is going to read files larger than 16M, then
set this variable accordingly. Please refer to the MySQL documentation on
how to properly set this variable. http://dev.mysql.com/doc/mysql/en/packet-too-large.html
- Lower Case Table Names (Non-Windows OSes only) – The lower_case_table_names
must be set to 1 prior to the Boomi Integration Platform Database is installed.
Please refer to the to MySQL documentation on how to properly set this
variable. If you are running MySQL on Windows you can ignore this setting, it
is default. http://dev.mysql.com/doc/mysql/en/name-case-sensitivity.html
- Proper user permissions – Clients will need to access the MySQL server from
different hosts other than the server. By default, users cannot access the
MySQL server from any other machine other than where MySQL is installed.
Please follow the directions in the MySQL documentation on how to create
and/or grant the proper permissions for users. http://dev.mysql.com/doc/mysql/en/adding-users.html