Explore the tech preview release of the pg_tde extension for PostgreSQL 16, now featuring multi-tenancy, key rotation, and a streamlined configuration process, alongside numerous bug fixes.

Percona Database Performance Blog

27.04.2024

Benchmarking MongoDB Performance on Kubernetes

Explore our comparative analysis of Percona Server for MongoDB on bare metal vs. Percona Operator for MongoDB in Kubernetes. Discover how Percona Operator for MongoDB maintains containerized database performance.

Percona Database Performance Blog

25.04.2024

Bringing Percona Experts to a City Near You

Percona.connect, a series of free events hosted by Percona database performance experts, is coming to a city near you!

Percona Database Performance Blog

24.04.2024

Why MariaDB Is "Better" Than MySQL

Explore the ongoing debate over MariaDB vs. MySQL. Learn about their origins, features, performance, compatibility, enterprise offerings, and what alternatives are available.

Percona Database Performance Blog

23.04.2024

PostgreSQL Database Security Best Practices

Explore essential PostgreSQL database security practices. Learn strategies to protect against threats and ensure compliance, enhancing security and meeting high data protection standards.

Percona Database Performance Blog

19.04.2024

Improving Database Performance: The Ultimate Guide

Looking to improve your database performance? Check out our detailed guide with optimization strategies, tips and best practices for increased performance.

Percona Database Performance Blog

19.04.2024

Should You Deploy Your Databases on Kubernetes? And What Makes StatefulSet Worthwhile?

Explore the benefits of running databases on Kubernetes with insights from Percona's experts. Learn how Kubernetes can enhance cost efficiency, scalability, flexibility, and compliance in your database operations, despite the challenges.

Percona Database Performance Blog

18.04.2024

Switch PostgreSQL Environments Across AWS, GCP, and k3d Using Kubernetes Contexts

Discover how to install the Percona Distribution for PostgreSQL using Kubernetes contexts across various platforms, including AWS, Google Cloud, and local setups using k3d.

Percona Database Performance Blog

17.04.2024

Percona Stands Firmly on the Side of Open Source

Percona is proud to state our support for the Valkey project and its community and will soon offer commercial support for the open source Redis alternative, Valkey.

Percona Database Performance Blog

16.04.2024

Why SELECT COUNT(*) FROM TABLE Is Sometimes Very Slow in MySQL or MariaDB

Explore why a simple SELECT COUNT(*) FROM TABLE; query in MySQL can be excessively slow or surprisingly fast, and gain insights into the factors that influence query performance.

Percona Database Performance Blog

13.04.2024

Partially Rolling Back a Transaction in MySQL or PostgreSQL

Discover how the savepoint feature enables partial rollback of transactions in MySQL and PostgreSQL, offering a flexible solution for restoring data to a specific point.

Percona Database Performance Blog

12.04.2024

How to Replicate and Rename a Database in MariaDB

Learn how to replicate and rename a database in MariaDB, from "db_primary" to "db_replica". Discover the nuances of replication filters and dynamic configurations for efficient database management.

Percona Database Performance Blog

12.04.2024

JSON_TABLE() Will Be in PostgreSQL 17

JSON_TABLE() will be a great addition to PostgreSQL 17. Those of us who deal with lots of JSON-formatted data will make heavy use of it.

Percona Database Performance Blog

12.04.2024

How to Set and Tune Autovacuum Settings in PostgreSQL

Autovacuum in PostgreSQL is useful for optimizing dead space, but it can also degrade performance. Learn how to set and tune autovacuum settings for best results.

Percona Database Performance Blog

11.04.2024

MongoDB 4.4 EOL with 5.0 Not Far Behind

Learn about the impact of MongoDB 4.4 having reached EOL in February 2024, the upcoming EOL for 5.0 in October, and how Percona's support services can assist with upgrades.

Percona Database Performance Blog

10.04.2024

Protect Your PostgreSQL Database with pg_tde: Safe and Secure

Explore the tech preview release of pg_tde, a new PostgreSQL encryption extension offering unparalleled protection for your data.

Percona Database Performance Blog

06.04.2024

Best Practices for PostgreSQL Migration

