MySQL 5.1 in Ubuntu's universe

On November 14th 2008 MySQL 5.1 reached General Availability status. A little less than two months later MySQL 5.1 entered Ubuntu’s universe thanks to the work of Chuck Short. Based on the version available from Debian experimental repository MySQL 5.1 brings new features such as:

  • Table and Index Partitioning to improve performance and management of very large database environments
  • Row-based and Hybrid Replication for improved replication security
  • Event Scheduler to create and schedule jobs that perform various database tasks

MySQL 5.1 should be included in the upcoming Ubuntu release codenamed  Jaunty Jackalope scheduled for April 2009. However users can already test it by installing the mysql-server-5.1 package on a system running the development version of Ubuntu. Upgrades from 5.0 to 5.1 are also possible.

MySQL 5.0 has also been updated to the latest version: 5.0.75. Thus Ubuntu users have the choice of running either MySQL 5.0 from the main component or MySQL 5.1 from the universe component. The Ubuntu Server team is looking for early testers. Having access to a MySQL environment and being able to run a database load in a testing environment are the two requirements to help shaping the next version Ubuntu and its support for MySQL.

11 Responses to “MySQL 5.1 in Ubuntu's universe”

  1. Kevin Says:

    What would be the minimum system requirements to run Ubuntu + Apache + PHP + mysql on a pc?
    I’m sorry, I know it doesn’t have much to do with the subject discussed here, but i’m looking for the answer and nobody is really able to give me some good advice.

    The case is, i have this 10 year old computer, which I know of, that Ubuntu won’t be any problem at all, but if it suddenly needs to handle more then one connections, would it still be able to hold on? I’m currently working on a windows desktop, but i have some (very little) experience with ubuntu.

    current specs are:

    256MB ram (could be upgraded to 512)
    60 GB Hard drive
    Small processor (don’t know exactly)

  2. GZ Says:

    @Kevin 256MB is enough for a smaller setup. You want whats known as a “LAMP” system.

    @Doc sounds like you need to enable the universe then you’ll get it vs 5.0. About to find this out for myself. đŸ™‚

  3. Steve Says:

    re: getting mysql 5.1
    Some confusion on how to get it working on Hardy.
    I tried the binaries from mysql and am running into odd problems.

    re: getting mysql onto a box.
    the mentioned system:
    256MB ram (could be upgraded to 512)
    60 GB Hard drive
    Small processor

    Should be fine if the processor is PIII or P4 or equiv.
    To keep current I would suggest at least Hardy Ubuntu 8.04 LTS

    With an older system, I have found that the alternate install cd works better even if you have the RAM for the graphical install

    – for example the via m10000 chipset not supported by live cd – but works fine. They may have fixed this by now in the new release of the 8.04 cd.

    You really want the 512MB of RAM.
    I like to have at least 20G disk.

    256MB RAM – non graphical or some of the light weight window managers. Needs the alternate install cd.
    512MB RAM – you will be much happier.

    System Requirements

    Ubuntu is available for PC, 64-Bit PC and Intel based Mac architectures. At least 256 MB of RAM is required to run the alternate install CD (384MB of RAM is required to use the live CD based installer). Install requires at least 4 GB of disk space.

  4. The Doctor Says:

    Forgive my ignorance, but what repo is 5.1 located in?

    Running a straight “apt-get install mysql-server-5.1” fails, stating it cannot locate 5.1.

    Reviewing, I find only 5.0.51a for 8.04 & 8.04-updates, but 5.1.31 (& .30) show for 9.04.

    8.04.2 amd64

  5. Calvin Mitchell Says:

    MySQL 5.1 is broken in Karmic Koala; an attempt to install it will dump the entire desktop system (kubuntu-desktop)…even though amarok 2.1 expects 5.1.30.

  6. Dave Says:

    Anyway to get mysql 5.1 into the LTS repos for Hardy????

  7. svittal Says:

    @Dave – I know this is an old posting, but did you get mysql 5.1 for Hardy LTS?

  8. RizKhan Says:

    @svittal we have problems getting mysql 5.1 on ubuntu 8.04 (hardy), any advice would help


  9. Adam Monsen Says:

    Try the following to install MySQL 5.1 on Ubuntu 8.04 (hardy):

  10. Julio Alberto Lascano Says:

    This repository walks well with Ubuntu 8.01 server for mysql-server:

    MySQL 5.1.36 for Debian 5.0:

    deb lenny-backports main

  11. Dyon Says:

    I tried Adam’s solution, and it worked perfectly. Thanks!

Leave a Reply