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. That’s why it’s essential to implement the best practices and strategies for MongoDB database backups.

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. In this blog post, we will delve into the world of PostgreSQL performance tuning and establish some basic guidelines for setting database parameters to enhance the performance of your PostgreSQL database, based on the workload.

Tuning 52

Tuning Efficiency Database Performance 52

Dynatrace

JANUARY 18, 2023

In fact, 98% of DevOps leaders say that extending DevOps to more applications is key for digital transformation and customer experience, and 41% of applications will be fully DevOps enabled by 2023. DevOps is a tactical approach to creating and delivering software designed to close the gap between development and IT operations.

DevOps 207

DevOps Best Practices Innovation Strategy 207

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. As a result, typically, much more data is stored in MongoDB than in traditional SQL databases.

Best Practices 41

Best Practices Transportation Open Source Traffic 41

Percona

SEPTEMBER 1, 2023

This blog was originally published in October 2017 and was updated in September 2023. In this blog post, we will talk about MongoDB sharding and walk through the main reasons why you should start a cluster (independent of the approach you have chosen). Learn more: View our webinar on How to Scale with MongoDB.

Best Practices 72

Best Practices Traffic Database Servers 72

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 90

Best Practices Tuning Database Testing 90

Percona

JUNE 7, 2023

In this blog post, we will explore using triggers on DDL events in PostgreSQL to implement custom logic and automate database management tasks. 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 75

Database Best Practices Open Source C++ 75

Official Blog - World Web Technology

NOVEMBER 27, 2023

You may have to put off learning web development and design. You can make a great website without coding or advanced web design skills. Anyone can use a good website builder, even if they don’t know web design. It depends on the best practices of web design. Top 5 Website Builders to Choose in 2023!

Website 59

Website Development Mobile Storage 59

ACM Sigarch

JULY 17, 2023

One such challenge has been the emergence of marginal defect-driven faults that are difficult to address solely using best practices in manufacturing test and screening. We then discuss defects observed, the role of test and design to address this problem, and identify research opportunities.

Energy 52

Energy Hardware Best Practices Architecture 52

Percona

JULY 19, 2023

In this blog post, we will explore how to deploy the Percona Operator for PostgreSQL v2 using GitOps and ArgoCD. 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.

Servers 79

Servers Best Practices DevOps Open Source 79

Percona

FEBRUARY 2, 2023

Additionally, it is best practice to monitor regularly and audit database authentication logs to detect and prevent unauthorized access attempts. In this blog post, we will go over how to set up RADIUS authentication for PostgreSQL and provide an example of how it can be configured.

Database 124

Database Servers Testing Programming 124

Percona

AUGUST 5, 2023

This blog was originally published in July 2017 and was updated in August 2023. If you don’t have well-designed and small columns for this composite primary key, it could enlarge all of your secondary indexes. Check out this blog to learn how to avoid disaster! So, What is MySQL Partitioning? Upgrading MySQL to 8.0?

Strategy 40

Strategy Storage Database Best Practices 40

Smashing Magazine

OCTOBER 24, 2023

The Fight For The Main Thread The Fight For The Main Thread Geoff Graham 2023-10-24T18:00:00+00:00 2023-10-24T22:02:26+00:00 This article is sponsored by SpeedCurve Performance work is one of those things, as they say, that ought to happen in development. Hey, look at that — great job, team! Large preview ) I love this stuff!

Google 91

Google Analytics Traffic Metrics 91

O'Reilly

JULY 25, 2023

So far I’ve read a gazillion blog posts about people’s experiences with these AI coding assistance tools. 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.

Programming 98

Programming Code Design Benchmarking 98

Percona

SEPTEMBER 1, 2023

This blog was originally published in February 2019 and was updated in September 2023. In today’s blog, I’ll take a look at MySQL collation and charset settings to shed light on how they impact the performance of web applications and how to use them to effectively communicate with your users. In this case, MySQL 8.0

Performance 52

Performance Storage Social Media Database 52

Percona

JULY 2, 2023

This blog was originally written in September 2018 and was updated in June 2023. As discussed in the introductory blog post , we highlight important aspects an enterprise should consider for its PostgreSQL environments. In setting up our demonstration system, we use pg_basebackup and continuous archiving.

Strategy 52

Strategy Database Storage Open Source 52

Percona

JULY 7, 2023

Where a high availability design once worked well, it can no longer keep up with more complex requirements. This blog highlights considerations for keeping your own PostgreSQL databases highly available and healthy. Do you have the expertise and resources to design, implement, and manage a high availability solution for PostgreSQL?

Availability 84

Availability Open Source Architecture Database 84

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 61

Cache Database Games Healthcare 61