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

DECEMBER 27, 2023

As we at Percona wind down 2023 and look into what the next year holds, our attention is drawn to the cloud-native landscape and how it is maturing, growing, and evolving. KubeCon NA 2023 recap The theme for KubeCon NA was very clear — AI and Large Language Models (LLMs). We expect that number to rise higher in 2024.

Cloud 77

Cloud Open Source Strategy Best Practices 77

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 75

Code Best Practices Open Source C++ 75

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

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 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

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

O'Reilly

JULY 18, 2023

That said, instructors considered these strategies short-term patches; the sudden appearance of ChatGPT at the end of 2022 meant that instructors needed to make adjustments before their courses started in 2023, which was when we interviewed them for our study. Others shared concerns over the training data bias for AI tools.

Programming 60

Programming Education Code Strategy 60

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 121

Traffic Scalability Database Servers 121

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

Percona

NOVEMBER 1, 2023

This blog was originally published in August of 2021 and updated in November of 2023. Following the series of blogs written with the intention to describe basic operations matching Docker and open source databases, in this article, I will demonstrate how to proceed with installing MongoDB with Docker.

Scalability 57

Scalability Best Practices Servers Database 57

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

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

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

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

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