Apples or oranges?Tea or coffee?Books or eBooks?Each of these comparisons has very similar features and serves many of the same purposes, but in the end, they are different choices people make. D...
https://www.percona.com/blog/why-mariadb-is-better-than-mysql/
When data is everything, the sophistication of cybersecurity threats casts a shadow over the world of data security, including for those using PostgreSQL as their database of choice. Although ren...
https://www.percona.com/blog/postgresql-database-security-best-practices/
Yes, but now it likes them more, and here is why.IntroUsing the LIKE clause to filter triggers or views from a specific table is common. However, it can play a trick on you, especially if you don...
Why do cloud-native databases matter?Kubernetes makes it easier to run applications. It’s like having a magic wand for managing everything from small tasks to significant operations. However, d...
Welcome to the ultimate guide on how to boost your database performance! We’ve designed it to help you understand and improve the performance of your databases, regardless of your level of expe...
https://www.percona.com/blog/ultimate-guide-to-improving-database-performance/
This article explains how to install the Percona Distribution for PostgreSQL on Kubernetes using “context”. We will show you how to set up this distribution on Kubernetes clusters in AWS, Goo...
Percona is proud to formally state our support for the Valkey project and its community. We will soon offer commercial support for the open source Redis alternative, Valkey.The world of open so...
https://www.percona.com/blog/percona-stands-firmly-on-the-side-of-open-source/
We usually receive and see some questions regarding the charset levels in MySQL, especially after the deprecation of utf8mb3 and the new default uf8mb4. If you understand how the charset works on...
https://www.percona.com/blog/a-guide-to-better-understanding-mysql-charset-levels/
If you have enough experience with MySQL, it is very possible that you stumbled upon an unusually slow SELECT COUNT(*) FROM TABLE; query execution, at least occasionally.Recently, I had a chance ...
https://www.percona.com/blog/why-select-count-from-table-is-sometimes-very-slow-in-mysql-or-mariadb/
This short write-up focuses on a different transaction control behavior of databases. Though this is not unusual, I decided to write an article on rolling back transactions to a particular point....
https://www.percona.com/blog/partially-rolling-back-a-transaction-in-mysql-or-postgresql/
JSON_TABLE() will be in PostgreSQL 17! It almost made it two years ago but was yanked away at the last minute. We will get it shortly when PostgreSQL 17 is officially released this year! Please s...
https://www.percona.com/blog/json_table-will-be-in-postgresql-17/
MySQL/MariaDB replication filter is an important feature when we need to replicate only certain databases or tables. Having this configuration option change dynamically is really convenient, but ...
https://www.percona.com/blog/how-to-replicate-and-rename-a-database-in-mariadb/
February 2024 marked the end of life (EOL) of MongoDB 4.4.Another year, another EOL, is a fitting summary. Time goes by fast, and looking from this perspective, 5.0 is one we will soon also say g...
https://www.percona.com/blog/mongodb-4-4-eol-with-5-0-not-far-behind/
It’s a common scenario to have a Percona Monitoring and Management (PMM) server running on Kubernetes and also desire to monitor databases that are running outside the Kubernetes cluster. The I...
We met with Vinicius Grippa, a Senior Support Engineer at Percona. He is also active in the open source community and was recognized as a MySQL Rock Star in 2023.In the previous interview with Vi...
https://www.percona.com/blog/ask-me-anything-about-mysql-5-7-to-8-0-post-eol/
Tech Preview release of pg_tde now availableAs organizations collect, store, and analyze vast amounts of data, ensuring its confidentiality and integrity becomes a top priority. For PostgreSQL us...
https://www.percona.com/blog/protect-your-postgresql-database-with-pg_tde-safe-and-secure/
With all the convenience Kubernetes operators provide in managing resources, it can still be a challenge to conveniently store, query, manage, and download the database logs from the pods. Since ...
https://www.percona.com/blog/querying-percona-operator-for-mongodb-logs-using-logcli/
PostgreSQL’s reputation as a powerful, open source database management system has been steadily rising, making it a top choice for businesses looking to upgrade or switch their database infrast...
https://www.percona.com/blog/best-practices-for-postgresql-migration/
When you design a backup strategy, you need to think about the business requirements, as you will need to shape your backups to meet them. Let’s review the basics briefly; you need to define th...
https://www.percona.com/blog/percona-backup-for-mongodb-restore-a-single-collection-from-backup/
A Foreign Data Wrapper (FDW) is a feature in database management systems that can communicate with an external data source and access data without physically moving the data on a working local da...
https://www.percona.com/blog/foreign-data-wrappers-in-postgresql-databases-postgres_fdw-dblink/