Update: MariaDB 5.1.62 and 5.2.12 have been released. They contain an important security fix.

We are pleased to announce the immediate availability of MariaDB 5.1.61 and MariaDB 5.2.11. Both of these stable (GA) releases incorporate MySQL 5.1.61 and several bug fixes.

Please see the What is MariaDB 5.1 page for an overview of MariaDB 5.1, and the What is MariaDB 5.2 page for an overview of MariaDB 5.2.

Sources, binaries, …

When I was at MySQL, I took for granted that pretty much every website I used had software at the back of it that was basically MySQL. It was a nice feeling. MariaDB is a lot younger, so when I was in Paris and had to make a payment for the taxi I was sitting in, I smiled a little when I saw that Paybox Services was processing my transaction. Some might recall that Paybox Services deployed MariaDB, since the 5.2 release. It was a wonderful feeling that somewhere in that transaction, MariaDB was behind it!

Paybox wanted some features inside of MySQL 5.5 and have been holding out for MariaDB 5.5. Its kind of nice to see that today, …

We are pleased to announce the immediate availability of MariaDB 5.5.22-rc. MariaDB 5.5.22 is the first release candidate (RC) release in the 5.5 series and follows the MariaDB 5.5.20-alpha and 5.5.21-beta releases. We hope to follow it up soon with a Stable (GA) 5.5 release.

MariaDB 5.5 is a merge of MariaDB 5.3 and MySQL 5.5 with some limited additional bug fixes. Please see the What is MariaDB 5.5 page for an overview of MariaDB 5.5.

The Release Notes page has some notes on the release. There is also a Changelog available for those who are interested.

…

MySQL version 4.1 was quite revolutionary. The main reason for that was support for sub-queries.1

However since then MySQL users were rather discouraged to use that functionality, basically due to the implementation’s poor performance  and forced to build complicated queries based on joins rather than on subqueries.

Of course you can do some effort to optimize your subquery with sometimes very good results2. Not always it’s easy or even possible if you can’t change the code though.

You’d say it’s not a problem for typical OLTP, web based traffic at all, just don’t use subqueries! That’s true, …

Complex multi-master solutions made easy with Tungsten by Robert Hodges & Giuseppe MaxiaFriday, April 13 at 1:00 pmTungsten has broken new ground how to make previously complex or completely unattainable solutions very simple and easy to deploy. Tungsten Replicator offers improvements in replication topologies and performance, using technologies that were either unknown or not used together

Right after Percona Live Santa Clara (which MariaDB is quite present for), its worth noting there are a few more events happening on Friday, April 13, 2012 at the Hyatt Regency Santa Clara. MariaDB will be present at 2/3 of those events.

• SkySQL & MariaDB Solutions Day – go ahead and register
• Sphinx Search Day – if you dig full-text search, you should be present so go ahead and register

The one event MariaDB won’t be present at is the Drizzle Day. That …

I for one can say that I’m truly excited that MariaDB will be part of Percona Live Santa Clara. The MariaDB session list includes:

• A tutorial: Improving MySQL/MariaDB query performance through optimizer tuning by Timour Katchaounov and Sergey Petrunia. You can benefit from this even as a stock MySQL user naturally.
• MySQL Plugins – why should I bother? by Sergei Golubchik is again something that isn’t only MariaDB specific since MySQL also has a plugin architecture. I don’t know if Sergei will talk about authentication plugins as …

I have written a second blog post in the series of blog posts leading up to the talk comparing the optimizer enhancements in MySQL 5.6 and MariaDB 5.5. This blog post is aimed at the optimizer enhancement Multi Range Read (MRR). Its available in both MySQL 5.6 and MariaDB 5.5

The post Multi Range Read (MRR) in MySQL 5.6 and MariaDB 5.5 appeared first on ovais.tariq.

This is the second blog post in the series of blog posts leading up to the talk comparing the optimizer enhancements in MySQL 5.6 and MariaDB 5.5. This blog post is aimed at the optimizer enhancement Multi Range Read (MRR). Its available in both MySQL 5.6 and MariaDB 5.5

Now let’s take a look at what this optimization actually is and what benefits it brings.

Multi Range Read

With traditional secondary index lookups, if the columns that are being fetched do not belong to the secondary index definition (and hence covering index optimization is not used), then primary key lookups have to be performed for each secondary key entry fetched. This means that secondary key lookups for column values that do not belong to the secondary index definition can result in a lot of Random I/O. The …

A screencast demonstrating the MariaDB Windows installer.

(I recommend watching it in full screen 720p, so you can see the details.)

Some links:

• The MariaDB homepage
• The AskMonty Knowledgebase
• The MariaDB Downloads page
• Installing MariaDB on Windows documentation
• The HeidiSQL homepage

Acknowledgments:

A big thanks to Vladislav Vaintroub, MariaDB’s Windows guru, and to Rasmus Johansson for help with the screencast.