class="alignleft size-full wp-image-12668" alt="Percona XtraBackup for MySQL" src="http://www.mysqlperformanceblog.com/wp-content/uploads/2013/01/Percona_XtraBackup.jpg" width="229" height="87" /> Percona is glad to announce the release of Percona XtraBackup 2.1.1 on May 15th 2013. Downloads are available from our download site
I ran single-threaded performance tests to compare MySQL using releases 4.0.30, 5.0.85, 5.1.63 and 5.6.11. On my simple tests 4.0.30 is almost 1.5X faster than 5.6.11. I think it is important to reduce these regressions. Maybe this is an area in which the forks (MariaDB, Percona) will lead the way? I previously opened bug 68825 for this and will update it with the results I report here.
I talk with lot of people who are really interested in
href="http://www.percona.com/software/percona-xtradb-cluster" target="_blank">Percona XtraDB Cluster (PXC) and mostly they are interested in PXC as a high-availability solution. But, what they tend not to think too much about is if moving from async to synchronous replication is right for their application or not.
Facts about Galera replication
There’s a lot of different facts about Galera that come into play here, and it isn’t always obvious how they will affect your database workload. For example:
class="alignleft wp-image-12964" alt="Using MySQL 5.6 Performance Schema to Troubleshoot Typical Workload Bottlenecks" src="http://www.mysqlperformanceblog.com/wp-content/uploads/2013/02/Percona-MySQL-Webinars.jpg" width="141" height="149" />This Wednesday, May 15 at 10 a.m. Pacific, I’ll be leading a Webinar titled, “
class="alignleft wp-image-15389" style="margin: 9px;" alt="Open Source & the MySQL market" src="http://www.mysqlperformanceblog.com/wp-content/uploads/2013/05/access_key.jpg" width="208" height="208" />I was reviewing the
I found myself in a, ahem, lively discussion with someone recently. It started when I said “there was always something wrong about the daily deals businesses (i.e. Groupon), but I’m sure they’ll teach us what’s really needed.” Turns out this person ran a local daily-deals site. Oops.
This is the start of the heavy travel season for the MySQL Community Team. So if you are attending PHPTek, Drupalcon, Texas LinuxFest, SELF, Redhat Summit, or Lonestar PHP please make sure to say ‘hi’ while you are in Chicago, Portland, Austin, Charlotte, Boston, or Addison. This group of trips is starting with a swag bag full of MySQL stickers, thumb drives, and ‘boogie bots’
For some workloads the InnoDB performance model is very simple. It must flush dirty pages as fast as storage will allow. With a few more bug fixes InnoDB in MySQL 5.6 should be able to do that. The performance model becomes a bit more complicated when you consider that there are two reasons for sustaining a high rate of flushing dirty pages.
title="XtraBackup 2.0.7" href="http://www.mysqlperformanceblog.com/2013/05/06/percona-xtrabackup-2-0-7-for-mysql-available-for-download/">Percona XtraBackup 2.0.7 has been published with support for GTID based replication.