Questions tagged [galera]

MariaDB Galera Cluster is a synchronous multi-master cluster.

Filter by
Sorted by
Tagged with
0
votes
0answers
11 views

MariaDB Cluster node crashes after upgrade

I have a 3 node MariaDB galera cluster running. It was running fine until I updated one node from MariaDB 10.3.14 to 10.3.16 (the other nodes are still on 10.3.14). Since then, this one node regularly ...
1
vote
0answers
10 views

queries to active live test health of a galera cluster

What queries could be used to foresee or better fine tune alerts to check the health status of a Galera (MariaDB) cluster? The problem I am facing is that randomly the cluster gest stalled because of ...
0
votes
0answers
19 views

MariaDB Galera + Replication (GTID error)

Using MariaDB 10.2.25 + Galera with 3 masters All Masters have binlogs active Want to switch the Master_Host of an external salve (also running MariaDB 10.2.25) to a different Master. Replication is ...
0
votes
2answers
27 views

Took a full backup of a running mariadb server and restored, but none of the databases are visible

I'm setting up a mariadb galera cluster to ultimately switch production to. However, I don't have the ability to stop the production instance so I'm trying to set this up using various workarounds I'...
2
votes
1answer
18 views

How can I specify which MariaDB instance to launch in a Galera Cluster

I have several MariaDB servers, each with multiple instances running. I'm trying to figure out how would I bootstrap a Galera cluster but specify which instance I want to launch i.e: node1, 2, and 3 ...
0
votes
1answer
24 views

How to cache inserted data with ProxySQL to avoid delays

we are using MariaDB 10.2 with Galera plugin. Cluster consists of 4 nodes - 3 are busy service complex queries and 1 is more for a backup. Recently we came across ProxySQL and this sounds very ...
0
votes
0answers
9 views

RUN DDLs in Galera Cluster

I have 3 node Production Mariadb Galera Cluster with many schemas. I need to run ALTERs quite often and since its a Galera , cluster wide locking is happening and currently wsrep_OSU_method=TOI. I am ...
0
votes
1answer
24 views

galera cluster how to run an ALTER without using RSU/TOI

I need to run an alter statement but would like to prevent locking/stall the cluster. The Galera docs advised using: SET wsrep_OSU_method='RSU'; Then Run the ALTER statement, once finich: SET ...
1
vote
1answer
15 views

how wsrep_local_index is defined or could be changed?

I have a cluster of 3 nodes using Galera with MariaDB, every time I want to backup I check the node with the highest wsrep_local_index and then do: SET GLOBAL wsrep_desync = ON; Take the backup, ...
0
votes
1answer
56 views

Is it possible to setup MySQL replication through ProxySQL?

We currently have replication working through haproxy so that if a node goes down replication continues with one of the other nodes. We're trying to completely replace haproxy with proxysql. Due to ...
1
vote
0answers
42 views

MariaDB Galera slave thinks it's replicating, but it isn't

I have a MariaDB 10.3 Galera slave node with general logging turned on. It's consuming binlogs generated by a MySQL 5.5 NDB cluster. The binlog format is row-based in both databases. SHOW ALL ...
0
votes
0answers
34 views

how to remove/deal with locks in a MariaDB Galera cluster

I have a cluster of 3 nodes running MariaDB Galera cluster, cluster works as expected, I can reboot a single node at a time and in the best case, IST will be used or SST(using rsync) to sync back the ...
0
votes
2answers
93 views

Percona Xtradb cluster 56 node 2 rejoin cluster failed

I have following DB cluster: Node 1: Percona-XtraDB-Cluster-56-5.6.39-26.25.1 Node 2: Percona-XtraDB-Cluster-56-5.6.39-26.25.1 Node 3: Percona-XtraDB-Cluster-56-5.6.41-28.28.1 I start in order ...
0
votes
0answers
47 views

MariaDB Galera journalctl

I've noticed something weird. I have 3 nodes galera cluster, installed using mariadb. I'm pretty sure that I did all three nodes installations exactly the same. All three nodes display their --...
1
vote
1answer
58 views

MariaDB 10.2.22 Galera Cluster Using Bad Indexes After Analyze

