We’re pleased to announce the first preview version of the Cassandra Storage Engine!

The Cassandra Storage Engine (SE) allows access to Cassandra databases from MariaDB/MySQL, and to provide data integration between the SQL and NoSQL worlds.

Have you ever needed to

• grab some of Cassandra’s data from your web frontend, or SQL query?
• insert a few records into Cassandra from some part of your app?

With Cassandra SE, this is easily possible. Cassandra SE makes Cassandra’s column families appear as MariaDB/MySQL tables that you can insert to, update, and select from. You can perform joins on Cassandra data, or againist data in Cassandra and data in MariaDB.

Today we’re releasing a source tarball, as well as a binary tarball package …

Infor announced this week, that they will provide open source database alternatives to some of their products. MariaDB has been chosen, tested, and certified by Infor to be the open source database of choice (together with MySQL) for the Infor LN and ION products. Infor LN is Infor’s flagship ERP and is sometimes better known by its former name, Baan. It has 25 years of manufacturing know-how built into it and is used by more than 5,000 companies worldwide in a wide range of industries. These include automotive, industrial equipment and machinery, high tech and electronics, and aerospace and defense. This is a big stamp of approval that even the most critical systems can be run on MariaDB.

In other news, there are currently several really interesting paths coming together into some important milestones. The rest of this post …

Calling all SF-Bay Area Sphinxes, Thursday, October 11, 2012 at 6:30 PM, Andrew Aksyonoff (CEO/Founder) will be speaking at the San Francisco MySQL Meetup.  He’ll take the audience into a world where Sphinx goes beyond ‘old-school’ fulltext search.  Into a reality where this unique engine performs blazing full-scans, easy multi-core and multi-box queries, and wicked (fast) [...]

For some of you who situated near New York City I am happy to announce that you could attend two events related to leading Full-Text search engines in open source – Sphinx Search.

First meeting organized by NYPHP meetup on Tuesday, September 25th at IBM, 590 Madison Avenue, New York. I’ll be speaking about search services in cloud environment and distributed search tips and tricks. Event is free, please RSVP.

One week later on October 1st, I’ll be doing tutorial about MySQL and Sphinx “Full-text based services with Sphinx and MySQL” …

A few months ago we announced the EXPLAIN Analyzer, a simple tool to help you understand how MariaDB / MySQL was running queries. For users of HeidiSQL this is now even easier. As discussed in their news post you can now send a query to the EXPLAIN analyzer with a single click.

We hope this helps both new and experienced users better understand the queries they run.

More information about the EXPLAIN Analyzer and the simple API client authors can use to add support to their apps is available in the AskMonty Knowledgebase:

• …

About a week ago I was looking at MySQL 5.5.27, and noticed a curious thing. Despite the fact that the new MySQL release contained its usual share of bug fixes, not a single one of them was accompanied with a test case.

Now, let me tell you something about tests. For many years MySQL was using its own testing framework, called mysql-test. The first version was written as early as 1999. Over the years it has accumulated a lot of tests. Tests for new features and regression tests — those that guarantee that a bug, once fixed, will never ever show up again. We had pretty strict policies about it in MySQL AB (and, later, Sun Microsystems) — every new bug fix always had to come with a test case for the bug. And because these tests were always run on many platforms for every push (by the continuous integration tool called Pushbuild — developed in-house by …

In end of May I told about the numbering plans for the next version of MariaDB in the blog post What comes in between MariaDB now and MySQL 5.6?. We received quite a lot of feedback and criticism on the idea of calling the next version MariaDB 10.0. Here is a little more information about why it makes sense to call the next version 10.0.

This is not news for most of you. MariaDB is not just a set of patches applied on top of MySQL. MariaDB includes features which are similar to the corresponding features in MySQL, but the implementations differ, like for example the thread pool, microsecond support and …

So I have noticed that people don't like it when I talk about all the cool stuff Jackrabbit can do. Many people are still scared of running Java stuff in production which I guess is to be expected since PHP shops tend to .. guess what .. PHP. So in this post I just want to talk about all the cool features we have ready to use in the pure PHP Doctrine DBAL based implementation of PHPCR. Just to say it again: PHP, no Java. So first up the implementation with all its features works with MySQL, PostgreSQL and SQLite. Given that we started with MySQL we ended up relying on few specific MySQL behaviors. These are all gone now, so adding another RDBMS is likely just a half days work, maybe a day if you look at the code base for the first time, then again the relevant code to edit are just a few places in two classes ( …

Like others we were not satisfied with the fix for a bug in MySQL which caused the query cache and partitioning to not work reliably together. The bug, in simple terms, was that if the query cache was enabled and you used partitioned tables and if a partitioned table was using a transactional engine like InnoDB or XtraDB, the query cache could, under certain circumstances, return incorrect results.

Returning incorrect results is a definite, high-priority bug. However, the upstream fix was to disable all caching of queries from …

So in the summer of 2007 I switched from Windows to OSX which also meant switching from Thinkpad to Macbook Pro. While there were some details I liked on the Macbook Pro, like the at the time quite innovative magnetic design on the lid latch, overall I was sad to not be able to use a Thinkpad. So it also came that my first Macbook Pro had to repaired 3 times in total. Despite having bought the insanely expensive AppleCare this meant having to drop off my laptop for several days (usually 5 business days) or paying an "express service" charge. In general I believe Macbook's to be pretty decent, but not as sturdy as Thinkpads (starting with the availability of spill resistant keyboards). More over they tend to skip on connection options and are overpriced. Then again I really don't care about the price that much. I use my laptop for pretty much everything, from work to DJing to private use. …