While we prepare to enter 2022 and start to sum up its results and schedule a plan for the future, let’s look back at the awesome posts published in the Percona Blog and find out which products and themes raised more engagement among readers.
We count the number of views of each blog post and recognize its author internally with the Blogger of the Month award: an exclusive hat and a bonus.
So here are the most popular articles in each month that draw the most of your attention.
January Champion – PostgreSQL on ARM-based AWS EC2 Instances: Is It Any Good? by Jobin Augustine and Sergey Kuzmichev. They took an independent look at the price/performance of the new instances from the standpoint of running PostgreSQL, and perform some tests described in the post.
February Champion – PostgreSQL Database Security: Authentication by Ibrar Ahmed. It covers each and every PostgreSQL internal authentication method in detail.
March Champion – Overview of MySQL Alternative Storage Engines by Sri Sakthivel. InnoDB engines are very popular but there are some alternatives for MySQL to consider. This post is an overview of other engines with examples.
April Champion – Upgrading to MySQL 8: Embrace the Challenge by Mike Benshoof. He shared some tips to facilitate and approach the upgrade to MySQL 8.
May Champion – Manage MySQL Users with Kubernetes by Sergey Pronin. Quite a common request that we receive from the community and customers is to provide a way to manage database users with Operators. Sergey described the way to take it to another level and create a way to provision users on any database through the Kubernetes control plane with the help of Crossplane.io.
June Champion – Autoscaling Databases in Kubernetes for MongoDB, MySQL, and PostgreSQL by Dmitriy Kostiuk and Mykola Marzhan explores to what extent it is possible to automate horizontal scaling of those databases in Kubernetes and how we do it.
July Champion – Improve PostgreSQL Query Performance Insights with pg_stat_monitor by Ibrar Ahmed and Hamid Akthar. It describes how pg_stat_monitor helps to look at query performance and avoid combining manually client/connection information from pg_stat_activity, statistical data from pg_stat_statements, and query plan from auto_analyze to complete the dataset to understand query performance patterns.
August Champion – Migrating PostgreSQL to Kubernetes by Sergey Pronin. Sergey described the way to migrate PostgreSQL with minimal downtime using Percona Distribution for PostgreSQL Operator.
September Champion – PostgreSQL 14 – Performance, Security, Usability, and Observability by Umair Shahid. It is an overview of the PostgreSQL 14 enhancements for heavy transactional workloads, specialized use cases, and additional support for distributed data.
October Champion – Why Linux HugePages are Super Important for Database Servers: A Case with PostgreSQL by Jobin Augustine. He described how Linux Huge Pages can potentially save the database server from OOM Killers and associated crashes with a testable and repeatable case.
And while we don’t know the November most popular post now, we definitely have the leader – Should I Create an Index on Foreign Keys in PostgreSQL? by Charly Batista, with the answer to the question he’s seen in the webinars he presented.
Some articles did not take first place the month they were published, but they definitely deserve special mention as very popular ones covering some interesting themes.
- Migration of a MySQL Database to a Kubernetes Cluster Using Asynchronous Replication by Slava Sarzhan.
- Pros and Cons: When You Should and Should Not Use MongoDB by Jean da Silva.
- MySQL/ZFS Performance Update by Yves Trudeau.
Often we also invite authors of those posts and other active community members to take part in another Community project – The HOSS Talks FOSS podcast, hosted by Matt Yonkovit. There they have fun, chat, and discuss all things open source. Episodes are available on the Percona YouTube channel, as well as the recordings of weekly online meetups for PostgreSQL, MySQL, MongoDB, and Percona Monitoring and Management. Subscribe to the channel updates to stay tuned for new episodes!
