New & Featured Articles
Blog articles, announcements, news, updates and more
April 17, 2024
Switch PostgreSQL Environments Across AWS, GCP, and k3d Using Kubernetes Contexts
This article explains how to install the Percona Distribution for PostgreSQL on Kubernetes using “context”. We will show you how [...]
MOST RECENT ARTICLES
April 16, 2024
Percona Stands Firmly on the Side of Open Source
Percona is proud to formally state our support for the Valkey project and its community. We will soon offer commercial [...]
April 16, 2024
A Guide to Better Understanding MySQL Charset Levels
We usually receive and see some questions regarding the charset levels in MySQL, especially after the deprecation of utf8mb3 and [...]
April 15, 2024
Why SELECT COUNT(*) FROM TABLE Is Sometimes Very Slow in MySQL or MariaDB
If you have enough experience with MySQL, it is very possible that you stumbled upon an unusually slow SELECT COUNT(*) [...]
April 12, 2024
Partially Rolling Back a Transaction in MySQL or PostgreSQL
This short write-up focuses on a different transaction control behavior of databases. Though this is not unusual, I decided to [...]
April 11, 2024
JSON_TABLE() Will Be in PostgreSQL 17
JSON_TABLE() will be in PostgreSQL 17! It almost made it two years ago but was yanked away at the last [...]
April 11, 2024
How to Replicate and Rename a Database in MariaDB
MySQL/MariaDB replication filter is an important feature when we need to replicate only certain databases or tables. Having this configuration [...]
Want to get weekly updates listing the latest blog posts?
Subscribe now and we'll send you an update every Friday at 1pm ET.
April 10, 2024
MongoDB 4.4 EOL with 5.0 Not Far Behind
February 2024 marked the end of life (EOL) of MongoDB 4.4. Another year, another EOL, is a fitting summary. Time [...]
April 10, 2024
Juan Arruti and Agustín
Percona Monitoring and Management Setup on Kubernetes with NGINX Ingress for External Databases
It’s a common scenario to have a Percona Monitoring and Management (PMM) server running on Kubernetes and also desire to [...]
April 9, 2024
Ask Me Anything About MySQL 5.7 to 8.0 Post EOL
We met with Vinicius Grippa, a Senior Support Engineer at Percona. He is also active in the open source community [...]
April 9, 2024
Protect Your PostgreSQL Database with pg_tde: Safe and Secure
Tech Preview release of pg_tde now available As organizations collect, store, and analyze vast amounts of data, ensuring its confidentiality [...]
April 5, 2024
Querying Percona Operator for MongoDB Logs Using LogCLI
With all the convenience Kubernetes operators provide in managing resources, it can still be a challenge to conveniently store, query, [...]
April 5, 2024
Best Practices for PostgreSQL Migration
PostgreSQL’s reputation as a powerful, open source database management system has been steadily rising, making it a top choice for [...]
April 4, 2024
Percona Backup for MongoDB: Restore a Single Collection From Backup
When you design a backup strategy, you need to think about the business requirements, as you will need to shape [...]
April 3, 2024
Foreign Data Wrappers in PostgreSQL Databases (postgres_fdw & dblink)
A Foreign Data Wrapper (FDW) is a feature in database management systems that can communicate with an external data source [...]
April 3, 2024
MongoDB Log and the Message “RSM Not Processing Response”
One of the most common tasks for database administrators is checking logs; you can either work directly with the file [...]
April 3, 2024
MySQL 101: How to Find and Tune a Slow MySQL Query
This blog was originally published in June 2020 and was updated in April 2024. One of the most common support [...]
April 2, 2024
PostgreSQL for MySQL DBAs Second Edition Is Now Available
Many years ago, when I was the Certification Manager for MySQL AB, I would be in contact with hiring managers [...]
April 2, 2024
How to Find Duplicate, Unused, and Invisible Indexes in MySQL
This blog was originally published in January 2023 and was updated in April 2024. MySQL index is a data structure [...]