Severalnines Blog
The automation and management blog for open source databases

Severalnines blog

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

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.

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.

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.

Percona Live Frankfurt 2018 - Event Recap & Our Sessions

Severalnines was a sponsor at 2018’s Percona Live Europe which was held in Frankfurt, Germany. This blog details our participation at the event and includes the slides from the sessions we presented.

Posted in:

Effective Monitoring of MySQL With SCUMM Dashboards - Part 3

In this 3rd part of the blog series, we’ll discuss what ClusterControl’s new InnoDB Metrics and MySQL Performance dashboards have to offer. These dashboards provide a pretty in-depth view of MySQL performance. We’ll go through the different graphs, and see how a DBA can leverage them.

Pages