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
0
votes
1 answer

Skip failing statement in galera multi-master: Duplicate Column, wsrep_local_state: 2

After a Schema-Change on which I have missed out to take care about replication, I now have one Server not synching anymore, as it tries to alter the table which already has been taken care of (Server 1&2 have the additional column and are fine,…
Chris
  • 123
  • 1
  • 4
0
votes
2 answers

Galera new cluster WSREP Unknown error 141

I am trying to create a new Galera cluster in the cloud using Ansible (DevOps tool). I can get the cluster started by issuing commands from an SSH shell, but not from Ansible. I have simplified the configuration to two nodes, but cannot get the…
Larry Singer
  • 3
  • 1
  • 4
0
votes
1 answer

Galera cluster implementation questions

I've just successfully created my first Galera cluster using MariaDB 10.0.20 between three servers. I have a few questions regarding my implementation: 1. what will happen if one server becomes isolated from the other servers but still has clients…
gijs007
  • 117
  • 1
  • 4
  • 18
0
votes
0 answers

Mariadb galera node error when joinning cluster

I am getting these errors when trying to join nodes to a master. Ubuntu 14.04 MariaDb Galera 5.5.42. I had this problem with rsync as well. No iptables rules blocking connections. Any help would be great with this. WSREP: Failed to prepare for…
Nvasion
  • 213
  • 1
  • 2
  • 6
0
votes
1 answer

MariaDB Galera Deployment

I am looking to experiment with MariaDB 10 Galera Cluster. I am looking for highly available, scalable and reliable architecture. Basically I am curious what would be the better architecture and would this be possible and is it a good practice? 1)…
user3526540
  • 1
  • 1
0
votes
1 answer

Fail to set up mariadb-galera cluster

I am trying to set up galera cluster in my VM cluster, however I can't seem to get the second node to connect to the first properly, this is my current…
Jeffrey04
  • 145
  • 1
  • 8
0
votes
0 answers

Direct server return loadbalancer for mariadb galera cluster with 2 networks

Is it possible to configure LVS (keepalived) loadbalancer with direct server return (DSR) for 2 leg network setup? The desired architecture is as follows: mariadb galera cluster, where each node has 4 NICs. The networks attached are C, B, R and M.…
faraway
  • 1
  • 3
0
votes
0 answers

High CPU load because high CPU time for sys

I am using MariaDB galera cluster with two nodes + one node for arbiter. My system has 24 core CPU. I am getting stuck with CPU bound. Sometimes, my system consume CPU time to 1000% and CPU load get above 16. mysqld process consume about 200-300%…
Luke Nguyen
  • 111
  • 2
  • 7
0
votes
2 answers

Debian autostart MariaDB Galera cluster

I have a MariaDB Galera cluster with two nodes. I have got it up and running fine, however the first node in the cluster needs to be started with: sudo service mysql start --wsrep-new-cluster I am using Debian 7 and MariaDB will auto start, however…
Mark Winterbottom
  • 101
  • 5
0
votes
0 answers

Mixing percona and mariadb in a galera cluster

Assuming both percona and mariadb runs the same engine (innoDB), can i use them interchangeably in a galera cluster? If it is possible, is there anything I should know before doing it?
Jeffrey04
  • 145
  • 1
  • 8
0
votes
2 answers

new Percona XtraDB nodes unable to join cluster

I have a four node Percona XtraDB cluster. Each night, one node shuts down for a backup and subsequently rejoins the cluster. This has run fine for quite some time now. Last night, the backup node refused to rejoin the cluster. The other three nodes…
ceejayoz
  • 32,910
  • 7
  • 82
  • 106
0
votes
1 answer

Galera SQL Cluster - reset & rejoin a node

i have a three node galera cluster. one of the nodes (its a passive not active used node) died and mysql is not able to start again on this host: InnoDB: We intentionally generate a memory trap. InnoDB: Submit a detailed bug report to…
Rick_Stinson
  • 1
  • 1
0
votes
0 answers

HAProxy inside Kubernetes proxying to MariaDB Galera Cluster VMs having intermittent connectivity if more than one pod

My project at work is having applications running on Kubernetes that connect to MariaDB Galera cluster running on VMs. To manage the connections to the MariaDB, I'm using HAProxy running as pods inside the Kubernetes. However, the HAProxy is set up…
Lukman
  • 186
  • 6
0
votes
1 answer

MariaDB Galera. Why is replication not working?

I tried a lot of manuals for configuring MariaDB Galera and in all cases replication does not work. I struggled with version 10.5 Today I tried version 10.3 and the only thing that appeared was wsrep_ready | ON At 10.5, this was not the case…
Maksim
  • 11
  • 3
0
votes
1 answer

Different bin log file index on maria db galera nodes

Setup: Galera Cluster with 3 nodes running in Docker Containers. In front of every node is a maxscale proxy. Remotely is a replication slave running with bin-log replication where the cluster is acting as the master (behind the maxscale proxy).…
Jonas Marty
  • 101
1 2 3
…
8 9