Remove Best Practices Remove Document Remove Storage Remove Strategy
article thumbnail

MySQL Backup and Recovery Best Practices: The Ultimate Guide

Percona

In this age of digital information, robust backup and recovery strategies are the pillars on which the stability of applications stands. In this blog, we will review all of the potential MySQL backup and restore strategies, the cornerstones of any application. There are two main different MySQL backup types: physical and logical.

article thumbnail

MongoDB Database Backup: Best Practices & Expert Tips

Percona

That’s why it’s essential to implement the best practices and strategies for MongoDB database backups. In the absence of a proper backup strategy, the data can be lost forever, leading to significant financial and reputational damage. Best practice tip : Use PBM to time huge backup sets.

Insiders

Sign Up for our Newsletter

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Trending Sources

article thumbnail

Master MySQL Point in Time Recovery

Scalegrid

These logs meticulously document every modification executed within the database in the data directory, providing essential incremental updates that facilitate time-specific recovery efforts. STATEMENT level – at which only SQL statements causing changes in data are documented succinctly.

Database 162
article thumbnail

Optimize MongoDB® Pagination

Scalegrid

Implementing pagination can be done using two primary strategies: offset-based and cursor-based methods. Offset-based involves utilizing functions such as skip , limit and a query which indicates how many documents should be skipped or returned at maximum. This can be expressed as db.collection_name.find().limit(number). limit(number).

article thumbnail

MongoDB Best Practices: Security, Data Modeling, & Schema Design

Percona

In this blog post, we will discuss the best practices on the MongoDB ecosystem applied at the Operating System (OS) and MongoDB levels. We’ll also go over some best practices for MongoDB security as well as MongoDB data modeling. Lower values increase the durability of the journal at the expense of disk performance.

article thumbnail

Exploring PostgreSQL Backup Strategies for Enterprise-Grade Environments

Percona

In this post, we cover the methods used to achieve an enterprise-grade backup strategy for the PostgreSQL cluster. Having a backup strategy in place that takes regular backups and has secure storage is essential to protect the database in an enterprise-grade environment to ensure its availability in the event of failures or disasters.

article thumbnail

Maximizing Performance of AWS RDS for MySQL with Dedicated Log Volumes

Percona

A Dedicated Log Volume (DLV) is a specialized storage volume designed to house database transaction logs separately from the volume containing the database tables. DLVs are particularly advantageous for databases with large allocated storage, high I/O per second (IOPS) requirements, or latency-sensitive workloads.

AWS 97