Discover essential best practices for a PostgreSQL migration, including planning, tools, and post-migration tips to overcome challenges and ensure a successful transition.

Percona Database Performance Blog

06.04.2024

Querying Percona Operator for MongoDB Logs Using LogCLI

Learn how to use LogCLI with the Percona Operator for MongoDB to efficiently store, query, and manage your database logs.

Percona Database Performance Blog

05.04.2024

Percona Backup for MongoDB: Restore a Single Collection From Backup

Percona Backup for MongoDB offers flexible ways to manage backup and restore operations, and restoring a single collection from backup is a simple scenario it can help with.

Percona Database Performance Blog

04.04.2024

MongoDB Log and the Message "RSM Not Processing Response"

Understanding and fixing the MongoDB message "RSM not processing response" to help maintain the health and performance of MongoDB's replication system.

Percona Database Performance Blog

04.04.2024

Foreign Data Wrappers in PostgreSQL Database

A FDW is a feature in DBMS that can communicate with a remote data source and access data without physically moving the data to local DB.

Percona Database Performance Blog

03.04.2024

Five Reasons Why WAL Segments Accumulate in the pg_wal Directory in PostgreSQL

Covering some common reasons why the pg_wal directory has increased its size, how to troubleshoot, and strategies to mitigate the problem.

Percona Database Performance Blog

03.04.2024

PostgreSQL for MySQL DBAs Second Edition Is Now Available

The original PostgreSQL for MySQL DBAs series was started two years ago, and Percona's Dave Stokes is back with the second edition!

Percona Database Performance Blog

02.04.2024

Percona pg_tde Project Keyring Options

Percona’s pg_tde project brings a long-needed ability to encrypt data to PostgreSQL transparently. As mentioned before, it depends on a keyring.

Percona Database Performance Blog

30.03.2024

A MyLoader Error You Might Face When Restoring Databases

Occasionally we use mydumper/myloader to transfer databases from production to a lower environment. This process was successful — until we encountered an error one day.

Percona Database Performance Blog

29.03.2024

Percona’s PostgreSQL pg_tde Extension: March Update

Transparent Data Encryption is one ‘missing item’ in comparing PostgreSQL to commercial databases. Percona’s pg_tde project will correct this shortcoming.

Percona Database Performance Blog

28.03.2024

Using PAM with SASL in Percona Server for MongoDB

Using Pluggable Authentication Modules with Simple Authentication and Security Layer in Percona Server for MongoDB.

Percona Database Performance Blog

28.03.2024

Enhancing PostgreSQL Insights with Percona Monitoring and Management: A Closer Look at Recent Updates

Two significant enhancements have been made to Percona Monitoring and Management to make it an even more powerful tool for PostgreSQL.

Percona Database Performance Blog

27.03.2024

Why Your Next MySQL Database Should Not Be a MySQL Database

MySQL is a very popular database and a good choice for new projects. Percona, for free, offers enterprise MySQL features and more.

Percona Database Performance Blog

27.03.2024

Copying Alert Rules From One Percona Monitoring and Management Server to Another

How to simply migrate an alert rule from one Percona Monitoring and Management server to another, focusing on the steps to perform the export/import of Grafana alert rules.

Percona Database Performance Blog

26.03.2024

Stages of Index Build in MongoDB

Stages of index build in MongoDB go through various phases, enhancing performance and query speed. It's essential for DBAs to grasp these steps to fine-tune their MongoDB setup efficiently.

Percona Database Performance Blog

26.03.2024

A Guide to Database Security: Best Practices & Solutions

Data breaches, insider threats, and unauthorized access are major threats to database security. Learn best practices for database security in our guide.

Percona Database Performance Blog

23.03.2024

How Can I Take a Backup of Configuration Files in PostgreSQL?

Explore how to effectively back up PostgreSQL configuration files, including their locations and backup methods, to maintain efficient, secure backups.

Percona Database Performance Blog

22.03.2024

Enable Data Checksums With Minimum Downtime in PostgreSQL

How to enable data checksums on an existing running cluster using pg_checksums with minimum downtime.

Percona Database Performance Blog

22.03.2024

