At the recent Percona Live, Agust'in Gallego and I did a presentation Optimizing and Troubleshooting PostgreSQL with PMM. While preparing for this talk, I’ve ported some of the older PostgreSQL custom dashboards that we published over the years over at grafana.com. Initially made for Percona Monitoring and Management (PMM) 1, they are now capable of [&]

https://www.percona.com/blog/postgresql-custom-dashboards-ported-to-pmm-2/

During the development of the myloader innodb-optimize-keys option, which was released in version 0.10.7, we found several issues and opportunities to improve the process. We had to change the approach, reimplement some of the core functionality and add a couple of data structures. That allowed us to implement, at a really low cost, a feature [&]

https://www.percona.com/blog/myloader-stops-causing-data-fragmentation/

Security is everybodys concern when talking about data and information, and therefore it becomes the main foundation of every database. Security means protecting your data from unauthorized access. That means only authorized users can log in to a system called authentication; a user can only do what they are authorized to do (authorization) and log [&]

https://www.percona.com/blog/postgresql-database-security-os-authentication/

The engineering marvel that is Percona Monitoring and Management (PMM), has to be, for me, one of the best examples out there of how a large number of vastly different community projects can successfully combine into something whose value and features far exceeds the sum of its component open-source parts. Thats a lot of words [&]

https://www.percona.com/blog/2021/08/23/august-is-hot-but-not-as-hot-as-our-next-community-engineering-meeting/

EBS storage type choices in AWS can be impacted by a lot of factors. As a consultant, I get a lot of questions about choosing the best storage type for a workload. Let me share a few examples. Is io2 better than gp2/3 if the configured iops are the same? What can I expect when [&]

https://www.percona.com/blog/performance-of-various-ebs-storage-types-in-aws/

JSON Structure, The Next Generation (Performance, Scale, and Fun) Now you know the basic JSON functionality available to you, as covered in part one of this series.  Let’s look deeper into performance, scale, and oddities that may occur. You can do almost anything you could do in SQL with standard data types and objects, but [&]

https://www.percona.com/blog/storing-json-in-your-databases-tips-and-tricks-for-mysql-part-two/

You may have already seen this document which describes the integration between HashiCorp Vault and Percona Distribution for MySQL Operator to enable data-at-rest encryption for self-managed Vault deployments.  In April 2021, HashiCorp announced a fully managed offering, HashiCorp Cloud Platform Vault (HCP Vault), that simplifies deployment and management of the Vault. With that in mind, [&]

https://www.percona.com/blog/dynamic-user-creation-with-mysql-on-kubernetes-and-hashicorp-cloud-platform-vault/

Database architecture and design are becoming an increasingly lost art. With new technologies and the push towards faster development cycles, people continue to take shortcuts, often to the detriment of long-term performance, scalability, and security. Designing how your application stores, accesses, and processes data is so fundamentally important, it can not be overlooked. I want [&]

https://www.percona.com/blog/storing-json-in-your-databases-tips-mysql/

Over the weekend, the Debian project announced the availability of their newest major distribution release, Debian 11 (code name “bullseye”). We’d like to congratulate the Debian project and the open source community for achieving this major milestone! With over two years in the making, it contains an impressive amount of new and updated software for [&]

https://www.percona.com/blog/first-packages-for-debian-11-bullseye-now-available/

We’re happy to announce the first release candidate of Percona Server for MongoDB version 5.0.2 (PSMDB). It is now available for download from the Percona website and via the Percona Software Repositories. Percona Server for MongoDB 5.0.2 is an enhanced, source-available, and highly scalable document-oriented database that is a fully compatible drop-in replacement for MongoDB [&]

https://www.percona.com/blog/percona-server-for-mongodb-5-0-2-release-candidate-now-available/

Its release roundup time again here at Percona! Our Release Roundups showcase the latest Percona software updates, tools, and features to help you manage and deploy our software. It offers highlights and critical information, as well as links to the full release notes and direct links to the software or service itself to download. Todays [&]

https://www.percona.com/blog/release-roundup-august-16-2021/

The next 10 user reviews for Percona Server for MySQL will receive a $10 Amazon gift card from Sourceforge. Add yours now! Why does Percona value honest user reviews? They provide valuable information for engineers to guide product development. They help more users become aware of Percona software.  They help inspire our development process! If [&]

https://www.percona.com/blog/2021/08/13/get-an-amazon-gift-card-for-a-review/

More and more companies are adopting Kubernetes. For some it is about being cutting-edge, for some, it is a well-defined strategy and a business transformation. Developers and operations teams all over the world are struggling with moving applications that arent cloud-native friendly to containers and Kubernetes. Migrating databases is always a challenge, which comes with [&]

https://www.percona.com/blog/migrating-postgresql-to-kubernetes

Quite often we see that the main operational storage is used in conjunction with some additional services, for example, for caching or full-text search. Another architecture approach using multiple databases is microservices, where every microservice has its own database better optimized for the tasks of this particular service. For example, you can use MySQL for [&]

https://www.percona.com/blog/pros-and-cons-when-you-should-and-should-not-use-mongodb/

We discussed how to install and create a simple class in the first part of this series where we ran a SELECT and returned one row with one column with a formatted text. Now its time to expand and see how to return multiple tuples. A little disclaimer here; Im not going to comment much [&]

https://www.percona.com/blog/postgresql-pl-java-a-how-to-part-2-how-to-manipulate-and-return-tuples/

Many times, we see PostgreSQL users getting confused about the query/statement duration reported in PostgreSQL logs. Other PostgreSQL tools like pgBadger present the same data based on the log file, which further increases the confusion. Knowing the full impact of network-related overhead and cursors is important not only to alleviate the confusion but also to [&]

https://www.percona.com/blog/impact-of-network-and-cursor-on-query-performance-of-postgresql/

Its release roundup time again here at Percona! Our Release Roundups showcase the latest Percona software updates, tools, and features to help you manage and deploy our software. It offers highlights and critical information, as well as links to the full release notes and direct links to the software or service itself to download. Todays [&]

https://www.percona.com/blog/new-features-in-percona-server-for-mongodb-release-roundup-august-2-2021/

Understanding query performance patterns is essentially the foundation for query performance tuning. It, in many ways, dictates how a database cluster evolves. And then there are obviously direct and indirect cost connotations as well. PostgreSQL provides very detailed statistics through a number of catalog views and extensions that can be easily added to provide more [&]

https://www.percona.com/blog/improve-postgresql-query-performance-insights-with-pg_stat_monitor/

Here at Percona, we operate on the premise that full transparency makes a product better. We strive to build the best open-source database products, but also to help you manage any issues that arise in any of the databases that we support. And, in true open-source form, report back on any issues or bugs you [&]

https://www.percona.com/blog/percona-monthly-bug-report-july-2021/

Weve recently received some questions regarding PL/Java and I found it hard to get clear instructions searching on the internet. Its not that there is no good information out there, but most of it is either incomplete, outdated, or confusing and I decided to create this short how-to and show how to install it and [&]

https://www.percona.com/blog/postgresql-pl-java-how-to-part-1/