Webinar Replay: Backup Management for MySQL, MariaDB, PostgreSQL & MongoDB with ClusterControl
Thanks to everyone who participated in this week’s webinar on ‘Backup Management with ClusterControl’. The replay is now available to watch online as well as the slide deck. If you feel frustrated by traditional, labour-intensive...
Database Security – Backup Encryption In-Transit & At-Rest
Securing your data is one of the most important tasks that we should prioritize. The emergence of regulations that requires security compliance such as GDPR, HIPAA, PCI DSS, or PHI requires that your data should...
Percona Live Frankfurt 2018 – Event Recap & Our Sessions
Severalnines was pleased to yet again sponsor Percona Live Europe which was held this year in Frankfurt, Germany. Thanks to the Percona Team for having us and the great organisation. At the Conference Severalnines team...
How to Customize your MySQL & MariaDB Backups with ClusterControl
ClusterControl’s centralized backup management feature supports the standard mysqldump, Percona Xtrabackup backup and Mariabackup provided by MariaDB. We believe the chosen command line arguments for the respective methods are optimal for most database workloads, and...
Best Practices for Database Backups
Backups - one of the most important things to take care of while managing databases. It is said there are two types of people - those who backup their data and those who will backup...
Effective Monitoring of MySQL With SCUMM Dashboards: Part 3
We discussed in our previous blogs about the MySQL-related dashboards. We highlighted the things that a DBA can benefit from by studying the graphs, especially when performing their daily routines from diagnostics, metric reporting, and...
How to Create a Single Endpoint for Your PostgreSQL Replication Setup using HAProxy
Managing traffic to the database can get harder and harder as it increases in amount and the database is actually distributed across multiple servers. PostgreSQL clients usually talk to a single endpoint. When a primary...
SQL Firewalling Made Easy with ClusterControl & ProxySQL
Reading the title of this blog post may raise some questions. SQL firewall - what is that? What does it do? Why would I need something like that in the first place? Well, the ability...
How to Cluster Your ProxySQL Load Balancers
A proxy layer between applications and databases would typically consist of multiple proxy nodes for high availability. This is no different for ProxySQL. ProxySQL, just like other modern proxies, can be used to build complex...
Choosing a Database Proxy for MySQL & MariaDB
We’re happy to announce that our new whitepaper Choosing a Database Proxy for MySQL and MariaDB is now available to download for free! Load balancing and high availability go hand-in-hand. Without them, you are left...
Effective Monitoring of MySQL Replication With SCUMM Dashboards: Part 2
In our previous blog on SCUMM dashboards, we looked at the MySQL overview dashboard. The new version of ClusterControl (ver. 1.7) offers a number of high resolution graphs of useful metrics, and we went through...
How to Minimize RPO for Your PostgreSQL Databases Using Point in Time Recovery
In a disaster recovery plan, your Recovery Point Objective (RPO) is a key recovery parameter that dictates how much data you can afford to lose. RPO is listed in time, from seconds to days. Effectively,...