Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [galera]

Galera Cluster for MySQL is a true Multimaster Cluster based on synchronous replication.

123 questions
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
  • 445
  • 5
  • 18
5
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,454
  • 7
  • 48
  • 88
5
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,454
  • 7
  • 48
  • 88
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
  • 533
  • 3
  • 6
  • 12
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
  • 2
  • 14
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,454
  • 7
  • 48
  • 88
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…
Christopher Thonfeld-Guckes
  • 37
  • 2
  • 7
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
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,033
  • 11
  • 37
  • 72
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
  • 634
  • 2
  • 7
  • 16
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
  • 2
  • 6
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
  • 1
  • 9
2
votes
0 answers

configure pacemaker for galera

I have a galera / mariaDB cluster of two nodes on two remote sites that works perfectly. I want to set up a solution that would pause one of the two servers / node if the ping to an external IP was KO, then restart the same server as soon as the…
Arnaud21
  • 21
  • 3
2
votes
0 answers

Converting Mariadb Galera Cluster into Simple Master Slave Replication Cluster

Now we have this project to convert our Mariadb Galera Cluster (3 nodes) to Simple Master Slave cluster (One master and two slaves). So our goal to get rid of Galera and make our setup just async / semisync Master Slave cluster. We have big tables…
Milad Hamid Elhaei Sahar
  • 151
  • 8
2
votes
1 answer

High CPU usage on MariaDB Galera nodes

I have setup 3 cluster mariaDB using Galera for my web services which load balanced with haproxy. The cluster are working great and sync each other but when visitor on my website reach more than 3000 user, the CPU for each node are peak to high. top…
Robbi Nespu
  • 21
  • 2
1
2 3
…
8 9