How to Optimize Performance of ClusterControl and Its Components
Monitoring and management are critical to any production environment because performance matters. Slow user interfaces that lag or do not respond, delayed alerts, and cluster job timeouts when the server is starved of resources are...
How to Monitor HAProxy Metrics with ClusterControl
Load balancers are an essential component of any highly available database setup. They’re used to increase the capacity and reliability of your critical systems and applications by preventing any one server from becoming overloaded. We...
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...