Install MySQL Without Using The Install Script Included in Retain
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.
Contents |
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:
Installing MySQL
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)
Installing the RPM packages.
You remember where you put your files that you downloaded right?
Simple command to install any rpm:
- 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.
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:
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":
