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

Galera cluster not working use wsrep_sst_method=xtrabackup (-v2) until first use rsync

I'm trying to setup a galera cluster, with MariaDB 10.2, and percona-xtrabackup-2.3.10-1.el7.x86_64. If bootstrap the donor by wsrep_sst_method=xtrabackup or xtrabackup-v2, the joiner will be unable to join in the cluster, and the error message…
James
  • 1,373
  • 3
  • 13
  • 27
2
votes
2 answers

Kubernetes mariadb galera single node

I am trying to install galera mariadb on my cluster. I only have one node, but plan to scale in the future. It seems to install fine. When deployed it says: ** Please be patient while the chart is being deployed ** Tip: Watch the deployment status…
Peter
  • 23
  • 4
2
votes
0 answers

MariaDB / Galera - Hanging node freezes whole three node cluster

i hope you are all healthy. :-) Currently I have a recurring problem. Our database cluster, consisting of three nodes, currently fails almost daily. The reason is repeated that one of the three nodes hangs and thus somehow hangs the whole cluster.…
Binarycoded_M
  • 21
  • 3
2
votes
1 answer

Maxscale readwritesplit show the same number of connections

I've set up Maxscale to ReadWriteSplit with no reads to master (the default) to a Galera cluster (3 nodes). # # Global configuration # [maxscale] threads=auto local_address=10.1.0.11 query_retries=2 # #…
ac_s_fer
  • 53
  • 4
2
votes
2 answers

auto_increment jumps by 3 and not 1

I have noticed that in my mysql server, the auto_increment setting increments by 3, for example 3 6 9 12 15 etc. All the tables in the database are having the same problem. I'm using mariadb 10.5 on debian 10. Could it be because of having a 3 vps…
diaconu liviu
  • 1,032
  • 2
  • 13
  • 30
2
votes
0 answers

A problem about federated tables in different clusters

I have a Mysql server(node A) in galera cluster 1 and a Mysql server (node B) in galera cluster 2. Node A and node B are indifferent cluster so they have completely different write nodes. I'm trying to join tables in node A with those tables in node…
Shuetsu Haduki
  • 21
  • 1
2
votes
2 answers

Mysql server gone away when running magento setup upgrade after code change

We are on magento 2.3 version. After code change when we run setup:upgrade, our mysql server gets stuck. We noticed there are a lot of alter queries running on db during this. As our table size is large, the DB stuck with these alter queries. Does…
Prabhu
  • 666
  • 6
  • 11
2
votes
2 answers

Galera Mysql wsrep_cluster_status stays Disconnected

My cluster was previously running, I have made these config changes and now Galera cluster bootstrap is not working. I tried bootstraping with /usr/bin/mysqld_bootstrap as well as service mysql start --wsrep-new-cluster . but no luck. mysql> SHOW…
Srikanth Jeeva
  • 3,005
  • 4
  • 38
  • 58
2
votes
1 answer

MariaDB/Galera: Is it safe to connect MariaDB 10.4 nodes to a MariaDB 10.1 cluster?

I've got a running MariaDB/Galera cluster with three MariaDB 10.1 nodes and some InnoDB databases. I like to replace the whole cluster by three new nodes. I've already installed MariaDB on the new machines, but using the newer 10.4 version. Is it…
MW.
  • 544
  • 5
  • 19
2
votes
2 answers

I want to scale mariadb database for huge number of query requests

I use Moodle on centos7 with Php, Mariadb, Nginx. There are huge number of users that use this Moodle. If the number of users grows more than 300user per sec, the Moodle has delay in response and seems to be hanged! I read about: Galera (multi…
m.Azadi
  • 23
  • 4
2
votes
2 answers

How to test critical reads and slow synchronisation with a galera cluster

This question is not on how to solve issues with replication, the intention is to find bugs caused by slow replication. For performance, we do not want all queries to be synchronous, just queries we identify as critical read. We have sometimes bugs…
Trendfischer
  • 7,112
  • 5
  • 40
  • 51
2
votes
1 answer

How to configure datasource for keycloak to work well with galera cluster?

ENV: Linux: Red Hat 7.5 (Maipo) MariaDB: 10.2.13-MariaDB Keycloak: 3.4.3.Fina JDBC driver: mariadb-java-client-2.2.5.jar Decription: I start a keycloak instance , make it to connect to a galera-cluster. while : If I use “kill -9 mariaDB process” on…
ZOU Zhiyuan
  • 145
  • 3
  • 8
2
votes
0 answers

MariaDB Galera Cluster: SELECT ... FOR UPDATE why no locking?

Why is the record not locking between 2 nodes of MariaDB Galera Cluster 10.2.11? Node 1 Node 2 START TRANSACTION; SELECT * FROM table WHERE id = 1 FOR UPDATE; +----+------+ | id | info | +----+------+ | 1 |…
salam_akhin
  • 21
  • 3
2
votes
1 answer

why no index and/or PK on table DATABASECHANGELOG?

Quote from MariaDB Galera Cluster - Known Limitations All tables should have a primary key (multi-column primary keys are supported). DELETE operations are unsupported on tables without a primary key. Also, rows in tables without a primary key…
Sybil
  • 2,503
  • 3
  • 25
  • 36
2
votes
1 answer

Connection issue with MariaDB and HAProxy (cluster)

I have a problem with the connection of my vm where haproxy is running, and the clusters. Let me explain the issue. I’ve setup 2 galera cluster machine with MariaDB (IPs 192.168.0.1 and 192.168.0.2) and a haproxy host (IP 192.168.0.3). I’ve followed…
S. Galati
  • 58
  • 10
1 2 3
…
27 28