I'm using Drupal on a MariaDB Galera 10.2.22 3 node cluster and I'm having some problems with one query. I have a table (InnoDB) called field_data_field_department which has a bunch of indexes. If I ...
0
votes
1answer
60 views

Galera Arbitrator system requirements compared with the actual Galera MariaDB node requirements

Right now our setup is CloudFlare > 1x HAProxy (Dallas,TX), 3x App servers (Dallas,TX), 3x MariaDB nodes in a Galera multi-master cluster (Dallas,TX). The App servers auto-scale horizontally to handle ...
0
votes
0answers
196 views

“Resource deadlock avoided during COMMIT” when a node leaves the group

I believe it's a bug in MariaDB Galera (10.3) but wanted to confirm. I have 3 nodes in the cluster (A, B, C) and a sysbench running the OLTP write-only test connecting only to node "A". When the node "...
0
votes
0answers
413 views

Newly built Mysql galera cluster does not start up in centos 7

I am setting up a 3 node mysql galera cluster lab environment. All 3 nodes are centos 7 and followed the steps in below blog to setup mysql-wsrep-5.7 https://www.dreamvps.com/tutorials/install-...
0
votes
1answer
67 views

help understanding galera consistency (certification-based replication)

Galera uses a certification-based replication to achieve strong consistency. While doing a transaction after doing a COMMIT the other nodes will certify it and if is ok it will be successfully ...
1
vote
2answers
23 views

Replicated MySQL write performance query

Whilst I've worked with MySQL for years, I've never had to created a replicated database, and after researching the topic I have a query about performance. I'm thinking of an architecture based on 5 ...
0
votes
0answers
30 views

There are some inserted records on galera cluster that does not exist!

We are using a galera cluster with 3 node and 2 database on it which they are related to each other by some applications. The problem is, some records are inserted into table and galera generate id ...
0
votes
1answer
110 views

Galera cluster node fails with error. Brand new cluster + master / node. Access denied or can't connect

I am having issue. Previous cluster fatally crashed, so I've created a new one with pretty much same settings (changed cluster name only). Here is a galera.cnf for a node: [mysqld] binlog_format=...
0
votes
1answer
23 views

Xtrabackup corrupt incremental backup

I have 3 nodes PXC 5.6 cluster. Xtrabackup 2.3.10. Centos 7.6 Percona-XtraDB-Cluster-56-5.6.41-28.28.1.el7.x86_64 I am using only single Node-1 for both read and write. And I use to take backup ...
1
vote
5answers
792 views

Managing mariadb database performance with very large tables

I have a joomla-3.9 and apache-2.4.34 system on fedora29 with mariadb-10.2.19 and the tables that contain the search content are very large. Several are larger than 1.2GB and one is larger than 5.5GB. ...
0
votes
1answer
247 views

MariaDB Galera Cluster - first node won't reconnect after restart… Ever

Firewalls disabled, replication worked fine, IP's accessible.. All config copied from here: https://www.digitalocean.com/community/tutorials/how-to-configure-a-galera-cluster-with-mysql-5-6-on-ubuntu-...
0
votes
2answers
77 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 ...
0
votes
1answer
24 views

Convert MyISAM to InnoDB in PXC master master

I have 3 nodes PXC 5.6 master master cluster. I have few tables that are using MyISAM. Total MyISAM table = 120 Total MyISAM table size = 80MB I have also read few recommendations where it suggests ...
1
vote
2answers
42 views

Do VIEWS need a primary key in Galera?

We have a MariaDB Galera Setup, so do we require primary keys in a MySQL view? It contains a complex select query with joins of tables and the values get updated. so do they replicate in a Galera DB ...
0
votes
1answer
18 views

Character set warning in PXC logs

I am using PXC 5.6 (Percona-XtraDB-Cluster-56-5.6.41-28.28.1.el7.x86_64) and my log file is flooded with this warning: [Warning] Client failed to provide its character set. 'latin1' will be used ...
0
votes
1answer
56 views

Auto increment gap in percona xtradb cluster master master setup

I was using mariadb 5.5 before but now I have upgraded it and using percona xtradb cluster 5.6 I have 3 nodes cluster. I am only using single node for read and write. I saw some increment gaps in ...
2
votes
0answers
66 views

Percona Xtradb Cluster not accepting options on command line