Boosting IT Productivity: The Crucial Role of ITIL Knowledge for DBAs

Via ITIL knowledge, DBAs enhance efficiency, foster effective planning, operational excellence, and ongoing improvement in database services.

Percona Database Performance Blog

21.03.2024

PostgreSQL Monitoring with Percona Monitoring and Management: A Redefined Summary

The new PostgreSQL dashboard to see everything that matters will first be available as an experimental piece of Percona Monitoring and Management 2.41.2.

Percona Database Performance Blog

21.03.2024

Do You Leverage Index-Only Scans in PostgreSQL? Do You Want To?

The more query workload your systems generate, the more benefit you will get when you leverage index-only scans in PostgreSQL. But, we need to pay attention to how the tables behave regarding their updates and page visibility, as well.

Percona Database Performance Blog

20.03.2024

Percona Monitoring and Management Database Overview Dashboard, Simplified

Presenting a redesigned Percona Monitoring and Management dashboard focused on simplicity. Easily navigate between MySQL, PostgreSQL, and MongoDB overviews.

Percona Database Performance Blog

15.03.2024

The Challenge with Open Core Software

Peter Zaitsev discusses the open core monetization strategy and its impact on open source community contributions.

Percona Database Performance Blog

15.03.2024

Analyzing Slow Queries After MongoDB 4.4

How to analyze slow queries after the change in the format of the log file of MongoDB 4.4.

home›Percona Database Performance Blog›Software

Percona Database Performance Blog - Software

Trying out the PostgreSQL pg_tde Tech Preview Release

Benchmarking MongoDB Performance on Kubernetes

Bringing Percona Experts to a City Near You

Why MariaDB Is "Better" Than MySQL

PostgreSQL Database Security Best Practices

Improving Database Performance: The Ultimate Guide

Should You Deploy Your Databases on Kubernetes? And What Makes StatefulSet Worthwhile?

Switch PostgreSQL Environments Across AWS, GCP, and k3d Using Kubernetes Contexts

Percona Stands Firmly on the Side of Open Source

Why SELECT COUNT(*) FROM TABLE Is Sometimes Very Slow in MySQL or MariaDB

Partially Rolling Back a Transaction in MySQL or PostgreSQL

How to Replicate and Rename a Database in MariaDB

JSON_TABLE() Will Be in PostgreSQL 17

How to Set and Tune Autovacuum Settings in PostgreSQL

MongoDB 4.4 EOL with 5.0 Not Far Behind

Protect Your PostgreSQL Database with pg_tde: Safe and Secure

Best Practices for PostgreSQL Migration

Querying Percona Operator for MongoDB Logs Using LogCLI

Percona Backup for MongoDB: Restore a Single Collection From Backup

MongoDB Log and the Message "RSM Not Processing Response"

Foreign Data Wrappers in PostgreSQL Database

Five Reasons Why WAL Segments Accumulate in the pg_wal Directory in PostgreSQL

PostgreSQL for MySQL DBAs Second Edition Is Now Available

Percona pg_tde Project Keyring Options

A MyLoader Error You Might Face When Restoring Databases

Percona’s PostgreSQL pg_tde Extension: March Update

Using PAM with SASL in Percona Server for MongoDB

Enhancing PostgreSQL Insights with Percona Monitoring and Management: A Closer Look at Recent Updates

Why Your Next MySQL Database Should Not Be a MySQL Database

Copying Alert Rules From One Percona Monitoring and Management Server to Another

Stages of Index Build in MongoDB

A Guide to Database Security: Best Practices & Solutions

How Can I Take a Backup of Configuration Files in PostgreSQL?

Enable Data Checksums With Minimum Downtime in PostgreSQL

Boosting IT Productivity: The Crucial Role of ITIL Knowledge for DBAs

PostgreSQL Monitoring with Percona Monitoring and Management: A Redefined Summary

Do You Leverage Index-Only Scans in PostgreSQL? Do You Want To?

Percona Monitoring and Management Database Overview Dashboard, Simplified

The Challenge with Open Core Software

Analyzing Slow Queries After MongoDB 4.4

home
›
Percona Database Performance Blog
›
Software