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
1 answer

Deploy mariadb galera cluster in kubernetes/docker swarm

I'm trying to deploy scalable mariadb galera cluster in kubernetes or docker swarm. Since each pod or containers needs its own galera config, how should i create my deployment so i could be able to scale it without any manual work? I think we can't…
hamedb71
  • 141
  • 1
  • 8
1
vote
1 answer

Both datacenters continue working when connection between is down

Suppose we have one galera clusters in two data centers. one with 3 nodes and the other one with two nodes. When connection between them goes down, 3 nodes datacenter will be primery and continue working.but two node side will stop. How is it…
Behdad
  • 184
  • 3
  • 12
1
vote
0 answers

Cant start mariadb after switching Data Directory

Im trying to switch the data directory of mariadb to my HDD drive. But if i change datadir variable in the 50-server.cnf, mariadb wont start. I have already modified the new directory with chmod and chown. After switching the directory i get this…
KingArthur
  • 11
  • 1
1
vote
0 answers

Galera Cluster: mysterious desync every night at 5:30

We have a galera cluster with four servers at two locations with the following setting: server1 (location 1) with weight 2 server2 (location 1) with weight 2 server3 (location 2) with weight 2 server4 (location 2) with weight…
Mel_T
  • 451
  • 5
  • 15
1
vote
3 answers

Cannot get galera cluster to start - -bash: galera_new_cluster: command not found

I am following instructions to install MariaDB Galera cluster on Centos 7.6 But, I just cannot get the cluster to start. I can get the MariaDB service started on both nodes. Here is my server.cnf [galera] # Mandatory…
sharadov
  • 968
  • 2
  • 13
  • 32
1
vote
0 answers

Async replication between 2 mariadb galera clusters

I have 2 mariadb galera clusters having 3 nodes each. I want to achieve async replication between them(master slave). What would be the parameters that needs to be configured in all 6 nodes. As per my understanding we can achieve this with help of…
Gurmeet singh
  • 11
  • 2
1
vote
1 answer

MariaDB + Galera node 99% RAM usage

The database node is consuming 99% of RAM and 100% of the swap. The server has CPU with 48 cores and 126GB of RAM. It is a dedicated server to MariaDB. total used free shared buff/cache available Mem: …
ancar31
  • 172
  • 2
  • 8
1
vote
1 answer

Seeking solution for implementing backups in only one DC

We are running MariaDB Galera cluster in 3 Datacenters. We are using mariabackup tool for taking backups in each datacenter but, since the same data is replicating on all the 3 datacenters we are trying to implement a solution which includes…
Harika Kusuma
  • 99
  • 1
  • 1
  • 4
1
vote
1 answer

cannot start galera cluster on centos 7

I am trying to install a new galera cluster on 3 nodes with centos 7. When I try to start the cluster on the master node with gcomm:// nothing in starts successfully but I cannot start Mariadb on the other nodes. systemctl status mariadb.service…
Apostolis Type R
  • 13
  • 3
1
vote
0 answers

Unable to complete SST transfer due to "WSREP: SST position can't be set in past." error

I am using "MariaDB 10.3.8" and "MariaBackup" for state transfer.wsrep_sst_method=Mariabackup. I have a donor node and "galera_new_cluster" is running. I want to add another node(joiner) to the cluster. After the mariabackup SST transfer finishes, I…
Sam Moradi
  • 11
  • 2
1
vote
1 answer

MySQL Galera 5.7 max connection issue

I am using MySQL Galera cluster as a backed database for Cloudera CDH environment. Recently I upgraded MySQL version from 5.6 to 5.7, My CDH version is 5.14.But post upgrade I am facing max_connections issues sometimes, max connection limit is 512…
Anurag
  • 11
  • 1
1
vote
1 answer

Galera: Cannot write to database when indexing large data

I am using Galera Cluster with 3 nodes. I am currently meet following problems. I want to write more than 500 millions of records into database, for example table Data. Here is following steps: Create table NewData with schema as Data but without…
Trần Kim Dự
  • 5,872
  • 12
  • 55
  • 107
1
vote
0 answers

Galera 'Deadlock found when trying to get lock' on commit when a node drops

I'm seeing 'Deadlock found when trying to get lock' when issuing a COMMIT while a different node in the WAN Galera cluster has recently had connectivity issues (at virtually the same time as the COMMIT). In this particular situation I'm inserting…
human79
  • 11
  • 2
1
vote
1 answer

What are the risks associated with Galera Active-Active for a single table with continuous reads and writes?

I am considering using Galera Active-Active with five MySQL nodes. The nodes sit behind a load balancer, and the application can write to any of the nodes. My application reads / writes / updates to the same table roughly 1000 times per second. The…
Tom Brock
  • 920
  • 7
  • 29
1
vote
1 answer

Removing a Galera node from a cluster

There is a lot of documentation and mentions online for removing a node from the cluster that you simply need to do: SET GLOBAL wsrep_desync = ON; SET GLOBAL wsrep_on = OFF; However this doesn't seem to remove the node at all from the cluster,…
James MV
  • 8,569
  • 17
  • 65
  • 96
1 2 3
…
27 28