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
1
vote
1 answer

MariaDB Galera Cluster, Force Sync

I have three servers in a multi-master Galera cluster. I've imported some old databases recently, and noticed that the tables were being created across all three, but the data wasn't being replicated. It turns out I wasn't paying attention, and…
Nick Coons
  • 387
  • 4
  • 16
1
vote
1 answer

MariaDB Galera SST Fails

I am running a 3 node MariaDB 10 Galera Cluster on CentOS 6. I have use this set-up before without issue else where but now when adding a 3rd node the SST fails with this error in the logs: 150212 18:03:02 [Warning] WSREP: 1.0 (server1.example.com):…
kemra102
  • 211
  • 4
  • 12
1
vote
1 answer

HAProxy's Flooding MySQL Connections

I have a setup of 2 HAProxy servers using the KeepAlived process for failover, and each HAProxy is configured to load balance mysql connections to my MariaDB Galera cluster of 3 nodes. I'm trying to load test my environment, and before I even push…
Daniel Graves
  • 33
  • 5
1
vote
1 answer

Configuring resources for Galera and Corosync/Pacemaker

I can't seem to find a proper way of setting up resources in pacemaker to manager my Galera cluster. I want a VIP that will failover betwen 5 boxes ( this works ), but I would also like to tie this into a resource that monitors mysql as well. If a…
Roncioiu
  • 53
  • 8
1
vote
1 answer

Error when i install mysql + galera

I want install mysql server + galera in my vps Centos 6.5. When I install yum update -y && yum install wget libevent perl mysql-y wget…
user3353678
  • 11
  • 3
1
vote
2 answers

Query cache for MariaDB Galera cluster

I've read from multiple sources now that you can't have query caches with Galera, but my current application could really benefit from a query cache. I'm load-balancing this cluster with HAProxy and am curious if HAProxy has any kind of caching…
David Perry
  • 131
  • 1
  • 1
  • 7
1
vote
0 answers

Bootstrapping Galera Cluster

We would like to use a MariaDB Galera cluster for our project. The Galera cluster works and seems to work fine. If some nodes of cluster are down the cluster continues to work. But after a complete restart of all nodes (restarting the VMWare host)…
bernhardrusch
  • 175
  • 1
  • 9
1
vote
0 answers

MariaDB Galera cluster with failed node

A client of mine asked a question that I'm not really sure how to answer correctly. His question is: In case of one node falls out of the cluster, stays offline for a few hours or days and then comes back: how fast the new data will be migrated to…
Bert
  • 1,028
  • 1
  • 16
  • 33
1
vote
1 answer

Mariadb Galera Cluster Cannot Start Up

I built a mariadb galera cluster on CentOS7. Below is the galera node information: 10.200.67.27 MariaDB-Node1 10.200.67.29 MariaDB-Node2 10.200.67.26 MariaDB-Node3 However, MariaDB-Node2 and MariaDB-Node3 were unexpected stopped. I tried…
Winbert
  • 13
  • 5
1
vote
1 answer

mariaDB 10.5.12 access denied for root@127.0.0.1

fresh installation of mariaDB 10.5.12 on debian 11 was hardened with 'mysql_secure_installation' script, question "Switch to unix_socket authentication [Y/n]" was answered with 'yes'. Now mariaDB allows local root to log in when host equals to…
mpr
  • 11
  • 2
1
vote
0 answers

Firewall Ports for MariaDB Galera

I am trying to secure my MariaDB Galera servers. They are setup and configured to use SSL. wsrep_on = ON wsrep_provider = /usr/lib/galera/libgalera_smm.so wsrep_cluster_name = "db-cluster" wsrep_cluster_address =…
Aaron A
  • 239
  • 2
  • 14
1
vote
2 answers

MariaDB galera cluster, add node without interruption

I would like to setup a Galera Cluster with 3 servers. But i have a question who can be a problem : How can i add a new IP in wsrep_cluster_address parameter to allow this new server to be sync in the cluster without interruption ? (restarting…
AmieLL
  • 11
  • 1
  • 2
1
vote
1 answer

Galera Manager on none Amazon environment

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 nodes. But because I am not using Galera Manager…
Fardin Kamali
  • 11
  • 2
1
vote
0 answers

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 was finished updating. I then re-added it to the…
David W
  • 3,453
  • 5
  • 36
  • 62
1
vote
1 answer

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 libthread_db library "/lib64/libthread_db.so.1". Core…
Dovid Bender
  • 427
  • 2
  • 7
  • 19
1 2 3
…
8 9