Thousands of people have testified to the value of the Oracle Certification Program as follows:

• 97% said they have benefited from certification.
• 96% would recommend the program to a professional colleague.
• 89% said they gained more confidence in their expertise after becoming certified.

You have until December 21st to take the new MySQL Server 5.6 Certification exams in their beta form. A reminder of what is on offer:

• Oracle Certified Professional, MySQL 5.6 Developer
• Oracle Certified Professional, MySQL 5.6 Database Administrator

Until December …

Another month has come to an end. If you’re looking to be updated on MariaDB content on a regular basis, don’t forget to be on Twitter (@mariadb), Facebook (MariaDB.dbms), or Google Plus (+mariadb).

There was a question on Quora – Is Facebook considering ditching MySQL in favor of MariaDB like Google did? The best answer really comes from Harrison Fisk, so I’ll leave you to it to read. The older link made its way on social media about Wikipedia_$ mv MySQL MariaDB. …

This is an incomplete fragment from 2011. Figure its worth publishing this now, considering MariaDB is likely to get groonga in the near future. The groonga team have released MariaDB 10.0.6 binaries as well. This is all part of the mroonga project.

These were my quick notes from the groonga talk at the O’Reilly MySQL Conference & Expo 2011. I haven’t tried it yet (and don’t know if it really is faster than Sphinx), but its something I definitely want to play with. Maybe even get a MariaDB tree going.

groonga is a fulltext search library for cloud & web.

groonga is easy to embed & is scalable. It is written in C.

Highly precise search for …

For my 25 readers (Italians would know better, citing The Betrothed by Alessandro Manzoni): if you are a techie and you do not know me , you can stop reading. No tech tips inside, nor 5 gazillion queries per second improvement in this post, sorry!

On the other hand, if curiosity is what drives you through the posts of PlanetMySQL  you may find bits in this post of some interest, or even helpful.

Few days ago I opened my blog and found the last post, dated April 2013. It was a reminder for the readers that the OpenStack Summit …

Using disk snapshots to perform MariaDB backups has become more and more common, but this seems to have been limited to Linux and Cloud environments. There seems that there has been a notion that Snapshots cannot be done on native Windows, the way we can do snapshots using LVM on Linux for example. This is actually False, if you use the NTFS filesystem snapshoting is built in and has been so for a long time, the base for it is the Volume Snapshot Service (VSS) which was introduced as far back as Windows XP.

Using Snapshots to backup on Linux or Windows works well, assuming that the storage engine you use can recover on startup, the backups created this was are physically consistent but not logically, but InnoDB will recover this. Also note that any warnings about using snapshots with MyISAM also applies to the mysql database, i.e. the database metadata. Usually though, this …

Today new version of JSON UDF functions: 0.2.1 was released. This is maintenance release which added no new functionality and only contains bug fixes. However, it also includes improvements for build ans test procedures. As usual, you can download source and binary packages at MySQL Labs. Binary packages were build for MySQL server 5.6.14. If you want to use other version of the server, you need to recompile functions.

What was changed? Let me quote the ChangeLog.

Functionality added or changed:

Added cmake option WITH_PCRE which alolows to specify if existent or bundled version of PCRE  should be used. Bundled is default on Windows. To compile with bundled version, run: "cmake . -DMYSQL_DIR=/path/to/mysql/dir -DWITH_PCRE=bundled", to turn bundled version off on Windows, run: "cmake . …

Before there was PERFORMANCE_SCHEMA, there was SHOW ENGINE INNODB MUTEX. As I wrote yesterday, these commands are useful for exposing internal locking operations that happen inside of MySQL. They are mainly useful for MySQL developers, but have some appeal for DBAs as well.

As part of an ongoing effort to cleanup the MySQL code-base and increase usability, the MySQL development team is interested in hearing feedback from users who currently use the command SHOW ENGINE INNODB MUTEX.

Specifically:

• Is there a use case for the command that is not well satisfied by Performance Schema?
• Would you be adversely affected if SHOW ENGINE INNODB MUTEX were to be deprecated?
…

I took the MySQL 5.6-Exam today and it really is not easy. Lets get straight to the facts i remember:

• I had 130 questions and 180 minutes time
• I needed 155 minutes but i was a bit exhausted at the end so went a bit quicker through the questions as in the beginning. Normally i am a fast exam taker and only need a third of the time.
• The option to eliminate obviously wrong answers by CTRL-Rightclick is often really helpful

What you should learn in the following order:

• Performance Schema
• Replication Features, especially GTID, and mysqlbinlog-usage
• Partitioning
• Optimizing MySQL Queries
• MySQL Enterprise Backup-Features
• Anything else (command line options, Windows Cluster, mysqldump, mysqlshow, etc..)

I had 3 or 4 questions where i thought that the answers (or the question) were not correct or no …

So, after installing Workbench 6.0.7 on my pc, and playing around with the MySQL Utilities that are included, I thought I’d do similar to what others have done (Thanks Tony D.) and share my experience on how I’ve used them. If you haven’t installed Workbench before, you might want to check your platform first: http://www.mysql.com/support/supportedplatforms/workbench.html.

So, even if you’re not using any of the recent versions and editions of Workbench (Utilities comes with all of them, Tools menu -> “Start Shell for MySQL Utilities“) you can just download the standalone scripts on a Linux machine. Flexibility being the name of the game again. …

So, after installing Workbench 6.0.7 on my pc, and playing around with the MySQL Utilities that are included, I thought I’d do similar to what others have done (Thanks Tony D.) and share my experience on how I’ve used them. If you haven’t installed Workbench before, you might want to check your platform first: http://www.mysql.com/support/supportedplatforms/workbench.html.

So, even if you’re not using any of the recent versions and editions of Workbench (Utilities comes with all of them, Tools menu -> “Start Shell for MySQL Utilities“) you can just download the standalone scripts on a Linux machine. Flexibility being the name of the game again. …