Featured
MySQL 5.7
Support
Compare Percona to Leading Database Solutions
Percona Products
Percona Services
Use Cases
April 26, 2023
Open Source Software Security: Is Open Source Software Safe?
Even though open source software is firmly in the mainstream, used widely by businesses, governments, and everyone who owns a [...]
April 17, 2023
Percona Monitoring and Management and Datadog Integration
So your company is using Datadog on the global level. Still, as DBA, you want to use Percona Monitoring and [...]
April 4, 2023
MySQL 5.7 Upgrade Issue: Reserved Words
MySQL 5.7 reaches End of Life status this October. If you still need to start your migration, time is getting [...]
March 24, 2023
A Workaround for The “RELOAD/FLUSH_TABLES privilege required” Problem When Using Oracle mysqldump 8.0.32
In MySQL Server 8.0.32, Oracle fixed Bug #105761: “mysqldump make a non-consistent backup with ‐‐single-transaction option” (this commit) which caused [...]
March 24, 2023
Replication Issues and Binlog Compressor
You might want to use binlog compression with MySQL/Percona Server for MySQL, but it can come with drawbacks. This article [...]
March 8, 2023
Dealing With “Too Many Connections” Error in MySQL 8
Over the years of being a DBA, I had to deal with all kinds of problems in the database. One [...]
February 2, 2023
An Argument for Logical Failover Slots
These days, the typical PostgreSQL cluster consists not only of a multi-node replication cluster, which is ordinarily an asynchronous streaming [...]
December 23, 2022
Diffing PostgreSQL Schema Changes
One of the routine operations when administering PostgreSQL is periodic updates to the database system’s architecture. PostgreSQL does a good [...]
December 8, 2022
Percona Live 2023 Call For Papers Open!
Percona Live 2023 will be in Denver Colorado May 22nd through the 24th. This is the premier open source database [...]
December 2, 2022
Using Liquibase as a Solution for Deploying and Tracking MySQL Schema Changes
Database-as-code service is a new concept and gaining some popularity in recent years. As we already know, we have deployment [...]
November 18, 2022
Root Cause Analysis in Quality Engineering
In software development, dealing with bugs found by customers is inevitable. There is no perfect software. We’ve all been there: [...]
November 16, 2022
How to Generate Test Data for MongoDB With Python
For testing purposes, especially if you’re working on a project that uses any database technology to store information, you may [...]
November 15, 2022
PMM v2.32: Backup Management for MongoDB in GA, New Home Dashboard, and More!
We are pleased to announce the general availability of the Backup Management for MongoDB and other improvements in Percona Monitoring [...]
November 9, 2022
MySQL: Using UNION, INTERSECT, & EXCEPT
MySQL 8.0.31 added INTERSECT and EXCEPT to augment the long-lived UNION operator. That is the good news. The bad news [...]
November 4, 2022
PostgreSQL: Are All NULLs the Same?
I was recently reading the PostgreSQL 15 release notes and stopped at “Allow unique constraints and indexes to treat NULL [...]
November 3, 2022
WHAT IF… The User Exists on the Replica and Not in the Primary? (Or Any Other Objects?)
Hey folks, This blog is straightforward but, at the same time, handy. At Percona, we know that the audience of [...]
November 2, 2022
Set Theory in MySQL 8.0: UNION and Now INTERSECT and EXCEPT
Are you familiar with the UNION statement for your SQL queries? Most likely, you are. It has been supported for [...]
November 2, 2022
First PostgreSQL Conference Ever: What You’ve Missed at PGConf.EU 2022
I just became part of the PostgreSQL ecosystem and was really curious to get in touch with the community. What [...]
October 12, 2022
A Quick Peek at MySQL 8.0.31
Oracle releases updates to MySQL on a quarterly basis and the Release Notes for 8.0.31 arrived just before the software. [...]
October 5, 2022
When Manipulating MySQL User Tables Goes Wrong: Troubleshooting ERROR 1396
A few weeks back, we faced an issue in a replication environment for a Managed Services client: LAST_ERROR_MESSAGE: Worker 2 [...]