Featured
MySQL 5.7
Support
Compare Percona to Leading Database Solutions
Percona Products
Percona Services
Use Cases
June 20, 2016
Webinar Thursday June 23: Choosing a MySQL High Availability Solution Today
Please join Percona, Technical Account Manager, Michael Patrick on Thursday, June 23, 2016 at 10 AM PDT (UTC-7) as he [...]
May 24, 2016
pt-online-schema-change (if misused) can’t save the day
In this blog post we’ll discuss pt-online-schema-change, and how to correctly use it. Always use pt-osc? Altering large tables can be [...]
May 23, 2016
Take Percona’s one-click high availability poll
Wondering what high availability (HA) solutions are most popular? Take our high availability poll below! HA is always a hot [...]
May 20, 2016
Introduction to Troubleshooting Performance – Troubleshooting Slow Queries webinar: Q & A
In this blog, I will provide answers to the Q & A for the Troubleshooting Slow Queries webinar. First, I want to [...]
May 19, 2016
Webinar Tuesday, May 24: Understanding how your MongoDB schema affects scaling, and when to consider sharding for help
Please join David Murphy on Tuesday, May 24 at 10 am PDT (UTC-7) as he presents “Understanding how your MongoDB [...]
April 26, 2016
How We Made MySQL Great Again, or Upgrading MySQL with Orchestrator
In this blog post, we’ll discuss upgrading MySQL with Orchestrator. I recently had a client, Life360, that wanted to upgrade from [...]
April 13, 2016
Orchestrator-agent: How to recover a MySQL database
In our previous post, we showed how Orchestrator can handle complex replication topologies. Today we will discuss how the Orchestrator-agent complements Orchestrator by [...]
April 6, 2016
EXPLAIN FORMAT=JSON wrap-up
This blog is an EXPLAIN FORMAT=JSON wrap-up for the series of posts I’ve done in the last few months. In [...]
March 30, 2016
Docker MySQL Replication 101
In this blog post, we’ll discuss some of the basics regarding Docker MySQL replication. Docker has gained widespread popularity in recent [...]
March 29, 2016
Read-write split routing in MaxScale
In this blog post, we’ll discuss read-write split routing in MaxScale. The two previous posts have shown how to setup high [...]
March 9, 2016
Evaluating Database Compression Methods
NOTE: This blog post contains some mistakes in data. While many of our conclusions are still valid, we’ve updated the [...]
March 8, 2016
Orchestrator: MySQL Replication Topology Manager
This blog post discusses Orchestrator: MySQL Replication Topology Manager. What is Orchestrator? Orchestrator is a replication topology manager for MySQL. [...]
March 2, 2016
How MaxScale monitors servers
In this post, we’ll address how MaxScale monitors servers. We saw in the We saw in the previous post how [...]
February 29, 2016
EXPLAIN FORMAT=JSON: nested_loop makes JOIN hierarchy transparent
Once again it’s time for another EXPLAIN FORMAT=JSON is cool! post. This post will discuss how EXPLAIN FORMAT=JSON allows the [...]
February 25, 2016
High availability with asynchronous replication… and transparent R/W split
In this post, the first one of a Maxscale series, I describe how to use MariaDB’s MaxScale and MySQL-utilities with [...]
February 22, 2016
EXPLAIN FORMAT=JSON: cost_info knows why optimizer prefers one index to another
Time for another entry in the EXPLAIN FORMAT=JSON is cool! series of blog posts. This time we’ll discuss how using [...]
February 9, 2016
EXPLAIN FORMAT=JSON: buffer_result is not hidden!
Time for another entry in the EXPLAIN FORMAT=JSON is cool! series. Today we’re going to look at how you can [...]
January 29, 2016
EXPLAIN FORMAT=JSON knows everything about UNIONs: union_result and query_specifications
Ready for another post in the EXPLAIN FORMAT=JSON is Cool series! Great! This post will discuss how to see all [...]
January 25, 2016
EXPLAIN FORMAT=JSON has details for subqueries in HAVING, nested selects and subqueries that update values
Over several previous blog posts, we’ve already discussed what information the [crayon-68dd1d3f20d7c622580801-i/] output provides for some subqueries. You can review those discussions here, [...]
January 15, 2016
Making Apache Spark Four Times Faster
This is a followup to my previous post Apache Spark with Air ontime performance data. To recap an interesting point [...]