New & Featured Articles
Blog articles, announcements, news, updates and more
August 9, 2024
Improve the Security of a Percona Server for MongoDB Deployment with KMIP Key State Polling
Data-at-rest encryption (also known as transparent data encryption or TDE) is a necessary mechanism for ensuring the security of a [...]
MOST RECENT ARTICLES
August 8, 2024
MySQL Router and RestAPI – What Do They Have in Common?
The usage of MySQL Router as a Middleware/Proxy/Router has increased along with the rise in MySQL InnoDB Cluster usage. While [...]
August 7, 2024
Open Source AI Database Agent Part 2: OSADA
In the first part of this series, we built a basic AI-powered database agent. Now, it’s time to make a [...]
August 6, 2024
Dispelling Myths About PostgreSQL Default Privileges
The ALTER DEFAULT PRIVILEGES command allows us to set the privileges that will be applied to objects created in the [...]
August 5, 2024
Open Source AI Database Agent Part 1: Introduction
Generative AI is top of mind for many engineers. The questions of how it can be applied to solve business [...]
August 5, 2024
How to Upgrade MongoDB Using Backups Through Many Major Versions
Companies use specific database versions because they’re proven performers or because it’s hard to keep up with frequent releases. But [...]
August 2, 2024
Update Your Percona Release Repository (Or Start Using It!)
We published a blog a few months back about incorporating telemetry into our core database products. My colleague, Bartek, did [...]
Want to get weekly updates listing the latest blog posts?
Subscribe now and we'll send you an update every Friday at 1pm ET.
July 25, 2024
Severe Instability of MySQL 8.0.38, 8.4.1 and 9.0 Resolved in Upcoming Releases
A couple of weeks ago, my colleague Marco Tusa published an important announcement titled “Do Not Upgrade to Any Version [...]
July 22, 2024
Online Schema Changes on Tables with Foreign Keys in MySQL
pt-online-schema-change is an amazing tool for assisting in table modifications in cases where ONLINE ALTER is not an option. But [...]
July 19, 2024
MySQL 9.0 Includes a New Option for Explaining Queries
MySQL 9.0 is an Innovation Release, but as you may have read in my Quick Peek, I found little innovation. [...]
July 19, 2024
How to Monitor Valkey/Redis with Percona Monitoring and Management
In this blog post, we will show you how to add external exporters to Percona Monitoring and Management (PMM) and [...]
July 18, 2024
How to Have a Single MySQL User Account From Specific Hosts
In this article, we will demonstrate how to have a single MySQL database user account that can connect from specific [...]
July 17, 2024
Using Compact in Percona Server for MongoDB From Version 4.4+
In the previously posted blog, Compaction in Percona Server for MongoDB (PSMDB), we discussed how compact works before version 4.4. [...]
July 17, 2024
Ultimate Guide to Improving MySQL Query Performance
MySQL is certainly a powerful open source database management system, but even the most robust engine struggles when queries take [...]
July 16, 2024
No MySQL 9.x Innovation Releases from Percona
On July 1st, 2024, Oracle launched MySQL 9.0.0, the first release in the 9.x series. This release and the following [...]
July 15, 2024
Using pt-online-schema-change for Purging Rows and Reclaiming Disk Space in a Single Operation
You probably missed the news, but… PT-1751: Adds –where param to pt-online-schema-change This brings the possibility to perform what I [...]
July 15, 2024
Percona Server for MySQL and Percona XtraBackup Now Available for ARM64
We’re excited to announce that both Percona Server for MySQL and Percona XtraBackup now support the ARM64 architecture on Red [...]
July 12, 2024
Using the Percona Audit Logging Plugin on MySQL Community 8.0.x
At Percona Managed Services, we manage Percona MySQL, Community MySQL, and MariaDB. Sometimes, we might need to enable audit logging [...]
July 11, 2024
Key Metrics and Tools for Effective PostgreSQL Monitoring
Running a high-performance, reliable PostgreSQL database is crucial for any business and application. However, as workloads grow and database environments [...]