11

Percona's Most Popular Posts on Open Source Database Technologies - Percona Data...

 3 years ago
source link: https://www.percona.com/blog/perconas-2021-most-popular-posts-on-open-source-database-technologies/
Go to the source link to view the article. You can view the picture content, updated content and better typesetting reading experience. If the link is broken, please click the button below to view the snapshot at that time.
neoserver,ios ssh client
Percona's Most Popular Posts on Open Source Database Technologies

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 – The Steps Involved in Creating a Percona Product Release by Kathy Williamson. Kathy revealed the Merge Process which happens each time we receive an upstream release.

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.

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!


report

Recommend

About Joyk


Aggregate valuable and interesting links.
Joyk means Joy of geeK