I am using Percona Xtradb Cluster 5.6 and trying to start my cluster through a donor node via command line and I am getting this error: CentOS 7: systemctl start mysql --wsrep-sst-donor=srv1 ...
2
votes
1answer
325 views

Galera - single database backup & restore

I have a MariaDB Galera cluster. One of its nodes is dedicated for the backups (pc.weight=0 and the MaxScale SQL proxy doesn't know it exists). I'm using mariabackup --backup --galera-info --target-...
0
votes
1answer
34 views

Missing wsrep variables in mysql / percona / galera cluster

I set up a small mysql/percona/galera cluster using the percona cluster docker image, with 3 nodes. I followed the documentation written here After starting up the whole cluster, I'm missing some of ...
0
votes
1answer
206 views

InnoDB Buffer causing a lot of deadlocks and connection/client timeouts

I have a PXC cluster (5.7) with three nodes running on CentOS 7 VMs, each with the following system info: mysql_db# free total used free shared buff/cache ...
0
votes
1answer
162 views

query_cache_type on mysql galera cluster

I was wondering could I turn on the query_cache_type for mysql galera cluster of two nodes. The scenario is : 1. Proxysql infront of two master-master galera(mysql) nodes 2. Inserts are coming ...
1
vote
1answer
41 views

mysql_insert_id() on galera mysql cluster

I have percona mysql galera cluster. It inherited a MyISAM database. In order for the galera to work it had to alter to innodb. Replication is working so far so good. However I have a php application ...
0
votes
1answer
47 views

Mariadb 10.1 / Galera - bootstrap node always doesn't lose quorum

I'm using mariadb10.1.37, wsrep_provider_version 25.3.24(r3825). On my dev cluster (2node+1arbitrator) I found the following behaviour: node1: bootstrap new cluster (using galera_new_cluster, with pc....
2
votes
1answer
392 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 ...
1
vote
1answer
247 views

WSREP: Writeset deserialization failed: Unsupported RecordSet version: 2: 71 (Protocol error)

We are running a Mariadb galera cluster with 3 data nodes. Recently one of them crashed and I had to do a SST (State Snapshot Transfer). Nothing I haven't done or seen before. However, after the SST ...
0
votes
1answer
59 views

MariaDB Galera Cluster - Cert Deps Distance issue

I have mariaDB Galera 10.2 Cluster running with 3 nodes; in google cloud VMs with 8 cpu ; 15Gigs Ram / node; My slave_thread setting = 24 ; currently there is no much write happening and ...
1
vote
1answer
155 views

MySQL PXC node failing to receive state

I have three nodes that I want to setup into a Percona XtraDB Cluster (PXC). I have bootstrapped the first node and joined the second node, but cannot somehow join the third node. All configuration is ...
1
vote
3answers
100 views

Read after write in Galera

I am facing a issue with 3 node galera cluster where the read doesn't return any records even when the write has been commited. Below are the steps which can happen from multiple servers. 1>Server A ...
0
votes
1answer
103 views

all gradestate.dat seqno: -1 why?

All my 3 nodes in mariadb galera cluster seqno is -1 and when i restart the whole cluster i need to start with --wsrep_new_cluster just to start the other nodes. can anyone help me with this? all 3 ...
0
votes
1answer
135 views

Enable GTID on one node in Percona/Galera

Im having 3 node percona cluster. (5.6) Server ID is enabled on each node but all are different IDs. Binlog and log slave updates are enabled. Now I want to enable GTID on the third node alone. I ...
1
vote
0answers
50 views

MariaDB Cluster Cannot Join new Node

This is status on Main node. it's show some seqno as 17210843 when new empty node is join. i'm found rsync process is ok. but i see difference seqno in linux process after finish this process my ...
1
vote
0answers
61 views

One node causing entire Galera Cluster to remain in bad state

I have a production MariaDB Galera 5 node cluster that has been running for about 8 months at our factory. One node had a powerfail / un-graceful shutdown (Ubuntu 16.04) and since then if that node is ...
2
votes
0answers
278 views

Third node cannot join Galera cluster after mariadb update

I tried to deal with this issue for three days now, but unfortunately without success. I have a Galera cluster (Node1 - donor, Node2 - joiner, Node3 - arbitrator) which was working flawlessly until I ...
1
vote
0answers
54 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
209 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
95 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....