Questions tagged [galera]

MariaDB Galera Cluster is a synchronous multi-master cluster.

Filter by
Sorted by
Tagged with
7 votes
3 answers
6k views

100x less insert performance with Galera multi-master

I am running an application which inserts a lot of rows and we were experiencing some low performance. So i started benchmarking the Galera Cluster with sysbench and oltp_insert.lua (practically ...
mhstnsc's user avatar
  • 173
15 votes
2 answers
10k views

What are the drawbacks of using Galera Cluster instead of Master/Slave Replication?

What are the drawbacks of using Galera Cluster instead of regular Master/Slave Replication? Galera's 0 slave lag time, Synchronous replication and no Single point of failure seem very appealing then ...
Sam's user avatar
  • 334
3 votes
1 answer
20k views

InnoDB: Error: Table “mysql”.“innodb_table_stats” not found

I've got the same error, although I'm running galera cluster with 3 nodes. I tried following the instructions from InnoDB: Error: Table "mysql"."innodb_table_stats" not found after ...
Aaron's user avatar
  • 151
2 votes
1 answer
5k views

'kill <thread id>' gives ERROR 1095 (HY000): You are not owner of thread ... even though I am

I did an ALTER TABLE on a huge table on a MariaDB Galera Cluster 10.2, but after a while of waiting I changed my mind and tried to kill the connection. However, MariaDB said ERROR 1095 (HY000): You ...
dbdemon's user avatar
  • 6,351
5 votes
2 answers
17k views

grastate.dat with seqno -1 on a healthy cluster. Why?

We use those versions: # rpm -qa | egrep '(galera|maria)' mariadb-libs-5.5.41-2.el7_0.x86_64 mariadb-galera-common-5.5.40-6.el7ost.x86_64 mariadb-galera-server-5.5.40-6.el7ost.x86_64 mariadb-5.5.41-2....
Sybil's user avatar
  • 2,498
4 votes
2 answers
2k views

Keepalived vIP as Galera wsrep_cluster_address

I have a MariaDB Galera cluster. If some nodes fail, I cannot blindly restart them, I have to determine a good wsrep_cluster_address first. If I can keep a keepalived virtual IP on one of the healthy ...
scream314's user avatar
  • 103
3 votes
1 answer
234 views

Will "bridge" storage engines work with MariaDB Galera Cluster?

Galera states that it only supports InnoDB. The reason is quite clear, and it is related with the way synchronous replication is implemented in Galera. However, some storage engines are just "bridges"...
Federico Razzoli's user avatar
3 votes
1 answer
9k views

what is the right way to restart a mariadb galera cluster?

I am trying to restart cluster. I have two problems in stopping cluster and starting cluster In stopping cluster, I follow the instruction https://software.mirantis.com/reference-documentation-on-...
Luke Nguyen's user avatar
1 vote
1 answer
1k views

Automatically and robustly restarting a Galera cluster

Galera clusters, somewhat famously, have a requirement that nodes need to be shut down and brought back up again in a certain order. There are a few questions here and on other sites about recovering ...
jstarek's user avatar
  • 115
1 vote
1 answer
796 views

Why should I use MaxScale readwritesplit router over a three node Galera cluster?

In the following official MariaDB blog Getting Started with MariaDB Galera and MariaDB MaxScale the author configures a MaxScale host over a three node Galera cluster, and uses the Galer monitor (OK) ...
g.pickardou's user avatar
1 vote
2 answers
2k views

Galera cluster without having to specify all hosts on wsrep_cluster_address

While evaluating the galera cluster, on the documentation it mentions that all cluster members should be listed on the "wsrep_cluster_address" setting... This doesn't seem very scalable to me as ...
Onitlikesonic's user avatar
1 vote
1 answer
2k views

MySQL 5.5 Replication to Galera/Percona XtraDB Cluster

We are currently investigating moving our current MySQL 5.5 Master > 5 x Slaves (with Statement Based Replication, apx 250GB data and growing) to a HA clustering option. Mainly to provide greater ...
IGGt's user avatar
  • 2,126
1 vote
1 answer
2k views

Galera won`t start

MariaDB 10.1. I have 3 nodes: KVM-1 wsrep_on=ON binlog_format=ROW default_storage_engine=InnoDB innodb_autoinc_lock_mode=2 innodb_locks_unsafe_for_binlog=1 query_cache_size=0 query_cache_type=0 ...
Roman Bogachev's user avatar
1 vote
1 answer
2k views

MariaDB 10.1 Galera cluster error

I'm trying to install MariaDB Galera Cluster with 2 nodes : node 1/ 172.23.0.2 : wsrep_on=ON wsrep_provider=/usr/lib64/galera/libgalera_smm.so binlog_format=ROW wsrep_cluster_address='gcomm://' ...
Yassine LD's user avatar
0 votes
1 answer
1k views

mariaDB with a 3 node galera cluster is eating more and more RAM

I am running mariaDB 10.3.29 in a 3 node Galera Cluster on 3 VMs with 14G RAM each. Despite configuring to best knowledge, it continues to eat more and more RAM and after around 3 months the machines ...
user3528657's user avatar
0 votes
1 answer
1k views

Upgrading MariaDB Galera cluster from 5.5 to 10.0 - rolling upgrade possible?

I've had a good search around and cannot find much on the topic. We want to upgrade our live MariaDB 5.5 Galera cluster to the MariaDB 10.0 branch, ideally without any downtime. We installed ...
Luke Cousins's user avatar
0 votes
2 answers
522 views

Steps to remove node from percona 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 ...
newdeveloper's user avatar
0 votes
2 answers
539 views

Safe backup of PXC / Galera cluster

I have 3 nodes 'master master' cluster and using PXC 5.6 But I am only using a single node for both read and write. Before using pxc, i was using standalone Mariadb 5.5 and I was taking backup using ...
JKhan's user avatar
  • 123
0 votes
1 answer
5k views

Internal MariaDB error code: 1927 ('Connection was killed')

Edit: filed a bug report at https://jira.mariadb.org/browse/MDEV-14493 Mariadb nodes freeze occasionally with the following error in the logs, any clues? (drupal app, db freezes on clearing ...
a_at_cyber_dot_training's user avatar
0 votes
1 answer
685 views

Restarting Galera MySQL after proper Shutdown

I already have read and followed dozens of documents describing a split brain situation and how to restart the cluster after then. However, I am less in this situation as in the situation of shutting ...
rexkogitans's user avatar