Severalnines Blog
The automation and management blog for open source databases

Severalnines blog

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

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.

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.

SQL Firewalling Made Easy with ClusterControl & ProxySQL

This blog describes how to use ClusterControl and ProxySQL to implement an SQL firewall in front of your database servers. The firewall uses a regular expression matching engine to inspect SQL statements going to the database through the proxy, and determines whether to allow, block, reroute or rewrite the incoming query.

Posted in:

MySQL on Docker: Running ProxySQL as Kubernetes Service

When your application containers are orchestrated and managed by Kubernetes, you might want to use ProxySQL in front of your database servers. In this post, we’ll show you how to configure ProxySQL as a Kubernetes service.

Effective Monitoring of MySQL Replication with SCUMM Dashboards - Part 2

The new release of ClusterControl 1.7.0 introduces SCUMM (Severalnines ClusterControl Unified Management and Monitoring). Monitoring MySQL with SCUMM Part 1 adds the efficiency and productivity for a MySQL Database Administrator.

MySQL on Docker: Running ProxySQL as a Helper Container on Kubernetes

When your application containers are orchestrated and managed by Kubernetes, you might want to use ProxySQL to better take advantage of your distributed database service running on replication or Galera. In this post, we are going to cover how to run ProxySQL on Kubernetes as a helper container in a pod.