Deploying and Managing PostgreSQL 11: New in ClusterControl 1.7.1
A few days ago was the release of a new version of ClusterControl, the 1.7.1, where we can see several new features, one of the main ones being the support for PostgreSQL 11. To install...
Announcing ClusterControl 1.7.1: Support for PostgreSQL 11 and MongoDB 4.0, Enhanced Monitoring
We are excited to announce the 1.7.1 release of ClusterControl - the only management system you’ll ever need to take control of your open source database infrastructure! ClusterControl 1.7.1 introduces the next iteration of our agent-based...
MySQL Performance Cheat Sheet
MySQL is extensive and has lots of areas to optimize and tweak for the desired performance. Some changes can be performed dynamically, others require a server restart. It is pretty common to find a MySQL...
What is MariaDB TX? How to Manage the New MariaDB MySQL Fork!
You may have heard about MariaDB TX and you may have wondered what it is? Is there a difference between it and MariaDB Server 10.3? In this blog post we would like to give you...
Raising the Bar on MySQL, MariaDB, PostgreSQL & MongoDB Management
I’d like to take advantage of the quiet days between holidays to look back on 2018 at Severalnines as we continue to advance automation and management of the world’s most popular open source databases: MySQL,...
The New Way to Manage Open Source Databases
Not so long ago, the database industry consisted of a handful of vendors. Databases were mainly relational, and ran on single machines. High availability was implemented via active-standby ‘clusters’. With a vertical ’scale-up’ model, it...
2019 Open Source Database Trends & Predictions
As we wrap up 2018 and prepare for 2019 we decided it was time to take a moment and pause to think about the changes that have been happening over the past year and what...
Webinar Replay: How to Manage Replication Failover Processes for MySQL, MariaDB & PostgreSQL
If you’re looking at minimizing downtime and meet your SLAs through an automated or semi-automated approach, then this webinar replay is for you: A detailed overview of what failover processes may look like in MySQL,...
MySQL & MariaDB Query Caching With ProxySQL & ClusterControl
Queries have to be cached in every heavily loaded database, there is simply no way for a database to handle all traffic with reasonable performance. There are various mechanisms in which a query cache can...
Database Monitoring – Troubleshooting Prometheus With SCUMM Dashboards
It’s almost two months now since we released SCUMM (Severalnines ClusterControl Unified Management and Monitoring). SCUMM utilizes Prometheus as the underlying method to gather time series data from exporters running on database instances and load...
Database Backup Encryption – Best Practices
Offsite backup storage should be a critical part of any organisation’s disaster recovery plan. The ability to store data in a separate physical location, where it could survive a catastrophic event which destroys all the...
How to Encrypt Your MySQL & MariaDB Backups
We usually take care of things we value, whether it is an expensive smartphone or the company’s servers. Data is one of the most important assets of the organisation, and although we do not see...