Oh yes, the nights were short last week!
The committee and myself have worked tirelessly to provide this wonderful schedule.

Now, you have no excuse not to register : http://www.percona.com/live/london-2013/registration

First, I would like to thanks David, Ivan, Todd, Kenny and Ben for their fantastic work!
There were tears, blood, passion and much respect ;-)
And of course a lot of fun!

Secondly, I would like to thanks all of you who submitted a talk.
We received a considerable amount of excellent talks from fantastic speakers.
And it was really, really hard to choose only 30 talks among this long …

In my last post, I discussed the existing backup solutions for MySQL.  At the end I briefly discussed why the backup solutions for InnoDB do not apply to TokuDB.  Now I’m going to outline the backup solution we created.  Our solution works for both TokuDB and InnoDB.  It also has no knowledge of the log files and does not require any changes to either storage engine.  In fact, the library could be used with almost any process; it has no knowledge of what types of files are being backed up.

Shims

Tokutek’s Hot Backup is essentially a shim between the mysqld process and the operating system (Linux only, at this point.)  It is a separately compiled C++ library that simply gets linked into the mysqld application at the end of the respective build process.  We ship this library with our own enterprise …

MySQL Enterprise Backup has been improved to support single step restore from the latest release 3.9.0. It enables you to restore the backup image to remote machine in single step. However, first you would have to create the backup image in local disk, copy the backup image to remote machine, and then restore in remote machine by running copy-back-and-apply-log command.

This approach has two overheads:     Serial execution: You have to wait for each step to finish before beginning the next (e.g. You must have to wait for backup-to-image operation to finish before beginning copy).     Disk consumption: You might not have enough space on the …

Heading to MySQL Connect right now.. Seems there will be a lot of interesting stuff, my prediction ;-)

This year I have 2 talks about MySQL Performance:

• Presentation: MySQL Performance: Benchmarks, Tuning, and “Best” Practices 
  Sunday, 11.30 am, Imperial Ballroom B
  
  
• Tutorial: MySQL 5.6 Performance Tuning and Best Practices 
  Monday, 4.00 pm, Moscone South - 236
  
  

Looking forward to exchange and to learn from others.. And, of course there will be some surprises ;-))

So, stay tuned ;-)

Rgds,
-Dimitri

Later this week I’m traveling to San Francisco to attend MySQL Connect – which looks like an exciting event to be at. I’m going to deliver two talks at this show, both on Sunday – MySQL Indexing Best Practices for MySQL 5.6 and Optimizing MySQL Configuration for MySQL 5.6. I will also be there for a Percona Toolkit BoF on Saturday and at our Booth (6004) during select expo hall hours.

What I’m looking forward to at this event the most is an update on MySQL technology both from Oracle’s engineering team as well as MySQL users. People from Facebook, Twitter, LinkedIn, Paypal …

MySQL DBA and Developer Certification Exams are now in beta! Besides covering the new material in MySQL 5.6, you now have to pass one exam to earn the certification where previously you needed to pass two exams. Signup at Pearson Vue and reserve your exam. Testing will start in October.

The exams for older certifications will not be available after October 31st and the Certification Paths for DBA 5.0, Developer 5.0, Cluster DBA 5.1, and Associate will end at the end of the year. Those certifications are still valid once earned forever. For more details.

The MariaDB project is pleased to announce the immediate availability of the MariaDB Java Client 1.1.5. This is a Stable (GA) release. See the Release Notes and Changelog for detailed information on this release and the About the MariaDB Java Client page in the MariaDB Knowledge Base for general information about the client.

Download MariaDB Java Client 1.1.5

Release Notes …

Percona is glad to announce the release of Percona XtraDB Cluster 5.5.33-23.7.6 on September 18, 2013. Binaries are available from the downloads area or from our software repositories.

New Features:

• Default State Snapshot Transfer method, defined in wsrep_sst_method variable has been changed from mysqldump to …

You may have already seen the news: Oracle is launching an updated certification for MySQL Developers, based on MySQL Server 5.6.  This is exciting to me for several reasons that I want to share:

Only one exam

Earlier versions of the MySQL Developer certification required sitting for two separate exams.  One goal in redefining the certification process was to make it more accessible to candidates, and reducing the cost – in both time and money – developers need to invest in examinations.  This obviously presented a challenge to cover the same material – actually more, when you consider MySQL 5.6 features – in fewer questions, but we feel we’ve done it.

Content from the experts

Content creation for this exam has drawn from many different volunteers from a wide range of MySQL teams including Training, …

TokuMX v1.2.1 introduces two simple new features to help you understand the performance characteristics of your database: lock diagnostics and index usage statistics. We’d like to take you through a few examples of what these features are and how to use them.

Lock Diagnostics

Since we introduced TokuMX, one of the most frequent complaints has been about “lock not granted” errors.  These arise when a long-running operation takes document-level locks, and other clients timeout while waiting to acquire the same locks.

This is a new problem in TokuMX that doesn’t exist in MongoDB, because MongoDB doesn’t have document-level locks.  It has a single lock per database, and if an operation takes a long time, it simply …