Severalnines Blog
The automation and management blog for open source databases

Severalnines blog

Filter by:
Clear
Apply (1) filters
55 blog posts in 1 category

MySQL on Docker: Multiple Delayed Replication Slaves for Disaster Recovery with Low RTO

A delayed replication slave is useful in recovering from accidental data deletion. But how long should the delay be? Too short delay might not be enough for you to get to a terminal and stop an offending query. Too long delay means a long recovery time when catching up.

This blog post shows how to deploy multiple MySQL delayed slaves on one single physical host with Docker, and shows some of the recovery scenarios.

Database Backup Encryption - Best Practices

Backups that contain critical data are stored offsite as part of a disaster recovery solution. Encryption is a basic requirement, but how do you ensure you have the right encryption? How do you manage the encryption keys? And once everything is encrypted, how do you ensure you have the right data in your backups? This blog will discuss some of the best practices related to backup encryption.

Cloud Backup Options for MySQL & MariaDB Databases

Cloud storage is a scalable and reliable way of archiving backups. There are some design considerations when building cloud-enabled backup solutions for MySQL or MariaDB in order to meet security and recovery objectives.

In this blog post, we will discuss encryption, compression, and network traffic throttling. We’ll also see how you can upload your backups to Amazon S3, Google Cloud Storage and Azure Storage.

Database Backups - Comparing MariaDB Mariabackup and Percona Xtrabackup

Percona XtraBackup is one of the most used tools for backing up MySQL and MariaDB databases. Mariabackup is a fork of XtraBackup, extending its functionality to support compression and at-rest encryption. In this blog, we will look at the differences between these two, and also see how we use them.

Cloud Backup Options for PostgreSQL

This blog provides an overview of the options available for backing up your PostgreSQL database in the cloud including ClusterControl which provides easy cloud backup sync with a graphic interface.

How to Encrypt Your MySQL & MariaDB Backups

Backup encryption is a must if you want to store backups offsite for disaster recovery. This post will describe ways in which you can encrypt your MySQL and MariaDB backups.

Webinar Replay: Backup Management for MySQL, MariaDB, PostgreSQL & MongoDB with ClusterControl

Watch the replay of this webinar on Backup Management for MySQL, MariaDB, PostgreSQL and MongoDB with ClusterControl. Whether you are looking at rebuilding your existing backup infrastructure, or updating it, then this webinar is for you.

Database Security - Backup Encryption In-Transit & At-Rest

Backup Encryption in-transit and at-rest are important when complying with PHI, PII, PCI DSS, GDPR, and HIPAA. This blog discusses how you can use ClusterControl to safely secure your data during transmission over the network or when persistently stored on disk.

How to Customize your MySQL & MariaDB Backups with ClusterControl

ClusterControl provides centralized backup management for MySQL and MariaDB, and it supports the main backup tools - mysqldump, xtrabackup and mariabackup. The command line arguments used are supposed to be the most optimal for most use cases, but you might still want to customize these to fit your particular needs. In this post, we will show you how to do that.

ClusterControl Tips & Tricks - Best Practices for Database Backups

This blog is about good practices for taking database backups using ClusterControl 1.7. ClusterControl’s centralized backup management for MySQL, MariaDB, PostgreSQL and MongoDB provides you with hot backups of large datasets, point in time recovery, at-rest and in-transit data encryption, data integrity via automatic restore verification, cloud backups (AWS, Google and Azure) for Disaster Recovery, retention policies to ensure compliance, and automated alerts and reporting.