Questions tagged [galera]
MariaDB Galera Cluster is a synchronous multi-master cluster.
319 questions
0 votes
0 answers
8 views
MariaDB Slave replication just for backup
I have a MariaDB Galera master-master replication with 2 nodes. I would like to know if it is a good idea / best practice to add a third slave node just to run periodical dump. Currently dumps are ...
- 211
0 votes
1 answer
23 views
Galera 4.24: Added option to disable application level protocol check to allow migration from MySQL to MariaDB?
The release notes at https://github.com/codership/documentation/blob/master/release-notes/release-notes-galera-26.4.24.txt say Added option to disable application level protocol check to allow ...
- 479
1 vote
2 answers
119 views
Why Maxscale doesn't switch master?
I have a galera cluster with mariadb 10.6.22 and maxscale 24.02.2 in ubuntu 22.04 server. This is my configuration: [maxscale] threads=auto [srv1] type=server address=127.0.0.1 port=3306 [srv2] type=...
- 211
1 vote
1 answer
75 views
Mariadb Galera - limiting schema replication between datacenters
we have a multi-datacenter Mariadb Galera cluster, replicating data and working fine. Each datacenter have 3 nodes and they all replicate data between each node of every datacenter. On each datacenter,...
- 11
0 votes
1 answer
139 views
MySQL 5.7 multi-master Galera Cluster - Index Creation
I have a production Galera (v3) Cluster with 3 MySQL (v5.7) nodes running in multi-master mode. I need to create a new index (~16GB) and drop an old index on a large table (112 million rows, ~20GB ...
- 3
0 votes
0 answers
91 views
Replication vs a ReadOnly Galera Cluster Node
In our current setup with MS SQL Server, we have replication running exporting the data from production to a secondary server for the purposes of report writing. We're looking at migrating to MariaDB, ...
- 1
0 votes
2 answers
199 views
How to handle asynchronous slave synchronization with Galera?
I have a server with a service that uses mariadb database. This machine is remote and the database is far away in a Galera cluster of two servers. Currently, this server is connected using an ssh ...
- 211
0 votes
1 answer
126 views
How can I disable the MaxScale readwriterouter for specific queries?
I'm using a Galera replication and MaxScale readwriterouter. I'm facing an issue because the application has been developed with this flow: start transaction update a record commit read that record ...
- 211
1 vote
0 answers
44 views
Master - Slave - Galera cluster
The current setup is comprised of two nodes, a Master-Slave setup. No encryption, no compression. I would love to switch this to a Galera Cluster, with encryption, compression and, to make things ...
0 votes
1 answer
211 views
MariaDB Galera and Geo redundancy
I am trying to simulate 2 clusters in different datacenters/different locations, using VMWare VSXi and 6 VMs: 3 are located on DC1 and other 3 on DC2. All nodes are RHEL 9. Both DCs communicate ...
- 11
0 votes
1 answer
103 views
WSREP_SST: [ERROR] Possible timeout in receiving first data from donor in gtid stage
I have deployed Alma Linux 9 and MariaDB 10.11.7 with Galera 4 on two AWS instances and all the ports and firewall rules are open between 2 instances, I set the proper wsrep options and I am still ...
- 101
0 votes
1 answer
136 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 ...
- 121
0 votes
1 answer
377 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 ...
- 101
0 votes
1 answer
86 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 ...
- 101
0 votes
0 answers
240 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 ...
