What are your pet peeves about the tools? I have a lot. For example, pt-table-sync doesn’t let me do things I want it to do sometimes (and I know it could be made to do them). Another example: pt-query-digest’s tcpdump parser doesn’t pay attention to TCP sequence numbers, so sometimes it invents a really long-running query where there isn’t one. Post your gripes, big and small, in the comments!

(This blog post is an attempt to do a 37signals approach to prioritizing: the stuff people complain about repeatedly is what you should focus on. No promises about fixing the gripes — I just want to hear them!)

Further Reading:

• I need your advice on how to package MySQL Toolkit as one file
• …

I’m happy to announce that version 1.0 of Percona Monitoring Plugins is now available. The Percona Monitoring Plugins are high-quality plugins, templates, and add-ons for Nagios and Cacti, so you can add world-class MySQL monitoring to your existing enterprise open-source monitoring products.

Version 1.0 fixes a variety of bugs that users found in version 0.9.0. Here are the usual links: changelog, documentation, downloads, source code, …

Things are going to be busy over the next few months. I look forward to meeting many of you from the MySQL community over the next few months. I would also like to pass along my thanks for the MySQL Community Award, we (not just Dave and I but everyone here) are just getting started...
April 22nd -26th - starts things off for the MySQL Community Team. Dave Stokes and I will be presenting at different two sessions and available in the demo grounds at Collaborate in Vegas.
May 2nd -- MySQL heads to the big apple for an OTN Developer Day in NYC. Ronald Bradford as well as Calvin Sun are among some of the speakers for this …

Last week was full of exciting news for all things MySQL.

However, SkySQL also had some great individual news in that it announced 2 new partners:

• hastexo
• PalominoDB

I just wanted to take a moment and officially welcome both to the SkySQL fold!

PalominoDB and hastexo, it’s great to be partnered with you!

And we’re looking forward to all the exciting things the future has to hold!

For those interested, you can read more about each partnership here:

SkySQL & hastexo …

The SkySQL & MariaDB: Solutions Day for the MySQL Database (the first of its kind) took place last Friday (April 13th) in Santa Clara, and we’d like to thank everyone who attended, participated and generally helped make it the successful day that it was!

read more

Well, as you or may not have heard, MariaDB 5.5 (5.5.23) was declared GA last week!

It was only about 6-ish weeks ago that MariaDB 5.5 had been released as alpha, so the fact it’s already GA is excellent news for all MariaDB users (and MySQL 5.5 users looking to migrate).

Some of the 5.5 enhancements include:

• Significantly more efficient thread pool, comparable in functionality to the closed source feature in MySQL Enterprise.
• Non-blocking client API Library (MWL#192)
• @@skip_replication option (MWL#234)
• SphinxSE updated to version 2.0.4.
• “extended keys” support for XtraDB and InnoDB
• New INSTALL SONAME statement
• New LIMIT ROWS EXAMINED optimization.
• mysql_real_connect() Changes
  In MySQL, and in MariaDB versions before 5.5.21, mysql_real_connect() …

Read the original article at Easy MySQL replication with hotbackups

Setting up replication in MySQL is something we need to do quite often. Slaves die, replication fails, or tables and data get out of sync. Whenever we build a slave, we must start with a snapshot of all the data from the master database.

MySQLdump is the tried and true method of doing this, however it requires that we lock all the tables in the database. If we’re dumping a large database, this could be a significant period, where no writing can happen to our database for the duration of the backup. For many environments read-only is still an outage.

Enter hotbackups to the rescue. Percona comes with a tool that allows you to …

Hi Folks,

Just a quick note to let you know that I am planning to add support to XtraBackup Manager to work with XtraBackup 2.0 series releases fairly soon.

Using the XtraBackup 2.0 series will mean that XtraBackup Manager will no longer need to stage the incremental backups to a location on the remote host before copying them back to the XtraBackup Manager storage.

This can be a remarkable efficiency saving for systems with a lot of page changes between backups.

I will also be trying to address some of the feedback/requests that I have received in the Google Code Issues section.

Please check out the project in Google Code here, if you have not already. Feedback and contributions are welcomed!

http://code.google.com/p/xtrabackup-manager/

Cheers,
Lachlan

The journey to the Hotel in Santa Clara took me something like 16 hours. It was long, arduous and at times despairing, but was it worth it? Absolutely! I made the epic journey with my Pythian (and former Nokia) colleague Andrew Moore, and once at the conference we met up with more members of our [...]

MySQLBoy attends the annual MySQL Conference and Expo host by Percona. [part 1 of 2]