We've published our first case study. The customer, ideeli, had a database that was struggling on standard MySQL and InnoDB. The big win was the upgrade to XtraDB. The business continued to grow quickly, and months later under much more traffic, the database is still outperforming their previous version.

I thought I'd write a few notes that didn't seem appropriate to include in the case study, because this was a fun project that might be interesting to readers.

As usual, it was all about diagnosing the problem correctly. I used a variety of tools to help with this, foremost among them "stalk" and "collect" from Aspersa. There were several problems, not just one, and they required different techniques to diagnose. This can be hard when the …

Dear Community,

Percona Server version 5.1.50-rel12.1 RC is now available for download.

Functionality Added or Changed

• Percona Server 5.1.50-rel12.1 is now based on MySQL 5.1.50.
• New Features Added:
  • innodb_lru_dump_restore - Implemented automatic dumping of the buffer pool at specified intervals.
  • innodb_buffer_pool_shm - Implemented option ''innodb_buffer_pool_shm_checksum''; when enabled, shared memory buffer pool is checksum validated. This change also fixed these bugs: #643724, #649408, and #649393. (Yasufumi Kinoshita)
  • …

Vadim and I have just published a new technical white paper. It shows how Percona Server with XtraDB can make large-scale multi-tenant databases easier to build with MySQL. Our experiences working with SaaS and shared-hosting companies influenced the features we included in Percona Server and XtraDB, and I think this is the best explanation of what levers are available and how to use them.

Percona Server with XtraDB for Software-as-a-Service Application Databases is posted on the white-paper section of our website. No registration is required; it is just a PDF, freely downloadable with no marketing follow-up. Many thanks to Mark Callaghan and Dimitri Kravtchuk, who reviewed and gave valuable suggestions that made the white paper better.

…

My colleague Aleksandr Kuzminsky will be speaking at WebConf Riga 2010 next month on XtraBackup: Hot Backups and More and Recovery of Lost or Corrupted InnoDB Tables.

WebConf is the first big conference of its kind in the Baltic states (Estonia, Latvia, Lithuania) and we are very happy to be participating.

In addition to Aleksandr's talks, we will also be offering our training courses. You can find out more from the conference website (they will be publishing more information in the next two days).

Entry posted by Morgan Tocker | No comment

Add to: …

We've just announced a new support offering for MySQL. There's a press release here, and product information page here. But what does this new service really mean for you, in practical terms? This is actually important -- it will open up a range of new choices for you. I'll explain two major points that matter to you.

Before I begin, I want to make it clear that in some ways, what we're offering is something we've always offered. That is actually why it took us a while to re-align the product a bit. We thought we were serving you fully. You told us that wasn't really true. Thank you. We've listened.

1. Sensible Pricing

We've always offered pay-as-you-go support, and we've had a dedicated support staff for a while. The missing ingredient was flat-rate pricing. Big …

Dear Community,

Percona Server version 5.1.50-rel11.4 is now available for download.

The changes in this release include:

New features

The primary purpose of this release is to update to the latest version of MySQL 5.1.

• Percona Server 5.1.50-rel11.4 is now based on MySQL 5.1.50.

Fixed bugs

• innodb_use_sys_stats_table – The SYS_STATS table is now used only for non-temporary tables.

The binary packages are available on our website.

Percona Server can be installed from either our  …

Dear Community,

Starting with this release, we introduce a new release model for Percona Server. From now on, we will have both Stable and Release Candidate releases. Release Candidates will introduce new features not yet available in Stable releases.

Along with new features, our new 5.1.49-12.0 RC contains a couple of patches from the Facebook-MySQL tree - https://launchpad.net/mysqlatfacebook . Of particular note is better integration with FlashCache.

We also introduce the very interesting new feature called ”Permanent InnoDB Buffer Pool”  (sponsored by a Well Known Social Network site). It allows you to keep the InnoDB buffer pool in memory between restarts of MySQL servers.
This can result in a significant decrease in warmup time after MySQL restarts.

Starting with this release, we will also provide special …

We're opening up registration for our new training courses today.  In short: we are moving from two days to a new four-day format.  The new additions are created by:

• Splitting our current InnoDB day in half. We now have one day for DBAs, and one day just on InnoDB topics.
• A new Operations Day - covering how to maintain MySQL in production.

Our developer course has also undergone revision, and we now have more query tuning examples, and a new instrumentation chapter.

What is operations training?

Many companies split their …

Dear Community,

Percona Server version 5.1.47-rel11.0 is available for download now.

The changes in this release include:

New features

• Percona Server is now based on MySQL 5.1.47, and XtraDB is now based on InnoDB plugin 1.0.8.
• XtraDB now uses the fast recovery code released in InnoDB Plugin version 1.0.8, instead of Percona's earlier fast-recovery code.
• Added the --percona_innodb_doublewrite_path option to place the double-write-buffer into its own file (issue #584299). The feature is sponsored by Large Social Network website.
• Added the --suppress_log_warning_1592 option to disable …

As you may know MySQL ® announced 5.0.91 and 5.1.47 with serious security fixes, so we provide binary releases of Percona Server 5.0 and Percona Server / XtraDB 5.1 with security patches.

Fixed bugs:

• Bug#53371, CVE-2010-1848
• Bug#53237, CVE-2010-1850
• Bug#50974, CVE-2010-1849

Release Percona Server 5.0.91-rel22 is available in our download area:
…