by Hrvoje Matijakovic | Jun 3, 2013 | MySQL, Percona Software
Percona is glad to announce the first Release Candidate release of Percona Server 5.6.11-60.3 on June 3rd, 2013 (Downloads are available here and from the Percona Software Repositories). Based on MySQL 5.6.11, including all the bug fixes in it, Percona Server...
by Bill Karwin | Jun 3, 2013 | Insight for Developers, MySQL, Webinars
On Friday I gave a presentation on “MySQL Query Patterns, Optimized” for Percona MySQL Webinars. If you missed it, you can still register to view the recording and my slides. Thanks to everyone who attended, and especially to folks who asked the great questions. I...
by Jaime Crespo | May 31, 2013 | Insight for DBAs, MySQL, Percona Software
Here at the MySQL Performance Blog, we’ve been discussing the several new features that MySQL 5.6 brought: GTID-based replication, InnoDB Fulltext, Memcached integration, a more complete performance schema, online DDL and several other InnoDB and query optimizer...
by Stephane Combaudon | May 30, 2013 | Insight for DBAs, MySQL
The main benefit of using GTIDs is to have much easier failover than with file-based replication. We will see how to change the replication topology when using GTID-based replication. That will show where GTIDs shine and where improvements are expected. This is the...
by Frederic Descamps | May 29, 2013 | MySQL, Percona Software
If you are using Percona Replication Manager (PRM) with RHEL/CentOS prior to 6.4, upgrading your distribution to 6.4 may break your cluster. In this post I will explain you how to fix your cluster in case it breaks after a distribution upgrade that implies an update...
by Tim.Callaghan | May 28, 2013 | MySQL
Two months ago I posted a performance comparison running Sysbench on MongoDB versus MongoDB with Fractal Tree Indexes v0.0.2. The benchmark showed a 133% improvement in throughput. Nice, but our engineering team had an effort on our road-map for lock refinement that...
by Ernie Souhrada | May 28, 2013 | Insight for DBAs, MySQL, Percona Events, Webinars
Selecting the most appropriate solution for a MySQL HA infrastructure is as much a business and philosophical decision as it is a technical one, but often the choice is made without adequately considering all three perspectives. When too much attention is paid to one...
by Hrvoje Matijakovic | May 24, 2013 | MySQL, Percona Software
Percona is glad to announce the release of Percona Server for MySQL 5.5.31-30.3 on May 24, 2013 (Downloads are available here and from the Percona Software Repositories). Based on MySQL 5.5.31, including all the bug fixes in it, Percona Server 5.5.31-30.3 is now the...
by Yves Trudeau | May 24, 2013 | Hardware and Storage, Insight for DBAs, MySQL
I am currently working with a large customer and I am involved with servers located in two data centers, one with Solaris servers and the other one with Linux servers. The Solaris side is cleverly setup using zones and ZFS and this provides a very low virtualization...
by Fernando Ipar | May 23, 2013 | Insight for DBAs, MySQL
I recently had to do some customer work involving the McAfee MySQL Audit Plugin and would like to share my experience in this post. Auditing user activity in MySQL has traditionally been challenging. Most data can be obtained from the slow or general log, but this...
by Hrvoje Matijakovic | May 22, 2013 | MySQL, Percona Software
Percona is glad to announce the release of Percona XtraBackup 2.1.3 for MySQL on May 22, 2013. Downloads are available from our download site here and Percona Software Repositories. This release fixes a high priority bug. It’s advised to upgrade your latest 2.1...
by Peter Zaitsev | May 22, 2013 | MySQL
Portland is a well-recognized hub for Open Source technologies in the Northwest, home to conferences such as OSCON and Open Source Bridge as well as hosts of OpenSQL Camp in 2009. As such it is a very natural place for our next Percona MySQL University event scheduled...
by Justin Swanhart | May 22, 2013 | Benchmarks, MySQL
This blog post is part two in what is now a continuing series on the Star Schema Benchmark. In my previous blog post I compared MySQL 5.5.30 to MySQL 5.6.10, both with default settings using only the InnoDB storage engine. In my testing I discovered that...
by Stephane Combaudon | May 21, 2013 | MySQL
Global Transactions Identifiers are one of the new features regarding replication in MySQL 5.6. They open up a lot of opportunities to make the life of DBAs much easier when having to maintain servers under a specific replication topology. However you should keep in...
by Bill Karwin | May 20, 2013 | MySQL, Webinars
Next Friday, May 31 at 10 a.m. Pacific, I’ll present Percona’s next webinar, “SQL Query Patterns, Optimized.” Based on my experiences solving tough SQL problems for Percona training and consulting, I’ll classify several common types of...
by Hrvoje Matijakovic | May 18, 2013 | MySQL, Percona Software
Percona is glad to announce the release of Percona XtraBackup 2.1.2 for MySQL on May 18, 2013. Downloads are available from our download site here and Percona Software Repositories. This release fixes number of high-priority bugs since version 2.1 became GA. It’s...
by Ernie Souhrada | May 17, 2013 | Benchmarks, Hardware and Storage, MySQL
This is the second part in a two-part series comparing Virident’s vCache to FlashCache. The first part was focused on usability and feature comparison; in this post, we’ll look at some sysbench test results. Disclosure: The research and testing conducted...
by Ernie Souhrada | May 16, 2013 | Benchmarks, Hardware and Storage, MySQL
(This is part one of a two part series) Over the past few weeks I have been looking at a preview release of Virident’s vCache software, which is a kernel module and set of utilities designed to provide functionality similar to that of FlashCache. In particular,...
by Tim.Callaghan | May 15, 2013 | MySQL
I finally posted a copy of the slides from my Percona Live presentation, “Creating a Benchmarking Infrastructure that Just Works”. The PDF is available via this link. The content comes from my personal experiences over many years benchmarking and testing...
by Hrvoje Matijakovic | May 15, 2013 | MySQL, Percona Software
Percona is glad to announce the release of Percona XtraBackup 2.1.1 on May 15th 2013. Downloads are available from our download site here and Percona Software Repositories. Percona XtraBackup enables backups without blocking user queries, making it ideal for companies...
