Questions tagged [galera]

Galera Cluster for MySQL is a true Multimaster Cluster based on synchronous replication.

Filter by
Sorted by
Tagged with
1
vote
1answer
43 views

MariaDB Galera Cluster Rolling Upgrade - Replication Warning WSREP tx protocol version

I am upgrading a MariaDB Galera cluster from MariaDB 10.1.44 up to MariaDB 10.4.13 on Red Hat. I upgraded 1 member of the cluster and of course ran mysql_upgrade --skip-write-binlog when the software ...
1
vote
1answer
25 views

MariaDB crashing

We have a MariaDB cluster using Galera for replication. As of late (last 2-3 weeks) both have been crashing. Below is a sample backtrace [Thread debugging using libthread_db enabled] Using host ...
2
votes
0answers
25 views

Galera replication when two nodes can't communicate

Let's say I have a 3 nodes Galera cluster with MariaDB composed of servers A, B and C. Server A and server B can't communicate between each other but both servers can communicate with Server C. How ...
0
votes
0answers
17 views

Galera Mysql wsrep_connected stays OFF

My cluster was previously running, I have made these config changes and now Galera cluster bootstrap is not working. I tried bootstraping with /usr/bin/mysqld_bootstrap as well as service mysql start ...
0
votes
1answer
20 views

Can not stop mysqld after database upgrade

I have an old Galera cluster (MySQL 5.5) that I am upgrading to Percona XtraDB (MySQL 5.7) on Ubuntu 18.04 LTS. I have successfully imported the database with xtrabackup and synced the cluster - so ...
1
vote
1answer
27 views

Several MaxScale instances connected to one MariaDB Galera Cluster

In short, I have one MariaDB Galera Cluster consisting of 3 nodes. I have 3 independent servers on which MaxScale running. Are there any disadvantages to connecting three independent MaxScale ...
0
votes
0answers
15 views

Percona xtradb cluster breaks with conflict message when importing data into it

I have been banging my head over the wall for the past 2 weeks on this. I initially thought this was due to a bad or unsupported DDL syntax. But right now I am not sure of anything anymore. I have a ...
0
votes
1answer
29 views

Import of .SQL file is very slow with HeidiSQL

I have a database on a MariaDB server that I need to copy on a Galera Cluster on other machines. I used HeidiSQL to create a dump file which is pretty fast actually. The database is about 500Mb. ...
0
votes
1answer
33 views

mariadb galera cluster, resync nodes behind

I've followed this tutorial, and have a 3 server cluster set up behind a NGINX reverse proxy. https://www.digitalocean.com/community/tutorials/how-to-configure-a-galera-cluster-with-mariadb-on-...
0
votes
0answers
15 views

Adding node from one Galera cluster to another

What is the procedure to add a new node to a Galera cluster, when that node previously belonged to a different cluster? I presume: 1) Remove galera.cnf, start node, delete old databases 2) Edit new ...
0
votes
0answers
34 views

Trying to install MySQL with WSREP API by Ansible

I am trying to install a galera cluster (mysql with wsrep 5.7) on a centos 7.7 with ansible. My rule file: - name: Start the MySQL Daemon (first time) service: name: mysqld enabled: yes ...
0
votes
0answers
10 views

Upgrading mariadb 10.3.13 to 10.4.11 but wsrep variable not showng as expected

I have installed a galera cluster with 3 nodes with mariadb 10.3.13 on redhat 8.1 server. I upgraded to galera 26.4 and mariadb 10.4.11 on one of the three nodes. The cluster is working but I got some ...
0
votes
0answers
65 views

Laravel with Galera DB cluster

I have a Laravel project and created a Galera DB cluster. A feature of the cluster is that it is available on three different IP addresses. How can I declare these IP addresses for Laravel to use? I ...
0
votes
0answers
27 views

Automatically route MySQL connections based on GEO location to a closest Galera cluster node

So I managed to bring up a Galera cluster of 3 nodes as per this tutorial. The cluster works as expected. However, the task at hand is to automatically forward request from application to cluster's ...
0
votes
0answers
20 views

Can't run new Galera Cluster

I'm trying to run a new Galera Cluster on my local machine. I'm using CentOS 7 on Parallels Desktop. I followed all the instruction to bootstrap a new cluster but I keep getting this: MariaDB [(none)]...
0
votes
0answers
35 views

Create MariaDB cluster across 2 seperated OpenShift clusters

Good day, I am looking to create a MariaDB cluster in OpenShift/Kubernetes. The caveat, is that my cluster need to be ''spanned'' across 2 seperated OpenShift/Kubernetes clusters. I am trying to ...
0
votes
1answer
40 views

