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

Galera Kubernetes E2E - How to set password in YAML?

Is there a way to set a Galera root password with this script? https://github.com/kubernetes/kubernetes/tree/master/test/e2e/testing-manifests/statefulset/mysql-galera Everything works great but I can't figure out how to set password. Thank…
Chris
  • 336
  • 4
  • 15
1
vote
0 answers

Getting a lot of Mariadb log-error message with WSREP: cleanup transaction for LOCAL_STATE

I have setup Mariadb Galera cluster with 3 Node and recently after checking the mysql error-log file I got surprised to see (string like below) is repeating. I am confused why it is repeating so many time the same [Note] and should I be concern for…
user3205995
  • 31
  • 2
1
vote
2 answers

Designing XtraDB cluster

We have an application which consists of microservices all connected to the same Percona DB instance. Currently it is just one instance with 16 cores/32 GB memory without replication. One of our issues is that sometimes one of our microservices…
Vojtěch
  • 11,312
  • 31
  • 103
  • 173
1
vote
0 answers

Kubernetes Galera: WSREP: failed to open gcomm backend connection: 110:

I am trying to setup a Kubernetes Galera 3 Replica set. I am using: https://github.com/kubernetes/kubernetes/tree/master/test/e2e/testing-manifests/statefulset/mysql-galera The first pod spins up fine, but the second pod gets stuck: 1 [ERROR] WSREP:…
Chris
  • 336
  • 4
  • 15
1
vote
1 answer

Galera Cluster for Multi Master: Second node failed to start in Ubuntu 16.04.4 x64

I am trying to test master-master replication between two server by referring to this tutorial: Configure a galera cluster The first node was started normally after executing galera_new_cluster & get wsrep_cluster_size = 1, but when executed…
yyii
  • 143
  • 2
  • 12
1
vote
0 answers

MariaDB Galera Cluster with Docker containers - nodes do not join init cluster

I want to establish a Galera Cluster with three nodes, all on different hosts. The first one starts normally and the cluster is ready, but only native installations of MariaDB can join it, Docker containers don't. It is strange that native nodes can…
ganzvielstudent
  • 11
  • 2
1
vote
1 answer

MariaDB Galera Cluster : Second node not coming up

Installing MariaDB Galera cluster 10.0.35 on two nodes on RHEL 7.5. I am able to bring up first node successfully.However getting below error when bringing the second node : 180524 23:45:27 [Warning] WSREP: Gap in state sequence. Need state…
Vijaykumar S Mathad
  • 31
  • 1
  • 7
1
vote
0 answers

mariadb, add 4th galera node failed

I have three node setup and running perfectly for the past months. Recently I want to add another node in a different location but somehow I keep on getting errors. At first, I was just following this tutorial (where I setup the first time few…
Dora
  • 6,776
  • 14
  • 51
  • 99
1
vote
2 answers

MariaDB galera cluster 10.2 second node "Failed to open channel"

I'm trying to run mariadb:10.2.14 as a galera cluster on my windows computer locally using docker compose. Running the initial boot node works fine, but the second node fails to join the cluster with an error: node_1 | 2018-05-04 3:13:46…
Amos Yuen
  • 1,420
  • 1
  • 9
  • 19
1
vote
1 answer

Mariadb galera cluster and cap theorem

Where does mariadb galera cluster lies according to cap theorem CP or AP based on a brief explanation how it works.
pvjhs
  • 549
  • 1
  • 9
  • 24
1
vote
0 answers

Restarting Galera cluster after maintence on 2 of 3 nodes

I'm running a Galera Cluster using 3 nodes. I shutdown 2 of the 3 nodes to service the appliance. After restarting the 2 servers, I get errors: "Failed to open backend connection: -110 (Connection timed out) "Failed to open channel 'galera_cluster'…
Robert Daniels
  • 161
  • 10
1
vote
0 answers

Setting up Galera nodes with different server credentials

Is it possible to have Galera nodes with a different username, password, and port?
user7562197
1
vote
0 answers

docker swarm uses ingress as the default IP other than the default overlay network

When I use docker deploy a docker-compose.yml with all my stack. It creates a default overlay network. ac4ole1w87ws ingress overlay swarm vcl2s9otd2qx stack_default overlay swarm The…
Robert Chen
  • 19
  • 4
1
vote
1 answer

Galera cluster nodes do not trigger wsrep_notify_cmd and wsrep_sst_method

I did setup the Galera cluster with 3 nodes using 3 docker containers. There is a requirement that when data is synchronized from the donor node to the other nodes, based on the wsrep_notify_cmd trigger or wsrep_sst_method trigger at the…
tilonthuduc
  • 45
  • 9
1
vote
0 answers

Galera cluster randomly hangs

Hello I have a Galera cluster for MySQL 5.6.36 that apparently works fine. I have a microservice with a REST API running in Docker that is connected via JPA + Hibernate to this database. Randomly, the service takes about 15 min to produce the…
Alessandro Dionisi
  • 2,494
  • 4
  • 33
  • 37
1 2 3
…
27 28