Questions tagged [galera]

MariaDB Galera Cluster is a synchronous multi-master cluster.

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

galera_new_cluster hangs with galera_recovery

My cluster crashed and i cannot restart the first node with galera_new_cluster. The nodes are distributed geographically in France with medium latency of 12ms. It remains on /usr/bin/galera_recovery ...
0
votes
1answer
25 views

Galera - why can't I use port 4567 for replication?

I have two Galera clusters in two different datacenters. I want to replicate cluster c1(using c1-1 node as replication master) to cluster c2 (using c2-1 node as replication slave). Everything works ...
0
votes
0answers
10 views

Can we use proxysql 2.x for load balancing multiple Galera clusters?

We have recently introduced proxysql 2.x for loadbalancing a galera cluster in production environment. It is working great so far. I have been tasked to separate staging cluster which is currently in ...
1
vote
1answer
20 views

How to limit impact of a bad application on MariaDB Galera Cluster with MaxScale?

I have a Galera Replication cluster with three MariaDB nodes where a Maxscale Active-Passive cluster in front provides a single node image to tis clients. I have a bad behaving client, which opens ...
0
votes
1answer
59 views

Galera cluster slightly slower than single database?

I recently set up a MariaDB galera cluster for our production. I used sysbench to benchmark the cluster against the old database which is on a single server. On my PRD Galera Cluster I got the ...
1
vote
1answer
29 views

Automatically and robustly restarting a Galera cluster

Galera clusters, somewhat famously, have a requirement that nodes need to be shut down and brought back up again in a certain order. There are a few questions here and on other sites about recovering ...
1
vote
0answers
126 views

Galera Manager web gui for mariadb

I want to create a MariaDB 10.4 multi-master cluster on four Ubuntu 20.04 nodes. As you know Galera manager provides a web GUI interface for the cluster and it's handy for monitoring and add or remove ...
1
vote
0answers
62 views

Why setting up new galera cluster with mariabackup as sst starts but all other nodes failed with same error?

I did a fresh reinstallation of mariadb-server on all the nodes (I removed using sudo apt purge mariadb-*) I started the first node using sudo galera_new_cluster it went fine and is still running. but ...
0
votes
0answers
16 views

How to setup Galera Cluster when nodes are located multiple sites?

I am setting up a web app that runs on 2 sites and shares db, Initially I setup 1 Galera Cluster with all nodes in it, but sometimes SST on bringing node up takes lot of time and service start times ...
0
votes
0answers
7 views

How redo log transferred in galera SST

the galera replication can initiate a node with SST(mysql and mariadb) or mariadbbackup(with MariaDB 10.1 and above) . a SST operation works with rsync and transfer data to new node and then apply ...
0
votes
1answer
38 views

My Galera Cluster does not connect across AWS regions

I am building a MariaDB Galera Cluster, on AWS, EC2. Using MariaDB 10.5 and Galera 4. I have two nodes in the California region, named galera_ca and galera_ca2, and a third node in Oregon name ...
0
votes
0answers
101 views

Master node of galera cluster is not in sync, how should I sync them?

master node server id 10 SHOW STATUS LIKE 'wsrep_local_state_comment'; +---------------------------+----------------+ | Variable_name | Value | +---------------------------+-------...
1
vote
1answer
144 views

Mariadb galera cluster master node started and reporting 2 nodes but second node service says activating mariadb

I managed to start the master node mariadb galera cluster, then I started the second node and I check on the first master node; $ sudo mysql -u root -p -e "SHOW STATUS LIKE 'wsrep_cluster_size'&...
0
votes
0answers
74 views

mariadb galera cluster not starting

when I start my mariadb service and all nodes tries to join, I get below line in the systemd service WSREP: Recovered position 00000000-0000-0000-0000-000000000000:-1 -- Logs begin at Tue 2020-11-10 ...
0
votes
0answers
68 views

please help starting mariadb galera cluster node

I am getting thsi error: Starting MariaDB 10.4.17 database server... WSREP: Failed to start mysqld for wsrep recovery: '2020-11-23 21:48:20 0 [Note] /usr/sbin/mysqld (mysqld 10.4.17-MariaDB-1:10.4.17+...
0
votes
0answers
18 views

How to increase donor speed on mariadb galera cluster?

hi currently i have database with size 200gb and my every node at 1Gb/s so when 1 node is down and then 2 node will be donor i config mariadb donor with wsrep_sst_method = rsync method. but it's take ...
1
vote
0answers
45 views

How to hot merge MariaDb databases from multiple servers into a single one

Current Configuration I currently have 3 servers: server australia with the database canberra servers belgium and germany are a galera cluster with the database bruxelles. Target Configuration My ...
0
votes
0answers
40 views

Does commit after a normal select can call any fsync or flush operations?

I'm using Mariadb 10.2.16. 3 Node cluster. Coms counts taken at particular time for all 3 (insert,update,commit). Com_inserts are in 1.1K Com_updates are in 1.6k Com_commit are in 10K When ...
0
votes
0answers
13 views

Is it possible to replicate different Galera MAIN-MAIN clusters (MariaDB) with another Galera MAIN-MAIN cluster but as MAIN-SECONDARY asynchronously?

We are a small team of developers and we usually deal with single database access locally or remotely. We are working on a project that needs to have not only replication on the local network (we'll ...
0
votes
1answer
34 views

Percona xtradb cluster 5.7 solution on AWS and on premise. Not all nodes are connected to

We have 3 nodes cluster. 2 in virginia and 1 in ohio. The cluster is working fine we do not have any issues. But nothing pop out when we started doing extensive monitoring using datadog. It shows that ...
0
votes
0answers
116 views

Recover MariaDB & Galera from crash

I have two servers in the same network. Both are ubuntu servers with LAMP. My main server crashed today because of a power failure, after the server restarted MariaDB was totally unresponsive. All the ...
0
votes
0answers
168 views

Best way to prevent lock wait timeout exceeded try restarting transaction

I'm not totally savvy about databases, I just know the basics. We encountered this problem while trying to query something from our database. This query occurs every 10 seconds. This is the first I ...
0
votes
0answers
9 views

MariaDB uses HAProxy IP instead of the WebServer IP

I have a HA Setup that goes like this: I made a user for the web server: grant all on user_db.* to 'db_user'@'10.10.10.26' identified by 'password'; But when I try to access it via this command: ...
0
votes
2answers
145 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
28 views

Mysql replication between 3 + 1 nodes

Suppose I have the following configuration for mysql 5.6 replication. Nodes A B C D Nodes A,B,C have wsrep_cluster_address set to respective ip's of nodes A,B and C. Then node D has ...
0
votes
1answer
73 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
10 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
9 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
30 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
23 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
22 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
46 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
166 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
10 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
37 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
210 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
19 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
71 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
1answer
252 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
1answer
93 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
241 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
94 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
273 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 ...
1
vote
1answer
3k 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
294 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
1answer
188 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....
1
vote
1answer
952 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
20 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
46 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
81 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
2 3 4 5 6