Is it safe to patch Galera without updating MariaDB?

I've been running MariaDB Galera Cluster for some time and only today realised that despite having identical versions of the MariaDB on all nodes, my versions of the Galera plugin are all different. ...
1
vote
0answers
44 views

Εxponentially growing Innodb_row_lock_time on “master” node of MariaDB 10.3 Galera cluster

I've been trying to investigate issues with an application failing, and I have reason to believe that the culprit lies somewhere in the database backend. To this end, I started collecting metrics from ...
0
votes
1answer
287 views

MariaDB Galera Cluster over IPSec

I am working on the expandation of my server infrastrucutre, so I orderd Servers in a second datacenter which I want to use as failover location. For better identifiaction I will use "ffm1" for the ...
0
votes
0answers
615 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" ...
0
votes
1answer
80 views

Connecting to MariaDB Galera Cluster takes a long time

I have a 5 node production MariaDb 10.3 Galera cluster that has been running for well over a year. In the last few weeks, it now takes more than 10 seconds for any client to establish a database ...
1
vote
1answer
116 views

Can a galera node weight (pc.weight) be a non-integer?

In a MariaDB Galera cluster, you can assign a weight to each node, from 0-255. However, the documentation does not specify if this is allowed to be a decimal number (like 1.5). In other areas, it does ...
0
votes
1answer
445 views

Restart Galera Cluster - all nodes with same sequence number

I have a 3 node Galera cluster running MariaDB on Ubuntu 18. I ran a few batch files to add data to the database, then shut down each node as this cluster is being relocated to a different subnet at a ...
0
votes
1answer
347 views

MySQL Cluster -> Galera MariaDB Cluster Replication not working, but no errors

I am setting up a database migration between a 2-node master cluster running MySQL Cluster 7.2 (MySQL 5.5) and a 2-node slave cluster (plus arbitrator) running MariaDB 10.3 with Galera clustering. I ...
0
votes
0answers
2k views

Failed to read uuid:seqno and wsrep_gtid_domain_id from joiner script?

I have a Galera Cluster in production which hosts 3 nodes. Nodes are Debian 9.5. I did some stupid stuff and edited my.cnf and corrupted some stuff. I reverted it back after long hours of fighting. 2 ...
1
vote
1answer
264 views

How likely is a Split Brain situation when dealing with Galera clusters?

Assuming I have a server setup where a quorum vote is always satisfied, how likely will a Split Brain situation occur with Galera? My understanding is Galera does its best to avoid it, but does that ...
0
votes
1answer
148 views

MariaDB 10.3.10 Galera Cluster not syncing InnoDB table definition

I have a 3 node multimaster MariaDB Galera Cluster that is not syncing a modification to an InnoDB table definition. Server version: 10.3.10-MariaDB MariaDB Server wsrep_provider_version: 25.3....
2
votes
0answers
83 views

configure pacemaker for galera

I have a galera / mariaDB cluster of two nodes on two remote sites that works perfectly. I want to set up a solution that would pause one of the two servers / node if the ping to an external IP was ...
0
votes
1answer
2k views

How to recover Galera cluster node

I'm running a three node, multi-master Galera cluster under MariaDB. One of the nodes has crashed due to a hardware fault (node3) and for whatever reason this crashed one of the healthy nodes too (...
1
vote
0answers
447 views

Converting Mariadb Galera Cluster into Simple Master Slave Replication Cluster

Now we have this project to convert our Mariadb Galera Cluster (3 nodes) to Simple Master Slave cluster (One master and two slaves). So our goal to get rid of Galera and make our setup just async / ...
3
votes
1answer
2k views

Does a Galera equivalent for Postgres exist? [closed]

I've been working with Galera for a number of months and like the failover along with the redundancy. I've got a Postgres DB that is in testing and will probably move to production. Is there a Galera ...
0
votes
4answers
483 views

mysql (Perconadb) Galera/Xtrabackup cluster join fails with “Invalid Argument”

I have a MySQL Galera cluster, using Perconadb and Xtrabackup. The nodes can start stand-alone, or can join the cluster if only an IST is required. However, if an SST is required, then this runs to ...
-1
votes
1answer
49 views

PHP can't connect to 127.0.0.1 or localhost to galera but can iva mysql cmd

I am having an issue with MySQL where I can't connect via localhost or 127.0.0.1, I get "Access denied ". On the same box if I use mysql -p -h localhost -u mysuser -p'mypassword' or mysql -p -h 127....
0
votes
1answer
528 views

Galera or master/slave MariaDB

What would be the recommended choice for database replication with failover? I know this is a broad question but I'm curious what the general experiences are when it comes to real life setups. As far ...
1
vote
0answers
888 views

Mariadb 10.1 - 1 of 3 nodes will not restart

Here is the scenario, had to make a config change to Mariadb in a 3 node cluster. I edited the config file, and shut down the node with: # service mysqld stop Made the change on the other 2 nodes ...
1
vote
0answers
191 views

Moving entire database server to Galera cluster

We currently have more or less the following setup: Three individual MySQL database servers (individual Linux machines) with 15 to 50 logical databases and 20 to 50 GB of data Galera cluster (MariaDB)...
2
votes
1answer
2k views

Why is keepalived running two MASTER nodes in my Sticky VIP configuration?

I have keepalived setup (floating VIP) in front of haproxy on each of my three-node galera cluster nodes. When I restart keepalived on any given node, sometimes I end up with two nodes running in ...
0
votes
1answer
667 views

Mariadb tuning - slow writes

Background: I have a a website I am migrating from a stand alone MariaDB server to a MariaDB galera cluster. Part of this had me convert the tables from a large number of MyISAM to InnoDB. For what it ...
0
votes
1answer
1k views

MariaDB Galera cluster - 3rd node can not start/connect

I am in the process of trying to set up a MariaDB galera cluster. The first 2 nodes went fine, have them started, connected. On the third node, it won't start/connect. # service mysql start ...
1
vote
2answers
5k views

How to “safely” shutdown/restart a Galera cluster?

First time setting up Galera (Ubuntu 14.04) and I'm unable to restart the cluster after rebooting my nodes. I'm following the this guide and it doesn't exactly mention how to handle a shutdown or ...
1
vote
1answer
978 views

MariaDB Galera cluster slow SST sync

I have a MariaDB Galera cluster with 3 nodes and I configured the SST transfer as wsrep_sst_method = rsync When I have to stop and restart a single node, the synchronization is very slow even if the ...
0
votes
1answer
343 views

Galera cluster donor node changed

I just started node1 as donor with ‘/etc/init.d/mysql start --wsrep-new-cluster’. Then started second node. and check "show status like 'wsrep%'" in mysql. but the second’s wsrep_local_index became 0 ...
0
votes
1answer
111 views

MariaDB Galera stop working without network connectivity

I am running MariaDB Galera cluster whose using mariaDB and 3 nodes(node A, node B, node C). My nodes are placed locally in our office. My problem is if node A/B/C lost network connection, it also ...
0
votes
1answer
253 views

Different InnoDB data file sizes on Galera

We have a cluster of 3 Galera-MariaDB boxes, using InnoDB as an engine. Cluster's in sync, and reporting all good as far as I can see. Much to my surprise, the size of the InnoDB data files differ ...
0
votes
1answer
568 views

Initial Xtradb Cluster setup — each node comes up isolated

I'm setting up a percona-xtradb-cluster-57 (3 nodes) on Ubuntu 16.04. They are to communicate using a private network, 10.254.10.101 through 10.254.10.103. When I follow the instructions on Percona'...
0
votes
2answers
280 views

how mariadb galera can help me scale writes?

if I have 1 server that's getting 30 writes per seconds and then I am moving to 3 galera nodes so now each server is getting 10 writes per seconds but due to how galera works every server in the ...
3
votes
1answer
4k views

Transform Galera cluster into single node mariadb server

We want to get rid of all cluster features on our galera cluster (currently consisting of three virtual machines). The connection between the nodes is not stable enough so the cluster is much slower ...
0
votes
1answer
963 views

HAProxy don't balancing requests between nodes of Galera cluster

I stuck with the problem with balancing requests from app server to Galera cluster nodes. The strukture of HA is node1 10.62.10.35 (HAProxy + Keepalived) Master node1 10.62.10.36 (HAProxy + ...
0
votes
1answer
299 views

LXD + Galera Cluster + Max Scale : Shutting down server != Stopping containers

I have a galera cluster with 4 nodes. 2 in one server (server-master) and 2 in another server (server-slave). The clusters are controlled through "Max Scale". All the setup seems correct as ...
0
votes
1answer
273 views

setting up MariaDB Galera cluster Ubuntu Zesty

I can't figure out how to initialize a MariaDB Galera cluster on Ubuntu Zesty. I've followed the documentation, but something seems to be missing. I cannot get the first node to come up. I ...