2022 Developer Survey is open! Take survey.

Questions tagged [galera]

MariaDB Galera Cluster is a synchronous multi-master cluster.

Filter by
Sorted by
Tagged with
1 vote
0 answers
21 views

Different size binlogs of galera-cluster nodes

I have galera-cluster with (HA) Keepalived. I noticed that node receiving the connection from the applications has a smaller binlog. On a node that accepts connections from applications: START ...
user avatar
0 votes
0 answers
26 views

Which MariaDB-Galera Node Should I Start After Cluster Crushing or Failing?

Sometimes my 3-Node GaleraCluster fails and doesn't serve. When I check I see all of them are activated but two of them are not working, so I check log files I see one of them could not operate an ...
user avatar
0 votes
1 answer
23 views

prevent a galera node from bootstrapping

I have bootstrapped a node as the first node in a new galera cluster. then when I joined another node to it. the node joind as bootstrap but there are no grastat.dat file in that joind node because I ...
user avatar
0 votes
0 answers
19 views

ERROR WSREP: Failed to create TOI event buf: 1

We encounter the following error in our Mariadb galera cluster after we update to 10.4.24- Can someone help ? 2022-04-11 13:37:47 4865 [ERROR] WSREP: Failed to create TOI event buf: 1 2022-04-11 13:...
user avatar
0 votes
0 answers
70 views

Best Practice of High Availability For MariaDB

I'm preparing to run a MariaDB Cluster with High Availability and I'm looking for the best practices. Years back, I used to run MariaDB in master-master mode, and there was a big issue. Whenever any ...
user avatar
0 votes
1 answer
22 views

MariaDB Galera estimated database size is different from each node

newbie question, why does my database size differs from other nodes in the cluster when I run: SELECT table_schema "database", sum(data_length + index_length)/1024/1024/1024 "size in GB&...
user avatar
  • 3
0 votes
0 answers
30 views

How to Check Which Node of Galera Cluster Has the Latest Data When the Galera Cluster Fall in Deadlock?

I have a 3-node MariaDB Galera cluster and sometimes I see that the database system doesn't answer to connections. To ask a better question, let me explain with an example situatiın which I faced ...
user avatar
0 votes
0 answers
42 views

remote backup restore with xtraBackup

how i can restore backup created with xtrabackup to remote server ? we do not have enough space to copy backup files and then restore them . is it any way like xbstream that backup on remote server , ...
user avatar
0 votes
1 answer
19 views

MariaDB run a new cluster while keeping an old cluster running

I currently have a 5-cluster mariadb galera set up. Two of the servers are in the cloud while three of them are locally hosted. I kinda want to start the three on premise servers to act as a separate ...
user avatar
  • 3
0 votes
0 answers
127 views

MariaDB Galera cluster filling disk with gcache.page files

I am running 3 node Galera cluster MariaDB-server-10.3.13-1.el7.centos.x86_64 on CentOS7 and its been 2 years no issue but suddenly recently without any change on node-2/3 disk started filling up and ...
user avatar
  • 181
0 votes
0 answers
45 views

Galera Cluster in read-write split and query cache

I currently have 3 MariaDB 10.4 servers, configured as a Galera cluster. In front of it, a Maxscale router to split writes (1 master) and reads (2 slaves). QC is disabled in all 3 servers. My question ...
user avatar
0 votes
1 answer
32 views

Does a read-write-split on your galera cluster still make sense when running the servers on the same (private) cloud environment?

I know about the claims that a Galera cluster should/might perform better in a lot of cases whenever a read-write-split is set up, so there are dedicated read and write hosts in the cluster. This ...
user avatar
0 votes
1 answer
181 views

Recover 3-node Galera cluster from crash

this morning we got a power failure and all (physical) servers were abruplty shut down. I got a problem on my MySQL Galera cluster (3 nodes). I was able to start 1 node. On other two, MySQL cannot ...
user avatar
1 vote
1 answer
292 views

MariaDB Galera Cluster galera.cache file getting bigger than specified gcache.size

We have a 3 node Galera Cluster running on Kubernetes, behind 2 HAProxy PODs configured so, all queries are executed on the first POD/node of the cluster if available, and the other 2 nodes, provide ...
user avatar
0 votes
0 answers
55 views

How to configure ProxySQL with Galera to allow using user-defined variables?

My original use case was more complicated, involving calling stored procedures with user-defined variables and getting a result back in the variable, but even this simple thing doesn't work: SELECT @x;...
user avatar
  • 5,716
0 votes
1 answer
113 views

Monitor existing cluster using Galera Manager throwing: deployment status error: DB IP address must be provided

I am trying to monitor my existing galera cluster using galera manager. I installed galera manager and chose Monitor existing cluster. I added the ssh keys provided in the manager in the respective ...
user avatar
  • 103
1 vote
1 answer
100 views

gtid_binlog_pos variable contains two values

I am trying to setup a master-slave replication with galera-cluster (choose 1 node as the primary master) and a standalone mariadb server (slave). I have successfully setup the replication and data is ...
user avatar
1 vote
0 answers
22 views

