Severalnines Blog
The automation and management blog for open source databases

Severalnines blog

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

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.

MySQL on Docker: Running a MariaDB Galera Cluster without Orchestration Tools - DB Container Management - Part 2

So you’ve deployed MariaDB cluster on Docker, what next? What do you do when containers fail or are rescheduled, and IP addresses change? How do you ensure that the database adapts to changes to the underlying container configurations? In this follow-up blog post, we’ll look into cluster management and orchestration of Galera cluster on Docker.

Deploying PostgreSQL on a Docker Container

This blog provides a high level overview and tips and tricks for deploying your PostgreSQL database on Docker.

MySQL on Docker: Running a MariaDB Galera Cluster without Container Orchestration Tools - Part 1

Container orchestration tools do not always play nicely with database clusters. In this blog post, we are going to look into how to run a MariaDB Galera Cluster on Docker containers using the standard Docker image on multiple Docker hosts without the help of orchestration tools like Swarm or Kubernetes.