Over the past couple of weeks, I have converted a couple of boxes from mysql to mariadb, citing concerns with oracle's irresponsible handling of mysql. (There was another no-authentication exploit fixed in the massive patch cluster last week.)
I have come up with a method of upgrading from mysql 5.5 to mariadb 5.5, but it's kinda clunky and ugly, and I was wondering if anyone had a better way. This is the procedure I have developed over the two or three times I have done (or tried) it.
1. Set up /etc/apt/sources.list.d/mariadb.list:
# MariaDB 5.5 repository list - created 2013-04-08 22:43 UTC
Note that this is from the mariadb site, as are the debs.
2. Set up /etc/apt/preferences.d/mariadb:
Pin: origin ftp.osuosl.org
I'm sure the pinning is probably not optimal, but it worked in this case...
3. You then have to download the following debs
These debs have to be installed using dpkg, because for whatever reason, the libmysqlclient18 deb from mariadb will not install via apt-get install, and I generally try not to force anything. So I download and dpkg -i them, then I am able to apt-get install the rest, in this particular case,