Mariadb galera cluster with galera load balancer and master-slave replication: Errorno 1062 handler error HA_ERR_FOUND_DUPP_KEY

I have the following setup in my environment. Galera cluster with 2 nodes: db01 and db02. Server with galera load balancer installed: glb01, applications/clients connect to the cluster via port 8010 ...
user avatar
1 vote
1 answer
347 views

WSREP connection to peer timed out, no messages seen in PT3S

I'm running 3 node Galera cluster using MariaDB-server-10.3.13-1.el7.centos.x86_64 and periodically seeing following errors in logs. I did google about this error but didn't find any good answer. Does ...
user avatar
  • 181
0 votes
1 answer
62 views

How to Tune MariaDB Database System With Right Parameters

I have a MariaDB Galera 3-Node Cluster as the DB system but since I built, it is working with the default parameters. I only changed the parameter as max_connections=3000. It has been about 6 months ...
user avatar
0 votes
2 answers
133 views

Steps to remove node from percona cluster

I have to update the os on a few servers and I need to remove a db from the cluster. wsrep_cluster_address='gcomm://192.168.2.59,192.168.2.60,192.168.2.61,192.168.2.62,192.168.2.63' Do I remove the ...
user avatar
0 votes
0 answers
27 views

Where Should I Install Galera Load Balancer? On Cluster Nodes?

I want to install Galera Load Balancer for my 3-Node Galera Cluster, but where should I install the galera load balancer? Can I install on the cluster nodes or should I build a new server for galera ...
user avatar
0 votes
2 answers
58 views

How to Prevent the Connections for MariaDB Galera-Cluster When There is Only One Active Node?

I was using "rsync" as the wsrep_sst_method in my galera.cnf files on 3-Node Galera Cluster. When it was so, the system served when there was at least 2 active node. So when any two node ...
user avatar
0 votes
1 answer
70 views

MariaDB Galera 3-Node Cluster Sometimes Doesn't Serves

I have 3 Node MariaDB Galera cluster. I am using "mariabackup" as the wsrep_sst_method, but the database system doesn't work properly. I can say that sometimes there are 100 connection ...
user avatar
0 votes
1 answer
148 views

Galera Cluster Crashes together?

Hello I'm currently having trouble with my galera cluster. It was working fine earlier but suddenly all of the Nodes crashed. I have 3 local nodes and 1 node on the cloud. During the time it went down ...
user avatar
  • 3
1 vote
2 answers
74 views

Is Mysql creating any temp table , when running Mysql delete query?

Server details We have one Galera cluster Mariadb with 3 nodes . On primary node database size is 200GB & diskspace size is 400GB . On other 2 secondary nodes database size is 200GB & ...
user avatar
0 votes
0 answers
17 views

Galera: I want to add "Node X" to my cluster but use "Node Y" to transfer the data

I'm having quite a problem with adding a node to my current Galera cluster. Right now I have 4 nodes on my cluster: 3 of them are on my local and 1 currently on the cloud. I successfully synced my ...
user avatar
  • 3
0 votes
1 answer
211 views

mariaDB with a 3 node galera cluster is eating more and more RAM

I am running mariaDB 10.3.29 in a 3 node Galera Cluster on 3 VMs with 14G RAM each. Despite configuring to best knowledge, it continues to eat more and more RAM and after around 3 months the machines ...
user avatar
0 votes
0 answers
43 views

Correct way to setup wsrep_notify in MariaDB

I have been running 5 cluster nodes in MariaDB 10.4/galera setup for quite sometime without any wsrep_notify_cmd configuration. To test basic functionality, I added the notify script script and ...
user avatar
0 votes
2 answers
21 views

What will happens if read from a node which just suffering a net partition in Galera sql?

Suppose this mode, I have 3 node with Galera sql, each node is a master. I call them A,B,C. If I have a transaction like update, what will happens if I execute the transaction at node A, but the node ...
user avatar
0 votes
1 answer
29 views

How Can I Find the Problems Occurred on MySQL-MariadbDB Systems?

I have built a three-node galera cluster, so it is a Master-Master replication structure. But sometimes the first node goes down and I can't find the problem causing this. I am only looking at /var/...
user avatar
0 votes
0 answers
204 views

Maxscale configuration for read write split between galera nodes and replicas

I have a 3 node Galera Cluster. One of the Galera Cluster nodes is master to a slave and this slave is master to another two slaves. (see picture below). I would like to configure Maxscale so writes ...
user avatar
  • 101
1 vote
1 answer
716 views

ERROR 1180 (HY000): Got error 5 during COMMIT

We're using Galera cluster and I'm running below statement to make a new table: create table tab2 select distinct id , report from my_table ; It runs for sometime and after that it fails/cancel ...
user avatar
0 votes
0 answers
24 views

Mariadb galera cluster on asymmetric IP addresses fails IST/SST

