MySQL Server

This chapter describes how to setup the MySQL software for LN. Before you can install the LN software, you must complete several tasks, as described in the following sections.

Overview of the installation process

MySQL installations are version and system-dependant. Refer to the MySQL documentation for the installation procedure for the MySQL version you want to install. More information can be found at: http://www.mysql.com

Requirements

Install the latest version of the MySQL software. The minimal recommended version for installation is 5.0.19.

Reserve a dedicated disk for temporary storage of MySQL, by setting the MySQL variable tmpdir.

Set the lock wait timeout (MySQL variable innodb_lock_wait_timeout) to a low value such as 5.

For more-detailed information, refer to the Enterprise Server Technical Notes (U8891 US) or contact Infor for additional sizing information.

Character set for the MySQL database

For MySQLyou do not need to choose a default character set for the database. However, during the installation of LN on MySQL the user is prompted to choose a character set used for the creation of all database objects by the MySQL database driver. Here you must select a character set.