Severalnines Blog
The automation and management blog for open source databases

Severalnines blog

Filter by:
Clear
Apply (1) filters
23 blog posts in 13 categories

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.

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.

A Guide to the MariaDB Columnstore for MySQL Admins

Big data processing and data warehousing plays an important role in analytics, forecasting, statistical reports, and more. This blog will help MySQL DBA's leverage the MariaDB ColumnStore (a columnar-storage engine system which is part of MariaDB AX) for these types of tasks.

Posted in:

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.

How to Automate Daily DevOps Database Tasks with Chef

Managing databases can be repetitive, and performing manual tasks on a daily basis can be tedious and error-prone. Therefore, if you are already using Chef to automate your infrastructure, why not automate your databases as well? In this blog, we will show you how to translate your manual DBA tasks into an automated set of rules with Chef.

Top Common Issues with MHA and How to Fix Them

MHA (Master High Availability) is a popular failover solution used in MySQL Master-Slave topologies. It is stable and used in production by large companies such as Facebook. In this blog, we outline the most common but important issues that you might encounter when running MHA. We’ll also see how to resolve them.

How to Automate Database Failover with ClusterControl

It might not be possible to avoid disasters, but with some preparation, it is certainly feasible to reduce the impact on your business. Automatic failover is one of those things. The goal of database failover automation is to minimize your downtime and reduce loss of money. However, failover can not always be automated as there are risks; false positives may lead to unnecessary escalations.

In this blog, we’ll have a look components you may use to build an automated stack, and take a closer look at ClusterControl’s failover functionality.

Performance Monitoring for TimescaleDB

Doing a performance monitoring in TimescaleDB is always a challenging task, especially for a very huge time-series data. ClusterControl offers a way to help a DBA or a developer to make things feasible and productive with the aid of the different features integrated within ClusterControl. Check out this blog as we showcases what are these and how you can leverage ClusterControl to monitor your TimescaleDB cluster.

Deploying Secure Multicloud MySQL Replication on AWS and GCP with VPN

MySQL Replication is still favored by some organization as it's simple to implement and run. However, in a multi-cloud setup like Google Cloud Platform <–> Amazon Web Services, things can get tedious without proper cluster management, monitoring and observability tools. This blog showcases how to create a secure implementation of cloud <–> cloud replication and how ClusterControl can be used to resolve these impediments.

Pages