Severalnines Blog
The automation and management blog for open source databases

Severalnines blog

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

How to Setup Asynchronous Replication Between MariaDB Galera Clusters

Asynchronous replication is commonly used between Galera clusters. In this blog post we show how to set it up for MariaDB Galera clusters and how ClusterControl can help you with it.

Database Automation with Puppet: Deploying MySQL & MariaDB Galera Cluster

This post walks you through deployment of MySQL/MariaDB Galera Cluster using Puppet module. We’ll also look at how ClusterControl can be used to automate the management aspects of the environment once it’s set up.

What's New in MariaDB Cluster 10.4

This blog provides an overview of the new features and functions of MariaDB Cluster 10.4. Based on Galera Cluster from Codership, MariaDB Cluster is a synchronous multi-master database cluster that runs on Linux.

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.

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.

Database High Availability for Camunda BPM using MySQL or MariaDB Galera Cluster

This blog post covers how to deploy a highly available MySQL or MariaDB database cluster for Camunda BPM 7.10 Community Edition on Linux. Camunda supports major databases through JDBC drivers, namely Oracle, DB2, MySQL, MariaDB and PostgreSQL. We will show two different implementations for the database endpoint, one leveraging ProxySQL and the other using the standard JDBC driver.

How to Run and Configure ProxySQL 2.0 for MySQL Galera Cluster on Docker

ProxySQL 2.0 has become GA and it comes with new exciting features such as GTID consistent reads, frontend SSL, Galera and MySQL Group Replication native support. This blog post shows how to run the new ProxySQL 2.x for Galera Cluster on Docker container, which is quite a bit different as compared to ProxySQL 1.x.

HA for MySQL and MariaDB - Comparing Master-Master Replication to Galera Cluster

Replication and Galera Cluster are both widely used to implement high availability for MySQL/MariaDB, but when should you pick one over the other? What are the limitations of each solution, and what are the trade offs?
In this blog post, we will look at the differences in terms of data consistency, conflict resolution, failover, node provisioning and robustness.

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.

How to Improve Replication Performance in a MySQL or MariaDB Galera Cluster

Can we increase Galera performance if we speed up applying data that is replicated between its nodes? In this blog post, we assess the impact of having multiple wsrep_slave_threads on the overall performance of Galera cluster.

Pages