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
3
votes
2 answers

MariaDB Avoid Deadlocks

My original error was Error No: 1213 - Deadlock found when trying to get lock; try restarting transaction Okay, so I wrote a loop with max retries and a wait in between to try and get through the deadlocks. $Try = 0; while (!$Result =…
Brian Leishman
  • 8,155
  • 11
  • 57
  • 93
3
votes
0 answers

galera priority abort and thread certification errors

We are running Percona MySQL 5.5 XtraDB cluster (2 nodes and an arbitrator) galera 2-2.12. I'm running haproxy to provide a transparent proxy (through iptables TPROXY) aimed specifically at one node unless it's unavailable. Every 10-20 days we run…
user7937233
  • 31
  • 2
3
votes
2 answers

Getting a very bad performance with galera as compared to a standalone mariaDB server

I am getting an unacceptable low performance with the galera setup i created. In my setup there are 2 nodes in active-active and i am doing read/writes on both the nodes in a round robin fashion using HA-proxy load balancer. I was easily able to…
LakshayK
  • 162
  • 2
  • 8
3
votes
1 answer

Correct isolation level for sequential counter

I'm working on a billing system (C# code, MySQL Galera Cluster backend, InnoDB storage engine) and have a doubt about how to generate a truly unique sequence number for invoices. Usually in other systems I created a unique service to get the invoice…
Gusman
  • 14,905
  • 2
  • 34
  • 50
3
votes
2 answers

Galera_new_cluster command not starting a cluster

Following documentation on how to set up a MariaDB Galera cluster, I simply created the proper config files and started my primary db server with the galera_new_cluster command (I'm running RHEL7). According to the documentation, at that point you…
ctrlaltdel
  • 37
  • 1
  • 1
  • 4
3
votes
4 answers

mariadb 10.1.13 galera cluster : error

mariadb 10.1.x galera cluster setting. first node 192.168.159.132 /etc/mysql/my.cnf [galera] # Mandatory…
happymanxyz
  • 51
  • 1
  • 5
3
votes
2 answers

Galera replication ignore table

With normal Mysql replication we can ignore tables with: replicate_ignore_table I can't find any information on whether or not it's possible to do this with Galera cluster replication. I'd like to ignore a table that is not important so that no…
gijs007
  • 233
  • 1
  • 7
  • 19
3
votes
1 answer

Galera cluster replication between two data centers

We have 4 servers located in two data centers. A direct line connects the two datacenters. We are planning to switch from MariaDB to MariaBD Gallera as circular replication is a pain. A load-balancer is used to determine which server will handle an…
thedethfox
  • 1,651
  • 2
  • 20
  • 38
3
votes
3 answers

HAproxy status showing DOWN

I have setup MariaDB Galera cluster which i have tested and it working fine on the following servers: db1 192.169.0.1 db2 192.169.0.2 db3 192.169.0.3 They are all running on CentOS-6.5, and the MariaDB version is 10.0 My goal was to use HAproxy to…
The Georgia
  • 1,005
  • 7
  • 23
  • 59
3
votes
0 answers

Quartz JobStoreTX instances disappear on cluster recovery

I have configured two Java WARs with quartz schedulers (version 2.2.1) starting with XMLSchedulingProcessorPlugin. Both web applications are also running in a cluster mode (they are deployed in two identical machines), so I enabled the properties…
aloplop85
  • 892
  • 3
  • 16
  • 40
2
votes
1 answer

Keycloak and MariaDB Galera - No connection between

I am trying to install using Helm Chart Repository image of Keycloak so that MariaDB Galera is used as database. Installation helm repo add bitnami https://charts.bitnami.com/bitnami helm repo update helm upgrade keycloak bitnami/keycloak…
portableunit
  • 45
  • 3
2
votes
0 answers

deleting the database is not synchronized in another node

I used this tutorialand I have 2 servers (nodes). Everything works fine, the problem is when I stop MariaDB on both servers and then delete the database on the second node. When I try to synchronize again, the second server does not recognize the…
moh3en
  • 21
  • 3
2
votes
2 answers

How does data availability of Cassandra compare with MariaDB's Galera or MySQL replication?

I've tried my best to channel this into a specific and digestible question. I have a low traffic website that has ~1.5m database read/writes per day and 300k monthly human users. My synchronous Galera cluster consists of 2 nodes in the UK at DC1, 2…
igitabout
  • 21
  • 2
2
votes
1 answer

MariaDB THREADS_CONNECTED build up with php-fpm static

The Problem My app is written in PHP, on top of Laravel. Every hour, I have to restart php-fpm to prevent the MariaDB database from hitting max_connections = 150 and disabling the app since no more connections can be created. Diagnostic…
ProudOne
  • 333
  • 4
  • 17
2
votes
1 answer

MariaDB Galera on Minikube: mkdir: cannot create directory '/bitnami/mariadb/data': Permission denied

I want to deploy a MariaDB Galera instance onto a local Minikube cluster with 3 nodes via Helm. I used the following command for that: helm install my-release bitnami/mariadb-galera --set rootUser.password=test --set db.name=test The problem is, if…
Relative_Programming
  • 23
  • 1
  • 3
1 2
3
…
27 28