REQUEST A QUOTE -OR- CALL US: 866-728-9100

Replace MySQL with MariaDB on Ubuntu 12.04 LTS

Why MariaDB?

MariaDB includes important security fixes, a high performance drop-in replacement for the InnoDB storage engine, named XtraDB, and is a completely compatible replacement for MySQL without the doubts surrounding Oracle's stewardship of the MySQL project. In addition, MariaDB is headed up by the original MySQL project founder and lead, Michael "Monty" Widenius. In short, there is no good reason not to use this exciting fork of the venerable MySQL database project.

Add the MariaDB repository

We need to add a new repository to our list of recognized package locations and ensure the digital signature is recognized.

Add a file /etc/apt/sources.list.d/MariaDB.list with the following content per http://downloads.mariadb.org/mariadb/repositories/:
# MariaDB repository list - created 2012-07-11 21:37 UTC
# http://downloads.mariadb.org/mariadb/repositories/
deb http://ftp.osuosl.org/pub/mariadb/repo/5.5/ubuntu precise main
deb-src http://ftp.osuosl.org/pub/mariadb/repo/5.5/ubuntu precise main

Make our system recognize the digital signature:
apt-key adv --recv-keys --keyserver keyserver.ubuntu.com 0xcbcb082a1bb943db

Update our package list and check status of the mysql package:
aptitude update
apt-cache policy mysql-common

The last command returns something like
root@clouddev0:/etc/apt/sources.list.d# apt-cache policy mysql-common
mysql-common:
Installed: 5.5.22-0ubuntu1
Candidate: 5.5.25-mariadb1~precise
Version table:
5.5.25-mariadb1~precise 0
500 http://ftp.osuosl.org/pub/mariadb/repo/5.5/ubuntu/ precise/main amd64 Packages
5.5.24-0ubuntu0.12.04.1 0
500 http://us.archive.ubuntu.com/ubuntu/ precise-updates/main amd64 Packages
500 http://security.ubuntu.com/ubuntu/ precise-security/main amd64 Packages
*** 5.5.22-0ubuntu1 0
500 http://us.archive.ubuntu.com/ubuntu/ precise/main amd64 Packages
100 /var/lib/dpkg/status

which shows us that the new location is recognixed and ready to be used.

Upgrade the packages

This one is very straightforward:
aptitude upgrade mysql-common libmysqlclient18

Aptitude will respond with a bunch of messages and ask you for confirmation before it attempts to overwrite what you have in place. If all goes well you will now have MariaDB installed.

Add new comment

By submitting this form, you accept the Mollom privacy policy.