Stack Overflow
Stack Overflow

Questions tagged [galera]

Galera Cluster is a synchronous multi-master cluster for MySQL.

From the project home page, Galera Cluster's features include:

  • Synchronous replication
  • Active-active multi-master topology
  • Read and write to any cluster node
  • Automatic membership control, failed nodes drop from the cluster
  • Automatic node joining
  • True parallel replication, on row level
  • Direct client connections, native MySQL look & feel


410 questions
1
vote
0 answers

Galera mysql node joined the cluster unsuccessfully after being abnormally stopped

We have three nodes in Galera cluster with IPs 172.21.100.23, 172.21.100.24 and 172.21.100.25. The cluster had run successfully for a year. Recently I changed my.cnf on 23 to add some bin log configurations. After that, I restarted mysql on 23,the…
Roy
  • 11
  • 2
1
vote
0 answers

Galera connection issues over haproxy

In our K8 cluster, we use haproxy app for connecting to Galera cluster. Our haproxy.cnf file looks like global maxconn 2048 external-check stats socket /var/run/haproxy.sock mode 600 expose-fd listeners level user user haproxy …
Sachith Muhandiram
  • 2,819
  • 10
  • 45
  • 94
1
vote
1 answer

Understand HAProxy to load balance on a Galera Cluster

I am a newbie in software architecture and I have some question: I don't understand which requests is sent to the HAProxy on this image. I mean: if one "Application" Server (backend) want to save data in the Galera Cluster what is the request that…
Theo Cerutti
  • 779
  • 1
  • 10
  • 33
1
vote
1 answer

MariaDB Galera Cluster Node accesses disk a lot which leads to a massively degraded performance

We have a three node mariadb galera cluster, 3 ubuntu 20 VMs running on different physical servers, and one nodes can only process around half the queries, but has at least tripple the CPU load as each of the other two nodes. The three nodes run on…
user1526836
  • 73
  • 5
1
vote
0 answers

How to fix Mariadb Galera cluster error "Semaphore wait has lasted > 600 seconds"

I am getting following error on one of my node in Galera cluster and after the error, this node goes shutdown and eventually out from the Galera cluster. Someone please help to fix this. Mutex LOCK_SYS created…
Anup_Tripathi
  • 2,817
  • 3
  • 26
  • 37
1
vote
0 answers

A galera node went down and started reporting error innodb as unknown or unsupported engine

One of my node was down and it was also the donor for the node A, so from node A config I removed the down node as donor. This is so that node A should not have to wait for the node to come up. As the node that originally went down was on slow…
Ciasto piekarz
  • 7,853
  • 18
  • 101
  • 197
1
vote
1 answer

mariadb galera node stuck at WSREP state transfer ongoing

I restarted mariadb galera cluster node, and now its taking ages to start, however I noticed Status: "WSREP state transfer ongoing, current seqno: 9331 waited 510.000000 secs" and also noticed Memory: 71.3M memory usage is going up everytime I…
Ciasto piekarz
  • 7,853
  • 18
  • 101
  • 197
1
vote
0 answers

Mariadb Galera node will not successfully rejoin unless it picks a particular node to rejoin via

Debian 10, Maridadb 10.3.26, Galera-3 25.3.31 I have a three node cluster. The nodes are named node3, node4, and node5. Node3 gets disconnected from the cluster on occasion. If it picks node5 to recover from I get 2020-11-18 19:42:08 7 [Note] WSREP:…
user3718260
  • 181
  • 1
  • 6
1
vote
0 answers

MariaDB (10.5.8) Galera cluster nodes have out-of-sync GTID if writes to not-replicated DB

I've configured a Galera cluster using MariaDB official docker 10.5.8, consisting of 3 nodes. At first, I could see consistent value of gtid_binlog_pos in all nodes. But after a while I needed a database that shouldn't be replicated, so I created a…
JAE HOON KO
  • 51
  • 2
1
vote
0 answers

Can't install Galera Manger on Ubuntu

According to the documentation the Galera Manager can be installed on Ubuntu or AWS L2. Incidentally, at this point, Galera Manager runs either Ubuntu or Amazon Linux 2. Future releases of Galera Manager may allow for other distributions of…
glennstar
  • 161
  • 1
  • 10
1
vote
1 answer

Does maxscale (with Galera) handle Non-primary component/node condition automatically?

We are going to use maxscale as a sql proxy with our mariadb database, with Galera cluster. In Galera cluster, when quorum is not achieved and split-brain condition happens, some node becomes Non-primary. The Non-primary nodes start rejecting…
Anup_Tripathi
  • 2,817
  • 3
  • 26
  • 37
1
vote
1 answer

Asterisk Realtime Crashing on load when using HAProxy to Galera Cluster

Works fine under little load on our test bench but once we add to production the whole thing crashes and we are unable to get asterisk to function correctly. Almost as if there is a lag or delay in accessing the MariaDB cluster. Our architecture and…
growntreee
  • 21
  • 1
1
vote
1 answer

2 mySQL clusters in HAProxy

We use HAProxy (1.5) to proxy mysql to 4 Galera Nodes. We use roundrobin and works good for High Availability and Load Balancing. See /etc/haproxy/haproxy.cfg global user haproxy group haproxy defaults mode http log global …
user3148002
  • 51
  • 8
1
vote
1 answer

MySQL 8 does not use the provided config files

I am installing Galera 4 on top of MySQL 8 on Debian but can't make it work. Once I start first node with bootstrap command: mysqld_bootstrap it starts with the following options: /usr/sbin/mysqld $$'$\'$\\\'--wsrep-new-cluster --wsrep-on\\\'\''…
smoofy
  • 11
  • 2
1
vote
2 answers

proxysql SHUNNED servers in hostgroup

I have 2 proxysql(2.0.13) + keepalived in front of a 3-node galera-cluster, and 2 of the galera-nodes appeaers as "SHUNNED" in my hostgroup 10. I do not know why they appear as "SHUNNED" and they are never recovered. So i was hoping that somebody…
gwar
  • 21
  • 1
  • 4
1 2 3
…
27 28