Galera Cluster for MySQL is a true Multimaster Cluster based on synchronous replication.
Questions tagged [galera]
123 questions
1
vote
1 answer
HAProxy don't balancing requests between nodes of Galera cluster
I stuck with the problem with balancing requests from app server to Galera cluster nodes.
The strukture of HA is
node1 10.62.10.35 (HAProxy + Keepalived) Master
node1 10.62.10.36 (HAProxy + Keepalived) Backup
node1 10.62.10.37 (HAProxy + Keepalived)…
![](../../users/profiles/421561.webp)
O. Berdeha
- 11
- 3
1
vote
2 answers
Galera Node won't start after recovery
I have a Galera "Cluster" with one working node. I added a second node and start the synchronization via rsync.
The State transfer succeeded but when starting the database it tells me that the innodb shall be currupt.
But as far as I understand…
![](../../users/profiles/158030.webp)
PascalTurbo
- 121
- 1
- 9
1
vote
0 answers
Ignore a node while backup is active (GLB)
I'm building a HA cluster with CentOS 6
I have n number of database nodes (using percona xtradb cluster), and when backup process starts, I change the "wsrep_desync" to ON, this way locks caused by the backup tool doesn't affect to the other nodes.…
![](../../users/profiles/391821.webp)
user109200
- 11
- 3
1
vote
1 answer
MariaDB Galera Cluster Node cannot start after going down
My Environtment :
Two Nodes - CentOS 6.4 x86_64
Node1 : 10.10.201.3
Node2 : 10.10.201.4
MariaDB-server-10.2.0-1.el6.x86_64
Both nodes are running normally, but after restarting mysql on Node1, it'll be failed to start again whilst mysql on Node2…
![](../../users/profiles/265046.webp)
user36814
- 21
- 1
- 1
- 4
1
vote
1 answer
MariaDB Galera replication under Vagrant
I'm provisioning a Galera MySQL cluster under Vagrant using a multi machine VagrantFile.
I don't believe the issue lies with Vagrant
Vagrant Version
VagrantFile
Vagrant.configure(2) do |config|
config.vm.box = "ubuntu/trusty64"
…
![](../../users/profiles/351802.webp)
georgealton
- 136
- 6
1
vote
1 answer
Unable to connect to mysql DB through my HA Proxy Servers [Keepalived is used for Virtual IP-VIP]
I have my HAProxy running on VIP:192.168.61.32, also I've checked netstat -tulnp|grep 3306
tcp 0 0 192.168.61.32:3306 0.0.0.0:* LISTEN 7895/haproxy
But when I run
mysql -h 192.168.61.32 -u root -p:
ERROR 2013 (HY000): Lost…
![](../../users/profiles/351755.webp)
karthik v
- 191
- 2
- 9
1
vote
2 answers
WSREP: Bad value for 'socket.ssl_key'
I am attempting to initialize a new MariaDB Galera cluster with SSL-encrypted replication.
I have followed this guide to the letter, specified different details for CA, Server, and Client certificates (I read there can be issues when they are…
![](../../users/profiles/7559.webp)
Andrew Ensley
- 912
- 2
- 16
- 30
1
vote
1 answer
unable to run a mariadb 10.1 galera cluster
I have installed mariadb 10.1 via the instructions here:
https://mariadb.com/kb/en/mariadb/yum/#installing-mariadb-galera-cluster-with-yum
but when I run the server with :
sudo service mysql start --wsrep-new-cluster
the server is not run as a…
![](../../users/profiles/121395.webp)
simonC
- 195
- 2
- 12
1
vote
1 answer
Scaling Mariadb Galera Cluster
I have installed MariaDB Galera Cluster on ubuntu 14 and it is working fine.
See the tutorial
I have 3 nodes (each 500GB HDD capacity) mariadb cluster and all replications are working perfect.
My questions are :
When I run out of disk space after…
![](../../users/profiles/325916.webp)
Supun Silva
- 111
- 1
1
vote
1 answer
How to backup galera cluster through garbd? SST failes
We are runnning a MySQL Galera cluster (5.6) on 3 nodes.
In order to backup the cluster I am trying to follow this example: http://galeracluster.com/documentation-webpages/backingupthecluster.html
The command I am using:
node1:~$ sudo…
![](../../users/profiles/84332.webp)
merlin
- 2,033
- 11
- 37
- 72
1
vote
1 answer
How to enable slow query log in MySQL Galera?
I want to enable slow query logging in MySQL Galera.
In order to do so, I have enabled it through my.cnf:
log_slow_queries = /var/log/mysql/mysql-slow.log
long_query_time = 1
log-queries-not-using-indexes
Then, I tried to restart one…
![](../../users/profiles/84332.webp)
merlin
- 2,033
- 11
- 37
- 72
1
vote
2 answers
Galera bootstrap fails without errors
I've been pulling my hair out all weekend trying to get a Galera cluster up and running, using MariaDB 10.1.5 (which includes Galera 25.3.9) on CentOS 7. This server runs two database instances, one only local, one as part of a cluster.
I've done…
![](../../users/profiles/302793.webp)
WanWizard
- 111
- 1
- 6
1
vote
0 answers
how to do automatic failover of mysql / galera cluster
I have two mysql/galera clusters of three nodes each (two + garb node).
The clusters are in separate DC's (dc1 and dc2)
The cross cluster replication happens between
node1-dc1 and node1-dc2
I want to know how to automatically fail-over in case…
![](../../users/profiles/276000.webp)
John Test
- 89
- 1
- 3
- 14
1
vote
1 answer
MariaDB Galera Cluster, Force Sync
I have three servers in a multi-master Galera cluster. I've imported some old databases recently, and noticed that the tables were being created across all three, but the data wasn't being replicated. It turns out I wasn't paying attention, and…
![](../../users/profiles/180568.webp)
Nick Coons
- 345
- 4
- 16
1
vote
1 answer
MariaDB Galera SST Fails
I am running a 3 node MariaDB 10 Galera Cluster on CentOS 6. I have use this set-up before without issue else where but now when adding a 3rd node the SST fails with this error in the logs:
150212 18:03:02 [Warning] WSREP: 1.0 (server1.example.com):…
![](../../users/profiles/206224.webp)
kemra102
- 211
- 4
- 12