Difference between revisions of "MySQLInstallGuide"

Revision as of 21:37, 21 November 2014

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):

1. INNODB specific discussion: http://www.mysqlperformanceblog.com/files/presentations/UC2007-Innodb-Performance-Optimization.pdf
2. Clear and concise; the "bible" for optimization: http://www.mysqlperformanceblog.com/files/presentations/UC2007-MySQL-Server-Settings-Tuning.pdf
3. Also, for basic optimization directly after MySQL installation, see: http://www.mysqlperformanceblog.com/2006/09/29/what-to-tune-in-mysql-server-afterinstallation/

MySQL Installation Via the Installer Script (as of Retain 3.4 only works with MySQL 5.5)

Retain comes with automated MySQL installation and database creation scripts, mysqlinstall.sh andmysqlsetup.sh. To use the installation scripts, both the MySQL server and client packages must be downloaded to a known location. The scripts are run during Retain Install if the MySQL database server is selected and the MySQL server will be housed on the same server as Retain. If the install initiates the scrips, they will be run back to back and do not need to be initiated manually.

If the MySQL database is to be housed on the same physical or virtual machine as Retain, it is recommended to run the install and configuration through the install script, but it is not required or necessary. The Database question will not change database choices in the Retain Server Configuration and setup detailed in the administration manual.