Questions tagged [galera]

MariaDB Galera Cluster is a synchronous multi-master cluster.

Filter by
Sorted by
Tagged with
1
vote
0answers
306 views

Can't add new node to Galera Cluster

I have a 5 node Galera 3 Cluster running MySQL 5.6 on Ubuntu 16.04 (I tried running 5.7 but ran into the AppArmor issue). I'm trying to add another node to the cluster but it continually fails. The ...
0
votes
1answer
488 views

MariaDB Galera Cluster on Ubuntu 16.04 does not start after rebooting [closed]

I've installed a MariaDB Galera Cluster on Ubuntu 16.04 in 2 nodes. Here the info from node1: root@localhost:~# sudo more /etc/mysql/conf.d/galera.cnf [mysqld] binlog_format=ROW default-storage-...
1
vote
0answers
195 views

galera wsrep_cluster_address value

I am trying to deploy galera multimaster replication but faced some problems, google does not solve it it seems, but I see some people had the same problems in the past. Say, I have 3 servers 192....
0
votes
1answer
744 views

A minimum of a 3 Node Galera Cluster is Recommended, but is it better to have 5 nodes?

Right now I have a 400GB database, with a 5 node Galera Cluster. They are all RAID 10 SSDs. I've read the following: If the node goes missing due to a network problem or otherwise leaves without ...
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 [...
0
votes
0answers
126 views

MariaDB galera cluster with Mroonga in wrapper mode doesn't synch

MariaDB Galera Cluster states that the storage engine needs to be InnoDB. I am using Mroonga on some tables in wrapper mode {which uses InnoDB under the hood as storage engine}. The problem I am ...
0
votes
1answer
2k views

InnoDB: Error: log sequence number is in the future!

Hi I have 2 node cluster where recently went offline not sure why. Node1 started fine and all the traffic is on node 1 but node 2 still down due to below error. I tried set the inodb recovery to 3 and ...
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 (...
0
votes
1answer
492 views

Mariadb Galera cluster empty set

I am playing around with a MariaDB Galera Master Master Cluster and I have some issues which I do not understand. [mysqld] bind-address=0.0.0.0 [galera] wsrep_on=ON wsrep_provider=/usr/lib64/galera/...
1
vote
1answer
1k views

Using xtrabackup-v2 as SST method in MariaDB Galera cluster

I have configured mariadb galera cluster as docker swarm service using official docker image: during cluster startup rsync (default SST method) works fine. Wanted to change it to xtrabackup or ...
1
vote
2answers
519 views

MySQL XtraDB/Galera Cluster High Availability RamDisk *SuperFast*

Ok, So this is going to be a speculative question, mostly design oriented and a rather long one. I'd grab a cuppa' covfefe, if I were you. Preface: So I have been researching into databases and ...
0
votes
2answers
589 views

Percona XtraDb cluster auto increment

Help me please clarify a very important question on which I can't find the answer. It only can be proven with tests. Let's say we have XtraDB Cluster (or Galera Cluster) with three nodes. We have ...
1
vote
1answer
170 views

does the gcache.size matter during SST? What if more than gcache.size comes in during SST?

During SST my data dir looks like this (there is a hidden dir .sst with xtrabackup): -rw-rw---- 1 vcap vcap 113 Apr 16 08:13 grastate.dat -rw-rw---- 1 vcap vcap 265 Apr 16 08:13 gvwstate....
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 ...
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....
1
vote
1answer
2k views

SST not starting on a new node on MariaDB Galera Cluster

I have two MariaDB servers I want to use to create a new MariaDB Galera Cluster: Server mysql1, with some data and configured as a donor Server mysql2, with no data and /var/lib/mysql empty, which I ...
1
vote
1answer
228 views

Setup replication between two Galera nodes

I've been using MariaDB 10.2 Galera with 3 nodes successfully on local servers. Now, I have a second 3-nodes Galera cluster on another location, joined by an Site-to-Site IPSec Tunnel. I can't really ...
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 ...
1
vote
1answer
358 views

Can sst_state_transfer be set to rsync with innodb as storage engine in Galera cluster?

Galera cluster wsrep-sst-method docs states: You can only use rsync when anode is starting. You cannot use it with a running InnoDB storage engine. I do have InnoDB storage engine configured in ...
0
votes
1answer
69 views

I can't add extra node after reset root password mariadb 10.1.20

I have a mariadb 10.1.20 cluster with 5 nodes. I don't know root password so I did the following steps: On second node, I stopped mysql service I set wsrep = OFF on /etc/my.cnf.d/server.cnf I ...
0
votes
1answer
673 views

MySQL Galera cluster can't initiate first node

I'm using Ubuntu 16.04 and installed MySQL version 5.7 via apt-get in AWS. After that, I've managed to upgrade the MySQL to Galera Cluster by following the Documentation from the official website ...
0
votes
1answer
570 views

Galera Failures

I have 2 nodes. One a VPS on NFO Servers and another on Azure. I have setup the firewalls/disabled the firewalls. The nodes are CentOS 7, Latest Kernel. The configs are as follows: Node 1 (Master DB) ...
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 ...
0
votes
0answers
160 views

Debugging Galera TX conflicts when no SQL is logged

I'm trying to debug an intermittent transaction conflicts in my cluster. With the debug output enabled, I'm getting following logged: *** Priority TRANSACTION: TRANSACTION 1691804310, ACTIVE 0 sec ...
-1
votes
1answer
361 views

can't increase gcache.size galera cluster mariadb

i wanted to increase the value of gcache.size on my 3 nodes of the mariadb galera cluster (galera v25.3.22(r3764), mariadb Ver 15.1 Distrib 10.0.33 - MariaDB, for Linux (x86_64) using readline 5.1), ...
0
votes
1answer
1k views

mariadb galera bootstrapping fails

Starting point at the sandbox sb1, sb2, sb3: All boxes identical. A Fresh debian 9 install mariadb 10.2 Galera3 build a test galera cluster with empty databases works fine. All three nodes come up and ...
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 ...
0
votes
0answers
106 views

Move a node from cluster to be a slave of the cluster in Galera

I have 5 Node in Galera cluster. MariaDB Server 10.1.21-MariaDB-1~trusty. I will remove 2 nodes from it but one of them will be a slave. So from 5 nodes 5th one will be completely removed, 4th one ...
2
votes
1answer
836 views

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 ...
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 ...
0
votes
1answer
2k 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 ...
0
votes
1answer
91 views

Questions for 'Tips on Converting to Galera' on MariaDB KB [closed]

Some questions about the excellent writing Tips on Converting to Galera. Is "cross-colo writing" cross connect datacenters write? Also, you should use "START TRANSACTION READONLY" wherever ...
1
vote
1answer
823 views

How to backup a Galera node

I have a new production 3-node Galera (MariaDB 10.2) cluster, and am looking for advice on backups. My current plan is twofold: Replicate one node to a non-clustered slave, and schedule mysqldumps on ...
0
votes
1answer
224 views

mysqldump to a hostname which is proxy/router (not MySQL server)

I do a mysqldump with those options --single-transaction --routines --events --max_allowed_packet=1G --flush-logs --master-data=2. The desination hostname is not a MySQL server, it's a proxy/router. I ...
1
vote
2answers
6k views

Percona - Unable to start mysql after restart

I just configured a percona xtradb cluster in ubuntu with 2 node. This is what I did. launched 2 new servers. Installed percona cluster on both nodes. Stopped mysql on both nodes. On server1: /...
0
votes
1answer
693 views

Galera Cluster Setup - Primary and Secondary Site Scenario

I'm very new to Galera Cluster and is exploring a potential setup with reasonable resiliency to node failure and network failure. Looking at the very bottom part of this documentation, the Weighted ...
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 ...
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(...
0
votes
1answer
2k views

wsrep_sst_auth user permissions

In the my.cnf for our PXC cluster nodes, we have been using root user for wsrep_sst_auth with all the admin privileges that comes with the root account. We know using the root user:password inside the ...
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://' ...
1
vote
0answers
429 views

MariaDB Galera cluster: claster stalls with lots of “Query End”

I have cluster consists of 2 physical nodes (2x Intel Xeon E5-2670 2.6Ghz , 192Gb, RAID1 SSD, ОС Debian 8, mariadb-server-10.2) + arbitrator (on Proxmox). I write to only one node at time. My cluster ...
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. ...
0
votes
1answer
195 views

Cannot start the mariadb.service in the 3rd node

I have three nodes in a mariadb cluster. Node 3 cannot start mariadb: I use the systemctl status mariadb.service: [root@ha-node3 log]# systemctl status mariadb.service ● mariadb.service - MariaDB ...
1
vote
1answer
1k views

Galera multi-nodes Master-Master issue with READ right after INSERT

I have a multi-nodes Galera setup which is master-master. An API call to a web server A could write data to either database 1, 2, 3 or 4 (we are not using HaProxy). Another API call right after that ...
1
vote
1answer
344 views

Reboot VMs the mariadb do not restart

I install the MariaDB 10.1 on three VMs(controller1, controller2, controller3), and after I cluster them, it works well, but after I restart the three VMs, the mariadb_cluster did not restart. In ...
1
vote
1answer
3k views

Node unable to join a MariaDB Galera Cluster

I'm trying to setup a third node for my MariaDB cluster. I copied over the server.cnf file from my second node (which joins the cluster and can start its own cluster). The first two work fine using a ...
0
votes
1answer
741 views

Risks when running a MySQL Galera Cluster in production without binlogs?

First of all: I assume that this is no real good idea. However, this Bug in MariaDB 10.1.xx crashes single cluster nodes. https://jira.mariadb.org/browse/MDEV-9510 One of the workarounds is to ...
1
vote
0answers
75 views

Galera Async Multimaster Backup

I am just configuring a Galera 10.1.14 cluster and i want to set the Async replica from two different clusters. Cluster 1 -> Data Schema A \ ==(WAN)==> MariaDB 10.1....
1
vote
2answers
1k views

Java application unable to connect to MariaDB Galera cluster

I was debating whether to post this question here or on Stack Overflow but through my own examination, I believe this to be a server-side issue over Java code being wrong. My goal for this project is ...