by Jericho Rivera | May 13, 2014 | MySQL, Percona Software
There are a couple of posts about setting up Percona XtraDB Cluster on Vagrant and Percona Server on MySQL Sandbox – those are two of the top tools used by the Percona Support team for testing and bug processing among other things. In this post, however, I will...
by Peter Zaitsev | May 12, 2014 | Insight for DBAs, MySQL, Webinars
Achieving the best possible MySQL Performance doesn’t have to be complicated. It’s all about knowing which tools are designed for the task at hand – along with some basic (yet often overlooked) best practices. Join me Wednesday, May 14 at 10 a.m....
by Dave Rosenlund | May 9, 2014 | MySQL
Background: If you did not read my first blog post about why I am sharing my thoughts on the benchmarks published by Mark Callaghan on Small Datum you may want to skim through it now for a little context: “Thoughts on Small Datum – Part 1”...
by Stephane Combaudon | May 9, 2014 | Insight for DBAs, MySQL
One of the MySQL 5.6 features many people are interested in is Global Transactions IDs (GTIDs). This is for a good reason: Reconnecting a slave to a new master has always been a challenge while it is so trivial when GTIDs are enabled. However, using GTIDs is not only...
by Hrvoje Matijakovic | May 8, 2014 | MySQL, Percona Events, Percona Software
Percona is glad to announce the release of Percona XtraDB Cluster 5.5.37-25.10 on May 8, 2014. Binaries are available from the downloads area or from our software repositories. Based on Percona Server 5.5.37-35.0 including all the bug fixes in it, Galera Replicator...
by Jay Janssen | May 8, 2014 | MySQL, Percona Software
Overview Percona XtraDB Cluster 5.6 has been GA for several months now and people are thinking more and more about moving from 5.5 to 5.6. Most people don’t want to upgrade all at once, but would prefer a rolling upgrade to avoid downtime and ensure 5.6 is...
by Hrvoje Matijakovic | May 8, 2014 | MySQL, Percona Events, Percona Software
Percona is glad to announce the release of Percona XtraBackup 2.2.2-beta1 on May 8th 2014. Downloads are available from our download site here. This BETA release, will be available in our Debian experimental and CentOS testing repositories. This is a BETA quality...
by Dave Rosenlund | May 7, 2014 | MySQL
NoSQL time-series applications built with MongoDB frequently need to remove expired or unwanted data. This is especially true in the world of big data. Sub-optimization in this area leads to unnecessary database growth and decreased performance. In addition, the Time...
by Alexander Rubin | May 7, 2014 | Insight for DBAs, MySQL, Percona Software
The new Percona Server 5.5.37-35.0 and Percona Server 5.6.17-65.0-56, announced yesterday (May 6), both include the open source version of the MySQL Audit Plugin. The MySQL Audit Plugin is used to log all queries or connections (“audit” MySQL usage). Until...
by Hrvoje Matijakovic | May 7, 2014 | MySQL, Percona Events, Percona Software
Percona is glad to announce the release of Percona XtraBackup 2.1.9 on May 7th, 2014. 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.1 series. Percona...
by Hrvoje Matijakovic | May 6, 2014 | MySQL, Percona Events, Percona Software
Percona is glad to announce the release of Percona Server 5.6.17-65.0 on May 6th, 2014. Downloads are available
by Hrvoje Matijakovic | May 6, 2014 | Percona Events, Percona Software
Percona is glad to announce the release of Percona Server 5.5.37-35.0 on May 6th, 2014 (Downloads are available here and from the Percona Software Repositories). Based on MySQL 5.5.37, including all the bug fixes in it, Percona Server 5.5.37-35.0 is now the current...
by Jay Janssen | May 6, 2014 | MySQL, Percona Software
Whither your rollback plan? MySQL 5.6 upgrades are in full swing these days and knowing how to safely upgrade from MySQL 5.5 to 5.6 is important. When upgrading a replication environment, it’s important that you can build a migration plan that safely allows for...
by Yves Trudeau | May 5, 2014 | Insight for DBAs, MySQL
by Daniel Nichter | May 5, 2014 | Insight for DBAs, MySQL, Percona Software, Webinars
Tools for MySQL are a vital part of any deployment, so it’s important to use ones that are reliable and well-designed. Percona Toolkit is a collection of more than 30 command-line tools for MySQL, Percona Server, and MariaDB that can help database administrators...
by Muhammad Irfan | May 2, 2014 | Insight for DBAs, MySQL
Here on the Percona MySQL Support team, we often see issues where a customer is complaining about replication delays – and many times the problem ends up being tied to MySQL replication slave lag. This, of course, is nothing new for MySQL users and we’ve...
by Dave Rosenlund | May 1, 2014 | MySQL
The title of this post should really be, “Maybe He Should Try Taking a Walk in Your Shoes.” The he I’m referring to is economist and author, Tim Harford. The you is the people who use NewSQL and NoSQL approaches to mine big data with database platforms...
by Justin Swanhart | May 1, 2014 | Insight for DBAs, MySQL
While Shard-Query can work over multiple nodes, this blog post focuses on using Shard-Query with a single node. Shard-Query can add parallelism to queries which use partitioned tables. Very large tables can often be partitioned fairly easily. Shard-Query can...
by Hrvoje Matijakovic | Apr 30, 2014 | MySQL, Percona Software
Galera 3.5 improvements are now available for use with Percona XtraDB Cluster 5.6. Bugs fixed in Galera 3.5 include: A crash due to of-by-one error in certification index cleanup has been fixed. Bugs fixed #1309227 and #1267507. Fixed the corruption in gcache that...
by Peter Boros | Apr 29, 2014 | Benchmarks, Insight for DBAs, MySQL
ScaleArc recently hired Percona to perform various tests on its database traffic management product. This post is the outcome of the benchmarks carried out by me and ScaleArc co-founder and chief architect, Uday Sawant. The goal of this benchmark was to identify...
