Galera Cluster for MySQL is a true Multimaster Cluster based on synchronous replication.
Questions tagged [galera]
132 questions
6
votes
1 answer
Does a Galera equivalent for Postgres exist?
I've been working with Galera for a number of months and like the failover along with the redundancy. I've got a Postgres DB that is in testing and will probably move to production. Is there a Galera equivalent for Postgres? I read about "standby"…
Server Fault
- 3,884
6
votes
2 answers
How to "safely" shutdown/restart a Galera cluster?
First time setting up Galera (Ubuntu 14.04) and I'm unable to restart the cluster after rebooting my nodes. I'm following the this guide and it doesn't exactly mention how to handle a shutdown or reboot (for kernel patches, hypervisor updates,…
Server Fault
- 3,884
6
votes
1 answer
Galera cluster (MariaDB) on Docker/CoreOS: second node doesn't work on first attempt
I'm trying to create an automatic deployment of Galera Cluster with MariaDB, running inside Docker containers on CoreOS.
Software used:
- MariaDB official Docker image, version 10.1.10
- CoreOS 899.5.0, with Docker 1.9.1
Everything is running on 2…
ItalyPaleAle
- 465
4
votes
2 answers
MariaDB Galera Cluster falls out of sync easily
We're trying to debug an issue with a MariaDB cluster.
We're running Maria 10.0.19 on c4.large instances in Amazon EC2; the OS is Ubuntu 14.04 (Trusty).
There are three machines clustered together, replicating fine (we can run create database foo;…
Cera
- 553
4
votes
1 answer
MariaDB how to handle 2/3 node failure in multi master cluster.
I run 3 node multi master MariaDB galera cluster. It basically works for me how it is. When one node fails, two other work and it's fine.
But I'm wondering is there a way for it to keep working on one node? (that is really unlikely but I just…
piotrektt
- 184
3
votes
2 answers
Why is keepalived running two MASTER nodes in my Sticky VIP configuration?
I have keepalived setup (floating VIP) in front of haproxy on each of my three-node galera cluster nodes. When I restart keepalived on any given node, sometimes I end up with two nodes running in MASTER (as evidenced by the…
Server Fault
- 3,884
3
votes
1 answer
Transform Galera cluster into single node mariadb server
We want to get rid of all cluster features on our galera cluster (currently consisting of three virtual machines). The connection between the nodes is not stable enough so the cluster is much slower than our previous single node setup was. Is it…
3
votes
1 answer
Galera cluster - cannot start MariaDB (CentOS7)
I'm trying to install a Galera cluster with 3 mariadb VM's (all of them CentOS 7). I've never done this before, so I was following this guide:
http://tunnelix.com/mariadb-galera-cluster-installation/
The problem is that after I enter my settings on…
João Santos
- 39
3
votes
1 answer
Galera Rsync SST Secured via SSL/SSH
Is it possible to secure Galera Cluster SST via rsync with SSL/SSH? This page suggests it is not, specifically the following quote:
Unlike rsync, xtrabackup includes support for SSL encryption built in.
I have followed all the steps to secure the…
Andrew Ensley
- 972
3
votes
2 answers
Why does MySQL Galera not replicate the user table?
I am running a 3 node MySQL 5.6 Galera Cluster. Everything is in sync and looks fine, but as I just found out the user table was not in sync.
One particular user was not present on the other nodes where I thought it might replicate it after…
merlin
- 2,262
- 12
- 47
- 83
3
votes
2 answers
How to monitor MariaDB Galera cluster status from command line
I know to check the Galera cluster status, the command that should be used after login to the mysql client is:
SHOW STATUS LIKE 'wsrep%';
but, how to get the output directly from the command line?
The command below result in error:
[root@mariadb01…
Sharuzzaman Ahmat Raslan
- 450
- 1
- 5
- 15
3
votes
1 answer
Galera: Run slow ALTER without locking entire server
I have a 3-node galera cluster with a few hundred databases servicing various clients.
I'm only using galera as an easy way to handle replication and fallover. I'm not actually using multiple masters at once.
I need to run a rather expensive ALTER…
chroder
- 704
3
votes
2 answers
Installing MariaDB + Galera via yum fails with "No package MariaDB-Galera-server available"
I'm spun up a brand new Cento OS 7 virtual machine and I'm following this tutorial to install a MariaDB + Galera cluster.
I've added the MariaDB repos as follows:
vi /etc/yum.repos.d/MariaDB.repo
then filled it with
[mariadb]
name = MariaDB
baseurl…
sabbour
- 196
3
votes
1 answer
MariaDB, Galera, xtrabackup - do I need the binary log?
We are using a MariaDB Galera Cluster with 3 nodes. For the state transfer we are using xtrabackup.
We have some problems with the binary logs - they got too big and crashed the server. We can remove them manually with the purge binary logs…
bernhardrusch
- 175
3
votes
0 answers
WireGuard Failover for MySQL Galera Cluster
I'm setting up four servers across four locations in an attempt to create a geo-redundant MySQL Galera cluster. Two of the servers are behind NAT, and I'm currently attempting to use WireGuard to overcome this inconvenience.
Servers one and two are…
TecumTechCEO
- 31