Severalnines Blog
The automation and management blog for open source databases

Severalnines blog

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

How to Automate Daily DevOps Database Tasks with Chef

Managing databases can be repetitive, and performing manual tasks on a daily basis can be tedious and error-prone. Therefore, if you are already using Chef to automate your infrastructure, why not automate your databases as well? In this blog, we will show you how to translate your manual DBA tasks into an automated set of rules with Chef.

Benchmarking Managed PostgreSQL Cloud Solutions - Part Four: Microsoft Azure

The last in our four part series “Benchmarking Managed PostgreSQL Cloud Solution” this blog takes a close (and somewhat painful) look at Microsoft Azure and benchmark it for PostgreSQL using pgbench and sysbench.

Database-Aware Load Balancing: How to Migrate from HAProxy to ProxySQL

HAProxy is a great piece of software, but it may just not be enough for more demanding users and environments. How do you migrate from HAProxy to ProxySQL? This blog post explains the process and shows how ClusterControl can help.

Popular Docker Images for MySQL and MariaDB Server

There are many Docker images for MySQL and MariaDB, but which one should you use? This blog post lists the most popular Docker images that can be found on Docker Hub, the world's largest library and community for container images.

How to Deploy PostgreSQL to a Docker Container Using ClusterControl

Deploying a single PostgreSQL instance on Docker is fairly easy, but deploying a replication cluster requires a bit more work. In this blog, we’ll see how to deploy PostgreSQL on Docker and how we can make it easier to configure a primary-standby replication setup with ClusterControl.

What’s New in ProxySQL 2.0

ProxySQL 2.0 has been released recently with quite a few interesting features, including causal reads, SSL for frontend connections and native support for Galera Cluster. In this blog post, we will explore these new features.

Benchmarking MongoDB - Driving NoSQL Performance

Database systems are crucial components in the cycle of any successful running application. Every organization involving them therefore has the mandate to ensure smooth performance of these DBMs through consistent monitoring and handling minor setbacks before they escalate into enormous complications that may result in an application downtime or slow performance. This blog shows you how you can ensure you achieve MongoDB system performance.

An Overview of Streaming Replication for TimescaleDB

TimescaleDB uses a stream of write-ahead log (WAL) records to keep the standby databases synchronized. In this blog, we’ll review some concepts related to Streaming Replication and how ClusterControl can help us configure it in an easy way.

Benchmarking Manual Database Deployments vs Automated Deployments

Good system administrators and devops hate performing mundane tasks and constantly look for ways at automating themselves out of the job. There are plenty of automation tools out there to help the cause. But if automation is a no brainer, why aren’t more people doing it? In this blog post we compare three ways of deploying a MySQL Galera cluster - manual, Ansible playbook and ClusterControl.

How to Perform a Failback Operation for MySQL Replication Setup

In case of master failure in a MySQL Replication setup, the most updated slave can be promoted to new master and all slaves repointed to the new master. But once the failed master has been fixed, what is the best way to re-introduce it as master, so as to restore the original topology.

This blog post shows how to perform the MySQL master failback operation.

Pages