Severalnines Blog
The automation and management blog for open source databases

Severalnines blog

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

A Guide to Partitioning Data In PostgreSQL

For databases with extremely large tables, partitioning is a wonderful and crafty trick for database designers to improve database performance and make maintenance much easier.  This blog provides an overview of partitioning data for PostgreSQL.

Crash Course Webinar Replay: How to Get Started With Open Source Database Management

Watch the replay of this 60min crash course by Krzysztof Książek, Senior Support Engineer at Severalnines and expert Database Administrator (DBA), on managing open source databases.

How to Get Started with Open Source Database Management - Tips & Tricks from an Expert

This blog post presents tips & tricks helpful for getting started with and managing an open source database.

Newly Updated “MySQL Load Balancing with HAProxy” Tutorial

We have recently updated our tutorial on MySQL Load Balancing with HAProxy.  Read about deployment and configuration, monitoring, ongoing maintenance, health check methods, read-write splitting, redundancy with VIP and Keepalived and more.

How to Deploy Galera Cluster for MySQL using Docker Containers

Virtual Machines are great, and very useful when trying out new software. However, they might be an unnecessarily heavyweight solution when testing clusters, especially if these consist of multiple nodes running exactly the same software. Each VM runs a full-blown OS image. On the other hand, Linux Containers (LXC) are an efficient alternative to OS-level virtualization and can run multiple isolated systems on a single host. Docker is a wrapper around LXC, it automates the deployment of applications inside containers. 

Installing ClusterControl Standby Server

As you might already know, ClusterControl runs on a dedicated host. Failure of the ClusterControl host (or the datacenter it is running in) does not affect your running database cluster, however you cannot manage the cluster during that time. This is inconvenient. To guard against this, it is possible to deploy a standby ClusterControl server and increase the availability of your management infrastructure. 

Posted in:

Clustering MySQL Backend in OpenStack

OpenStack uses a database to store data for all OpenStack services such as compute nodes available, running instances, state and so on. The DB takes part in every user request, from listing all instances to creating new VMs, so it is central to the operation of OpenStack. In a high availability environment, the database should be clustered so as to avoid a single point of failure (SPOF).