Thank you ;) Nice!

Thank you. Great news.

It’s August 1st, 2011, and five years ago on or about this date (who can remember clearly?) Peter Zaitsev and Vadim Tkachenko founded Percona. What’s happened in the last five years?

We’re a privately held, privately funded company of over 50 employees distributed globally, serving 1200 customers worldwide with support, consulting, training, and engineering services for MySQL. Our revenue isn’t public, but we’re proud that we’re able to keep all those people busy and help provide for their families. We’ve contributed significantly to improved performance and advanced functionality in the MySQL server and InnoDB storage engine, and created the first and only opensource hot-backup tool for InnoDB, as well as many other open-source software engineering projects.

We’re happy that we’ve …

1. Backup outside of the Cloud

Some of the high profile companies affected by Amazon's April 2011 outage could have recovered had they kept a backup of their entire site outside of the cloud.  With any hosting provider, managed traditional data center or cloud provider, alternate backups are always a good idea.  A MySQL logical backup and/or incremental backup can be copied regularly offsite or to an alternate cloud provider.  That's real insurance!

2. Use alternate regions and availability zones

Amazon's outage in April …

Keith Larson (Oracle’s MySQL Community Manager) nominated me to become an Oracle ACE. Thank you Oracle — it feels very good to receive this award.

Related posts:

1. Oracle is not screwing MySQL
2. MySQL Enterprise/Community split could be renewed under Oracle
3. Migrating US Government applications from Oracle to MySQL …

I will be presenting Care and Feeding of a MySQL Server for Linux Adminstrators twice in August. The first is August 2nd at the Oracle Office in Frisco, Texas at 4:30 PM (Suite 300 ,7640 Warren Parkway, Frisco, TX). We will have refreshments, door prizes, and a discussion about having a meeting (or two) in the Irving office.

Come be cool with us!

The second will be August 19th, in Plaza B, Hyatt Regency Vancouver at 3PM at Linuxcon North America.

This presentation developed from requests from Linux Administrators who know MySQL runs great on commodity hardware. But they want to make sure that they get their servers set up to get the best possible performance. This is a presentation to turn anyone into a DBA after forty minutes. But it will help a Linux admin create the foundation for great MySQL servers. Topics …

I am quite excited at the MySQL Labs feature to have a Binary log API .
The reason is that I see this as a possible disk-based queuing system for MySQL.

An example of how you could do this, is instead of having a trigger with its own overhead, you could create a program to parse the binary log and run a trigger yourself a little bit later with no "real-time" overhead. As in, it would be run when the user isn't waiting for it.
You could also, for another example, develop a program that counts the rows in a table and update memcached directly, instead of querying MySQL for it.
This can already be done with other queuing systems like Gearman, but with this API, you can develop other APIs or applications on top of it. Like, memcache_table_counter demon.

In any case, it would be very …

I am quite excited at the MySQL Labs feature to have a Binary log API .
The reason is that I see this as a possible disk-based queuing system for MySQL.

An example of how you could do this, is instead of having a trigger with its own overhead, you could create a program to parse the binary log and run a trigger yourself a little bit later with no "real-time" overhead. As in, it would be run when the user isn't waiting for it.
You could also, for another example, develop a program that counts the rows in a table and update memcached directly, instead of querying MySQL for it.
This can already be done with other queuing systems like Gearman, but with this API, you can develop other APIs or applications on top of it. Like, memcache_table_counter demon.

In any case, it would be very …

Thank you. Great news.

Although I no longer maintain hackmysql.com, I still actively develop MySQL tools. An article I wrote, 10 essential MySQL tools for admin, was published today. I hope no one’s feelings are hurt if their tool isn’t in the list, but it was rather difficult to compile the list given that so many tools are either not actively developed, not tested, or not well documented. Given lag time between writing and publishing, I was not able to write about Yoshinori’s MHA or newer tools. And given length constraints, I was not able to write about more tools. In any case, the world of MySQL tools is alive and well.