Buy Percona ServicesBuy Now!

What is innodb_support_xa?

 | March 2, 2011 |  Posted In: Insight for DBAs, MySQL

A common misunderstanding about innodb_support_xa is that it enables user-initiated XA transactions, that is, transactions that are prepared and then committed on multiple systems, with an external transaction coordinator. This is actually not precisely what this option is for. It enables two-phase commit in InnoDB (prepare, then commit). This is necessary not only for user-initiated […]

Read More

Is VoltDB really as scalable as they claim?

 | February 28, 2011 |  Posted In: Benchmarks, MySQL

Before I begin, a disclaimer. VoltDB is not a customer, and did not pay Percona or me to investigate VoltDB’s scalability or publish this blog post. More disclaimers at the end. Short version: VoltDB is very scalable; it should scale to 120 partitions, 39 servers, and 1.6 million complex transactions per second at over 300 […]

Read More

Percona Server Scales Vertically with Virident tachIOn Drives

 | February 28, 2011 |  Posted In: Hardware and Storage, MySQL

We’ve published a new white paper that explains how to stop sharding and start scaling vertically with PCI-E flash drives, specifically the Virident tachIOn drive, which offers consistent, low-latency IO performance. I’ve been beating this drum for a while, so it’s a great feeling to have an explicitly recommended reference architecture: buy flash storage first, […]

Read More

Percona Server and XtraBackup weekly news, February 19th

 | February 21, 2011 |  Posted In: MySQL, Percona Software

This week’s announcement is short: last week was pretty much all-hands-on-deck for our first 5.5.8 release. Still, it wasn’t ALL about the new release: The beta release of Percona Server 5.5.8 is out! More details in the release notes. There are ongoing discussions about parallel replication, as well as customer requests for enhancements to row-based […]

Read More

How to syntax-check your my.cnf file

 | February 17, 2011 |  Posted In: Insight for DBAs, MySQL

For a long time I’ve used a little trick to check whether there are syntax errors in a server’s my.cnf file. I do this when I need to shut down and restart the server, and I’ve either made changes to the file, or I’m worried that someone else has done so. I don’t want to […]

Read More

Percona Server 5.5.8 Beta Release

 | February 16, 2011 |  Posted In: MySQL, Percona Software

It’s finally here! Percona Server Percona Server 5.5.8-20.0 is now available for download. This is a beta release of Percona’s enhancements to the MySQL 5.5.8 server. Here are some highlights: Performance and scalability improvements throughout the server and storage engine Optimizations for flash storage such as SSD, Virident, and FusionIO Optimizations for cloud computing The […]

Read More