Percona

OCTOBER 12, 2023

This article shows a possible scenario of why this happens. There is always one primary node that can accept writes, but the replica set topologies vary depending on the use case and scale. This is clearly visible in the PSA topology when the write concern is set to the majority. However, after some time (not immediately!),

Open Source 86

Open Source Traffic Availability Database 86

Percona

OCTOBER 17, 2023

These tickets are categorized into Read tickets and Write tickets. When multiple operations, such as reads and writes, attempt to access the database concurrently, WiredTiger uses tickets to ensure these operations do not conflict in a way that would compromise data integrity or performance. From that, this article is born.

Metrics 98

Metrics C++ Storage Database 98

Percona

MARCH 27, 2023

You might wonder why this error will come during PITR as the operations in the Oplog are idempotent, meaning they always result in the same change to the database no matter how many times they’re performed. I created a collection book with four documents with a unique compound index. sort({$natural:-1}).limit(1)

Games 91

Games Database Open Source C++ 91

Percona

MAY 15, 2023

However, those solutions do not offer the same level of scaling for writes operation. Because the solutions still rely on writing in one single node that works as Primary. Also, in the case of multi-Primary, the writes will be distributed by transaction. Why duplicate the data?

Traffic 121

Traffic Scalability Database Servers 121

Percona

JULY 15, 2023

This blog was originally published in January 2022 and was updated in July 2023. But, while indexes greatly enhance read operations, they can also impact the speed of write operations, as the indexes need to be updated whenever data changes. One very common problem when trying to optimize a database environment is index usage.

Virtualization 76

Virtualization Speed Database Efficiency 76

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

JULY 2, 2023

This blog was originally written in September 2018 and was updated in June 2023. Why are PostgreSQL Backups Necessary? WALs, Write-Ahead Logs ) stored on disk. In this post, we cover the methods used to achieve an enterprise-grade backup strategy for the PostgreSQL cluster.

Strategy 52

Strategy Database Storage Open Source 52