Questions tagged [galera]

MariaDB Galera Cluster is a synchronous multi-master cluster.

Filter by
Sorted by
Tagged with
14
votes
2answers
7k 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 ...
6
votes
2answers
3k views

MySQL stuck on “wsrep: initiating replication for write set (-1)”

I ran into a situation with MySQL recently which I hadn't seen before. We have a Percona cluster with 3 nodes. The master stopped processing queries and the PHP FPM web application we host became ...
5
votes
3answers
4k 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 ...
5
votes
2answers
21k views

How to recover MariaDB Galera Cluster after full crash?

I crashed all my 3 nodes. After all nodes have been started I noticed that mariadb is dead. An I couldn't run it again. I am using CentOS 7 on all servers I tried to start first node and then others ...
5
votes
1answer
4k views

Does it make sense to run a cluster of database servers in docker containers?

I'm currently looking into setting up a database cluster (MySQL Galera or Percona) but I have only 2 machines. However, according to many sources I've read (This article from the Mariadb KB), the ...
5
votes
2answers
11k 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....
5
votes
1answer
4k views

SELECT performance on MariaDB Galera cluster vs. MariaDB is terrible

We are evaluating a Galera setup and so far we have not noticed to many drawbacks except a few queries that have terrible READ performance I cannot put my finger on it. The query by itself isn't ...
5
votes
1answer
1k views

Getting duplicate record errors like “Duplicate Entry for key 'PRIMARY', error code 1062” when importing a full backup into slave

We're restoring our slave with a full backup from our master, and getting a bunch of duplicate key errors. Once the slave gets caught up, it does not throw any errors (only when it is behind the ...
4
votes
1answer
27k views

How to restart MariaDB Galera cluster?

How to restart MariaDB Galera cluster? After all node have been crashed I try to recover the cluster but without success. I have only 2 nodes. As documentation says I set a parameter on one of the ...
4
votes
1answer
854 views

Galera cluster into Google cloud platform

We have a galera cluster with 3 nodes, on 3 different physical machines but all located in the same datacenter. From what I understood, the reason they deployed this in the past was to increase ...
4
votes
2answers
8k views

ERROR WSREP`: gcs/src/gcs.cpp:gcs_open():1379:` Failed to open channel 'test_cluster'

I have three server that I want to Install Galera clustering on them, I followed this link to install and config it. but when I want to start the first server I got this error : root@node107:/home/...
4
votes
2answers
37k views

Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2 “No such file or directory”) when configuring cluster

I have 3 MariaDB nodes. Want to configure cluster. Specified in gcomm:// in my.cnf ips of all members in cluster according to this. And added ?pc.wait_prim=no at then of gcomm://ip1,ip2,ip3 Then ...
4
votes
2answers
1k views

Is it safe to disable sync_binlogs, innodb_flush_log_at_trx_commit and innodb_doublewrite on a site-redundant galera cluster?

On a site-redundant galera cluster, a commit should only return after a quorum of database nodes have accepted the transaction. If one database node goes down, all commits will be preserved by the ...
4
votes
2answers
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 ...
4
votes
1answer
4k views

WSREP: failed to report last committed and stop

I have galera cluster and I have 4 nodes. I'm importing some data. however one node gives error. Warning. The warning is; warning WSREP: Failed to report last committed 59102, -q (interrupted system ...
4
votes
0answers
1k views

Galera Cluster Failed to report last committed

