Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [galera]

MariaDB Galera Cluster is a synchronous multi-master cluster.

Galera Cluster is a virtually-synchronous multi-master, write-anywhere, nothing-shared clustering solution for MySQL. It features automatic data provisioning and parallel replication, and its main focus is on providing high availability and read scaling for the InnoDB engine.

It can be found under different names, depending on the vendor:

318 questions
16
votes
2 answers

What are the drawbacks of using Galera Cluster instead of Master/Slave Replication?

What are the drawbacks of using Galera Cluster instead of regular Master/Slave Replication? Galera's 0 slave lag time, Synchronous replication and no Single point of failure seem very appealing then why isn't Galera cluster as common?
Sam
  • 344
  • 1
  • 2
  • 12
8
votes
2 answers

How to recover MariaDB Galera Cluster after full crash?

I crashed all my 3 nodes. After all nodes have been started I noticed that mariadb is dead. An I couldn't run it again. I am using CentOS 7 on all servers I tried to start first node and then others but without success. First of all I tried to find…
Oleksandr
  • 403
  • 2
  • 6
  • 14
7
votes
3 answers

100x less insert performance with Galera multi-master

I am running an application which inserts a lot of rows and we were experiencing some low performance. So i started benchmarking the Galera Cluster with sysbench and oltp_insert.lua (practically inserts with random key). The performance of the…
mhstnsc
  • 173
  • 1
  • 6
6
votes
2 answers

MySQL stuck on "wsrep: initiating replication for write set (-1)"

I ran into a situation with MySQL recently which I hadn't seen before. We have a Percona cluster with 3 nodes. The master stopped processing queries and the PHP FPM web application we host became unresponsive. When I checked SHOW PROCESSLIST, MySQL…
Josh
  • 558
  • 3
  • 8
  • 18
5
votes
1 answer

SELECT performance on MariaDB Galera cluster vs. MariaDB is terrible

We are evaluating a Galera setup and so far we have not noticed to many drawbacks except a few queries that have terrible READ performance I cannot put my finger on it. The query by itself isn't really optimized but it comes back under 0.20 seconds…
Glenn Plas
  • 306
  • 2
  • 8
5
votes
1 answer

Does it make sense to run a cluster of database servers in docker containers?

I'm currently looking into setting up a database cluster (MySQL Galera or Percona) but I have only 2 machines. However, according to many sources I've read (This article from the Mariadb KB), the minimal node size in the cluster should be 3, to…
patatepartie
  • 53
  • 1
  • 3
5
votes
1 answer

Getting duplicate record errors like "Duplicate Entry for key 'PRIMARY', error code 1062" when importing a full backup into slave

We're restoring our slave with a full backup from our master, and getting a bunch of duplicate key errors. Once the slave gets caught up, it does not throw any errors (only when it is behind the master). We replicate all of the database tables. We…
John
  • 51
  • 2
5
votes
3 answers

How to restart MariaDB Galera cluster?

How to restart MariaDB Galera cluster? After all node have been crashed I try to recover the cluster but without success. I have only 2 nodes. As documentation says I set a parameter on one of the node: set global…
Oleksandr
  • 403
  • 2
  • 6
  • 14
5
votes
2 answers

ERROR WSREP`: gcs/src/gcs.cpp:gcs_open():1379:` Failed to open channel 'test_cluster'

I have three server that I want to Install Galera clustering on them, I followed this link to install and config it. but when I want to start the first server I got this error : root@node107:/home/debian# service mysql start --wsrep-new-clusterping…
amir jj
  • 289
  • 1
  • 5
  • 16
5
votes
1 answer

MySQL cluster write performance with Galera (MariaDB)

I am currently evaluating the migration from our current database server to a three node cluster. Our current server is a VM running MariaDB 10.1 with asynchronous replication to another server in order to perform backups of the database without any…
filotti
  • 51
  • 1
  • 2
5
votes
1 answer

WSREP: failed to report last committed and stop

I have galera cluster and I have 4 nodes. I'm importing some data. however one node gives error. Warning. The warning is; warning WSREP: Failed to report last committed 59102, -q (interrupted system call) mysqld_safe Number of processes running…
Melih
  • 337
  • 2
  • 5
  • 16
5
votes
2 answers

How (if at all) does Galera enforce authentication for SST via rsync when adding a node?

I have to be missing something here. It just hit me as added a new node to my cluster in order to prepare for the removal of a different node: "How does the cluster know that it is okay to send the new node a SST?" I am pretty sure that the only…
Shaun McPeck
  • 63
  • 6
5
votes
2 answers

grastate.dat with seqno -1 on a healthy cluster. Why?

We use those versions: # rpm -qa | egrep…
Sybil
  • 2,578
  • 6
  • 34
  • 61
4
votes
1 answer

Galera Cluster Failed to report last committed

I'm experimenting with Galera Cluster with 3 nodes, but I'm having some issues but I'm not sure why. What I noticed is that I'm having lots of failed to report last committed (number), -110 (connection timed out). Well I'm using 100Mb/s connection,…
Leandro Jacques
  • 153
  • 1
  • 7
4
votes
2 answers

Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2 “No such file or directory”) when configuring cluster

I have 3 MariaDB nodes. Want to configure cluster. Specified in gcomm:// in my.cnf ips of all members in cluster according to this. And added ?pc.wait_prim=no at then of gcomm://ip1,ip2,ip3 Then mysqld process starts on each VM, but when i try to…
rokpoto.com
  • 183
  • 1
  • 4
  • 14
1
2 3
…
21 22