Severalnines Blog
The automation and management blog for open source databases

Severalnines blog

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

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.

An Overview of WiredTiger Storage Engine for MongoDB

WiredTiger is a NoSQL, Open Source extensible platform for data management. WiredTiger uses MultiVersion Concurrency Control architecture. MongoDB acquired WiredTiger Inc. on December 16, 2014. The WiredTiger storage engine is the default storage engine starting in MongoDB version 3.2.

How to Migrate WHMCS Database to MariaDB Galera Cluster

The WHMCS software suite relies on a MySQL database to store its data, so how do you make it highly available? This blog post shows how to migrate the existing WHMCS database from a standalone MySQL server (provided by the WHM/cPanel server itself) to a three-node MariaDB Galera Cluster to improve the database availability.

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.

Which Time-Series Database is Better: TimescaleDB vs InfluxDB

In the new time-series database world, TimescaleDB and InfluxDB are two popular options with fundamentally different architectures. One is based off a relational database, PostgreSQL, the other build as a NoSQL engine. In this blog, we’ll give you a short description of those two, and how they stack against each other.

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.

Top Common Issues with MHA and How to Fix Them

MHA (Master High Availability) is a popular failover solution used in MySQL Master-Slave topologies. It is stable and used in production by large companies such as Facebook. In this blog, we outline the most common but important issues that you might encounter when running MHA. We’ll also see how to resolve them.