Severalnines Blog
The automation and management blog for open source databases

Severalnines blog

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

How to Optimize PostgreSQL Logical Replication

Logical Replication or pglogical is a method of replicating specific data objects (tables) and their changes to the replica in real-time which is similar to streaming replication. The term logical is in contrast to physical replication, which uses exact block addresses and byte-by-byte replication. This blog provides tips on how to optimize logical replication system.

How to Setup MariaDB 10.3 Replication Using Ansible and Vagrant

Ansible is a system that allows you to automate the deployment of various IT services. In this blog, we’ll show you how to expedite the deployment of your MariaDB master/slave environment using some Vagrant boxes and Ansible playbook.

What's New in MariaDB 10.4

MariaDB 10.4 will soon be released as production-ready. In this blog post, we’ll go through some of the most important features that MariaDB 10.4 will bring to us.

Database Automation with Puppet: Deploying MySQL & MariaDB Replication

This post walks you through deployment of MySQL/MariaDB replication using Puppet module. We’ll also look at how ClusterControl can be used to automate the management aspects of the environment once it’s set up.

Comparing Data Stores for PostgreSQL - MVCC vs InnoDB

MVCC is one of the primary ways for most of the RDBMS to solve read-write contention. In this blog, we’ll see in details how PostgreSQL and InnoDB implement the same. Also, we’ll see some of the major differences between their implementation.

A Guide to Deploying TimescaleDB with Docker

While setting up a single instance of Timescale on a Docker container is a pretty straight-forward task, deploying a replication cluster to achieve high availability is not. Customizing something from the OS side, or choosing a different OS image altogether makes it even harder. In this blog, we’ll deploy TimescaleDB on Docker and discuss a way to make it easier to configure a replication with ClusterControl using a clean OS image.

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.

Why You Should Still Be Using the MMAPv1 Storage Engine for MongoDB

This blog describes why you should consider the original MMAP storage engine which in MongoDB (which was replaced by Wired Tiger) if you are running a high-volume application.

How to Automate Migration from Standalone MySQL to Galera Cluster using Ansible

Database migrations are painful, as they involve a lot of steps - from creation of the target infrastructure to migrating schema and data, and oh.. a lot of testing. Some of the steps can be automated though, you can rely on Ansible. This blog post presents a playbook that can be used to assist in the process of migrating to Galera Cluster.

Deployment and Maintenance of MongoDB Using Ansible

Ansible can speed up your daily workflow and give you the ability to execute actions in a more controlled way. In this blog post, you will see how to start with Ansible and how it can help you to manage your MongoDB instances.