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). However, MariaDB has only been available on their platform for a little over two months and we’re very happy that so many users of Jelastic’s state-of-the-art Java cloud are choosing to use MariaDB. Thanks!

In the second blog post, Michal Hrušecký shares the results of what he terms his “little MySQL survey”. This time MariaDB comes in second behind MySQL Community Server (and ahead of MySQL Cluster and Percona Server). In case you didn’t know, Michal packages MySQL and MariaDB for openSUSE, so this survey was a good way for him to judge the relative popularity of some of the more popular variants and give him ideas on how to improve things.

BTW: If you know of other interesting/informative/etc… blog posts related to MariaDB, let us know so we can add them to the Blog Posts Relevant to MariaDB page of the AskMonty Knowledgebase!

The Caryatids - Some rights reserved by archer10 (Dennis) CC BY-SA
The Caryatids on the south porch of the Erechtheion (420 BC), Athens, Greece

I suppose I should probably say “MariaDB στην Ελλάδα” which, according to Google Translate, is Greek for “MariaDB in Greece”. We’re still finalizing the arrangements, but I’m pleased to announce that the next Monty Program-sponsored MariaDB Developer Meeting will be held in (or near) Athens, Greece. Update: See below for hotel/location information.

Monty Program tries to hold two MariaDB Developer Conferences / Monty Program company meetings each year. The most recent one was held in Portugal this past March and it’s past time for another one. Monty Program is a virtual company with employees scattered all around the world, and these meetings give us a chance to both get together with each other and to meet with other MariaDB developers and users.

The conference dates are Friday, Saturday, and Sunday, 11-13 November 2011. Most of us will be arriving on the 10th and leaving on the 15th. We will have an excursion day on Monday the 14th.

If you live in Greece, or would simply like to join us, please do! Nearly all of our conference sessions are open to the public, no registration required (but we would appreciate a heads up, just so we can make sure we have enough seats and power outlets). At past meetings we’ve had people from around the world join us, and we would like to continue that tradition.

As at past meetings, there will be three tracks: one focused on MariaDB development, a community track, and a documentation/infrastructure track. So there should be something of interest for anyone who would like to become involved in making MariaDB (and MySQL) better.

We’re working on the schedule right now. If there’s something you feel we should discuss, or if you are planning on attending let us know!

Update, 8 Nov 2011: I’ve posted the agendas for each day of the conference to the MariaDB Developer Meeting – Athens page of the AskMonty Knowledgebase. Notes from the various sessions will be posted to this category during the conference.

Thanks.

Hotel Information

We’re going to be at the Best Western Hotel Fenix in Glyfada. They’re located 24Km from the Athens International Airport and are a 20 minute drive from the center of Athens (at least, according to their website).

Hotel contact info:

Best Western Hotel Fenix
1-3 Artemisiou str., Glyfada, Athens, Greece 166-75
Phone: +30 210 8914000
Fax: +30 210 8914099

You can reserve your room at Booking.com (or on the hotel website).

See you there!

One thing which we, as developers of MariaDB, run into is that our personal database needs are not the same as many of our users. In fact, our needs are quite light compared to many. We have a MariaDB website, a company website, a knowledgebase, this blog, and that’s about it. None of them are particularly high traffic compared to what our customers have. But apart from talking to our customers, which are just a small percentage of the total MariaDB population, we wanted to have a way of finding out how MariaDB is used “in the real world”, so to speak.

Asking lots and lots of people to fill out surveys isn’t any fun, and we would have to keep repeating the survey ad nauseum to get useful information over time on trends and such. So many years ago (around 2003 or 2004), we came up with an idea of implementing a “phone home” feature in MySQL. It had an unfortunate fate — everyone agreed that we needed it, but, apparently, there was never a good time for implementing it. And we — in MySQL — kept on developing the features that we supposed you might want, without the statistics that would help us know what you actually needed.

But we can stop guessing now. Let me announce the User Feedback plugin, it’s included in the just-released MariaDB 5.3.2-beta. This plugin is disabled by default, but we hope many of you will enable it. The statistics gathered will help us determine where to focus our development efforts and we think they will prove beneficial, or at least interesting, to everyone else. (What? You thought we were going to keep all of the information to ourselves?)

More information on the plugin can be found at http://kb.askmonty.org/en/user-feedback-plugin and some nice charts will eventually be available for your viewing pleasure at: http://mariadb.org/feedback_plugin/. I say eventually because if you go there now, there’s not much to look at, what with the plugin being just released and all.

The statistics gathered include things like buffer sizes, CPU architecture, OS, kernel version, what plugins are enabled, how much memory is installed, and so on. The statistics are all anonymous and contain no sensitive or private information. The information is collected into the information_schema.feedback table (and if you have the plugin enabled you can see what has been collected with a simple SELECT * FROM information_schema.feedback query). Once enabled, the Feedback plugin will automatically send a report a few minutes after startup and then once a week. Submitting is done via an HTTP POST (just like a web form).

Even if you choose not to submit anonymous statistics to mariadb.org, you may still find the plugin useful, especially if you run many instances of MariaDB. You see, the URL the plugin POSTs to is configurable. The default is to post to mariadb.org, but you can easily change it to POST to your own server, or to your own server and mariadb.org (you can configure multiple URLs).

For paranoid folks out there (and a good DBA should be a little bit paranoid) we have provided many different ways to ensure that the plugin only sends what we say it does — anonymous usage statistics. You can configure multiple report URLs, can see the HTTP traffic with a network sniffer, and can even submit the data manually using a web browser if you so choose.

Full details on configuring the plugin, and how to enable it, are available at http://kb.askmonty.org/en/user-feedback-plugin.

So, if you’ve ever wanted to help out with MariaDB, but just couldn’t think of anything, here’s something that everyone who runs MariaDB can do without breaking a sweat. Help us help you by enabling the User Feedback plugin!

Thanks.