Tag: Galera Cluster

Clustering

Convert Galera Node to Async Slave And Vice-versa With Galera Cluster

Recently, I was working with one of our customers and this was their requirement as they wanted to automate this process for converting a galera node to async slave and make async slave to galera node without shutting down any servers. This blog post will provide a step-by-step instruction on how to accomplish this. Here, …

Clustering

Announcing Galera Cluster Security Release for MySQL 5.5.59, 5.6.39, 5.7.21 with Galera 3.23

Codership is pleased to announce the release of Galera Replication library 3.23, implementing wsrep API version 25. This release incorporates all changes up to MySQL 5.7.21, MySQL 5.6.39 and MySQL 5.5.59, including several fixes to vulnerabilities reported by Oracle in here. New features and notable fixes in Galera replication since last binary release by Codership …

Clustering

Galera Cluster and Antivirus Scanner on Linux

Today we had to investigate in a very strange behaviour of IST and SST on a MariaDB Galera Cluster. The symptom was, that some Galera Cluster nodes took a very long time to start. Up to 7 minutes. So the customer was concluding that the Galera Cluster node does an SST instead of an IST …

Clustering, Miscellaneous

How to move InnoDB-Logfiles on a Galera Cluster

Somebody recently asked, what they had to do, if they wanted to move their InnoDB-Logfiles back to the datadir. As a challenge, the servers were part of a Galera Cluster. My first thought was: The problem is not the Galera Cluster itself, it is the rsync-SST (wsrep_sst_method = rsync) that could cause trouble and destroy …