Install Tricks

Installing MySQL is a simple process. It is very common on a modern Windows machine to install in under three minutes. The Windows Installer Team have really increased the speed in the last few releases. But what if you are running Linux?

For the very fussy who want everything tailored ‘just so’, download the source code and configure exactly what you want. Don’t need Serbian character sets, different collations, or some storage engines you never use? Then read up on Installing MySQL from Source. With a bit of time and fuss, you can have a minimalist server that contains only the components you need. This is not recommended unless you know you can lock down the system and never, ever need to ad more components on the fly.

Next comes the MySQL Binaries. Untar/Zip the file from Dev.MySQl.Com, point your config files to the correct places, and run mysqld_safe. Read Installing MySQL from Generic Binaries on Unix/Linux for the details. This is my personal favorite as I can have several versions installed and change versions by starting the server for that version. The /usr/local of my test server has a version of 5.1, two versions of 5.5, and four versions of 5.6 available. Be sure to make your startup scripts point to /usr/local/mysql and that directory is linked to the version you want to use.

Finally comes the packages. Both let you leave much of the worry of software inconsistencies into package management software. This makes upgrades easier. However some distro are s-l-o-w about getting the latest and greatest MySQL packaged for their flavor. So please take a look at the packages from Dev.MyQL.Com rather than wait. Peruse Installing MySQL on Linux before you begin.

Next time we will cover initial configuration and start up.


2 Responses to Install Tricks

  1. […] MySQL is a simple process. It is very common on a modern Windows machine to install in under three […]

  2. […] is on a step that many DBAs either skip, ignore, or do not know about. My last entry was on some install tricks and this time I want to cover where to put the various pieces of a MySQL server if you are looking […]

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

%d bloggers like this: