Featured
MySQL 5.7
Support
Compare Percona to Leading Database Solutions
Percona Products
Percona Services
Use Cases
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-696e6f69de8a9287902437-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 [...]
January 9, 2016
ordering_operation: EXPLAIN FORMAT=JSON knows everything about ORDER BY processing
We’ve already discussed using the ORDER BY clause with subqueries. You can also, however, use the [crayon-696e6f69e0636126401858-i/] clause with sorting results of one of [...]
January 7, 2016
Apache Spark with Air ontime performance data
There is a growing interest in Apache Spark, so I wanted to play with it (especially after Alexander Rubin’s Using Apache Spark post). To start, [...]
January 4, 2016
grouping_operation, duplicates_removal: EXPLAIN FORMAT=JSON has all details about GROUP BY
In the previous blog post, we discussed the [crayon-696e6f69e2234514924908-i/] member (which is child of [crayon-696e6f69e223b400390498-i/]). Let’s now focus on the [crayon-696e6f69e223e125755405-i/] and [...]
December 29, 2015
2016 Percona Live Tutorials Schedule is UP!
We are excited to announce that the tutorial schedule for the Percona Live Data Performance Conference 2016 is up! The schedule [...]
December 29, 2015
EXPLAIN FORMAT=JSON: order_by_subqueries, group_by_subqueries details on subqueries in ORDER BY and GROUP BY
Another post in the EXPLAIN FORMAT=JSON is Cool! series! In this post, we’ll discuss how the EXPLAIN FORMAT=JSON provides optimization details for [crayon-696e6f69e318f866727933-i/] and [crayon-696e6f69e3195267559276-i/] operations in [...]
December 28, 2015
EXPLAIN FORMAT=JSON provides insights on optimizer_switch effectiveness
The EXPLAIN FORMAT=JSON is Cool! series showed an example of the query [crayon-696e6f69e40a5511282283-i/], where the subquery was materialized into a temporary table [...]