Featured
MySQL 5.7
Support
Compare Percona to Leading Database Solutions
Percona Products
Percona Services
Use Cases
March 21, 2017
Dropping the Foreign Key Constraint Using pt-online-schema-change
In this blog post, we’ll look at how to get rid of the unused Foreign Key (FK) constraint and/or related columns/keys with [...]
March 20, 2017
Prophet: Forecasting our Metrics (or Predicting the Future)
In this blog post, we’ll look at how Prophet can forecast metrics. Facebook recently released a forecasting tool called Prophet. [...]
March 17, 2017
Percona XtraDB Cluster 5.7.17-27.20 is now available
Percona announces the release of Percona XtraDB Cluster 5.7.17-27.20 on March 16, 2017. Binaries are available from the downloads section [...]
March 15, 2017
Upgrading to Percona Server for MongoDB 3.4 from Previous Versions
This post is another in the series on the Percona Server for MongoDB 3.4 bundle release. In this blog post, [...]
March 15, 2017
How to Restore a Single InnoDB Table from a Full Backup After Accidentally Dropping It
In this blog post, we’ll look at how to restore a single InnoDB table from a full backup after dropping [...]
March 13, 2017
Percona XtraDB Cluster 5.6.35-26.20 is now available
Percona announces the release of Percona XtraDB Cluster 5.6.35-26.20 on March 10, 2017. Binaries are available from the downloads section [...]
March 7, 2017
How to Change MongoDB Storage Engines Without Downtime
This blog is another in the series for the Percona Server for MongoDB 3.4 bundle release. Today’s blog post is [...]
March 6, 2017
Improving TokuDB Hot Backup Usage with the autotokubackup Command Line Tool
In this blog post, we’ll look at how the command line tool autotokubackup can make TokuDB hot backups easier. I [...]
March 6, 2017
MySQL, –i-am-a-dummy!
In this blog post, we’ll look at how “operator error” can cause serious problems (like the one we saw last [...]
February 24, 2017
Synchronous Replication in MySQL: Galera vs. Group Replication
UPDATE: Some of the language in the original post was considered overly-critical of Oracle by some community members. This was [...]
February 15, 2017
Group Replication: Shipped Too Early
This blog post is my overview of Group Replication technology. With Oracle clearly entering the “open source high availability solutions” [...]
February 15, 2017
Docker Images for Percona Server for MySQL Group Replication
In this blog post, we’ll point to a new Docker image for Percona Server for MySQL Group Replication. Our most [...]
February 9, 2017
Using NVMe Command Line Tools to Check NVMe Flash Health
In this blog post, I’ll look at the types of NVMe flash health information you can get from using the [...]
February 8, 2017
MySQL super_read_only Bugs
This blog we describe an issue with MySQL 5.7’s super_read_only feature when used alongside with GTID in chained slave instances. Background In [...]
February 1, 2017
WAN Synchronous Clusters: Dealing with Latency Using Concurrency
In this blog, we’ll discuss how to use concurrency to help with WAN latency when using synchronous clusters. WAN Latency [...]
January 30, 2017
MySQL Sharding Models for SaaS Applications
In this blog post, I’ll discuss MySQL sharding models, and how they apply to SaaS application environments. MySQL is one [...]
January 27, 2017
When MySQL Lies: Wrong seconds_behind_master with slave_parallel_workers > 0
In today’s blog, I will show an issue with seconds_behind_master that one of our clients faced when running slave_parallel_workers > 0. We [...]
January 26, 2017
Percona Live Featured Tutorial with Frédéric Descamps — MySQL InnoDB Cluster & Group Replication in a Nutshell: Hands-On Tutorial
Welcome to another post in the series of Percona Live featured tutorial speakers blogs! In these blogs, we’ll highlight some of [...]
January 19, 2017
Setup ProxySQL for High Availability (not a Single Point of Failure)
In this blog post, we’ll look at how to set up ProxySQL for high availability. During the last few months, [...]