Dynatrace

NOVEMBER 7, 2023

By leveraging the power of the Dynatrace ® platform and the new Kubernetes experience, platform engineers are empowered to implement the following best practices, thereby enabling their dev teams to deliver best-in-class applications and services to their customers. Monitoring-as-code can also be configured in GitOps fashion.

Engineering 267

Engineering DevOps Best Practices Infrastructure 267

Percona

MAY 2, 2023

This blog was originally published in September 2020 and was updated in May 2023. That’s why it’s essential to implement the best practices and strategies for MongoDB database backups. Percona Backup for MongoDB is an uncomplicated command-line tool by design that lends itself well to backing up larger data sets.

Best Practices 52

Best Practices Database Storage Servers 52

Percona

MAY 1, 2023

This blog was originally published in August 2018 and was updated in May 2023. Schema design: Evaluating the database schema design and making adjustments such as partitioning large tables, eliminating redundant data, and denormalizing tables for frequently accessed information can improve performance.

Tuning 52

Tuning Efficiency Database Performance 52

Percona

OCTOBER 16, 2023

Percona is a leading provider of unbiased, performance-first, open source database solutions that allow organizations to easily, securely, and affordably maintain business agility, minimize risks, and stay competitive, free from vendor lock-in. On October 5, 2023, Percona Monitoring and Management 2.40.0 Take a look.

Servers 73

Servers Monitoring Open Source Scalability 73

Percona

AUGUST 1, 2023

This blog was originally published on August 10, 2020, and was updated on August 1, 2023. Because of its NoSQL origin and document architecture design, MongoDB is much more flexible and scalable than SQL databases such as MySQL. However, it is available in other open-source versions of MongoDB, such as Percona Server for MongoDB.

Best Practices 40

Best Practices Transportation Open Source Traffic 40

Percona

AUGUST 16, 2023

A powerful tool designed to beautify and standardize SQL code is pgFormatter. pgFormatter is an open source utility that takes SQL code as input and outputs beautifully formatted, indented, and aligned SQL code following a set of predefined rules. What is pgFormatter?

Code 76

Code Best Practices Open Source C++ 76

Percona

JUNE 7, 2023

At the same time, it could act as a boon for the development (or non-production) environment to follow best practices and recommendations like who did what changes, whether proper naming conventions are used or not, and similar industry standards. Download Percona Distribution for PostgreSQL Today!

Database 73

Database Best Practices Open Source C++ 73

Percona

JULY 19, 2023

2023-07-07T10:11:22+03:00 pgv2.percona.com By leveraging automation and deployment best practices, teams can reduce the risk of human error, increase deployment velocity, and focus on delivering business value. Even when ArgoCD detects the change, it marks it as out of sync. ArgoCD detected the change: argocd app get percona-pg.

Servers 77

Servers Best Practices DevOps Open Source 77

Percona

JULY 6, 2023

I included a sequence creation statement for the id column since one best practice is always to have a primary key column, but for the specific examples we will go through, we don’t need it. then true else false end FROM generate_series(1, 10000000); Now we have our test table with some dummy data so we can practice.

Best Practices 87

Best Practices Tuning Database Testing 87

Percona

MAY 15, 2023

MySQL, as well as other RDBMS, are designed to work respecting the model and cannot scale in any way by fragmenting and distributing a schema, so what can be done to scale? In the MySQL open source ecosystem, we have only two consolidated ways to perform sharding — Vitess and ProxySQL. eu-central-1.elb.amazonaws.com

Traffic 122

Traffic Scalability Database Servers 122

Percona

JULY 7, 2023

Unfortunately, using certain open source database software as part of an HA architecture can present significant challenges. Therefore, DBAs must take a piecemeal approach to achieve HA with PostgreSQL, bringing together open source extensions and tools from multiple sources. Can you afford that recovery time?

Availability 82

Availability Open Source Architecture Database 82

Percona

FEBRUARY 2, 2023

Additionally, it is best practice to monitor regularly and audit database authentication logs to detect and prevent unauthorized access attempts. Percona Distribution for PostgreSQL provides the best and most critical enterprise components from the open source community in a single distribution, designed and tested to work together.

Database 121

Database Servers Testing Programming 121

Smashing Magazine

AUGUST 3, 2023

How We Optimized Performance To Serve A Global Audience How We Optimized Performance To Serve A Global Audience Liran Cohen 2023-08-03T10:00:00+00:00 2023-08-03T13:06:00+00:00 I work for Bookaway , a digital travel brand. Although landing pages are a common practice in online marketing, we were trying to make the most of it.

Performance 74

Performance Cache Traffic Metrics 74

O'Reilly

JULY 25, 2023

Here’s how I worked on it: I subscribed to ChatGPT Plus and used the GPT-4 model in ChatGPT (first the May 12, 2023 version, then the May 24 version) to help me with design and implementation. I liked how ChatGPT helped me work through the tradeoffs of these initial design decisions before diving head-first into coding.

Programming 98

Programming Code Design Benchmarking 98

Percona

JULY 2, 2023

This blog was originally written in September 2018 and was updated in June 2023. Overall, the role of a DBA in backup management is to design, implement, monitor, and maintain a backup strategy to protect critical data, ensure business continuity, and safeguard against potential data loss or corruption.

Strategy 52

Strategy Database Storage Open Source 52

Percona

SEPTEMBER 1, 2023

This blog was originally published in November 2021 and was updated in September 2023. By understanding these challenges and following best practices, you can make the most of triggers while minimizing potential drawbacks. However, they can also introduce performance bottlenecks, especially if poorly designed.

Cache 59

Cache Database Games Healthcare 59