Severalnines Blog
The automation and management blog for open source databases

Severalnines blog

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

High Availability on a Shoestring Budget - Deploying a Minimal Two Node MySQL Galera Cluster

Learn how to set up a Galera cluster with just 2 nodes and use Garbd to retain high availability.

Posted in:

Schema changes in Galera cluster for MySQL and MariaDB - how to avoid RSU locks

This post shows you how to avoid locking existing queries when performing rolling schema upgrades in Galera Cluster for MySQL and MariaDB.

Posted in:

9 DevOps Tips for going in production with MySQL / MariaDB Galera Cluster: webinar replay

In this webinar, we will guide you through 9 key tips to consider before taking Galera Cluster for MySQL / MariaDB into production.

Posted in:

Sign up for our new webinar: 9 DevOps Tips for Going in Production with Galera Cluster for MySQL / MariaDB

In this webinar, we will guide you through 9 key tips to consider before taking Galera Cluster for MySQL / MariaDB into production.

Posted in:

How to set up read-write split in Galera Cluster using ProxySQL

This blog shows you how to setup read-write split in Galera Cluster using ProxySQL. It also covers some limitations that we found at the time of writing.

Posted in:

MySQL on Docker: Introduction to Docker Swarm Mode and Multi-Host Networking

This blog post covers the basics of managing MySQL containers on top of Docker swarm mode and overlay network.

Severalnines Launches #MySQLHA CrowdChat

This post discusses the official launch of our #MySQLHA Crowdchat. This CrowdChat is brought to you by Severalnines and is hosted by a community of subject matter experts. CrowdChat is a community platform that works across Facebook, Twitter, and LinkedIn to allow users to discuss a topic using a specific #hashtag. We are focusing on the hashtag #MySQLHA in this CrowdChat.

Webinar Replay & Slides: How to build scalable database infrastructures with MariaDB & HAProxy

Replay of the webinar with WooServers and Severalnines on how CloudStats.me moved from MySQL to clustered MariaDB with HAProxy and MaxScale for high availability.

Posted in:

Automation & Management of Galera Clusters for MySQL, MariaDB & Percona XtraDB: New 1-Day Online Training Course

Galera Cluster for MySQL, MariaDB and Percona XtraDB involves more effort and resource to administer than standalone systems. If you would like to learn how to best deploy, monitor, manage and scale your database cluster(s), then this new online training course is for you!

Posted in:

Deploy an asynchronous slave to Galera Cluster for MySQL - The Easy Way

Due to its synchronous nature, Galera performance can be limited by the slowest node in the cluster. So running heavy reporting queries or making frequent backups on one node, or putting a node across a slow WAN link to a remote data center might indirectly affect cluster performance. Combining Galera and asynchronous MySQL replication in the same setup, aka Hybrid Replication, can help. A slave is loosely coupled to the cluster, and will be able to handle a heavy load without affecting the performance of the cluster. The slave can also be a live copy of the Galera cluster for disaster recovery purposes.

Posted in:

Pages