by Stephane Combaudon | Aug 20, 2014 | Insight for DBAs, MySQL, Percona Services, Webinars
Reconfiguring replication has always been a challenge with MySQL. Each time the replication topology has to be changed, the process is tedious and error-prone because finding the correct binlog position is not straightforward at all. Global Transaction IDs (GTIDs)...
by Daniel Nichter | Aug 19, 2014 | Cloud, Insight for DBAs, MySQL, Percona Software
It’s been three months since we announced anything for Percona Cloud Tools, not because we’ve been idle but because we’ve been so busy the time flew by! Here’s the TL;DR to pique your interest: EXPLAIN queries in real-time through the web app Query Analytics for...
by Peter Boros | Aug 19, 2014 | Benchmarks, Insight for DBAs, MySQL, Percona Services, Percona Software
ScaleArc hired Percona to benchmark failover times for the ScaleArc database traffic management software in different scenarios. We tested failover times for various clustered setups, where ScaleArc itself was the load balancer for the cluster. These tests complement...
by Yves Trudeau | Aug 18, 2014 | Insight for DBAs, MySQL
Like you all may know, OpenStack is currently one of the coolest open source projects, so I was thrilled when I was asked to manage the deployment of an OpenStack lab for internal Percona use. Starting from basically zero, I created tasks in our Jira and assigned them...
by Tom Diederich | Aug 15, 2014 | Insight for DBAs, Insight for Developers, MySQL, Percona Events, Percona Live
Twice each year members of the global open-source community converge on London in November and Santa Clara in April to network with, and learn from, some of the world’s most experienced and accomplished system architects, developers and DBAs. And now it’s time for YOU...
by Peter Boros | Aug 12, 2014 | Benchmarks, Insight for DBAs, MySQL
Diablo Technologies engaged Percona to benchmark IBM eXFlash™ DIMMs in various aspects. An eXFlash™ DIMM itself is quite an interesting piece of technology. In a nutshell, it’s flash storage, which you can put in the memory DIMM slots. Enabled by Diablo’s Memory...
by Hrvoje Matijakovic | Aug 8, 2014 | MySQL, Percona Events, Percona Software
The Percona team is pleased to announce the Release Candidate for Percona Software packages for Red Hat Enterprise Linux 7 and CentOS 7. With more than 1 million downloads and thousands of production deployments at small, mid-size and large enterprises, Percona...
by Hrvoje Matijakovic | Aug 8, 2014 | MySQL, Percona Events, Percona Software
Percona is glad to announce the release of Percona Toolkit 2.2.10 on August 8, 2014 (downloads are available here and from the Percona Software Repositories). This release is the current GA (Generally Available) stable release in the 2.2 series. Bugs Fixed: Fixed bug...
by Zardosht.Kasheff | Aug 7, 2014 | MySQL
This is the fourth post in a series of posts that explains Ark, a consensus algorithm we’ve developed for TokuMX and MongoDB to fix known issues in elections and failover. The tech report we released describes the algorithm in full detail. These posts are a layman’s...
by Rich.Prohaska | Aug 6, 2014 | MySQL
Covering indexes can result in orders of magnitude performance improvements for queries. Bradley’s presentation on covering indexes describes what a covering index is, how it can effect performance, and why it works. However, the definition of a covering index...
by Yves Trudeau | Aug 5, 2014 | Insight for DBAs, MySQL
Percona Replication Manager (PRM) continues to evolve and improve, I want to introduce two new features: Slave resync and Async stop. Slave resync This behavior is for regular non-gtid replication. When a master crashes and is no longer available, how do we make sure...
by Fernando Ipar | Aug 4, 2014 | Insight for DBAs, MySQL, Webinars
Martin Arrieta and I gave an online presentation last week on “Putting MySQL Fabric To Use.” If you missed it, you can find a recording and the slides here, and the vagrant environment we used plus a transcript of the commands we ran here (be sure to check...
by Alexander Rubin | Aug 4, 2014 | Insight for DBAs, MySQL, Webinars
I will be presenting two webinars in August: Aug 6, 10 a.m. PDT: Advanced Query Tuning in MySQL 5.6 and Beyond Aug 13, 10 a.m. PDT: Using Performance Schema to Monitor and Troubleshoot MySQL 5.6 This Wednesday’s webinar on advanced MySQL query tuning will be...
by Dave Rosenlund | Aug 1, 2014 | MySQL
Tokutek is pleased to announce the formation of two new TokuMX Bay Area Meetup Groups, as well as each group’s inaugural meet up event. These groups are for anyone who’s interested in delivering high-performance big data applications built with the...
by Matt Griffin | Aug 1, 2014 | Insight for DBAs, MySQL, Percona Services, Percona Software
MySQL plays a critical role in OpenStack. It serves as the host database supporting most components such as Nova, Glance, and Keystone and is the most mature guest database in Trove. Many OpenStack operators use Percona open source software including the MySQL drop-in...
by Frederic Descamps | Jul 31, 2014 | MariaDB, MySQL, Percona Software
In the first post in a series on MariaDB features we find interesting, we begin with selectively skipping replication of binlog events. This feature is available on MariaDB 5.5 and 10. By default when using MySQL’s standard replication, all events are logged in...
by Hrvoje Matijakovic | Jul 31, 2014 | MySQL, Percona Events, Percona Software
Percona is glad to announce the release of Percona Server 5.1.73-14.12 on July 31st, 2014 (Downloads are available here and from the Percona Software Repositories). Based on MySQL 5.1.73, including all the bug fixes in it, Percona Server 5.1.73-14.12 is now the...
by Peter Zaitsev | Jul 30, 2014 | Insight for DBAs, MySQL
As we know different storage engines in MySQL have different file structures. Every table in MySQL 5.6 must have a .frm file in the database directory matching the table name. But where the rest of the data resides depends on the storage engine. For MyISAM we have...
by Zardosht.Kasheff | Jul 30, 2014 | MySQL
This is the third post in a series of posts that explains Ark, a consensus algorithm we’ve developed for TokuMX and MongoDB to fix known issues in elections and failover. The tech report we released last week describes the algorithm in full detail. These posts are a...
by Peter Zaitsev | Jul 29, 2014 | Insight for DBAs, MySQL
One of the common causes of downtime with MySQL is running out of connections. Have you ever seen this error? “ERROR 1040 (00000): Too many connections.” If you’re working with MySQL long enough you surely have. This is quite a nasty error as it...
