Questions tagged [galera]

MariaDB Galera Cluster is a synchronous multi-master cluster.

115 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
5 votes
1 answer
2k views

Getting duplicate record errors like "Duplicate Entry for key 'PRIMARY', error code 1062" when importing a full backup into slave

We're restoring our slave with a full backup from our master, and getting a bunch of duplicate key errors. Once the slave gets caught up, it does not throw any errors (only when it is behind the ...
John's user avatar
  • 51
4 votes
0 answers
2k views

Galera Cluster Failed to report last committed

I'm experimenting with Galera Cluster with 3 nodes, but I'm having some issues but I'm not sure why. What I noticed is that I'm having lots of failed to report last committed (number), -110 (...
Leandro Jacques's user avatar
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
3 votes
0 answers
1k views

Galera cluster consume many CPU percent and CPU high load

I have implemented a cluster include three nodes: two stored nodes and one garbd (also haproxy - load balancer). Some information about servers: SSD 480G Raid1 Memory 32G Swap 16G 2xCPU, number of ...
Luke Nguyen's user avatar
3 votes
1 answer
9k views

what is the right way to restart a mariadb galera cluster?

I am trying to restart cluster. I have two problems in stopping cluster and starting cluster In stopping cluster, I follow the instruction https://software.mirantis.com/reference-documentation-on-...
Luke Nguyen's user avatar
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
2 votes
1 answer
358 views

Need help with some recovery

So i've gone and did something terribly wrong out of haste and not thinking properly. I have a PXC (percona cluster. I guess mysql cluster with Galera?) running with just 1 one being bootstrapped (...
Jdeboer's user avatar
  • 41
2 votes
0 answers
233 views

Percona Xtradb Cluster not accepting options on command line

I am using Percona Xtradb Cluster 5.6 and trying to start my cluster through a donor node via command line and I am getting this error: CentOS 7: systemctl start mysql --wsrep-sst-donor=srv1 ...
JKhan's user avatar
  • 123
2 votes
1 answer
2k views

Galera - single database backup & restore

I have a MariaDB Galera cluster. One of its nodes is dedicated for the backups (pc.weight=0 and the MaxScale SQL proxy doesn't know it exists). I'm using mariabackup --backup --galera-info --target-...
HORF's user avatar
  • 21
2 votes
0 answers
711 views

Third node cannot join Galera cluster after mariadb update

I tried to deal with this issue for three days now, but unfortunately without success. I have a Galera cluster (Node1 - donor, Node2 - joiner, Node3 - arbitrator) which was working flawlessly until I ...
Jax's user avatar
  • 21
2 votes
1 answer
2k views

Percona mysql xtradb cluster doesn't start properly and node restarts don't work

tl;dr When starting a fresh percona cluster of 3 kubernetes pods, the grastate.dat seq_no is set at -1 and doesn't change. On deleting one pod and watching it restart, expecting it to rejoin the ...
Jonathan's user avatar
  • 121
2 votes
2 answers
1k views

Mysql And Galera cluster mariaDB , Private and Public IP Addresses multisite

I am just wondering has anyone come accross this before and the best method to go about doing it. We have a customer that wants multi site replication over a galera cluster. I am familiar with setting ...
JamesG's user avatar
  • 21
2 votes
0 answers
1k views

Expanding MariaDB cluster (sharding)

I have an expanding MariaDB 3 node cluster and need to expand the available storage. Each node has (to make the maths slightly easier) 120Gb of database storage. As this is replicated, the total DB ...
user3566845's user avatar
2 votes
0 answers
1k views

mariadb galera cluster stop one node automaticly

I have Mariadb galera cluster. I have 4 nodes. but When one node become slow, it stop itself automaticly. that's the error. What should I do? 151030 17:17:14 [Note] WSREP: view((empty)) 151030 17:17:...
Melih's user avatar
  • 337
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
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
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
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
1 vote
0 answers
2k 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 ...
Satish's user avatar
  • 211
1 vote
0 answers
140 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 ...
Kevin Lee's user avatar
  • 121
1 vote
1 answer
165 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 ...
user3525290's user avatar
1 vote
0 answers
948 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 ...
Fardin Kamali's user avatar
1 vote
0 answers
417 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 ...
Ciasto piekarz's user avatar
1 vote
0 answers
301 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 ...
Elvex's user avatar
  • 111
1 vote
0 answers
19 views

Upgrading Debian version of PXC production cluster

I have a 3 node PXC 5.7 cluster behind a ProxySQL instance. The cluster is still running on Debian 8. I have setup recently a testing PXC 5.7 cluster with a copy of the database on Debian 10 without ...
Matthew Neirynck's user avatar
1 vote
0 answers
921 views

Galera node not accepting root password after restart

I have a Mariadb galera cluster running in Kubernetes with 2 Nodes. Recently, as part of a process of redeploying the mariadb chart, one of them (mariadb-1), was restarted. Trying to perform the ...
Tom Klino's user avatar
  • 111
1 vote
1 answer
113 views

MariaDB Parallel Replication Drifting at random times

I have recently been thrown in the deep-end to manage our Database servers since our DBA left. The current set-up is Mariadb (mariadb Ver 15.1 Distrib 10.1.38-MariaDB, for debian-linux-gnu), InnoDB (...
hexce's user avatar
  • 11
1 vote
0 answers
1k views

Cannot write to Galera Cluster (Lock wait timeout)

My Galera cluster has gone down / locked up, I can read from all databases, but I cannot write to any table in any database, it just locks / waits forever. I can fix it by shutting down all 3 mariadb ...
Sergeant's user avatar
1 vote
0 answers
386 views

Galera throws “WSREP has not yet prepared …” error but nodes are working

Yesterday we moved from 2 node Galera to 4 node Galera with a brand new infrastructure. But after we move the database, Galera started throwing "WSREP has not yet prepared node for application use" ...
Harun Baris Bulut's user avatar
1 vote
0 answers
119 views

queries to active live test health of a galera cluster

What queries could be used to foresee or better fine tune alerts to check the health status of a Galera (MariaDB) cluster? The problem I am facing is that randomly the cluster gest stalled because of ...
nbari's user avatar
  • 149
1 vote
0 answers
207 views

MariaDB Galera slave thinks it's replicating, but it isn't

I have a MariaDB 10.3 Galera slave node with general logging turned on. It's consuming binlogs generated by a MySQL 5.5 NDB cluster. The binlog format is row-based in both databases. SHOW ALL ...
Brian Bauman's user avatar
1 vote
0 answers
106 views

MariaDB Cluster Cannot Join new Node

This is status on Main node. it's show some seqno as 17210843 when new empty node is join. i'm found rsync process is ok. but i see difference seqno in linux process after finish this process my ...
Prawit Ritchalearnwatthu's user avatar
1 vote
0 answers
358 views

One node causing entire Galera Cluster to remain in bad state

I have a production MariaDB Galera 5 node cluster that has been running for about 8 months at our factory. One node had a powerfail / un-graceful shutdown (Ubuntu 16.04) and since then if that node is ...
Robert Daniels's user avatar
1 vote
0 answers
465 views

Can't add new node to Galera Cluster

I have a 5 node Galera 3 Cluster running MySQL 5.6 on Ubuntu 16.04 (I tried running 5.7 but ran into the AppArmor issue). I'm trying to add another node to the cluster but it continually fails. The ...
Adam Evers's user avatar
1 vote
1 answer
311 views

Setup replication between two Galera nodes

I've been using MariaDB 10.2 Galera with 3 nodes successfully on local servers. Now, I have a second 3-nodes Galera cluster on another location, joined by an Site-to-Site IPSec Tunnel. I can't really ...
Hakujou's user avatar
  • 11
1 vote
1 answer
982 views

MySQL Galera cluster can't initiate first node

I'm using Ubuntu 16.04 and installed MySQL version 5.7 via apt-get in AWS. After that, I've managed to upgrade the MySQL to Galera Cluster by following the Documentation from the official website ...
AFwcxx's user avatar
  • 111
1 vote
0 answers
558 views

MariaDB Galera cluster: claster stalls with lots of “Query End”

I have cluster consists of 2 physical nodes (2x Intel Xeon E5-2670 2.6Ghz , 192Gb, RAID1 SSD, ОС Debian 8, mariadb-server-10.2) + arbitrator (on Proxmox). I write to only one node at time. My cluster ...
vlarkanov's user avatar
1 vote
0 answers
106 views

Galera Async Multimaster Backup

I am just configuring a Galera 10.1.14 cluster and i want to set the Async replica from two different clusters. Cluster 1 -> Data Schema A \ ==(WAN)==> MariaDB 10.1....
PsySkeletor's user avatar
1 vote
1 answer
3k views

Connecting client application to MariaDB Galera cluster

I currently have a REST API written in Flask that connects to a MariaDB server. I'm thinking about replacing the server with a Galera cluster to improve availability and ensure continuity in case one ...
user3607758's user avatar
1 vote
1 answer
1k views

Innodb not started?

I installed MariaDB_Galera_server10.0 , but when i check the error log i see this: 170118 14:49:09 [Note] InnoDB: 128 rollback segment(s) are active. 170118 14:49:09 [Note] InnoDB: Waiting for purge ...
Yaser Jawi's user avatar
1 vote
0 answers
392 views

Galera log has WSREP: failed to initialize io-cache

I'm having trouble tracking down the cause of an error message that is appearing in my logs every 15 minutes or so. The cause of the error happened whilst performance testing a 3 node Galera Cluster (...
Dan's user avatar
  • 111
1 vote
0 answers
1k views

1 Node crashed of 3 node mariadb galera cluster

Heading I have three nodes Galera cluster MariaDB, a node in June 4, 2016 suddenly crash, the following is log error Red Hat Enterprise Linux Server release 6.5 Server version: 5.5.39-MariaDB-wsrep-...
xiaoshuang li's user avatar
1 vote
0 answers
166 views

Using Galera-Replication, what's the use in having a GTID associated with your backup?

On the topic of using a backupscripts the documentation for galera-cluster states that: You can use backups of this kind to recover data, but they are insufficient for use in recovering nodes to ...
Mustermann's user avatar
1 vote
0 answers
308 views

wsrep_slave_threads and tmpdir space usage

After increasing wsrep_slave_threads at Galera nodes I have experienced that the mysql tmpdir, which is a ramdisk, was using much more resources. Especially notable during xtrabackup-v2 STTs. Also ...
Leon Kramer's user avatar
1 vote
0 answers
1k views

What causes the creation of such a large number of Galera cache files?

I manage a Percona XtraDB 3-node cluster. Recently the MySQL datadir of one of the nodes (not the one from which the cluster has been bootstrapped) started being filled up with gcache.page.00nnnn ...
dr_'s user avatar
  • 1,314
1 vote
0 answers
194 views

Does galera cluster works in thecloud (Azure IAAS)

We are moving our infrastructure into the cloud (Microsoft) Our current MySQL master-Slave environments will be moved as Infrastructure as a service. At the same time I have been asked to look to ...
Philippe Courtois's user avatar
1 vote
1 answer
1k views

MariaDB Galera Cluster - nodes fail to start

This is a new installation (fresh VM and MariaDB install). For some reason, the nodes are having trouble joining the master server. The master server would pause at Preparing binlog files for ...
James Wong's user avatar
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