408 questions
- Bountied 0
- Unanswered
- Frequent
- Score
- Trending
- Week
- Month
- Unanswered (my tags)
2
votes
1
answer
79
views
How to wait for replication at mariadb transaction commit?
I have a MariaDB cluster made with Galera and my clients use MaxScale with RW router.
I'm having an issue because the application has something this sequential steps:
Start trx1
Insert new record
...
0
votes
0
answers
53
views
Best practice for avoiding cluster lockups in Galera DDL scripts
we have a Galera (wsrep_provider_version 4.23) cluster over 3 MariaDB 11.8.3 nodes. Our application has a number of migration scripts (about 50) that run on startup, via Flyway. At some point in the ...
0
votes
1
answer
60
views
In Mariadb and Galera cluster, will I get different value of a field in different node?
In Mariadb and Galera cluster, we have 3 nodes. I update a field from 99 to 100 through node 1. If I retrieve the same field through node 2, will I get 99 instead of 100 ?
Because the field is used ...
0
votes
1
answer
116
views
Can I create a consecutive sequence number using MariaDB and Galera Cluster?
I have 3 nodes in the galera cluster. When I get the next value from a sequence, it has gaps between the numbers. e.g. 1,4,7...
I would like to write a function to get a sequence number from a table ...
0
votes
0
answers
50
views
Is Lost Update without certification failure expected in Galera Cluster?
I'm using a multi-node Galera Cluster and encountered the following two scenarios:
Case 1 — Certification Conflict (Deadlock) occurs:
Node B and Node C both start transactions.
Both try to update the ...
0
votes
0
answers
57
views
garbd fails to connect to MariaDB Galera Cluster with SSL — Unrecognized gcs.ssl_* parameters
I'm trying to add a garbd (Galera Arbitrator Daemon) node to my MariaDB Galera Cluster (2 data nodes), which is configured with SSL encryption for intra-cluster communication. However, I’m getting SSL-...
0
votes
1
answer
135
views
Does the initial hostgroup_id assignment in ProxySQL (writer_hostgroup vs. reader_hostgroup) affect Galera load balancing?
Let's say we have three Galera nodes:
172.17.0.2
172.17.0.3
172.17.0.4
and we will have the following hostgroups:
writer_hostgroup=0
reader_hostgroup=1
backup_writer_hostgroup=2
offline_hostgroup=4
...
0
votes
1
answer
114
views
Commit delay for MariaDB Galera cluster and MaxScale
I'm working in a clustered MariaDB database with Galera and MaxScale in r/w routing.
My question is if the commit command successful return implies a completed replication or not.
This is the scenario:...
0
votes
1
answer
74
views
Deadlock while Pessimistic Locking in Ruby on Rails
I get a deadlock error while pessimistic locking in Ruby on Rails.
Versions:
MariaDB: Docker mariadb:10.11
Ruby: ruby-3.3.0 via rvm
Rails: 8.0.1
MySql2: 0.5
I have a three instances of an RoR ...
0
votes
0
answers
39
views
Galera Cluster (on GMD Gui need a refence cmd to Recover Cluster)
Under the cluster Galera Manager Daemon (gmd) gui dropdown there is the Recover Cluster option as shown in the image this work fine but requires me to manually press it:
Recover Cluster Button
What is ...
0
votes
1
answer
146
views
MariaDB 10.5.13 with Galera Cluster: Occasional Signal 11 Crashes During High Transaction Load with GET_LOCK/RELEASE_LOCK
Environment:
I am using MariaDB 10.5.13 with a Galera Cluster setup.
innodb storage engine.
Instance type: AWS t3.medium.
Memory usage details:
.
My.cnf configuration:
#
# These groups are read by ...
0
votes
0
answers
732
views
docker compose with Galera Cluster
I am setting a Galera Cluster using docker compose on my CentOS AlmaLinux 8.
Here is the firts attempt:
docker-compose.yml :
services:
sv-isoluce-galeradb-1:
build:
context: ./buildimg/...
0
votes
1
answer
200
views
How to get a safe and correct sequential number in a MariaDB Galera cluster?
I'm using Galera with in a multiserver MariaDB sluster.
I'm wondering what is a "by the book" method to get the next sequential number (without gaps) from an int column.
In a single server I ...
0
votes
1
answer
111
views
Galera syncronized but tables content looks different
I have a Galera replication between two mariadb 10.6.18 servers on ubuntu 22.04.
Checking the syncronization it seems ok.
SERVER 1
SHOW STATUS LIKE 'wsrep%';
+-------------------------------+----------...
0
votes
2
answers
150
views
Shell script not working when run as wsrep_notify_cmd by Galera Cluster for MariaDB
I have a simple shell script that I'm trying to use to test Galera Cluster for MariaDB's node state change notification mechanism, running on an AWS Ubuntu 20.04 LTS instance. The script is a ...