After reading some good opinions about MariaDB I wanted to give it a try. Upgrade looks quite straight forward but I found some issues a little tricky.


Add repo and key:

cat > /etc/apt/sources.list <<SRC
deb wheezy main
deb-src wheezy main

(find more repositories hereexternal link )

Now install MariaDB:

sudo apt-get update
sudo apt-get install mariadb-server

It could be better to install mariadb-server-5.5 and mariadb-client-5.5 package instead, because of this errorexternal link .

MariaDB repo pinning

Some time after installation I have problem with newer packages from Debian repositories that upgraded my MariaDB installation back to MySQL - it’s described hereexternal link , so I used pinning to resolve that.

cat > /etc/apt/preferences.d/mariadb.pref <<PIN
Package: *
Pin: origin
Pin-Priority: 1000


Before migration to MariaDB, front page of my blog needs about 650 ms to generate. After switch, it was only about 550ms. So it’s about 15% - absolutely for free 😄