'Installation' Tag

• How common_schema installs itself

  September 11, 2012

  Up till common_schema version 1.1, the user would need to choose from distinct distribution files: an install compatible with MySQL 5.1, one compatible with InnoDB Plugin enabled servers, and one compatible with Percona Server. The difference between the three is the availability of certain INFORMATION_SCHEMA tables. With 1.1, this is no longer the case: common_schema [...]

  posted in MySQL by shlomi

• Installing MySQL from source/binary tarball as a Linux service

  May 1, 2012

  I've written before I prefer to do a manual install of MySQL over a repository one. I still do: I typically install from binary tarball or by compiling from source. I'd like to share my setup procedure for Linux installation and service setup. I've done this dozens of times, on different Linux flavors, and it [...]

  posted in MySQL by shlomi

• Guide to MySQL installation files

  December 1, 2010

  Even for DBAs already familiar with MySQL, the choice of installation methods and the variety of install/package files is overwhelming and confusing. I'll make a (very!) brief introduction to the various installation options, concentrating on the Linux operating system, and provide with a simple shopping list. For illustration, I'll refer to the MySQL 5.1.52 community [...]

  posted in MySQL by shlomi

• To not yum or to not apt-get?

  February 16, 2010

  I've written shortly on this before. I like yum; I love apt-get; I prefer not to use them for MySQL installations. I consider a binary tarball to be the best MySQL installation format (source installations being a different case altogether). Why? I use yum and apt-get whenever I can and for almost all needs (sometimes [...]

  posted in MySQL by shlomi

• SphinxSE 0.9.9-RC2 bug workaround

  September 7, 2009

  There is a serious bug with the sphinx storage engine, introduced in 0.9.9-RC2 (and which has not been fixed in latest revisions, as yet - last checked with rev 2006). I would usually just revert to an older version (0.9.9-RC1 does not contain this bug), but for the reason that RC2 introduces an important feature: [...]

  posted in MySQL by shlomi

• Manually installing multiple MySQL instances on Linux: HOWTO

  February 19, 2009

  Installing a single MySQL instance on a linux machine is a very simple operation. It may be as simple as: apt-get install mysql-server But you cannot use this method to install another MySQL instance. Moreover, if you try to manually install another instance, you may find that some collisions occur. For example, when trying to [...]

  posted in MySQL by shlomi

• Do we need sql_mode?

  January 8, 2009

  sql_mode must be one of the most elusive issues in setting up a MySQL database. It is also responsible for difficulties in migration, upgrading and securing of databases. MySQL usually has little issues with migrating database from one machine to another, one version to another, one OS to another, one architecture to another. If we're [...]

  posted in MySQL by shlomi

• MySQL parameters & configuration sample file

  October 17, 2008

  The following is a sample my.cnf configuration file. It includes some common and uncommon parameters, along with occasional comments. You can use this file, and tune as appropriate for your machine, operating system, and application needs. In particular, note the high values set for the InnoDB related parameters, below, and change them to match your [...]

  posted in MySQL by shlomi