Questions tagged [galera]

MariaDB Galera Cluster is a synchronous multi-master cluster.

Filter by
Sorted by
Tagged with
0
votes
1answer
11 views

Can I setup several mariadb clusters, each for a schema

I'm planning to use MariaDB Cluster, as a way to sync several databases from different peripherals (raspberry pis). The peripherals don't share data, but all data should be shared with the main ...
1
vote
1answer
20 views

MariaDB Parallel Replication Drifting at random times

I have recently been thrown in the deep-end to manage our Database servers since our DBA left. The current set-up is Mariadb (mariadb Ver 15.1 Distrib 10.1.38-MariaDB, for debian-linux-gnu), InnoDB (...
0
votes
0answers
6 views

gcache.page_sizes and gcache.size are set at the same time. When will gcache.pagebe used?

After the power failure and restart, the slave node creates a large number of gcache.page, which occupies the disk. I would like to know if there is already gcache.cache, when will gcache.page be ...
1
vote
0answers
27 views

Getting the dreaded ERROR 1045 (28000) Access denied for user 'user'@'somehostname' (using password: YES) with a twist [closed]

I have set up a Mariadb Galera cluster following these instructions: https://severalnines.com/database-blog/running-mariadb-galera-cluster-without-container-orchestration-tools-part-one When I ...
0
votes
0answers
23 views

Cannot write to Galera Cluster (Lock wait timeout)

My Galera cluster has gone down / locked up, I can read from all databases, but I cannot write to any table in any database, it just locks / waits forever. I can fix it by shutting down all 3 mariadb ...
0
votes
0answers
9 views

Galera Mariadb: copy a database to different name

I have a Galera 3 node DB cluster server with a schema name largeDB with lots of triggers and tables. I would like to create another schema largeDB2 which is a mere copy of largeDB at that point. So ...
0
votes
1answer
25 views

which node will execute events in master-master setup

Am newbie in this database replication. Right now on server master-master setup with Galera setup. If I have events running in the database. It means from which master its running. If one master down ...
0
votes
1answer
28 views

MySql Galera Multi site high availability

We have a datacenter with 3 percona glera nodes We have a store that wants to be in sync with our datacenter(multi master) our store's internet connection is not reliable ( may be down for 30 min), ...
0
votes
0answers
21 views

Galera throws “WSREP has not yet prepared …” error but nodes are working

Yesterday we moved from 2 node Galera to 4 node Galera with a brand new infrastructure. But after we move the database, Galera started throwing "WSREP has not yet prepared node for application use" ...
0
votes
1answer
67 views

can't join a freshley started mariadb galera cluster

I'm at my very first clustering experience. I need to create a MariaDB Cluster. Currenlty I have two servers but I planned to add 1 more in the future. Now, I have: maz-pihole (a debian 9 based OS ...
0
votes
0answers
36 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
12 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
29 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
31 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
30 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
50 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
10 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
49 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
20 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
84 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
43 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
54 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
138 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
62 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
72 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
73 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
270 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
666 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
83 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
24 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
32 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
139 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
25 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
1k 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
300 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
98 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
31 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
49 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
20 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
70 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
82 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
414 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
37 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
264 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
200 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
50 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
59 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
536 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
281 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
66 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 ...