Featured
MySQL 5.7
Support
Compare Percona to Leading Database Solutions
Percona Products
Percona Services
Use Cases
February 26, 2018
MySQL Single Table Point-In-Time Recovery
In this blog post, I’ll look at how to execute a MySQL single table Point-In-Time Recovery. I recently wrote a [...]
February 26, 2018
Percona XtraDB Cluster 5.6.39-26.25 Is Now Available
Percona announces the release of Percona XtraDB Cluster 5.6.39-26.25 (PXC) on February 26, 2018. Binaries are available from the downloads [...]
February 22, 2018
How to Restore MySQL Logical Backups
The ability to restore MySQL logical backups is a significant part of disaster recovery procedures. It’s a last line of [...]
February 22, 2018
Percona Live 2018 Featured Talk – Scaling a High-Traffic Database: Moving Tables Across Clusters with Bryana Knight
Welcome to the first interview blog for the upcoming Percona Live 2018. Each post in this series highlights a Percona Live [...]
February 19, 2018
Archiving MySQL Tables in ClickHouse
In this blog post, I will talk about archiving MySQL tables in ClickHouse for storage and analytics. Why Archive? Hard drives [...]
February 13, 2018
Want IST Not SST for Node Rejoins? We Have a Solution!
What if we tell you that there is a sure way to get IST not SST for node rejoins? You [...]
February 12, 2018
Webinar Thursday, February 15, 2018: Basic Internal Troubleshooting Tools for MySQL Server
Please join Percona’s Principal Support Engineer, Sveta Smirnova, as she presents “Basic Internal Troubleshooting Tools for MySQL Server” on Thursday, [...]
February 9, 2018
This Week in Data with Colin Charles 27: Percona Live Tutorials Released and a Comprehensive Review of the FOSDEM MySQL DevRoom
Join Percona Chief Evangelist Colin Charles as he covers happenings, gives pointers and provides musings on the open source database community. [...]
February 8, 2018
Fsync Performance on Storage Devices
While preparing a post on the design of ZFS based servers for use with MySQL, I stumbled on the topic [...]
February 8, 2018
Tutorial Schedule for Percona Live 2018
Percona has revealed the line-up of in-depth tutorials for the Percona Live 2018 Open Source Database Conference, taking place April 23-25, [...]
February 7, 2018
ProxySQL Query Cache: What It Is, How It Works
In this blog post, I’ll present the ProxySQL query cache functionality. This is a query caching mechanism on top of [...]
February 5, 2018
Four Ways MySQL Executes GROUP BY
In this blog post, I’ll look into four ways MySQL executes GROUP BY. In my previous blog post, we learned that [...]
February 2, 2018
This Week in Data with Colin Charles 26: Percona Live Schedule is Near Completion, FOSDEM Underway and a Percona Toolkit Use Case
Join Percona Chief Evangelist Colin Charles as he covers happenings, gives pointers and provides musings on the open source database community. [...]
January 31, 2018
Aurora Hash Join Optimization (with a Gentle Reminder on Lab Features)
The Aurora hash join feature for relational databases has been around for a while now. But unlike MySQL Block Nested [...]
January 30, 2018
MySQL Query Performance: Not Just Indexes
In this blog post, I’ll look at whether optimizing indexing is always the key to improving MySQL query performance (spoiler, it isn’t). [...]
January 29, 2018
Using MySQL 5.7 Generated Columns to Increase Query Performance
In this blog post, we’ll look at ways you can use MySQL 5.7 generated columns (or virtual columns) to improve [...]
January 26, 2018
Percona XtraDB Cluster 5.7.20-29.24 Is Now Available
Percona announces the release of Percona XtraDB Cluster 5.7.20-29.24 (PXC) on January 26, 2018. Binaries are available from the downloads [...]
January 25, 2018
MySQL 8.0 RESOURCE_GROUP Overview
In this blog post, we’ll provide an overview of the new MySQL 8.0 RESOURCE_GROUP feature. One great new feature introduced [...]
January 24, 2018
Percona XtraDB Cluster 5.6.38-26.23 Is Now Available
Percona announces the release of Percona XtraDB Cluster 5.6.38-26.23 (PXC) on January 24, 2018. Binaries are available from the downloads [...]
January 24, 2018
MySQL 8.0.4 RC: auth_socket Users Beware!
The news that the latest MySQL 8.0.4 RC (release candidate) is available is indeed exciting. Unfortunately for users of the [...]