I have a 3-node WAN cluster. The nodes are connected to each-other by VPN without a central server so as to avoid a single point of failure. Instead, each node is an openvpn server with another as ...
user avatar
0 votes
1 answer
611 views

Mariadb Galera [ERROR] mysqld got signal 11 ;

I have a galera mariadb cluster on 3 centos 8 linux servers. Each server crashes several times a week. I have 16 Go RAM on one server and 60 Go ram on other servers. Each wsrep recovery takes about 12 ...
user avatar
1 vote
1 answer
61 views

Is it possible to join MySQL 8.0 to a cluster of MySQL 5.7

I have a MySQL 5.7 (5.7.19-17-57-log Percona XtraDB Cluster) cluster using Galera, but I am in the middle of upgrading to 8.0 -- 8.0.23-14 Percona Server (GPL), Release '14'. I wasn't sure if it was ...
user avatar
2 votes
1 answer
215 views

MariaDB Galera Arbitrator failing to sync with SSL

So the scenario is this. I have already setup a 4 node MariaDB Galera cluster (10.5). I'm also adding on top a 5th Galera Arbitrator and everything syncs and connects just fine. However when I enable ...
user avatar
  • 147
0 votes
0 answers
2k views

ERROR 1047 (08S01): WSREP has not yet prepared node for application use

I have 3 node MySQL Galera cluster in Production, Today when we hit large DDoS on our network cause some issue and assuming some kind of network separation caused following issue on node-1 ERROR 1047 (...
user avatar
  • 181
0 votes
1 answer
174 views

Galera - why can't I use port 4567 for replication?

I have two Galera clusters in two different datacenters. I want to replicate cluster c1(using c1-1 node as replication master) to cluster c2 (using c2-1 node as replication slave). Everything works ...
user avatar
  • 3
1 vote
2 answers
311 views

How to limit impact of a bad application on MariaDB Galera Cluster with MaxScale?

I have a Galera Replication cluster with three MariaDB nodes where a Maxscale Active-Passive cluster in front provides a single node image to tis clients. I have a bad behaving client, which opens ...
user avatar
  • 111
0 votes
1 answer
270 views

Galera cluster slightly slower than single database?

I recently set up a MariaDB galera cluster for our production. I used sysbench to benchmark the cluster against the old database which is on a single server. On my PRD Galera Cluster I got the ...
user avatar
  • 23
1 vote
1 answer
252 views

Automatically and robustly restarting a Galera cluster

Galera clusters, somewhat famously, have a requirement that nodes need to be shut down and brought back up again in a certain order. There are a few questions here and on other sites about recovering ...
user avatar
  • 115
1 vote
0 answers
515 views

Galera Manager web gui for mariadb

I want to create a MariaDB 10.4 multi-master cluster on four Ubuntu 20.04 nodes. As you know Galera manager provides a web GUI interface for the cluster and it's handy for monitoring and add or remove ...
user avatar
1 vote
0 answers
255 views

Why setting up new galera cluster with mariabackup as sst starts but all other nodes failed with same error?

I did a fresh reinstallation of mariadb-server on all the nodes (I removed using sudo apt purge mariadb-*) I started the first node using sudo galera_new_cluster it went fine and is still running. but ...
user avatar
0 votes
1 answer
228 views

My Galera Cluster does not connect across AWS regions

I am building a MariaDB Galera Cluster, on AWS, EC2. Using MariaDB 10.5 and Galera 4. I have two nodes in the California region, named galera_ca and galera_ca2, and a third node in Oregon name ...
user avatar
0 votes
0 answers
1k views

Master node of galera cluster is not in sync, how should I sync them?

master node server id 10 SHOW STATUS LIKE 'wsrep_local_state_comment'; +---------------------------+----------------+ | Variable_name | Value | +---------------------------+-------...
user avatar
1 vote
1 answer
541 views

Mariadb galera cluster master node started and reporting 2 nodes but second node service says activating mariadb

I managed to start the master node mariadb galera cluster, then I started the second node and I check on the first master node; $ sudo mysql -u root -p -e "SHOW STATUS LIKE 'wsrep_cluster_size'&...
user avatar
0 votes
0 answers
249 views

please help starting mariadb galera cluster node

I am getting thsi error: Starting MariaDB 10.4.17 database server... WSREP: Failed to start mysqld for wsrep recovery: '2020-11-23 21:48:20 0 [Note] /usr/sbin/mysqld (mysqld 10.4.17-MariaDB-1:10.4.17+...
user avatar
0 votes
0 answers
40 views

How to increase donor speed on mariadb galera cluster?

hi currently i have database with size 200gb and my every node at 1Gb/s so when 1 node is down and then 2 node will be donor i config mariadb donor with wsrep_sst_method = rsync method. but it's take ...
user avatar
  • 47
1 vote
0 answers
118 views

How to hot merge MariaDb databases from multiple servers into a single one

Current Configuration I currently have 3 servers: server australia with the database canberra servers belgium and germany are a galera cluster with the database bruxelles. Target Configuration My ...
user avatar
  • 111

1
2 3 4 5 6