'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 […]

  • 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 […]

  • 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 […]

  • 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 […]

  • 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: […]

  • 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 […]

  • 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 […]

  • 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 […]

Powered by Wordpress and MySQL. Theme by openark.org