Severalnines Database Blog

ClusterControl offers you a different approach of managing databases which can not be observed and experienced in other platforms. It can be deployed on-prem, on the cloud, or on a containerized type of environment. It can be deployed flexibly and has a massive feature that offers rich and powerful operations that makes it easier to manage your database and without requiring you to create your automated scripts. ClusterControl will handle this for you as shown by this blog. This blog showcases how it is feasible to manage multiple database technologies with ClusterControl.

This blog provides a brief guide on how to start with database automation. It will walk you through the main points and essentials of database automation, such as what can be and what should not be automated, and discusses some useful automation tools.

In this blog, we will validate a PostgreSQL backup by restoring the backup onto a Docker container. For this post, we will use pgBackRest as the tool of choice to run the PostgreSQL backup which is maintained in a separate repository host.

To efficiently manage multiple ProxySQL nodes, one has to make sure whatever changes performed on one of the nodes is applied across all the nodes. Without native clustering, one has to manually export the configurations and import them to the other nodes. This blog walks you through on how to run ProxySQL native clustering with headless service on Kubernetes.

Keeping up to date with database upgrades is crucial in defending against security vulnerabilities. Learn how ClusterControl can help manage all aspects of the database lifecycle, including upgrades and testing.

Previously, we announced a new ClusterControl feature called Cluster-to-Cluster Replication. It automates the entire process of setting up a DR cluster off your primary cluster, with replication in between. In this blog, we will show you how to use it in a Galera Cluster.

In this blog post, we will review how to utilize Developer Studio and Advisor features in ClusterControl and create a custom script to proactively monitor our Galera cluster.

In ClusterControl 1.9.0 a new query monitor has been introduced. We will go through what are some of the features that have been offered as well as look at some of the comparisons between an older version 1.8.2.

Keeping up to date with database upgrades is crucial in defending against security vulnerabilities. Learn how ClusterControl can help manage all aspects of the database lifecycle, including upgrades and testing.

Benchmarking sounds quite easy to do but there are several things you have to keep in mind while doing that. In this blog we are going to cover some of the traps you may run into while performing benchmarking

In ClusterControl 1.9.0 a new query monitor has been introduced. We will go through what are some of the features that have been offered as well as look at some of the comparisons between an older version 1.8.2.

Are you a MariaDB DBA? This webinar replay is for you! If you have missed it, we have taken a look into the top five tips that you can use to improve MariaDB Galera Cluster performance for Nextcloud. Tune in!

Sometimes, third party database monitoring and advisoring lack customization based on the needs. In this blog, we will review how easy to create Advisory for MongoDB in ClusterControl

One of the new and advanced feature for MongoDB backup management is the ability to upload the backup to the cloud. In this blog, we will review the difference between the backup methods and how to upload the backup to the cloud.

Two of the most popular NoSQL databases supported by ClusterControl are MongoDB and Redis. How they come into existence and gain attraction, popularity and changing the landscape of the database management system is the primary essence of this blog post.

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. In this blog, we will show you where you can modify the configuration and the available options.

Encryption and security have been accompanied as part of your success for managing your data, especially for MySQL databases nowadays. It's imperative that security is always a priority and that something is not to be overlooked. This blog demonstrates how to determine if your MySQL server connections are encrypted and how to enforce them.

In this blog post, we will discuss one of the common errors in MySQL, the reason why it happens as well as some tips on troubleshooting this.

Benchmarking sounds quite easy to do but there are several things you have to keep in mind while doing that. In this blog we are going to cover some of the traps you may run into while performing benchmarking

In ClusterControl 1.9.0 a new query monitor has been introduced. We will go through what are some of the features that have been offered as well as look at some of the comparisons between an older version 1.8.2.

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. In this blog, we will show you where you can modify the configuration and the available options.

ClusterControl offers you a different approach of managing databases which can not be observed and experienced in other platforms. It can be deployed on-prem, on the cloud, or on a containerized type of environment. It can be deployed flexibly and has a massive feature that offers rich and powerful operations that makes it easier to manage your database and without requiring you to create your automated scripts. ClusterControl will handle this for you as shown by this blog. This blog showcases how it is feasible to manage multiple database technologies with ClusterControl.

In this blog post, we are going to focus on SNMP traps and alerting. SNMP Traps are the most frequently used alert messages sent from a remote SNMP-enabled device (an agent) to a central collector, the “SNMP manager.” In the case of ClusterControl, a trap could be an alert after the critical alarm for a cluster is not 0, indicating something bad is happening.

In this blog series, we are going to showcase a proof-of-concept (PoC) on how to integrate ClusterControl with SNMP protocol. At the end of the blog series, we would ultimately be able to send an SNMP trap to an SNMP manager (Nagios, Zabbix, etc). In this first part, we are going to cover the MIB and SNMP agent.

Upgrading your PostgreSQL 11 to PostgreSQL 13 with TimescaleDB and PostGIS can be a tedious job, especially if you’re not familiar with the steps and procedures. What are the caveats and the prerequisites for doing this before you start the job? This blog will guide you on how to manage the major version upgrade on a complex setup with plugin extensions being enabled such as TimescaleDB and PostGIS.

Data is probably the most valuable asset in a company, so you need to make sure it is safe and can be restored in case of failure. In this blog, we will see how to restore a PostgreSQL and TimescaleDB backup from the ClusterControl CLI using the powerful s9s tool.

In ClusterControl 1.9.0 a new query monitor has been introduced. We will go through what are some of the features that have been offered as well as look at some of the comparisons between an older version 1.8.2.

No matter what type of technology you are using, it is always important to have a good monitoring system that allows you to prevent issues before affecting your business. In this blog, we will see how to use ClusterControl to monitor your PostgreSQL database in a proactive way using custom scripts.

Upgrading your PostgreSQL 11 to PostgreSQL 13 with TimescaleDB and PostGIS can be a tedious job, especially if you’re not familiar with the steps and procedures. What are the caveats and the prerequisites for doing this before you start the job? This blog will guide you on how to manage the major version upgrade on a complex setup with plugin extensions being enabled such as TimescaleDB and PostGIS.

Data is probably the most valuable asset in a company, so you need to make sure it is safe and can be restored in case of failure. In this blog, we will see how to restore a PostgreSQL and TimescaleDB backup from the ClusterControl CLI using the powerful s9s tool.

Backups are a basic step in all Disaster Recovery Plans, but the management and monitoring of them could be a difficult task if you have a complex environment. In this blog, we will see how you can use ClusterControl to manage your PostgreSQL backups using advanced backup features.

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. In this blog, we will show you where you can modify the configuration and the available options.