Dynamic columns came to my attention a few days back. Since then I read a little bit more in the documentation (see Dynamic columns in the Knowledge Base) and played with it a little. The reason I became curious was that it brings the 'schema less' feature of the NoSQL world into the MySQL world. It was implemented in MariaDB v5.3, and MariaDB 10.0 introduces several enhancements. We will cover the topic in some detail in episode 181 of the MySQL Community podcast in case you're interested. But I thought I'd showcase the feature through an hypothetical upgrade.

As some of you may know, CVE-2014-0160 (“Heartbleed”) announced a vulnerability in certain versions of OpenSSL.

After the announcement on Monday 7th April 2014, the team began investigating the level of potential risk to our hosted systems and on-premise software.

The announcement of MariaDB 10 with it's NoSQL integration features as well as SkySQL's enhanced MariaDB Enterprise offering has reached several news sites this week. Here are a few of the articles that have been published in Europe.

About a year ago I wrote a blog post comparing MariaDB 10 to MySQL 5.6. You can find that post here. Since then MariaDB 10 has changed quite a bit, many new features have gone in, such as Parallell replication, GTIDs etc, but many features from MySQL 5.6 have also been merged in to MariaDB. MariaDB 10 has now also advanced to a near GA status so it is perhaps time to renew the table.


The MySQL Community Dinner hosted by Pythian is an event that I look forward to each year. This year it's organised on Wednesday evening April 2 during Percona Live in Santa Clara, CA. When you combine great people, outstanding Mexican food, beer and margaritas you are bound to have a good time.

Pit stop photo by Bert van Dijk CC-BY from Wikimedia Commons.

In earlier blogs I talked about some of the scalability and NoSQL integration features of MariaDB 10. In this third and final part of my tour, I’ll discuss some of the performance, operations, and security enhancements in MariaDB. Performance is clearly all about speed. But speed isn’t just how many transactions per second the database can deliver. It is also about how quickly developers can bring an application to market and how quickly they can diagnose and solve issues, especially performance issues.

Image is a mix of 2 photos, one from stock.xchng (sxc.hu) and the other CC-BY from flickr, user massmatt.In my previous blog post, I described some of the key new replication features in MariaDB 10 that let this powerful open-source database shine in web-scale and analytical applications.

I was Image from a CC-BY image on flickr.com by user Musical Mint.  http://creativecommons.org/licenses/by/2.0/deed.en working on a 2nd article on the CONNECT engine, but instead found myself Yak Shaving.

Road sign image altered from a CC-BY image on flickr.com by user Hawaii County.  http://creativecommons.org/licenses/by/2.0/deed.enI’ve been a part of the software and open source world for two decades, but I’m a relative newcomer to the database world. Well, not exactly: enterprise software has always needed a place to store, retrieve, and process all that data, and so I’ve seen how database technology has evolved in the context of the broader software industry.

Not long ago on a blog post Dean Ellis talked about the new MariaDB 10.0, describing some of the 'little things' it brings to the community. But I believe that MariaDB 10.0 also brings a lot of 'big things' to the table. Sheeri Cabral and myself started covering the CONNECT engine in OurSQL podcast's episode 174.

Pages