Severalnines Blog
The automation and management blog for open source databases

Severalnines blog

Filter by:
Apply (1) filters
294 blog posts in 1 category

How to Monitor PostgreSQL Running Inside a Docker Container: Part Two

This is part II of the blog How to Monitor PostgreSQL Running Inside a Docker Container.

How to Manage MariaDB 10.3 with ClusterControl

In this blog post, we would like to give you an overview of the MariaDB 10.3 administration with ClusterControl.

Running Multiple PostgreSQL Instances on a Single Host

The recent release of ClusterControl 1.7.3 offers new functionality which allows for a multi-postgresql installation on the same host. This type of setup can save you money and resources by running two instances on the same server. In this blog will show how to do it with ClusterControl.

Announcing ClusterControl 1.7.3: Improved Support PostgreSQL & New Cloud Deployment Options

ClusterControl 1.7.3 includes improvements to PostgreSQL support including the ability to run multiple instances on a single host. It also includes support for new point-and-click cloud deployments to the top three cloud providers.

MySQL Replication with ProxySQL on WHM/cPanel Servers - Part 2

In this second part of how to run MySQL Replication with ProxySQL on WHM cPanel servers, we cover the post-deployment operations for maintenance, management, failover as well as advantages over the standalone setup.

MySQL Replication with ProxySQL on WHM/cPanel Servers - Part 1

In this two-part blog series, we are going to give a complete walkthrough on how to run MySQL Replication with ProxySQL on WHM cPanel servers. This first part covers the deployment of MySQL Replication and ProxySQL, as well as ProxySQL integration with cPanel via standardized hooks integration. The second part will cover management and ongoing maintenance of the setup.

How to Use the Failover Mechanism of MaxScale

A load balancer similar to the likes of ProxySQL & HAProxy, MariaDB MaxScale has its own diverse features and capabilities. MaxScale has the ability to do auto-failover which can save you from catastrophe as well as a switch over mechanism to make your life easier during maintenance. This blog explores this failover feature and how you can leverage it as part of your setup.

How to Setup Asynchronous Replication Between MariaDB Galera Clusters

Asynchronous replication is commonly used between Galera clusters. In this blog post we show how to set it up for MariaDB Galera clusters and how ClusterControl can help you with it.

Exploring the Different Ways to Encrypt Your MariaDB Data

Data encryption is very important especially if you have to follow the standards and recommendations that a law regulation requires you to implement based on your security and standards in your infrastructure. This blog will discuss about different ways to encrypt your data using MariaDB Database Server. It covers encryption in-transit, at rest, and RDS.

How to Automate Deployment of MySQL Galera Cluster using s9s CLI and Chef

To automate deployment of an entire database cluster via Chef requires a significant amount of coding, but by leveraging the s9s CLI, you can quickly get it done and be more productive. This blog shows you how to get the job done without having to write and maintain thousands of lines of code.