Difference between revisions of "MySQLInstallGuide"

Latest revision as of 19:16, 30 December 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

[edit] Getting MySQL

Although SLES 10, and 11 come with MySQL 5.0 as an optional package to be installed by YAST, these versions supplied by Novell are out of date and prone to data corruption. SLES 11 Service Pack 3 introduced MySQL 5.5 as part of the installation and could possibly be used. SLES 12 introduced including MariaDB for installation. As of 3.4 MariaDB has not been tested and is not supported even though it is technically a MySQL variant. It is STRONGLY recommended you download and install the latest RPMs from MySQL. For MySQL to be useful, two packages need to be installed: the Server, and the Client. You can also download the Libraries if your installation of SLES or Windows doesn't have the proper libraries for installation (In my experience SLES 11 and Win 2008 R2+ will not need the Libraries)

• Go to http://www.mysql.com
• Get MySQL 5.5 or 5.6

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 with Retain 3.x. Other versions may work, but are not supported by GWAVA Technical support.

Legacy note: MySQL 5.0 was supported with Retain 1.x and 2.x. So older systems not yet updated to Retain 3.x may still have this version behind it.

[edit] 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/

[edit] 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 install script will assume that the MySQL install rpm packages have been placed in the same folder as the retain installer, so if you're lazy just drop them there and use the enter key liberally. 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.

*Note: It still works with installing 5.1, however 5.1 is no longer supported with Retain 3.x (In fact you'll often have SQL errors with 5.0/5.1 if you try it. Don't do it)