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

How to sync table data between two nodes of a mariadb galera cluster?

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 was unexpected stopped. And I found a table named…
Winbert
  • 13
  • 5
0
votes
0 answers

Removing a node from Galera Cluster

I have to update the os on a few servers and I need to remove a db from the cluster. wsrep_cluster_address='gcomm://192.168.2.59,192.168.2.60,192.168.2.61,192.168.2.62,192.168.2.63' Do I remove the ip adress from the cluster line then restart each…
user3525290
  • 101
  • 1
0
votes
1 answer

MariaDB Galera Cluster simultaneously got 2000+ Connections on single node How to trace this issue

I am using MariaDB Galera Cluster (Master/Master) having 5 nodes with specs of 32Core 64GB Ram Ubuntu 20.04 Personal Vm-Machines at own Datacenter Top of these nodes, Haproxy is configured which balance the request load for DBs Node each node is…
Qazi
  • 101
  • 4
0
votes
0 answers

Getting error while connecting with other nodes in cluster

I create Galera cluster for mysql 8, when i'm restarting the nodes it is connecting in the cluster but after few seconds its getting disconnected. Please help me to fix this issue. Please see the logs- 2021-05-09T19:29:47.376651Z 0 [System]…
John The Hacker
  • 133
  • 9
0
votes
1 answer

Is it Safe to Use "ufw allow from xx.xx.xx.xx" Command for IP Addresses Which are Faced With UFW_BLOCK?

I have UFW opened on my database servers and I have seen a lot of UFW_BLOCK logs. Is it safe or right to use "ufw allow from xx.xx.xx.xx" and "ufw allow to xx.xx.xx.xx" command for all IP addresses which are blocked? I have allowed blocked IP…
TarabydaVllasıCafcaflıAtArabsı
  • 13
  • 2
0
votes
1 answer

galera cluster slow on hyperV (faster on ESX)

Solution inline We encountered a strange issue and are basically out of ideas by now: We setup a galera cluster (3 Nodes + MaxScale LB) for a customer and he reported slowness. We were unable to identify the issue so we setup a tes scenario to dig…
Niko
  • 108
  • 6
0
votes
1 answer

Galera cluster up sync but missing variable wsrep_cluster_size

I have a Galera cluster up running and in sync, but it's missing wsrep_cluster_size, see the command screenshot below. MariaDB [(none)]> show variables like 'wsrep_cluster_size'; Empty set (0.01 sec) More details: Configuration on the first…
James
  • 121
  • 3
0
votes
2 answers

Galera + MariaDB: Deadlock: wsrep aborted transaction

I have 1 server configured the galera, 4 servers with mariadb and 1 with haproxy. But when I want to do an update on any server I get the error "Deadlock: wsrep aborted transaction" or "wsrep_max_ws_rows exceeded" (sometimes). The servers are…
Kronnopio
  • 1
  • 1
  • 3
0
votes
0 answers

MariaDB Galera needs openssl 1.0.0 on RHEL 8

I have a RHEL 8.3 installation. It comes with openssl.x86_64 1:1.1.1g-11.el8. However the MariaDB 10.5.7 Galera needs libssl and libcrypto 1.0.0. ldd libgalera_smm.so ldd: warning: you do not have execution permission for `./libgalera_smm.so' …
Richard
  • 55
  • 5
0
votes
1 answer

Mixing Galera and MariaDB/MySQL replication

reading about it online, it appears we can use both Galera replication and native MariaDB/MySQL replication together. Can anyone confirm that this is correct? I'm thinking of a scenario where Data Center A has 3 Galera nodes synchronously…
David Cunningham
  • 31
  • 3
0
votes
1 answer

NginX and Galera Cluster are friends?

So I've found NginX's official tutorial, how to use NginX Plus as the proxy for the MariaDB Cluster. However, if I do this with my standard NginX (not the Plus edition) I constantly get the error nginx: [emerg] invalid URL prefix in…
Bert
  • 1,028
  • 1
  • 16
  • 33
0
votes
1 answer

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 far so good. My problem is that I can not stop the…
koenig
  • 125
  • 8
0
votes
1 answer

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. However, when I tried to import it on the other server…
Ror
  • 321
  • 3
  • 16
0
votes
1 answer

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-ubuntu-18-04-servers I can create a database or table…
MrPHP
  • 163
  • 8
0
votes
0 answers

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 state: started - name: Parse the logfile for…
iamcheko
  • 76
  • 2
1 2 3
…
8
9