Questions tagged [galera]

MariaDB Galera Cluster is a synchronous multi-master cluster.

Filter by
Sorted by
Tagged with
0 votes
1 answer
785 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 ...
2 votes
1 answer
362 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 (...
1 vote
1 answer
311 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 ...
0 votes
0 answers
13 views

Kubernetes create cluster multimaster using bitnami/mariadb-galera

I'm trying to deploy mariadb-galera multimaster on kubernetes. But when I set external volume I receive this error: mkdir: cannot create directory '/bitnami/mariadb/data': Permission denied this is ...
0 votes
1 answer
1k 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
2 answers
929 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
1 answer
989 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 ...
0 votes
1 answer
818 views

Bringing up galera cluster

Because of a mismanagement I have a 3 node cluster down. Before doing the due diligence disregarding seqno and recovery processes, the node that used to be the primary was brought up doing ...
0 votes
1 answer
17 views

Mariadb Galera can't start second node

EDIT: the both server was in Azure I tried to install Galera replication on two server. On my first server the "bootstrap" node will correctly start. When i try to start the second node with ...
0 votes
1 answer
1k 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 ...
2 votes
1 answer
2k views

Percona mysql xtradb cluster doesn't start properly and node restarts don't work

tl;dr When starting a fresh percona cluster of 3 kubernetes pods, the grastate.dat seq_no is set at -1 and doesn't change. On deleting one pod and watching it restart, expecting it to rejoin the ...
0 votes
1 answer
5k 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 ...
2 votes
2 answers
5k views

MariaDB Galera Cluster (master-master) does sync Tables but no data

I'm currently experiencing some sync-issues on my MariaDB Galera Cluster which is a master-master scenario. I've got everything set up properly and the cluster is syncing the DDL changes flawless. ...
0 votes
1 answer
321 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
2 answers
8k views

MariaDB Galera cluster node won't start

I have configured a MariaDB Galera cluster with three nodes. The master node and one slave-master node is up and running, but the third node just won't run. The system specs and cluster config are the ...
0 votes
1 answer
817 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
1 answer
590 views

How to Tune MariaDB Database System With Right Parameters

I have a MariaDB Galera 3-Node Cluster as the DB system but since I built, it is working with the default parameters. I only changed the parameter as max_connections=3000. It has been about 6 months ...
0 votes
2 answers
362 views

Can I prevent a galera cluster node from writing gcache.page files?

I have the following setup: 5 hosts, each of them running two galera clusters. One of those two clusters has a production database, the second one a test database. Once a week (early monday morning), ...
0 votes
1 answer
26 views

Row read lock on write

Suppose I have a Galera cluster with 3 nodes. If I start modifying a table and a client start to read the same table from another node, I want it to wait for the write on the other node to finish. The ...
0 votes
1 answer
685 views

Restarting Galera MySQL after proper Shutdown

I already have read and followed dozens of documents describing a split brain situation and how to restart the cluster after then. However, I am less in this situation as in the situation of shutting ...
2 votes
1 answer
393 views

Setup proxysql read-write split with both galera cluster and master slave replication

I have the following setup: Three node galera cluster (galera-1, galera-2, galera-3) galera-2 is master to slave-1 (master-slave replication) slave-1 is master to both slave-2 and slave-3 slave-1, ...
1 vote
1 answer
984 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
1 answer
1k 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
0 answers
31 views

Attempting to Switch from MariaDB FKM to Hashicorp Vault Key Management

I've been trying for a good few months now to switch our MariaDB 10.5-Enterprise servers over from File Key Management to Hashicorp Vault key management. We have 13 'regions' each with 3 MDB servers ...
0 votes
1 answer
2k views

Help with Galera Cluster Auto_Increment

We're currently running a Galera cluster of 3 DB nodes. The way we're set up (due to ORM and automagical locking), we only have one of the 3 DB nodes being written to, and the other two provisioned ...
0 votes
1 answer
689 views

Galera cluster replication stalls when using wsrep_provider_options repl.commit_order=2

we are currently testing if moving from mariaDB master/slave replication to a 3-node-galera-cluster is an option for us. General replication in the cluster works fine like expected. Load test shows ...
0 votes
0 answers
61 views

How do I fix a permission denied error when starting a MariaDB Galera node

I'm trying to spin up a galera cluster based on the official MariaDB 11.2 docker image. My dockerfile is below. When I start the node, I'm getting a permission denied error that is preventing the ...
0 votes
2 answers
2k views

MySQL duplicate entry error opon import to new server

I do have a DB on MySQL Galera 5.6.34 with a table that contains an index on ID,date. The table is fully functional and I have used repair and check to verify the table. However, upon backup/restore ...
0 votes
1 answer
4k 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 ...
0 votes
0 answers
10 views

Excluding specific schema (or permit specific schema) in galera cluster 3 nodes master-master

I have 3 dedicated servers connected in a private LAN. Each one uses Plesk, a tool that (should) help people to manage domains and other server settings. It uses a scheme called psa for storing server ...
0 votes
0 answers
16 views

Does MariaDB-Galera cluster have error tolerance function on sst_user credential?

We have done the testing and confirmed the following system behavior of MariaDB-Galera clustering: The first-time bootstrap always needs to get everything correct, including the sst_user credentials ...
1 vote
1 answer
3k views

Connecting client application to MariaDB Galera cluster

I currently have a REST API written in Flask that connects to a MariaDB server. I'm thinking about replacing the server with a Galera cluster to improve availability and ensure continuity in case one ...
0 votes
2 answers
524 views

Steps to remove node from percona cluster

I have to update the os on a few servers and I need to remove a db from the cluster. wsrep_cluster_address='gcomm://192.168.2.59,192.168.2.60,192.168.2.61,192.168.2.62,192.168.2.63' Do I remove the ...
0 votes
2 answers
5k views

MariaDB Galera Cluster initial rsync replication failing

I'm trying to install a new galera cluster. The primary host started fine, but the secondaries are failing during the state transfer with rsync, and are not starting. I haven't been able to fix the ...
1 vote
1 answer
1k views

Innodb not started?

I installed MariaDB_Galera_server10.0 , but when i check the error log i see this: 170118 14:49:09 [Note] InnoDB: 128 rollback segment(s) are active. 170118 14:49:09 [Note] InnoDB: Waiting for purge ...
0 votes
1 answer
346 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 ...
3 votes
1 answer
9k views

what is the right way to restart a mariadb galera cluster?

I am trying to restart cluster. I have two problems in stopping cluster and starting cluster In stopping cluster, I follow the instruction https://software.mirantis.com/reference-documentation-on-...
0 votes
1 answer
471 views

Monitor existing cluster using Galera Manager throwing: deployment status error: DB IP address must be provided

I am trying to monitor my existing galera cluster using galera manager. I installed galera manager and chose Monitor existing cluster. I added the ssh keys provided in the manager in the respective ...
0 votes
2 answers
2k 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 ...
2 votes
2 answers
1k views

Mysql And Galera cluster mariaDB , Private and Public IP Addresses multisite

I am just wondering has anyone come accross this before and the best method to go about doing it. We have a customer that wants multi site replication over a galera cluster. I am familiar with setting ...
0 votes
1 answer
310 views

Problem with seconds_behind_master in mysql replication with galera cluster

I have the next infrastructure of mysql servers: Node1 - MySQL 5.1.X Node2 - MariaDB 10.3.X Node3 - MariaDB 10.3.X Node4 - MariaDB 10.3.X Node1 is a master replication node. Node2 is a slave ...
2 votes
1 answer
2k 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-...
5 votes
1 answer
2k views

Getting duplicate record errors like "Duplicate Entry for key 'PRIMARY', error code 1062" when importing a full backup into slave

We're restoring our slave with a full backup from our master, and getting a bunch of duplicate key errors. Once the slave gets caught up, it does not throw any errors (only when it is behind the ...
0 votes
0 answers
15 views

MariaDB could not add nodes to cluster

could someone know how to solve below issue ? i have allow all user to all member node all node can communication as well with port 3306 the issue as below : WSREP: GCache history reset: 39163b37-...
0 votes
0 answers
52 views

Replication between two galera clusters

I currently have two 3 node mariadb (10.5.9) Galera clusters set up in different locations, I'm using standard replication to copy data between the primary and secondary. What I've recently noticed is ...
2 votes
1 answer
646 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
1 answer
122 views

MariaDB Galera Cluster (10.6.12) and Laravel WSREP issue

I'm administrating a galera cluster with 3 nodes, serving a Laravel application and HAProxy is the gateway to the cluster. We had an interesting issue, and I'm unable to figure out why was there an ...
0 votes
1 answer
97 views

Galera Cluster Upgrade

I have 3 node Galera Cluster on Ubuntu 18.04. As part of Ubuntu LCM, I'm upgrading my Setup to 22.04 along with this Galera MariaDB cluster will also upgrade. I have designed below plan to upgrade my ...
0 votes
2 answers
419 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. ...
3 votes
2 answers
93 views

Different Percona XtraDB nodes use different indexes for the same query

We have three Percona XtraDB nodes arranged in a master-master replication topology. One of our databases contains a heavily utilized table. This table has multiple indexes, as well as a few foreign ...

1
2 3 4 5
7