I'm experimenting with Galera Cluster with 3 nodes, but I'm having some issues but I'm not sure why. What I noticed is that I'm having lots of failed to report last committed (number), -110 (...
4
votes
1answer
2k views

mysqld got signal 11

I have MariaDB in Galera cluster of 3 nodes. Periodically, each node in the cluster restarts by sending yourself a signal 11. I scoured the Internet in search of a solution to the problem, but to no ...
4
votes
1answer
501 views

How (if at all) does Galera enforce authentication for SST via rsync when adding a node?

I have to be missing something here. It just hit me as added a new node to my cluster in order to prepare for the removal of a different node: "How does the cluster know that it is okay to send the ...
3
votes
1answer
16k 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 ...
3
votes
1answer
380 views

Why does most Galera cluster documentation recommend having at least 3 nodes as the typical set up?

The Galera documentation and most experts implementing this type of setup, recommend having at least 3 nodes in the Galera cluster. What is the reasoning behind this? Is a cluster setup with only two ...
3
votes
1answer
2k views

Stop INNODB MONITOR OUTPUT

I use MariaDB galera cluster 10.0.31 with 3 nodes. In one node when I tail -f err log to monitor server, Every 20 seconds MySQL dumping Show InnoDB Status to err log, and the log are getting bigger. ...
3
votes
1answer
9k views

How to verify galera is synced

I have been using mysql master:master replication and was always able to check the status of replication using this command: mysql > show slave status\G I was able to see this in the show slave ...
3
votes
1answer
1k views

Galera not working with Replication

I am using MariaDB 10.2 I have node2 (2.2.2.2) running as a slave to some external database. I bootstrapped node2 as the first member of a Galera cluster "my_cluster". Node1 (1.1.1.1) joined with ...
3
votes
1answer
2k views

Galera SST fails

I am using MariaDB 10.2 I have node2 (2.2.2.2) running as a slave to some external database. I bootstrapped node2 as the first member of a Galera cluster "my_cluster" When I try to join node1 (1.1.1....
3
votes
1answer
9k views

How to get number of active users with one SQL-Query?

I am running a site similar to craigslist where users can create classifieds and write/reply messages. In order to get an idea of activity I would like to get the amount of active users per month. ...
3
votes
1answer
2k views

How to perform backup on quite active 500G+ MariaDB Galera Cluster?

what would be your preferred method to perform backup on quite active 500G+ MariaDB Galera Cluster? Using mariabackup/innobackupex (fork of Percona Xtrabackup) with throttle. You must think about ...
3
votes
1answer
4k views

MySQL cluster write performance with Galera (MariaDB)

I am currently evaluating the migration from our current database server to a three node cluster. Our current server is a VM running MariaDB 10.1 with asynchronous replication to another server in ...
3
votes
1answer
195 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"...
3
votes
1answer
172 views

MariaDB cluster uptime

Is there a way to show the Cluster database's uptime? Obviously I can see each individual node's database uptime with the likes of: SHOW GLOBAL STATUS LIKE 'Uptime'; select TIME_FORMAT(SEC_TO_TIME(...
3
votes
0answers
1k views

Galera cluster consume many CPU percent and CPU high load

I have implemented a cluster include three nodes: two stored nodes and one garbd (also haproxy - load balancer). Some information about servers: SSD 480G Raid1 Memory 32G Swap 16G 2xCPU, number of ...
3
votes
1answer
8k 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-...
2
votes
2answers
8k views

MariaDB 10.1.16 on Ubuntu fails to start: WSREP Failed to recover position

I'm using 10.1.16-MariaDB-1~xenial from the official MariaDB apt repository for 10.1 [stable], via the University of Texas mirror. I had a perfectly functioning MariaDB Galera cluster setup on 3 ...
2
votes
1answer
2k views

'kill <query 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 ...
2
votes
2answers
2k views

MySQL Galera Cluster mass update delay

I have migrated my single MariaDB setup to a 3 node Galera cluster. I am currently in staging and most of normal operations run fine. I have one issue though: if I do a mass update of one column of ...
2
votes
2answers
826 views

Galera: any drawback of enabling wsrep_log_conflicts and cert.log_conflicts?

We have a HAProxy which balances reads and writes to only one (of three) Galera nodes. If this balancing works fine, the parameters wsrep_log_conflicts and cert.log_conflicts should never log any ...
2
votes
2answers
1k views

why I see only COMMIT or commit in SHOW FULL PROCESSLIST - No SQL statement

I see in lots of output from SHOW FULL PROCESSLIST only COMMIT or commit (lowercase and upercase mix). What are those transactions? Why no SQL statement? We are running MariaDB 10.1.x and Galera ...
2
votes
1answer
5k views

The right way of starting up a Galera Cluster

I am confused about the bootstrap process of MariaDB Galera Cluster. Let's say we have 3 nodes of a MariaDB Galera Cluster, working and functioning normally on CentOS6/7. However, at some point we ...
2
votes
1answer
5k views

Replicate only some tables of MariaDB database

I currently have a ready-made structure cluster with MariaDB Galera with two servers that keeps both updated database. However I now have the need to create a new similar structure but with one ...
2
votes
1answer
1k views

what is MDL? (e.g. 'MDL semantics' or 'MDL locks') Probably Galera related

I found a guy talking about MDL semantics in a Galera/XtraDB bug report. What is MDL? The term MDL also in Galera logs MDL conflict. Please explain in detail. 2018-06-14 17:07:10 140112699321088 [...
2
votes
3answers
2k views

Percona XtraDB - Random deadlock

Randomly my database gets locked completely and queries hang and they pile up until it gets "Too many connections". Below is my mysql log file, I couldn't find anything related to the error system ...
2
votes
1answer
1k views

Will large inserts crash a 3-node MySQL database cluster?

We have a 3 node MySQL database cluster than runs on Percona. I have a stored procedure that inserts a lot of rows in one hit, potentially over a million rows. I've been warned (by our DBA) this ...
2
votes
1answer
4k views

Galera Cluster with MariaDB 10 and asynchronous slave

As it's easier to understand what I'm trying to accomplish with a picture, here's a picture: I'm really not an expert in database administration, so please be patient. I am working on a setup where ...
2
votes
1answer
1k views

MariaDB Galera setup with drastically different amounts of memory used on cluster nodes - why?

We have a 3 node MariaDB Galera cluster. All nodes are identical and the config on each is identical. They have 64GB of RAM each. The output of the following query is 28: SELECT CEILING(...
2
votes
1answer
1k 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://' ...
2
votes
1answer
3k views

“No valid checkpoint found” when restoring xtrabackup

I have a cluster of MariaDB 10.1 servers, master/master with one node acting as arbitrator and incremental backups with xtrabackup. This is how I've pieced it together from the docs. Master01 does ...
2
votes
1answer
1k views

Galera, MariaDB and multiple datacenter

Looking into using Galera and MariaDB across 3 data centers. We have a metroE comnection between the sites. Connectivity is pretty stable, but my concern is if a WAN link goes down at one of the sites,...
2
votes
1answer
4k views

MariaDB Galera Cluster (master-master) does sync Tables but no data

I'm currently experiencing some sync-issues on my MariaDB Galera Cluster which is a master-master scenario. I've got everything set up properly and the cluster is syncing the DDL changes flawless. ...
2
votes
1answer
234 views

How to transition from a statement based log to row based log for Galera replication?

I'm new to clustering and I'm trying to implement a Galera cluster. I'm transitioning from a standalone MySQL instance to a MariaDB Galera Cluster consisting of (at the moment) 2 nodes. I have ...
2
votes
1answer
4k views

Is it safe to use mysqldump to backup and restore a master-master cluster

Not sure if the specifics matter but just to get it out of the way I am talking about a Galera cluster on XtraDB (MariaDB). I have a master-master setup and am interested in backing up and restoring ...
2
votes
1answer
1k views

MariaDB Cluster - data consistency for updates and auto_increment

I have two different MariaDB servers and plan to merge data into one database and create MariaDB Cluster with 3 nodes. I read about Galera and multi-master replication - which MariaDB Cluster use and ...

1
2 3 4 5 6