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.

About these ads

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

  1. 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)

    • @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. :)

  2. 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.

  3. 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 packages.ubuntu.com, 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

  4. 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.

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

  6. Try the following to install MySQL 5.1 on Ubuntu 8.04 (hardy):
    http://article.gmane.org/gmane.comp.finance.mifos.devel/7709

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

    MySQL 5.1.36 for Debian 5.0:

    deb http://people.debian.org/~nobse/mysql-dfsg-5.1/ lenny-backports main

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

Leave a Reply

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

WordPress.com Logo

You are commenting using your WordPress.com 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 )

Google+ photo

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

Connecting to %s

Follow

Get every new post delivered to your Inbox.

%d bloggers like this: