Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [galera]

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

124 questions
0
votes
0 answers

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 wrap my head around on how to do that. Doing so on VM…
yield
  • 771
  • 1
  • 9
  • 24
0
votes
1 answer

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. This seems to be the reason I am getting protocol…
Tim
  • 584
  • 2
  • 9
  • 20
0
votes
1 answer

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 primary datacenter and "ffm2" for the failover…
j0k4b0
  • 115
  • 5
0
votes
1 answer

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 connection. Our code runs in python, however even…
Robert Daniels
  • 101
  • 1
0
votes
1 answer

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 new location. After trying to bring the cluster…
Robert Daniels
  • 101
  • 1
0
votes
1 answer

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 currently have all but one of the Galera…
Brian Bauman
  • 256
  • 1
  • 2
  • 13
0
votes
0 answers

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 of my nodes manage to recover fine, they are…
Ümit Yayla
  • 11
  • 1
  • 4
0
votes
1 answer

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.24(r3825) The table is mysql.innodb_table_stats and…
Alexandre Juma
  • 103
  • 4
0
votes
1 answer

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 (node2). So I'm left with one running node (node1)…
Tim
  • 584
  • 2
  • 9
  • 20
0
votes
4 answers

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 completion and then fails. The logs show that,…
Steve Shipway
  • 740
  • 5
  • 17
0
votes
1 answer

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 as I understood galera is not a failover setup…
Misterr Moron
  • 75
  • 11
0
votes
1 answer

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 is worth, the website is a large joomla…
Marc
  • 33
  • 11
0
votes
1 answer

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 Starting mysql (via systemctl): Job for mariadb.service…
Marc
  • 33
  • 11
0
votes
1 answer

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 and first node became 1. Also started third…
user448347
  • 3
  • 2
0
votes
1 answer

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 lost it's working ability. Say a application is…
nixon1333
  • 101
  • 4
1 2 3
…
8 9