Over 200 attendees attended last week’s Percona Live NY event. This year we structured event different than in 2011 with Tutorial Day allowing for in-depth 3 hour presentations for those looking to dive deep into specific topics. We also added an Expo Hall which allowed a lot of MySQL Ecosystem participant to meet their prospective customers and showcase their technology.

I was very pleased with momentum of this event seeing great discussions between attendees, attendees and sponsors as well as many of us doing business around MySQL reconnecting and having a lot of good conversations. As usually between my own talks and …

Percona is glad to announce the release of Percona XtraBackup 2.0.3 on October 1st, 2012. Downloads are available from our download site here and Percona Software Repositories.

This release is the current GA (Generally Available) stable release in the 2.0 series.

New Features:

• innobackupex now supports new –move-back option that can be used instead of –copy-back in case there isn’t enough free disk space on the server to copy files. As this option removes backup files, it must be used with caution.

Bugs Fixed:

• Symlink for innobackupex-1.5.1 binary has been broken in the previous version of XtraBackup. Bug …

Attending MySQL Connect ? Do not miss our talks!

Peter Zaitsev is doing “Optimizing MySQL Configuration” talk at 2:30 PM in Golden Gate 4 room
Vadim Tkachenko is talking about “MySQL and Solid-State Drives: Usage and Tuning” at 4:00 PM in the same room.

See you around !

The Percona Toolkit team is happy to announce the release of Percona Toolkit version 2.1.4. This is the fifth stable release in the 2.1 series, and primarily a bug-fix release; We suggest that users upgrade to the latest version of the tools.

The complete list of changes is on the Launchpad milestone for 2.1.4, but here are some highlights the release:

• pt-table-checksum now works with Percona XtraDB Cluster
• The “Version Check” feature, explained at length here.
• –defaults-file is now used when connecting to discovered slaves in pt-table-checksum

All in all, a solid bug-fix release, with the addition of some new features too.

Remember that if you need …

Not so far ago Fusion-io announced SDK which provides direct API access to Fusion ioMemory(tm) in addition to providing a native filesystem (directFS) with a goal to avoid overhead from kernel and regular Linux filesystems: ext4 and xfs. Fusion-io will explain these features during our Percona Live New York conference and share performance numbers.

It is not too late to register for conference and talk with Fusion-io engineers directly. “PerconaNY” registration will give you 15% discount.

With Percona Live NYC right around the corner I decide some of attendees what did they like on the last year event and what they are looking forward to in 2012. Here are some responses I got. If you’ve attended in 2011 or planning to join us in 2012 please feel free to comment with your feedback!

Ori Herrnstadt, CTO, Akiban Technologies says:
“I truly appreciated the opportunity to present at Percona Live NY last year and can’t wait to show how Akiban has progressed since then. As the founder of a company that is eliminating data complexity while preserving SQL and embracing new development paradigms, Percona Live offers the right mix of savvy technologists.”

Ryan Lowe, Production Engineer at Square Inc. says:
“This will be the fifth …

On Percona Live New York I’ll be giving two talks

• “Percona XtraDB Cluster: HA solution for MySQL”. I will give introduction in MySQL clustering and show how Percona XtraDB Cluster solves HA and scalability problems.
• MySQL and SSD: usage and tuning. If you follow this blog, you know that I do quite a bit experiments with SSD / Flash. In this talk I will share my experience, results and some tuning advises.

Right now it is the best time to get tickets to Percona Live New York as our Advanced Rate prices end this Saturday.

If you are working with MySQL and you are in …

I’ve mentioned this before, but I’m delivering a tutorial on Percona XtraDB Cluster / Galera at Percona Live NY 2012 right in midtown-Manhattan on October 1st.

I really want this tutorial to be hands-on, not just a 3 hour lecture, so you can actually see how a cluster operates and interact with it.  So, I have come up with a set of walkthroughs for different features and areas of learning PXC using a common set of Virtual Machines setup with Vagrant and Puppet (which works on Linux, OSX, or Windows).  This sounds complicated, but it basically means we can create a test environment with a full 3-node cluster on …

Recently there has been a storm of bugs and problems in all variants of MySQL including MySQL, Percona Server, and MariaDB. To list a few:

• MySQL 5.5.25
  UPDATE on InnoDB table enters recursion, consumes all disk space
• All MariaDB and MySQL versions up to 5.1.61, 5.2.11, 5.3.5, 5.5.22
  Security vulnerability in MySQL/MariaDB sql/password.c
• MySQL 5.1.61
  DSA-2429-1 mysql-5.1 — several vulnerabilities
• MySQL 5.5.25a
  Slave crash regression
• Percona Server 5.5.27-28.0 regression
  …

You surely have heard about Percona Live,NY taking place October 1-2 in New York, you however might have been wondering what kind of talks you would see on this event and why would should you attend.

The day one of this event is Tutorial day, which is long (half to a full day) presentations which go deep into details and often feature hands on experience. We expect you to attend tutorial on the topic which is highly relevant for your job to significantly increase mastery of the topic. If you work with benchmarking, performance analyses load testing you might want to attend “Understanding Performance through Measurement, Benchmarking and Profiling” . If you’re using Innodb my tutorial on …