Severalnines Blog
The automation and management blog for open source databases

Severalnines blog

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

PostgreSQL on the Rise: 2018 Postgres Findings & 2019 Trends

PostgreSQL has seen real growth in the past few years, getting closer and closer to MySQL, which continues to be the world’s most popular open source database. In this blog we explore what’s been happening with PostgreSQL in 2018 and some predictions for the future.

2019 Open Source Database Trends & Predictions

2018 saw a rise in PostgreSQL, a boom in containizeration and increased adoption of DevOps in the enterprise. What will 2019 hold? This blog details some industry predictions as well as ones from the Severalnines team.

Deploying MongoDB Using Docker

This blog provides an introduction to deploying MongoDB using a Docker container. We will look at some important concepts like volume mapping and connecting to a MongoDB container from another container using links.

Webinar Replay: How to Manage Replication Failover Processes for MySQL, MariaDB & PostgreSQL

Watch the replay of this webinar for a detailed overview of what failover processes may look like in MySQL, MariaDB and PostgreSQL replication setups. We’ll cover the dangers related to the failover process and look at how ClusterControl manages it as well as how it can be configured for both assisted and automated failover.

Using PostgreSQL Logical Replication to Maintain an Always Up-to-Date Read/Write TEST Server

This blog discusses logical replication in PostgreSQL: its use cases, general information on the status of this technology, and a special use case in particular on how to setup a subscriber (replica) node of the primary server in order to function as the database server for the testing environment, and the challenges met.

How to Take Advantage of the New Partitioning Features in PostgreSQL 11

With the recent release of PostgreSQL 11 there are a lot of new amazing partitioning features. The details of these new partitioning features will be covered in this blog with a few code examples.

How to Upgrade PostgreSQL10 to PostgreSQL11 with Zero Downtime

The old way to accomplish upgrades on PostgreSQL used to be using pg_upgrade, dumping and restoring, or using some third party tools, all of them with their own caveats. Nowadays, PostgreSQL allows us to use logical replication which, in contrast to physical replication, you can replicate between different major versions of PostgreSQL. In this blog, we're going to see how we can upgrade our PostgreSQL 10 to PostgreSQL 11 with zero downtime using logical replication.

MySQL & MariaDB Query Caching with ProxySQL & ClusterControl

A query cache can greatly improve database performance, and there are various types of mechanisms available - from the inbuilt MySQL query cache to external key value stores like memcached or Redis. In this blog, we’ll show you how to cache your queries via ProxySQL, and avoid the overhead of an additional dedicated caching layer.

MySQL on Docker: Multiple Delayed Replication Slaves for Disaster Recovery with Low RTO

A delayed replication slave is useful in recovering from accidental data deletion. But how long should the delay be? Too short delay might not be enough for you to get to a terminal and stop an offending query. Too long delay means a long recovery time when catching up.

This blog post shows how to deploy multiple MySQL delayed slaves on one single physical host with Docker, and shows some of the recovery scenarios.

Database Monitoring - Troubleshooting Prometheus with SCUMM Dashboards

Our SCUMM dashboards rely on Prometheus and exporters to provide high-resolution monitoring data. However, there are cases when dashboards may not load. This blog goes through some troubleshooting guidelines.