Max Mether's blog

A high-level comparative overview of the features

With the recent GA release of MySQL 5.6, there have been a lot of questions about where MariaDB stands with regards to MySQL 5.6.  SkySQL will of course support both as Patrik explained in his recent blog post, but there are many questions about the technical differences. Rasmus from Monty Program gave a detailed view on MariaDB 10.0 here but I thought it would be beneficial to share a comparison table of the two. MariaDB recently released a benchmark including various versions of both MariaDB and MySQL (as did DmitriK from Oracle), but this post will focus solely on features (not performance). This comparison table is a high level overview with no intention to cover every single feature, only the ones deemed most significant.

Our customised training courses for the MySQL & MariaDB databases help your team learn exactly what they need to know

Since SkySQL’s inception, training has been an integral part of the services we provide. Training isn’t just something we offer, but an intrinsic aspect of our business model as we evolve into an all-inclusive service and product provider. And customized onsite training is the best way your team learns what your specific team needs to know.

SkySQL’s Newest Training Course, “MySQL Database for the Cloud”, Helps DBAs and Developers Find Success in the Cloud

Increasingly, more organisations are moving their database applications to cloud to take advantage of its superior agility and faster deployment over legacy systems.

There's definitely more and more buzz on and around cloud computing and different solutions to support it nowadays!

This was evident while visiting LinuxCon/CloudOpen in San Diego a few weeks ago, where I spoke about high availability solutions for MySQL. Most cloud sessions were highly attended, and I could sense an excitement in the air with regards to the cloud. It was also evident, however, that there is only a small percentage of people today truly taking advantage of the cloud. It seems that despite all the excitement, there is a large portion of potential users who don't know how to use the cloud, or what the benefits and potential drawbacks are.

We still have a few seats left for our MySQL Cluster training in Washington DC January 24 - 26. If you're interested in learning about MySQL Cluster, the architecture, how to install it, administer it and troubleshoot it this is the course for you. The course will also cover replication and optimization and we will also discuss the exciting new features coming in version 7.2 of MySQL Cluster. For more information about the course contents visit http://www.skysql.com/services/training/courses/administering-mysql-cluster and to sign up to the course go to http://www.skysql.com/services/training/schedule/administering-mysql-cluster-1.

See you there!

We welcome everyone to Amsterdam where on Friday at 16:00 CET we will be giving a talk together with SpamExperts at the Open Source Conference 2011. The talk will be about MariaDB and how SpamExperts successfully overcame their problems with MySQL by migrating to MariaDB. The talk will focus on the MariaDB features that differentiate it from vanilla MySQL and an in-depth case study on SpamExperts and the problems they faced when deciding to migrate to MariaDB and a detailed overview of the actual migration process.  For more information about the conference, check out their website: http://www.opensourceconference.nl/

If you’re in Nuremberg Germany next week (November 15-17th) and have anything to do with Oracle or their products, then the DOAG (German Oracle User Group) conference is the place to be. I will be representing SkySQL Ab at the conference, giving a talk about the internal architecture of MySQL Cluster. The talk will look at the internals of MySQL Cluster and at the different processes that ensure the High Availability of MySQL Cluster. Beyond that, the talk will also look at how the data is stored on the data nodes, how different types of queries are resolved in the cluster, and how a primary key lookup is executed differs significantly from a tree index search. The talk will also look at the resources involved in resolving the queries.

So if any of the above sounds interesting come and listen to my talk in room Singapur at 13:00 on Tuesday!