Difference between revisions of "MySQL Install Guide Without Using Install Script"

Latest revision as of 18:34, 19 December 2014

This section is dedicated to those that refuse to use the install script. I assume you're just stubborn. What's that? You want to learn something? I suppose you can read on too.

[edit] Downloading MySQL

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

Are you a simpleton and/or maybe lazy? Well, I suppose I can enable you: General download page: http://dev.mysql.com/downloads/mysql/

[edit] Installing MySQL

[edit] Linux

As of this writing all testing has been done on SLES 10/11, early testing on SLES 12 indicates that it should work (DanielC: I have gotten it to install and run and set up a database but have not run Retain against is yet. 2014/12/19) but can't find any documentation that it's supported properly. There are no install files for SLES 12 as of December 2014. MariaDB, a MySQL variant, has replaced MySQL as the included database management system. This is not supported with Retain (Dec 2014)

[edit] Installing the RPM packages.

This part of the guide assumes that you read the level 1 guide which has some information on where and how to download the MySQL installer package.

Simple command to do so:

• server: # rpm -ivh MySQL-server-5.5.41-1.sles11.x86_64.rpm

You'll need to install both the server and the client rpm packages.

[edit] Modifying the installation

This would be the best time to put in your own settings for MySQL and the my.cnf file in /etc/

Copy it from /usr/share/doc/packages/MySQL-server/

The installer bundled with Retain uses the my-large.cnf file and modifies the path locations. Use whatever file you feel best fits the server environment.

If you want to do a data directory other than the default /var/lib/mysql/ Add the line:

datadir=/path/to/where/you/want/the/MySQL/data

Couple of notes about adding this path:

• Do not put a trailing / on it, you don't need it. I.E. what not to do: datadir=/path/destination/
• The installer places this under the line "[mysqld]" for continuity sake please keep it there if you're modifying this line.

Here's an example File:My.cnf.doc This example file is a 5.5 .cnf file and is adapted for use on a 4-6 GB of RAM server also running Retain. probably safer with 5-6 GB of RAM.

Now would also be the time to add the line (if it's not already there)

• innodb_file_per_table

Now would also be an opportune time to tune the memory on the server:

[edit] Helpful links

There is a LOT of information on the MySQL sites. These should help you find what you want to know. The links are for 5.5 but there is a link on the left side of the page that will send you over to the corresponding article that you're in for 5.6 if you just click on "MySQL 5.6 Manual":

• MySQL main document page.
• my.cnf option file and information on the switches used in the file.
• innodb configuration.