Questions tagged [galera]

MariaDB Galera Cluster is a synchronous multi-master cluster.

Filter by
Sorted by
Tagged with
0 votes
0 answers
13 views

Kubernetes create cluster multimaster using bitnami/mariadb-galera

I'm trying to deploy mariadb-galera multimaster on kubernetes. But when I set external volume I receive this error: mkdir: cannot create directory '/bitnami/mariadb/data': Permission denied this is ...
Marco Ferrara's user avatar
0 votes
1 answer
15 views

Mariadb Galera can't start second node

EDIT: the both server was in Azure I tried to install Galera replication on two server. On my first server the "bootstrap" node will correctly start. When i try to start the second node with ...
Inazo's user avatar
  • 101
0 votes
1 answer
26 views

Row read lock on write

Suppose I have a Galera cluster with 3 nodes. If I start modifying a table and a client start to read the same table from another node, I want it to wait for the write on the other node to finish. The ...
Siavoshkc's user avatar
  • 101
0 votes
0 answers
31 views

Attempting to Switch from MariaDB FKM to Hashicorp Vault Key Management

I've been trying for a good few months now to switch our MariaDB 10.5-Enterprise servers over from File Key Management to Hashicorp Vault key management. We have 13 'regions' each with 3 MDB servers ...
Teemkill's user avatar
0 votes
0 answers
59 views

How do I fix a permission denied error when starting a MariaDB Galera node

I'm trying to spin up a galera cluster based on the official MariaDB 11.2 docker image. My dockerfile is below. When I start the node, I'm getting a permission denied error that is preventing the ...
CrossBound's user avatar
0 votes
0 answers
9 views

Excluding specific schema (or permit specific schema) in galera cluster 3 nodes master-master

I have 3 dedicated servers connected in a private LAN. Each one uses Plesk, a tool that (should) help people to manage domains and other server settings. It uses a scheme called psa for storing server ...
Marcello Kad's user avatar
0 votes
0 answers
16 views

Does MariaDB-Galera cluster have error tolerance function on sst_user credential?

We have done the testing and confirmed the following system behavior of MariaDB-Galera clustering: The first-time bootstrap always needs to get everything correct, including the sst_user credentials ...
Mike's user avatar
  • 13
0 votes
0 answers
15 views

MariaDB could not add nodes to cluster

could someone know how to solve below issue ? i have allow all user to all member node all node can communication as well with port 3306 the issue as below : WSREP: GCache history reset: 39163b37-...
veasna's user avatar
  • 1
0 votes
0 answers
51 views

Replication between two galera clusters

I currently have two 3 node mariadb (10.5.9) Galera clusters set up in different locations, I'm using standard replication to copy data between the primary and secondary. What I've recently noticed is ...
imbrian21's user avatar
0 votes
1 answer
119 views

MariaDB Galera Cluster (10.6.12) and Laravel WSREP issue

I'm administrating a galera cluster with 3 nodes, serving a Laravel application and HAProxy is the gateway to the cluster. We had an interesting issue, and I'm unable to figure out why was there an ...
Imre Bertalan's user avatar
0 votes
1 answer
94 views

Galera Cluster Upgrade

I have 3 node Galera Cluster on Ubuntu 18.04. As part of Ubuntu LCM, I'm upgrading my Setup to 22.04 along with this Galera MariaDB cluster will also upgrade. I have designed below plan to upgrade my ...
Veeru Sharma's user avatar
0 votes
1 answer
238 views

MariaDB not starting after I've deleted ib_logfile

My MariaDB couldn't start and after a little research I've found out I should delete ib_logfile s in /var/lib/mysql to make it run. so I moved ib_logfile0 and ib_logfile1 to another directory and ...
user avatar
0 votes
1 answer
30 views

Is it safe to restore a backup while accepting new queries?

Is it safe to restore a backup while my galera cluster is running and still accepting new queries? If not what is the recommended way to restore a backup? Before using a cluster I would just use ufw ...
Freedo's user avatar
  • 198
3 votes
2 answers
93 views

Different Percona XtraDB nodes use different indexes for the same query

We have three Percona XtraDB nodes arranged in a master-master replication topology. One of our databases contains a heavily utilized table. This table has multiple indexes, as well as a few foreign ...
Anne Douwe's user avatar
0 votes
0 answers
36 views

Data corruption on the secondary peer of a MariaDB-Galera cluster, while the main peer is OK, so how to recover?

We have a Galera cluster of MariaDB databases, consisting of: galera-4.x86_64 v26.4.9-1.el7.centos @mariadb MariaDB-server.x86_64 v10.5.12-1.el7.centos @mariadb The cluster has two nodes working in ...
James's user avatar
  • 149
0 votes
1 answer
54 views

