Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [galera]

Galera Cluster for MySQL is a true Multimaster Cluster based on synchronous replication.

124 questions
1
vote
0 answers

Moving entire database server to Galera cluster

We currently have more or less the following setup: Three individual MySQL database servers (individual Linux machines) with 15 to 50 logical databases and 20 to 50 GB of data Galera cluster (MariaDB) with 3 nodes and ~5 logical databases and…
r2_
  • 11
  • 2
1
vote
1 answer

MariaDB Galera cluster slow SST sync

I have a MariaDB Galera cluster with 3 nodes and I configured the SST transfer as wsrep_sst_method = rsync When I have to stop and restart a single node, the synchronization is very slow even if the node remained stopped only for 1 hour: it takes…
Mat
  • 1,873
  • 7
  • 25
  • 41
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)…
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…
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.…
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…
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" …
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…
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…
Andrew Ensley
  • 932
  • 2
  • 17
  • 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…
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…
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…
merlin
  • 2,093
  • 11
  • 39
  • 78
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…
merlin
  • 2,093
  • 11
  • 39
  • 78
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…
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…
John Test
  • 89
  • 1
  • 3
  • 14
1 2
3
…
8 9