Stack Overflow
Stack Overflow

Questions tagged [galera]

Galera Cluster is a synchronous multi-master cluster for MySQL.

From the project home page, Galera Cluster's features include:

  • Synchronous replication
  • Active-active multi-master topology
  • Read and write to any cluster node
  • Automatic membership control, failed nodes drop from the cluster
  • Automatic node joining
  • True parallel replication, on row level
  • Direct client connections, native MySQL look & feel


410 questions
1
vote
1 answer

MariaDB Galera Cluster php driver

I want to setup a master-slave MariaDB Galera cluster like this: I have 3 machines with LAMP and in front of them a load balancer. Every machine have the same front-end to process php requests from users. Every php request will either write or read…
Victor Laurentiu
  • 145
  • 1
  • 2
  • 9
1
vote
1 answer

Can't get haproxy to load balanace Galera Cluster nodes

I recently installed Galera Cluster on two Red Hat 7 servers and have it configured correctly. However I can't get HAProxy to work. I'm just getting errors. Node 1 has an IP of 1.1.1.1 and all traffic is open. SELinux has mysql set to…
user3299633
  • 2,971
  • 3
  • 24
  • 38
1
vote
0 answers

Galera mysql check for HAProxy

I am using Galera cluster with 3 nodes. I am using HAProxy as a load-balancer. I currently using a mysql check script that is written for Percona cluster and after some deadlock problems I suspect that the script may be the issue. I've modified the…
SapManTM
  • 126
  • 1
  • 10
1
vote
2 answers

Connect Django 1.11 to Mariadb Galera cluster

I am using Django 1.11 with MariaDB 10.1 Galera cluster I didn`t find in the documentation how to connect to a cluster. I tried using gcomm://NODE1,NODE2 url with no success... any idea?
Oz Bar-Shalom
  • 1,747
  • 1
  • 18
  • 33
1
vote
1 answer

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 cluster, it sets it's inital position to…
Jonathan
  • 10,792
  • 5
  • 65
  • 85
1
vote
1 answer

Add Persistant column with different Collate

I have a MariaDB Galera cluster with 3 nodes The database is created with latin1_swedish_ci and i want to add a new column with this command ALTER TABLE pakkeshop.leveringer ADD reverse_stregkode VARCHAR(45) COLLATE latin1_danish_ci GENERATED ALWAYS…
Windkin
  • 63
  • 1
  • 4
1
vote
1 answer

Inconsistency in Tables - Galera Cluster

MariaDB cluster Version : mysql Ver 15.1 Distrib 10.0.24-MariaDB, I have a two node + arbitrator cluster which is live and replicating data across nodes. Unfortunately we found some inconsistency in some of the tables in Databases. For…
Rameez
  • 564
  • 5
  • 11
1
vote
0 answers

Galera: replication with SSL

I am setting up a Galera MariaDB cluster. Everything works as expected, unless I turn on SSL. I have 3 nodes, all of them share the same private key and certificate (because I use load balancing as well). But when I fire up master node with SSL…
Misko
  • 1,542
  • 2
  • 19
  • 31
1
vote
0 answers

Galera cluster into Google cloud platform

We have a galera cluster with 3 nodes, on 3 different physical machines but all located in the same datacenter. From what I understood, the reason they deployed this in the past was to increase availability and reliability. Each node is installed on…
Vincent Teyssier
  • 2,146
  • 5
  • 25
  • 62
1
vote
1 answer

Alarmingly low performance with galera cluster

My aim is to utilise sufficient cpu resources of both the nodes in my galera cluster so that my end to end stack can support more TPS. Right now, my full stack is constrained by a single mariadb server of 36vcpu and it can go to 10000 TPS. I want to…
LakshayK
  • 162
  • 2
  • 8
1
vote
2 answers

How to debug "WSREP: SST failed: 1 (Operation not permitted)" with a MariaDB Galera cluster in Docker?

Requirement: CentOS-based Docker container providing a MariaDB 10.x Galera cluster Host Environment: OX X El Capitan 10.11.6, Docker 1.12.5 (14777) Docker Container OS: CentOS Linux release 7.3.1611 (Core) DB: 10.1.20-MariaDB I found a promising…
StaticNoiseLog
  • 1,370
  • 17
  • 27
1
vote
5 answers

Percona Xtradb - unable to start nodes after long downtime

We have a Percona Xtradb-v2 cluster set up with 3 nodes. Everything was working and in synchronisation when we shut down nodes 2 and 3, leaving only node 1. The nodes stayed down for a week, during which time the database grew by 100GB in…
Steve Shipway
  • 3,754
  • 3
  • 22
  • 39
1
vote
1 answer

Partition rotating in MariaDB with Galera cluster

How manage partition rotating in real time on Galera Cluster? I am catch from time to time metadata lock while dropping or adding partitions on a table. I have 3 nodes in a cluster and all application connections going to first node through load…
mgavrylov
  • 11
  • 3
1
vote
3 answers

Bootstrapping Galera on RHEL7.2 systemctl: unrecognized option '--wsrep-new-cluster'

I am trying to set up Galera cluster via Puppet and I have an additional (probably misguided) requirement to use "Red Hat supported" RPMs. The problem I have due to this requirement is that bootstrap command: systemctl start mysqld…
Red Cricket
  • 9,762
  • 21
  • 81
  • 166
1
vote
1 answer

How to speed up mariaDB query using multiple db server, using Galera Cluster and MaxScale?

I test with stress test tool (to run many concurrent user and many query). There is no speed added when i use more db server (i use 5 servers). I have check on each server, and i see the queries have been distributed on each server. What should i…
tesmojones
  • 2,496
  • 2
  • 21
  • 40
1 2 3
…
27 28