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. In today’s data-driven world, losing critical data can be catastrophic for any organization.

Best Practices 52

Best Practices Database Storage Servers 52

Percona

NOVEMBER 1, 2023

This blog was originally published in January 2021 and updated in November of 2023. In this age of digital information, robust backup and recovery strategies are the pillars on which the stability of applications stands. Below we will provide more insights into both of these backup types as well as some other strategies.

Best Practices 79

Best Practices Storage Strategy Database 79

Percona

MAY 1, 2023

This blog was originally published in August 2018 and was updated in May 2023. Hardware optimization : You need to ensure that the CPU, memory, and storage components meet the performance requirements of the database workload. Out of the box, the default PostgreSQL configuration is not tuned for any particular workload.

Tuning 52

Tuning Efficiency Database Performance 52

Sutter's Mill

MARCH 11, 2024

In that context, I’ll focus on C++ and try to: highlight what needs attention (what C++’s problem “is”), and how we can get there by building on solutions already underway; address some common misconceptions (what C++’s problem “isn’t”), including practical considerations of MSLs; and leave a call to action for programmers using all languages.

C++ 139

C++ Programming Code Java 139

Percona

JULY 2, 2023

This blog was originally written in September 2018 and was updated in June 2023. In this post, we cover the methods used to achieve an enterprise-grade backup strategy for the PostgreSQL cluster. They also ensure that backup strategies adhere to industry and legal compliance requirements. Why are PostgreSQL Backups Necessary?

Strategy 52

Strategy Database Storage Open Source 52

Percona

OCTOBER 18, 2023

Our goal with this post is to equip you with a comprehensive understanding of the steps, best practices, and pros and cons to ensure a smooth — and successful — transition to an open source database environment. Look closely at your current infrastructure (hardware, storage, networks, etc.)

Open Source 95

Open Source Database Hardware Strategy 95

Percona

SEPTEMBER 1, 2023

This blog was originally published in October 2017 and was updated in September 2023. To address these challenges, architects must design robust and scalable MongoDB databases and adopt appropriate sharding strategies that can efficiently handle increasing workloads while ensuring continuous availability. What is sharding in MongoDB?

Best Practices 75

Best Practices Traffic Database Servers 75

Percona

JUNE 6, 2023

This blog was originally published in January 2012 and was updated in June 2023. Therefore, establishing a strong backup strategy is essential to ensure data security and minimize potential disruptions. In order to implement effective full backups of your database, you must follow some best practices.

Storage 68

Storage Strategy Network Efficiency 68

Percona

SEPTEMBER 1, 2023

This blog was originally published in February 2019 and was updated in September 2023. Character encoding refers to the method used to represent characters as binary data for storage and transmission. This difference in storage size can lead to variations in the size of index entries, which can impact efficiency.

Performance 52

Performance Storage Social Media Database 52

Percona

AUGUST 5, 2023

This blog was originally published in July 2017 and was updated in August 2023. Otherwise, the storage engine does a scatter-gather and queries ALL partitions in a UNION that is not concurrent. This method distributes data evenly across partitions to achieve balanced storage and optimal query performance.

Strategy 40

Strategy Storage Database Best Practices 40