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 …

Very informative and to the point, useful! Thanks Sanjay.

Take a look at the comparison I think you will find it very interesting

Thank you!

Readers of the MySQLPlus blog have voted Galera as the top choice in the "What would you like to test in 2013?" category. We apparently are narrowly more interesting to test than MySQL 5.6, which is both humbling and difficult to put into right perspective. But we were all very glad to find out about this selection for sure!

Galera development was started in 2007 by Seppo, Teemu and Alex. They had already worked on various MySQL replication products since 2003. Around that time they read about some new academic research on concepts like virtual synchrony and certification based clustering. They were convinced this was the key to create a robust and useful synchronous multi-master cluster for MySQL.

Having failed to convince the management of their then employer about the …

Time for some shameful self promotion and hopefully some helpful information too.

What follows are my lists of talks  at the MySQL conference that I would suggest to others, based on experience level, and/or interests.  I've focused on my interest areas, as others have posted lists with their interest areas already, but I also provide a list of those who may be new to the event and want suggestions for what I think will be great all-around talks with a wide focus.


If you are new to MySQL, or new to PCLME: Day 1:

• 
  
• http://www.percona.com/live/mysql-conference-2013/sessions/how-design-indexes-really
  
• …

In the MySQL QA teams in Oracle we have been using a tool called the Random Query Generator (or "RQG" for short) for some time now. The main RQG testing effort has been on new server development, including regression testing. The recent MySQL 5.6 GA is a result of a couple of years of hard work, including a lot of RQG testing and bugfixing as a result of that.

I can easily say that the RQG has helped making MySQL 5.6 a better release than it would otherwise be. It is of course not our only testing tool, but there are plenty of bugs this tool has uncovered that would likely not have been seen in our other testing. Such issues include:

• crashes and asserts
• memory management bugs (valgrind errors)
• wrong results

The main clue to the power of the RQG is its …

Percona XtraDB Cluster

Percona is glad to announce the release of Percona XtraDB Cluster 5.5.29-23.7.2 on February 13th, 2013. Binaries are available from downloads area or from our software repositories.

Bugs fixed:

• DML operations on temporary tables would try to append the key for provider library, which could cause a memory leak. Bug fixed for MyISAM temporary tables, InnoDB temporary tables still have this issue, probably caused by upstream bug …

I’ve finally gotten around to starting to write my presentations for PLMCE2013. So, in the spirit of procrastination, I went through all of the sessions and highlighted some of the ones that I want to attend! Tutorial: Percona XtraDB Cluster Percona Server 5.6 Crossing the Production Barrier: Development at Scale MySQL performance monitoring using Statsd [...]

Finalizing my series of MySQL 5.6 -vs- MySQL 5.5 benchmarks (best-to-best results and config settings (1), scalability (2), tuning details and yet more test results (3)), I've realized that it just needs a one point more - MariaDB results..

One of my friends called me to tell a story about an article in one of computer magazines saying that "If you're having performance issues with MySQL 5.5, you should try MariaDB 5.5 and you'll be surprised!"..

It waked up my curiosity. MariaDB-10 seems to be only in alpha stage for …

It’s time to unveil the winners of the [Plus] readers choice awards!
Thank you again for your votes, remember that the real winner was the community, again.

I asked you to vote for what you used in 2012 and you’ve voted with your heart.
Here are the final results, congrats to the lucky guys and teams :

The most useful blogs in 2012 :

1. MySQL Performance Blog
2. The MariaDB Blog
3. SkySQL Blog

Ok, the Percona team members provides the best technical blog about MySQL (and more), this year again. Of course, this blog is very useful and interesting, I recommend to read the comments too, they are often very informative.
There is a …