What alternatives are there to generate correlative numbers instead of using primary keys or sequences into galera cluster?

I have galera cluster of three nodes (Mariadb 10.3.13). The server has a database called 'entities'. This database has a table called 'operations'. This table has the following columns: id Int ...
user3637971's user avatar
1 vote
0 answers
111 views

Why does Galera Cluster show port 0?

I am trying to set up my first Galera cluster with MariaDB 11.0.2 on an Arch-based system. I followed the instructions here: https://wiki.archlinux.org/title/Galera server.conf file [galera] # ...
Centaro's user avatar
  • 11
0 votes
0 answers
122 views

Galera cluster truncate table

I have a Galera cluster with three node and they are synced. when I truncate a table in master, the same table is not truncated in other nodes. Also when I truncate, it does not even go to syncing ...
user avatar
0 votes
1 answer
100 views

Data inconsistency between Galera cluster nodes

We currently have a mariab galera cluster with 7 nodes; 3 on local and 4 on Azure cloud. All nodes are using Mariadb 10.5.16 version. My issue is that on my local cluster when I run the following ...
Gwynn's user avatar
  • 33
2 votes
1 answer
387 views

Setup proxysql read-write split with both galera cluster and master slave replication

I have the following setup: Three node galera cluster (galera-1, galera-2, galera-3) galera-2 is master to slave-1 (master-slave replication) slave-1 is master to both slave-2 and slave-3 slave-1, ...
supercoco's user avatar
  • 121
0 votes
1 answer
808 views

Bringing up galera cluster

Because of a mismanagement I have a 3 node cluster down. Before doing the due diligence disregarding seqno and recovery processes, the node that used to be the primary was brought up doing ...
blackliquid's user avatar
0 votes
1 answer
93 views

How do I add 2 missing nodes to MariaDB Galera Cluster using IST and not SST

I inherited an issue where a MariaDB Galera Cluster has only one out of 3 nodes working. Node1: up and running in production and is accepting reads and writes Node2: fresh install it just need to sync ...
netrangermike's user avatar
1 vote
1 answer
56 views

Updating gcache.size on a Three Node Cluster

Is it possible to update this value on Percona 5.7 without restarting a node? Also, do I need to bring the entire cluster down to update the setting, or can I update one node at a time?
Ndeb's user avatar
  • 11
0 votes
1 answer
184 views

Galera WAN Clustering use case, having remote nodes performance impact is not clear

In official doc Galera Use Cases for the 2nd, WAN Clustering use case I am reading the following: "Synchronous replication works fine over the WAN network. There will be a delay, which is ...
g.pickardou's user avatar
0 votes
0 answers
3k views

Is is related the 'Aborted connection 0 to db: unconnected user: unauthenticated host: connecting host' message with server disk full?

I have a MariaDB Galera cluster with three nodes. Let's say the node A, B and C. The node A was detected that disk is full on 2023-01-20 at 20:07:27. I giving you the log results from three nodes. The ...
user3637971's user avatar
0 votes
0 answers
24 views

Can not find Incrementantal State Transfer documentation for MariaDB

I can find State Snapshot Transfers documentation for MariaDB, but can not find the same documentation for IST. IST is mentioned indeed on Configuring MariaDB Galera Cluster page, under the title &...
g.pickardou's user avatar
1 vote
1 answer
796 views

Why should I use MaxScale readwritesplit router over a three node Galera cluster?

In the following official MariaDB blog Getting Started with MariaDB Galera and MariaDB MaxScale the author configures a MaxScale host over a three node Galera cluster, and uses the Galer monitor (OK) ...
g.pickardou's user avatar
0 votes
1 answer
362 views

Galera cluster performance, node count, and where to write?

