Monthly Archives - October 2015

Percona Welcomes David Murphy as Practice Manager for MongoDB

We are excited this week to welcome David Murphy to Percona as our Practice Manager for MongoDB®. A veteran of ObjectRocket, Electronic Arts, and Rackspace, David is a welcome addition to our team and will provide vision, direction and best practices for all things MongoDB. David also has an extensive background in MySQL and […]

Read more

MySQL 101 Videos – A Must Have Starter Kit for a MySQL DBA

The MySQL 101 track was introduced at the 2015 Percona Live MySQL Conference & Expo in Santa Clara, California. This track was tailored specifically for software developers and other specialists with technical backgrounds wanting to acquire the basic skills needed for a MySQL DBA role. The Percona Live Conference Committee saw an increase in demand […]

Read more

Gartner, Thank You for Recognizing Percona in the Magic Quadrant for ODBMS!

But mostly thank you to our customers who said more about Percona than we ever could have.
There are many milestones in the life of the company, and being included in the Gartner Magic Quadrant is one of very significant ones! I’m very proud we have now reached that milestone and have been recognized as […]

Read more

Proxy Protocol and Percona XtraDB Cluster: A Quick Guide

On September 21st, we released Percona XtraDB Cluster 5.6.25. This is the first PXC release supporting proxy-protocol that has been included in Percona Server since 5.6.25-73.0.
With this blog post, I want to promote a new feature that you may have ignored.
Let’s start with a description of the use case:
Architecture Overview:

HAProxy is configured like this:

Shell

listen 3307-active-passive-writes 0.0.0.0:3307
[…]

Read more

Percona XtraDB Cluster 5.6.26-25.12 is now available

Percona is glad to announce the new release of Percona XtraDB Cluster 5.6 on October 15th 2015. Binaries are available from downloads area or from our software repositories.
Based on Percona Server 5.6.26-74.0 including all the bug fixes in it, Galera Replicator 3.12, and on Codership wsrep API 25.11, Percona XtraDB Cluster 5.6.26-25.12 is now […]

Read more

MySQL query digest with Performance Schema

Data Analysis

Query analysis is a fantastic path in the pursuit to achieve high performance. It’s also probably the most repeated part of a DBA’s daily adventure. For most of us, the weapon of choice is definitely pt-query-digest, which is one of the best tools for slow query analysis out there.
Why not use pt-query-digest? Well, sometimes […]

Read more

When mysqld kills mysqld

The other day a colleague and friend of mine, Peter Boros, had a case where one of our clients had to track down the process shutting down MySQL. This blog is based on the discussion we had about that internally.
Our client wanted Peter to identify the culprit behind periodic shutdowns. This proved to be […]

Read more

Using Apache Spark and MySQL for Data Analysis

What is Spark
Apache Spark is a cluster computing framework, similar to Apache Hadoop. Wikipedia has a great description of it:
Apache Spark is an open source cluster computing framework originally developed in the AMPLab at University of California, Berkeley but was later donated to the Apache Software Foundation where it remains today. In contrast to […]

Read more