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.

Q&A with Monty by PacktPub

Monty just got interviewed by Packt Publishing in a Q&A format. There’s no way to comment on that article, so I’m wondering if you have any feedback — drop it here.

Also decided to start collecting interviews related to MariaDB on the Knowledgebase. Remember that its open for all to edit, so sign up.

Newsletters from the MariaDB dev meeting in Lisbon

Every morning before any of the meetings get started I print out a small one page newsletter which contains (among other things) the program for the day. Rather than keep them private, Colin suggested I post them here. I call the newsletter the “MariaDB Programador de Journal” which (I think) translates to “MariaDB Programmer’s Journal” in Portuguese.

[Updated, 13 Mar 2011, to add the newsletter for that day.]

At the meeting we’ve also been taking notes and posting them online for what improvements we want to make this year in MariaDB to make it even better. …

The AskMonty Knowledge Base – Open for editing

Almost a year ago we launched the AskMonty Knowledgebase, a home for information on MariaDB and MySQL. When we launched, only employees had access to write articles, though anyone could ask a question. This was done for technical reasons. The good news is that that has changed, with the latest version we just pushed live, anyone with an account (or an open ID) can create and edit articles.

There is only so much content we can write so we want your contributions, from completely new articles to editing and improving what we already have. If you have questions on how to get started, you can join the Maria Docs group on launchpad and ask on the mailing list. …