As far I understand Galera does not scale write performance, best case it does not degrade it, compared to one single server, so we use Galera for HA. (read performance may benefit and it can be load ...
g.pickardou's user avatar
0 votes
1 answer
85 views

Why should any application treat all nodes except one as slaves in a Galera cluster?

In official doc Galera Use Cases for the very first use case I read the following: "Traditional MariaDB master-slave topology, but with Galera all "slave" nodes are capable masters at ...
g.pickardou's user avatar
1 vote
1 answer
421 views

galara unable to sync

I upgraded all servers from 10.3.x to 10.4.x. mysql1 and mysql2 were upgraded successfully however, mysql3 was accidentally upgraded to a much more recent build. All mysql servers are lxc hosted. ...
Arlion's user avatar
  • 71
0 votes
0 answers
51 views

Permanent node removal from Percona cluster

There are instructions about temporary removal a node from Galera, for backup, upgrade or testing. But I couldn't find a safe step-by-step procedure for permanent removal. I have a cluster with 4 ...
sa7's user avatar
  • 101
0 votes
0 answers
239 views

MariaDB 10.9.2 memory leak

I recently upgraded from a single node MySql 5.5 to a 3 node Galera cluster with MariDB 10.9.2. The application is Drupal. All the traffic goes to one node in the cluster, the others are basically ...
Snorri Bergmann's user avatar
0 votes
0 answers
76 views

mariadbd 10.5.18 seems to stop working

I've got a three node galera cluster (mariadb 10.5.18, ubuntu 20.04.5 LTS) with a haproxy as loadbalancer in front of it. Normally, there are up to 80 tcp based connection from a java application, ...
Mrk's user avatar
  • 1
0 votes
0 answers
835 views

Why am I getting a "connection timeout" when adding a node to a Galera cluster?

I am setting up a MariaDB 10.6.11 Galera cluster with two nodes. One node is working and showing as a primary, but when I add the 2nd node I'm getting a "Connection timed out" error : 2022-...
Rajeev Choudhary's user avatar
0 votes
1 answer
162 views

Monitoring wsrep_local_recv_queue_avg for slow node

I'm monitoring the wsrep_local_recv_queue_avg status variable of a MariaDB Galera cluster to detect slow nodes within the cluster. However, whenever this value spikes the average queue size will stay ...
kba's user avatar
  • 3
0 votes
1 answer
50 views

Is it recommended changing the file /sys/kernel/mm/transparent_hugepage/enabled for MariaDB node?

Is it recommended changing the file /sys/kernel/mm/transparent_hugepage/enabled from 'always' to 'never' for a MariaDB Galera node?
user3637971's user avatar
0 votes
1 answer
117 views

Can MySQL Commercial server Multi Master Replication using Galera Cluster?

Can MySQL Commercial Sever 8.x Multi-Master Replication using Galera 4 and MySQL WSRep?
user3562918's user avatar
0 votes
2 answers
357 views

Can I prevent a galera cluster node from writing gcache.page files?

I have the following setup: 5 hosts, each of them running two galera clusters. One of those two clusters has a production database, the second one a test database. Once a week (early monday morning), ...
Guntram Blohm's user avatar
0 votes
1 answer
309 views

Problem with seconds_behind_master in mysql replication with galera cluster

I have the next infrastructure of mysql servers: Node1 - MySQL 5.1.X Node2 - MariaDB 10.3.X Node3 - MariaDB 10.3.X Node4 - MariaDB 10.3.X Node1 is a master replication node. Node2 is a slave ...
Miguelitio's user avatar
0 votes
1 answer
159 views

mariadb galera : member count keeps changing between 5 and 3

I have a 5 nodes cluster, 2 nodes per DC, and an arbiter on a 3rd DC. The cluster is running fine in the sense that data is synced, DBs don't have any errors. The network is fine too. However, in the ...
boran's user avatar
  • 101
0 votes
0 answers
82 views

Galera Cluster MariaDB down due too high CPU

We have 3 nodes of MariaDB Galera Cluster runing with 2 HAproxy for loadbalancing. Recently, all 3 nodes of MariaDB crashed . I noticed that CPU was really high like 99% or 100% on the 3 nodes before ...
Lucas Rasolofoniaina's user avatar
0 votes
0 answers
96 views

Page cleaner took ms to flush pages/WSREP has not yet prepared node for application use

I am running percona xtradb cluster 8.0. One of my nodes went down, when I try to bring it up. The log says the transfer is complete and joined. 0.0 (DB404): State transfer from 3.0 (DB403) complete....
user3525290's user avatar
0 votes
0 answers
1k views

remove a node from galera cluster

I am trying to remove a node from MariaDB Galera cluster but I always get message on icinga for remaining nodes as node state: synced disconnected nodes : galera04 although I stopped the MariaDB ...
sameer's user avatar
  • 1
0 votes
0 answers
572 views

Node not joining galera cluster after reboot

I have upgraded from Debian 10 to 11 on one of the nodes of a Galera cluster. The other nodes complain on Icinga that node 1 is disconnected from them and is not synced...I rebooted after the upgrade ...
sameer's user avatar
  • 1
0 votes
1 answer
44 views

MySQL partition failed

I do partition with 6.595.057 rows in MySQL with the Galera cluster. When I tried partition in server without galera, partition successfull. But when I tried partition in server with galera cluster, ...
Adi Prasetyo's user avatar
1 vote
0 answers
127 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 ...
LittleYo's user avatar
1 vote
0 answers
262 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 ...
prenses_mahmut's user avatar
1 vote
1 answer
643 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 ...
ibrahim mohammad's user avatar
1 vote
0 answers
646 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 ...
Zareh Kasparian's user avatar
0 votes
1 answer
257 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&...
Glen G's user avatar
  • 3

1
2 3 4 5
7