Severalnines Blog
The automation and management blog for open source databases

Severalnines blog

Filter by:
Clear
Apply (1) filters
633 blog posts in 13 categories

An Overview of the New Stored Procedures in PostgreSQL 11

The recent release of PostgreSQL 11 included the introduction of stored functions that allow users to use embedded transactions within a procedure. In this blog we deep-dive into this new PostgreSQL feature.

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.

What's New in PostgreSQL 11

This blog provides an overview of the new features and functions that can be found in PostgreSQL 11 including stored functions, partitioning, and much more!

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.

Ten Ways to Expand the Functionality of PostgreSQL

There are different extensions to improve or adapt your PostgreSQL to specific needs. In this blog, we'll see some of the most popular open source extensions in PostgreSQL and how it can be used to expand its capability.

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.

Scaling Connections in PostgreSQL using Connection Pooling

This blog provides a high-level overview of connection pooling for PostgreSQL. Connection pooling has become one of the most common methods of handling database connections prior to a query request.

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.

Linking & Creating MongoDB Joins Using SQL - Part 3

This blog series describes how to create and link MongoDB joins using an SQL database and Studio3T. This blog focuses on multiple joins and collections.