MariaDB Statistics and Surveys

I just finished reading a couple of interesting, and somewhat related, blog posts which I think are worth sharing (apologies to anyone who has already seen them). One is from Jelastic and the other is from Michal Hrušecký.

I’ve written about MariaDB and the Jelastic cloud before (see MariaDB now available as a hosted database via Jelastic cloud platform). Now Jelastic has published statistics on the relative popularity of the various databases they offer. The good news is MariaDB is currently the database of choice for 14% of their customers. The bad news is that we’re in fourth place behind their other three database choices (MySQL, PostgreSQL, and MongoDB). …

The 2 year old MariaDB

One could say that MariaDB now is 2 years old as a packaged product. The latest version, MariaDB 5.3 Beta, is the culmination of many years of hard work. We believe it contains the largest and most significant change to the code of MySQL since the launch of MySQL 5.0. I’m talking about the changes made to the central product component called the Optimizer.

Why did we touch something so central to the product? The fast answer is that the original Optimizer is about 17 years old. Prior to the work we did for MariaDB 5.3, the Optimizer hadn’t had any huge evolutionary improvements or changes in a decade (except for some features that were added in 2003-2005). …

MariaDB Crash Course

Ben Forta, the author of MySQL Crash Course and Sams Teach Yourself SQL in 10 Minutes, has written what I believe is the first MariaDB-specific book: MariaDB Crash Course. I just received word from Ben that the book is now shipping.

Most MySQL books can, of course, be used to learn almost everything you need to know about using MariaDB. But with all of the features and abilities MariaDB has gained in the MariaDB 5.2 and MariaDB 5.3 releases, it’s nice there is now a book specific to MariaDB. …

Early tests show MariaDB 5.3.0 having a performance speed-up against DBT-3 query set

Posted recently on the maria-developers mailing list, by Igor Babaev, Principal MariaDB developer at Monty Program is some interesting preliminary results for MariaDB 5.3.0 benchmarked against the DBT-3 benchmarking program.

DBT-3 is a benchmark to test a decision support workload, with a suite of business-oriented queries and concurrent data modifications.

Read Igor’s discoveries, which he ran on a laptop with 4 cores (multi-threaded = 8 cores in total), 8GB RAM and SSD on SuSE, and as Igor says, enjoy his numbers. It is a repeatable benchmark with all settings included.

Quick distribution update: openSUSE, Gentoo

If you’re on openSUSE, you definitely want to upgrade to the latest MariaDB release made on 19/07/2011. Previous security fix disabled XtraDB! This is MariaDB 5.1.55.

If you’re using Gentoo, please test MariaDB 5.2 ebuilds in the MySQL overlay. Its current with MariaDB 5.2.7 as well as MariaDB 5.1.55.

Mac OS X users can install MariaDB via Homebrew

The gist of it is, if you’ve installed Mac OS X and you use Homebrew, you’ll be pleased to note that you’re just a brew install away for getting a working MariaDB. Yes, that’s right, simply do: brew install mariadb and that’s it — you’ll have MariaDB (currently 5.2.6) installed in no time. For further documentation and a step-by-step guide, visit the Knowledgebase article: Building MariaDB on Mac OS X using Homebrew.

Setting up MariaDB repositories for Debian/Ubuntu

If you run Debian or Ubuntu, and want a way to auto-generate a sources.list entry, then you should definitely look at: Setting up Repositories for Ubuntu/Debian. Its very simple: choose a distribution, then a release, then choose what version of MariaDB you would like to track and a mirror of your choice, and voila! it generates the sources.list for you.

Tickets to giveaway for Percona Live NYC

We all know that Kurt von Finck is going to give a talk at Percona Live NYC happening May 26 2011. If you want to attend we’ve got three tickets to give away (worth USD$249 each).

This should be the easiest contest ever to enter and win. Just go to the Knowledgebase, create an account and write one new article, longer than 2 paragraphs. Once you’re done, send a quick email to community@montyprogram.com with a link to the article, and if there is no duplicate content already on the Knowledgebase, you’ll get your ticket to Percona Live NYC.