Severalnines Blog
The automation and management blog for open source databases

Severalnines blog

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

How to Monitor Your ProxySQL with Prometheus and ClusterControl

In this blog post, we’ll look into how to monitor your ProxySQL instances in-depth using ClusterControl’s new agent-based monitoring approach with Prometheus.

Tracking High Availability for PostgreSQL with Heartbeat

This blog details how you can use the program Heartbeat to deliver high availability for PostgreSQL.

How to Deploy PostgreSQL for High Availability

In this blog, we will review some important concepts of High Availability, possible database HA architectures and useful components when implementing PostgreSQL HA. Then we will see how to use ClusterControl to deploy an entire high availability stack for PostgreSQL.

How to Deploy MongoDB for High Availability

MongoDB provides ReplicaSets to help you address high availability database requirements. Although support for replication and failover is built-in, it is not enough for the database to be considered production-ready. That requires a set of policies and procedures, like getting alerted in case of performance slowdowns, anomalies or failures in a live environment. Backups are essential. Being able to automatically recover from different types of failures can drastically reduce downtime.

How to Deploy a Production-Ready MySQL or MariaDB Galera Cluster using ClusterControl

ClusterControl can be used to deploy open-source database clusters that are configured in complex topologies. The full high availability stack includes both database and proxy layers.

In this blog, we are going to show you how to deploy a production-grade Galera Cluster, complete with load balancers, for a high availability setup.

An Overview of Volume Level Replication for PostgreSQL Using DRBD

Volume level replication is a generic approach that not only applies to PostgreSQL, but also all relational databases. In this blog, we’ll show you how to use DRBD,  a distributed replicated storage system for Linux, to replicate your database for high availability.

A Developer’s Guide to MongoDB Replica Sets

This blog provides a high-level, developers view of achieving high availability with MongoDB using replica sets. It includes how-to instructions and tips and tricks for getting it right.

The Easy Way to Deploy MySQL Replication and ProxySQL with Automatic Failover

This blog post shows you how to easily deploy a highly available MySQL replication setup with ProxySQL and Keepalived using ClusterControl.

Creating New Modules using PostgreSQL Create Extension

The PostgreSQL Create Extension allows you to extend the functionality of PostgreSQL to meet the needs of your specific application. This blog details how to use this functionality.

Multitenancy Options for PostgreSQL

How do you get multiple databases to co-exist in Postgres? Do you place them in separate databases within the same cluster? Or is a harder separation approach better? Are there any implications on security or the ability to get a consolidated view of the data? As we will see in this blog, there are different approaches to consider.