Severalnines Blog
The automation and management blog for open source databases

Severalnines blog

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

2019 Open Source Database Trends & Predictions

2018 saw a rise in PostgreSQL, a boom in containizeration and increased adoption of DevOps in the enterprise. What will 2019 hold? This blog details some industry predictions as well as ones from the Severalnines team.

Webinar Replay: How to Manage Replication Failover Processes for MySQL, MariaDB & PostgreSQL

Watch the replay of this webinar for a detailed overview of what failover processes may look like in MySQL, MariaDB and PostgreSQL replication setups. We’ll cover the dangers related to the failover process and look at how ClusterControl manages it as well as how it can be configured for both assisted and automated failover.

MySQL & MariaDB Query Caching with ProxySQL & ClusterControl

A query cache can greatly improve database performance, and there are various types of mechanisms available - from the inbuilt MySQL query cache to external key value stores like memcached or Redis. In this blog, we’ll show you how to cache your queries via ProxySQL, and avoid the overhead of an additional dedicated caching layer.

Database Monitoring - Troubleshooting Prometheus with SCUMM Dashboards

Our SCUMM dashboards rely on Prometheus and exporters to provide high-resolution monitoring data. However, there are cases when dashboards may not load. This blog goes through some troubleshooting guidelines.

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.

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.