MySQLInstallGuide

This guide is provided purely as a courtesy and will detail a very basic installation and database creation for Retain. This guide is provided with no warranty and no MySQL support offered. To use MySQL with Retain, you will need to do the following: 1) Download MySQL 2) Install it to the server of your choice 3) Log in and create a database for Retain to use 4) Create a user with rights for Retain 5) Retain will do all the rest

Getting MySQL

Although SLES 10, and 11 come with MySQL 5.x as an optional package to be installed by YAST, the version supplied by Novell is out of date and prone to data corruption. It is STRONGLY recommended you download and install the latest RPMs from MySQL. For MySQL to be useful, three packages need to be installed: the Server, Client, and shared client libraries.  Go to http://www.mysql.com  Get MySQL 5.5 Get the binaries appropriate for your system. Again, the Server package alone will not create a full working system; the Client and shared Client Libraries are required. NOTE: 5.5 and 5.6 are the currently tested and supported versions of MySQL, other versions may work, but are not supported by Retain.

MySQL Optimization

MySQL requires careful memory tuning. By default it assumes it is running on a 64 MB Server. The administrator should give at least 1 GB RAM to MySQL. Larger sites may well allocate 2, 4, 16, or even 64 GBs of RAM depending on their data store. We do not support or discuss memory tuning requirements. However the following links may help (Retain uses InnoDB tables):

 http://www.mysqlperformanceblog.com/files/presentations/UC2007-Innodb-Performance-Optimization.pdf covers InnoDB specifically. Clear and concise; the "bible" for optimization: http://www.mysqlperformanceblog.com/files/presentations/UC2007-MySQL-Server-Settings-Tuning.pdf

 Also, for basic optimization directly after MySQL installation, see: http://www.mysqlperformanceblog.com/2006/09/29/what-to-tune-in-mysql-server-afterinstallation/