Severalnines Blog
The automation and management blog for open source databases

Severalnines blog

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

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.

PostgreSQL Streaming Replication vs Logical Replication

This blog provides an overview of streaming replication and logical replication for PostgreSQL and what you can use each for in your setup.

MySQL on Docker: How to Monitor MySQL Containers with Prometheus - Part 1 - Deployment on Standalone and Swarm

Prometheus is an open-source software for monitoring and alerting, it depends on exporters to ‘scrape’ information from e.g., MySQL running on Docker. In this blog, we’ll see how to deploy the database as well as the monitoring stack with Prometheus and its components. We’ll do this for both MySQL running on standalone Docker containers as well as a Galera Cluster running on Docker Swarm.

An Overview of Amazon RDS & Aurora Offerings for PostgreSQL

This provides an overview and tips & tricks for running PostgreSQL on Amazon RDS and Aurora.

Using Kubernetes to Deploy PostgreSQL

This blog provides steps on how to run a PostgreSQL database on a Kubernetes cluster using Docker containerization.

How to perform Schema Changes in MySQL & MariaDB in a Safe Way

This blog describes best practices to make your database schema changes in MySQL and MariaDB flawless. We will walk you through different scenarios and recomment some approaches for each.