Introduction to the Severalnines ClusterControl API and SDK – Part I
This is Part I of a multi-part Several9s blog series on how to use Severalnines' ClusterControl REST API client SDK to programmatically control ClusterControl in order to accomplish many facets of database life cycle management...
Zero Downtime Upgrades Made Easy with ClusterControl
“Keep your database upgraded to the latest version - it’s for your safety” is something you may frequently hear as sound advice and best practice when it comes to database management. On the other hand,...
How to use Cluster-to-Cluster Replication in a Galera Cluster
Previously, we announced a new ClusterControl 1.7.4 feature called Cluster-to-Cluster Replication. It automates the entire process of setting up a disaster recovery cluster off your primary cluster, with replication in between. With this feature: One...
Proactive Galera Monitoring (Developer Studio/Advisors angle)
Monitoring is one of the vital parts for many organizations. In fact, there is a role specifically for monitoring purposes. This proves that with proactive monitoring, a lot of things could be achieved including driving...
ClusterControl: Intro to the New Query Monitor
ClusterControl 1.9.0 was released on July 16th 2021 with a lot of new features introduced to the system. Those features include Redis Management and Monitoring, a new agent-based Query Monitoring system for MySQL and PostgreSQL,...
Webinar Replay: Top Five Tips to Drive MariaDB Galera Cluster Performance for Nextcloud
Are you a MariaDB database administrator that is facing problems regarding your Galera Cluster implementations? Perhaps you even tried to make it work in harmony with Nextcloud? If you have answered “yes” to any of...
Proactive MySQL Monitoring (Developer Studio/Advisors Angle)
Monitoring your MySQL database proactively is imperative nowadays. It plays a crucial and significant part for managing and controlling your database especially for your production-grade clusters. Missing specific information that would be beneficial for improving...
ClusterControl – Advanced Backup Management – mariabackup Part II
In the previous part we have tested backup time and effectiveness of the compression for different backup compression levels and methods. In this blog we will continue our efforts and we will talk about more...
ClusterControl runtime configuration options
When you install ClusterControl, it has a default configuration that maybe doesn’t fit your requirements so probably you will need to customize this installation. For this, you can modify the configuration files, but you can...
ClusterControl – Advanced Backup Management – mariabackup Part I
ClusterControl can, among others, act as a great tool to help you design and execute the backup schedule. Numerous features are available including backup verification, transparent backup encryption and many others. What is quite commonly...
Using Sysbench to Generate Test Data for Sharded Table in MySQL
Sysbench is a great tool to generate test data and perform MySQL OLTP benchmarks. Commonly, one would do a prepare-run-cleanup cycle when performing benchmark using Sysbench. By default, the table generated by Sysbench is a...
How to configure SELinux for MySQL-based systems (MySQL/MariaDB Replication + Galera)
In the era that we are living in now, anything with a less secure environment is easily a target for an attack and becomes a bounty for the attackers. Compared to the past 20 years,...