Questions tagged [galera]

MariaDB Galera Cluster is a synchronous multi-master cluster.

Filter by
Sorted by
Tagged with
0
votes
2answers
17 views

Help setting up Galera Arbitrator

I am testing a MariaDB Galera Cluster set up with only 2 nodes, I have three servers haproxy, node1 and node2 . I was able to set it up and it worked fine until testing phase. There are two types of ...
0
votes
1answer
29 views

Need help with some recovery

So i've gone and did something terribly wrong out of haste and not thinking properly. I have a PXC (percona cluster. I guess mysql cluster with Galera?) running with just 1 one being bootstrapped (...
0
votes
0answers
8 views

Resource Limits when switching from rsync to xtrabackup-v2

I am having some problem when using wsrep_sst_method=xtrabackup-v2 When I use node 2 join into cluster, node 2 always response "Resource limits" although I have free disk, ram and cpu.
0
votes
0answers
6 views

How does Gcache save state in galera cluster work

I am wondering how does gcache save data. Does gcache always save data for the last seqno of database or which point of seqno?
2
votes
1answer
21 views

Galera Mariadb Multi-Master Replication [closed]

I am trying to setup a cluster of 3 servers in 3 different locations; Dallas-US, London-UK, Mumbai-India. On each location I have setup a webserver and db server. On db server I have configured Galera ...
0
votes
0answers
9 views

How to avoid SST in Mariadb Galera

I want to add a new node to galera without affecting existing node (donor). For example: node 1 is receive inserted data, and then node 2 join to cluster, node 1 is stuck and can't receive inserted ...
0
votes
0answers
19 views

determine how long the “write lock” is going to last

In a MariaDB Galera cluster composed of 3 nodes when running schema changes, for example, an ALTER and being in TOI(Total Order Isolation) mode it will write lock the full cluster until the schema ...
0
votes
0answers
17 views

Why won't node-1 restart successfully on my 4-node MariaDB Galera cluster, but the others will?

I setup a 4-node Galera cluster on the following platform: CentOS 8.1.1911, with MariaDB 10.3.17 and Galera 3.26. Galera config: wsrep_cluster_address="gcomm://192.168.10.47,192.168.10.48,192.168.11....
1
vote
1answer
26 views

How to alter tables safely to set row_format as Compressed or Dynamic in Mariadb Galera Cluster?

We have some tables with row_format=Compact. The biggest table is around 30Gb, so how safely i can alter tables and set the row format as Compressed for the big table and Dynamic for other three ...
1
vote
0answers
7 views

Upgrading Debian version of PXC production cluster

I have a 3 node PXC 5.7 cluster behind a ProxySQL instance. The cluster is still running on Debian 8. I have setup recently a testing PXC 5.7 cluster with a copy of the database on Debian 10 without ...
0
votes
1answer
25 views

Galera wih MariaDB master-master to support write enable on disconnect

I'm trying out a distributed app using Galera replication topology that needs to support writes if nodes are disconnected from the cluster. The idea was to have an extra MariaDB that is connected to ...
1
vote
2answers
59 views

mysql error code 1292

We are running kea DHCP server with MySQL DB and today we encounter following error and after googling everyone saying it could be MySQL bug so wanted to see if it's really a bug or implementation ...
0
votes
0answers
16 views

after running Galera Replication for MariaDB , performance (TPS) does huge diffrence [duplicate]

I have two VM machines (with exact hardware-software configuration on two ESXI Servers in same rack and same subnet too) that is running with nginx + PHP-FPM + and MariaDB 10.4. in each ESXI server I ...
0
votes
1answer
28 views

After change to 13306, Galera logs error: Slave I/O: error connecting to master 'repuser@<master node ID>:3306'

Working with Galera 25.3.23 on RHEL 7.3 Galera works good before. After changing the MySQL server port from 3306 to 13306, one of the node report error, after restart: Slave I/O: error connecting to ...
0
votes
0answers
42 views

1 Galera node freezes, rejoin is ok but not working

We have a 5-node Galera cluster in a high-load application. One of the nodes freezes in production. Still the cluster-size=5 and Galera/WSREP writes to this node, but the node is not working. Then we ...
0
votes
1answer
74 views

How to restart MariaDB Galera cluster to change my.cnf

I have 3 dbs servers with mariadb galera cluster. I need few my.cnf change but each time I try to just restart with mysql restart command , replication gets affected. So can anybody let me know ...
0
votes
0answers
18 views

Codership Galera - Lock Wait Timeout

We are trying to make the switch to Galera for more HA capabilities but during our testing we are hitting an issue which we can't really pinpoint where the issue would be. The application is returning ...
0
votes
1answer
38 views

galera cluster with mariadb 10.3.13 is not replicating on RHEL 8.1

I'm installing a galera cluster using mariadb 10.3.13 with two nodes in redhat 8.1 server. I enabled ports 3306, 4567, 4568 y 4444 ports. selinux is disabled. firewall disabled. The first node is ...
0
votes
1answer
63 views

MaxScale login as root or other users

I installed MaxScale 2.4.4 with Galera Cluster. I can access to galera with maxscale user but I can't login with other users to maxscale. I created a user in galera and another user with same username ...
0
votes
0answers
52 views

Lost data in bulk Insert on Galera Cluster

I have a 2-node fresh Galera Cluster in 2 DCs. I Import a 3GB dump into one node and the other starts to sync. After importing dump, I check the size and rows on both nodes and they are not equal. ...
0
votes
0answers
113 views

Galera node not accepting root password after restart

I have a Mariadb galera cluster running in Kubernetes with 2 Nodes. Recently, as part of a process of redeploying the mariadb chart, one of them (mariadb-1), was restarted. Trying to perform the ...
0
votes
1answer
635 views

single node stuck in WSREP has not yet prepared node for application use

I have a four node galera mariadb cluster based on mariadb 10.3 that has been running for about a year. For unknown reasons a particular node tends to fall out of the cluster and is unable to rejoin ...
0
votes
0answers
108 views

Galera cluster problem after full crash with mariadb

I have a galera cluster with 2 mariadb nodes running. I know that this isn't best practise but I hadn't a chance to do it in another way. I had a crash and needed to reinitiate the cluster on one ...
0
votes
0answers
65 views

MariaDB Galera: the node, that needs to be joined to others, starts as “wsrep-new-cluster”

We have 4 node Galera Cluster (10.1.14-MariaDB, wsrep_sst_method=xtrabackup-v2). The 1st node successfully started with "/usr/bin/galera_new_cluster" command. The 2-nd and the 3-rd nodes are ...
0
votes
1answer
72 views

Mysql binary logs are not deleted after expiration

I have 3 Mysql 5.6 nodes in one galera cluster in the first DC and 3 MariaDB 10.3 nodes in another galera cluster in the DR site. One node on the 1st DC is the master for one slave node on the DR site....
0
votes
1answer
434 views

mariabackup from remote mariadb10.3 galera | '/var/lib/mysql/' (Errcode: 2 “No such file or directory”)

The following setup applies: 3 node galera cluster in docker backup container that should run mariabackup to get the data out of the galera cluster network is fine. backup container can ping galera ...
0
votes
1answer
17 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
40 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
1answer
38 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 ...
0
votes
0answers
197 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
17 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
121 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
65 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), ...
1
vote
0answers
116 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
375 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
119 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
30 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
2answers
47 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
98 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
148 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
1answer
205 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
164 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
347 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
59 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
1answer
352 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
454 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
1answer
110 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
181 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
2k 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
166 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
2 3 4 5