Featured
MySQL 5.7
Support
Compare Percona to Leading Database Solutions
Percona Products
Percona Services
Use Cases
April 1, 2021
Working to Validate MyRocks in the Enterprise with Dropbox
Percona Technical Account Managers get the privilege of working with some of our largest enterprise clients day in and day [...]
April 1, 2021
Infinitely Scalable Storage with High Compression Feature
It is no secret that compute and storage costs are the main drivers of cloud bills. Migration of data from [...]
March 31, 2021
Webinar April 14: Optimize and Troubleshoot MySQL Using Percona Monitoring and Management
Optimizing MySQL performance and troubleshooting MySQL problems are two of the most critical and challenging tasks for MySQL DBAs. The [...]
March 31, 2021
MySQL 101: Using super_read_only
As many of you may remember, Percona added the super_read_only feature way back in Percona Server for MySQL 5.6.21, based [...]
March 26, 2021
Overview of MySQL Alternative Storage Engines
For MySQL, MyISAM and InnoDB storage engines are very popular. Currently, we are mostly using InnoDB engines for high reliability [...]
March 25, 2021
The Steps Involved in Creating a Percona Product Release
Have you ever wondered what it takes to complete Percona Server for MySQL (PS), Percona XtraDB Cluster (PXC), and Percona [...]
March 24, 2021
Importing an Encrypted InnoDB Tablespace into MySQL
Transportable tablespaces were introduced in MySQL 5.6. Using this feature, we can directly copy a tablespace to another server and [...]
March 23, 2021
Is a Session Analyzer a Good Tool to Simulate Real Traffic?
Starting a long time ago, we wanted to reproduce workload in a non-production environment, and there were different attempts to [...]
March 23, 2021
CVE-2020-29488: Changes in How Absolute Paths are Handled in Percona XtraBackup xbstream
Due to CVE-2020-29488, Percona XtraBackup is modifying how xbstream handles absolute paths to prevent malicious file injections. Like the tar [...]
March 10, 2021
How to Build Percona Server for MySQL From Sources
Lately, the number of questions about how to build Percona software has been increased. More and more people try to [...]
February 25, 2021
MySQL Monitoring and Reporting Using the MySQL Shell
MySQL Shell is the advanced MySQL client, which has many excellent features. In this blog, I am going to explain [...]
February 24, 2021
Point-In-Time Recovery in Percona Operator for MySQL Based on Percona XtraDB Cluster – Architecture Decisions
Point-In-Time Recovery (PITR) for MySQL databases is an important feature that is essential and covers common use cases, like a [...]
February 16, 2021
MySQL 5.6 and Percona Server for MySQL 5.6 are End of Life
MySQL 5.6.51 is the last release of the MySQL 5.6 series. Oracle will no longer provide updates or security fixes [...]
February 11, 2021
Various Types of InnoDB Transaction Isolation Levels Explained Using Terminal
The goal of this blog post is to explain the various types of transaction isolation levels available in MySQL. After [...]
February 5, 2021
Webinar February 24: What’s Old Is New, What’s Coming Is Here – Percona Offerings for MySQL 5.6 and DBaaS in PMM
Join Brian Walters and Brandon Fleisher for an interactive discussion around new service and software offerings coming from Percona. Oracle [...]
February 3, 2021
Q&A on Webinar “Using PMM to Identify and Troubleshoot Problematic MySQL Queries”
Hi and thanks to all who attended my webinar on Tuesday, January 26th titled Using PMM to Identify & Troubleshoot [...]
January 28, 2021
Load Balancing ProxySQL in AWS
There are several ways to deploy ProxySQL between your applications and the database servers. A common approach is to have [...]
January 27, 2021
Percona XtraBackup 8 Enables –lock-ddl by Default
Percona XtraBackup 8.0.23 enables the “lock-ddl” option by default to ensure any DDL events do not corrupt the backups. Any [...]
January 27, 2021
Deploying Any Version of Leading Open Source Databases for Tests and Experiments
I want to present a tool for running a specific version of open source databases in a single instance, replication [...]
January 21, 2021
Low Value in range_optimizer_max_mem_size Might Cause Full Table Scan
Although how range_optimizer_max_mem_size operates is explained in the official doc, it’s not a well-known variable and surely not a variable [...]