Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [galera]

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

0
votes
0answers
11 views

Failed to read uuid:seqno and wsrep_gtid_domain_id from joiner script?

I have a Galera Cluster in production which hosts 3 nodes. Nodes are Debian 9.5. I did some stupid stuff and edited my.cnf and corrupted some stuff. I reverted it back after long hours of fighting. 2 ...
1
vote
1answer
65 views

How likely is a Split Brain situation when dealing with Galera clusters?

Assuming I have a server setup where a quorum vote is always satisfied, how likely will a Split Brain situation occur with Galera? My understanding is Galera does its best to avoid it, but does that ...
0
votes
1answer
15 views

MariaDB 10.3.10 Galera Cluster not syncing InnoDB table definition

I have a 3 node multimaster MariaDB Galera Cluster that is not syncing a modification to an InnoDB table definition. Server version: 10.3.10-MariaDB MariaDB Server wsrep_provider_version: 25.3....
2
votes
0answers
33 views

configure pacemaker for galera

I have a galera / mariaDB cluster of two nodes on two remote sites that works perfectly. I want to set up a solution that would pause one of the two servers / node if the ping to an external IP was ...
0
votes
1answer
52 views

How to recover Galera cluster node

I'm running a three node, multi-master Galera cluster under MariaDB. One of the nodes has crashed due to a hardware fault (node3) and for whatever reason this crashed one of the healthy nodes too (...
0
votes
0answers
43 views

Multi-master PowerDNS setup

I'm trying to set up multiple PowerDNS hosts (masters), that will write to a Galera MariaDB backend. I provisioned a HAProxy loadbalancer in front of the Galera cluster nodes and all the PowerDNS ...
1
vote
0answers
156 views

Converting Mariadb Galera Cluster into Simple Master Slave Replication Cluster

Now we have this project to convert our Mariadb Galera Cluster (3 nodes) to Simple Master Slave cluster (One master and two slaves). So our goal to get rid of Galera and make our setup just async / ...
0
votes
0answers
33 views

Recovering MariaDB with broken permissions

I am trying to build a MariaDB Galera cluster. But sometimes when I restart a node, it does seem to start fine, but it does not accept any connections. All attempts end with ERROR 1045 (28000): Access ...
0
votes
0answers
20 views

select query fails in a single node in a 3 nodes galera

I have a MariaDB Galera with 3 nodes. If I run a select query, with 25,000 rows, in the Node A or Node B, everything goes perfect, but if the same query runs on Node C, this node goes to 110% CPU, ...
0
votes
0answers
415 views

Does a Galera equivalent for Postgres exist?

I've been working with Galera for a number of months and like the failover along with the redundancy. I've got a Postgres DB that is in testing and will probably move to production. Is there a Galera ...
0
votes
3answers
132 views

mysql (Perconadb) Galera/Xtrabackup cluster join fails with “Invalid Argument”

I have a MySQL Galera cluster, using Perconadb and Xtrabackup. The nodes can start stand-alone, or can join the cluster if only an IST is required. However, if an SST is required, then this runs to ...
0
votes
0answers
23 views

start service after GLB (Galera Load Balancer) has started

On CentOS 7, the goal is to start a service after the glb service has started. The problem is that glb.service not a native service when I run systemctl enable glb glb.service is not a native ...
-1
votes
1answer
28 views

PHP can't connect to 127.0.0.1 or localhost to galera but can iva mysql cmd

I am having an issue with MySQL where I can't connect via localhost or 127.0.0.1, I get "Access denied ". On the same box if I use mysql -p -h localhost -u mysuser -p'mypassword' or mysql -p -h 127....
0
votes
0answers
81 views

MariaDB Galera Cluster ECDSA certificate and cipher

I have created a working MariaDB Galera Cluster and would like to secure it with SSL encryption. I have an ECDSA certificate (ecdsa-with-SHA512) and have setup SSL between the Nodes, but I get the ...
0
votes
0answers
26 views

Galera: What happens after simultaneous downtime

I've got a MariaDB Galera cluster with three nodes in a data center. There is currently only one node that handles the incoming requests (queries). The other nodes are just there for replication and ...
0
votes
0answers
39 views

How change Galera Cluster port 3306 to avoid conflict between stunnel and SSL

My web app is in another server and I connect to mysql db through stunnel port 3306. Can I change the Galera Cluster regular port from port 3306 to another port? I need this port from web app be ...
0
votes
1answer
225 views

Galera or master/slave MariaDB

What would be the recommended choice for database replication with failover? I know this is a broad question but I'm curious what the general experiences are when it comes to real life setups. As far ...
0
votes
0answers
65 views

Percona XtraDb cluster auto increment

Help me please clarify a very important question on which I can't find the answer. It only can be proven with tests. Let's say we have XtraDB Cluster (or Galera Cluster) with three nodes. We have ...
1
vote
0answers
517 views

Mariadb 10.1 - 1 of 3 nodes will not restart

Here is the scenario, had to make a config change to Mariadb in a 3 node cluster. I edited the config file, and shut down the node with: # service mysqld stop Made the change on the other 2 nodes ...
1
vote
0answers
125 views

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)...
1
vote
1answer
886 views

Why is keepalived running two MASTER nodes in my Sticky VIP configuration?

I have keepalived setup (floating VIP) in front of haproxy on each of my three-node galera cluster nodes. When I restart keepalived on any given node, sometimes I end up with two nodes running in ...
0
votes
1answer
451 views

Mariadb tuning - slow writes

Background: I have a a website I am migrating from a stand alone MariaDB server to a MariaDB galera cluster. Part of this had me convert the tables from a large number of MyISAM to InnoDB. For what it ...
0
votes
1answer
488 views

MariaDB Galera cluster - 3rd node can not start/connect

I am in the process of trying to set up a MariaDB galera cluster. The first 2 nodes went fine, have them started, connected. On the third node, it won't start/connect. # service mysql start ...
1
vote
2answers
2k views

How to “safely” shutdown/restart a Galera cluster?

First time setting up Galera (Ubuntu 14.04) and I'm unable to restart the cluster after rebooting my nodes. I'm following the this guide and it doesn't exactly mention how to handle a shutdown or ...
1
vote
1answer
677 views

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

Galera cluster donor node changed

I just started node1 as donor with ‘/etc/init.d/mysql start --wsrep-new-cluster’. Then started second node. and check "show status like 'wsrep%'" in mysql. but the second’s wsrep_local_index became 0 ...
0
votes
1answer
64 views

MariaDB Galera stop working without network connectivity

I am running MariaDB Galera cluster whose using mariaDB and 3 nodes(node A, node B, node C). My nodes are placed locally in our office. My problem is if node A/B/C lost network connection, it also ...
0
votes
1answer
162 views

Different InnoDB data file sizes on Galera

We have a cluster of 3 Galera-MariaDB boxes, using InnoDB as an engine. Cluster's in sync, and reporting all good as far as I can see. Much to my surprise, the size of the InnoDB data files differ ...
0
votes
1answer
367 views

Initial Xtradb Cluster setup — each node comes up isolated

I'm setting up a percona-xtradb-cluster-57 (3 nodes) on Ubuntu 16.04. They are to communicate using a private network, 10.254.10.101 through 10.254.10.103. When I follow the instructions on Percona'...
0
votes
2answers
201 views

how mariadb galera can help me scale writes?

if I have 1 server that's getting 30 writes per seconds and then I am moving to 3 galera nodes so now each server is getting 10 writes per seconds but due to how galera works every server in the ...
3
votes
1answer
2k views

Transform Galera cluster into single node mariadb server

We want to get rid of all cluster features on our galera cluster (currently consisting of three virtual machines). The connection between the nodes is not stable enough so the cluster is much slower ...
0
votes
1answer
609 views

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 + ...
0
votes
1answer
223 views

LXD + Galera Cluster + Max Scale : Shutting down server != Stopping containers

I have a galera cluster with 4 nodes. 2 in one server (server-master) and 2 in another server (server-slave). The clusters are controlled through "Max Scale". All the setup seems correct as ...
0
votes
1answer
202 views

setting up MariaDB Galera cluster Ubuntu Zesty

I can't figure out how to initialize a MariaDB Galera cluster on Ubuntu Zesty. I've followed the documentation, but something seems to be missing. I cannot get the first node to come up. I ...
0
votes
1answer
457 views

Do slow nodes bottleneck a Galera Cluster?

Let's say I have a 5 node cluster, with 3 SSD RAID 10 nodes and a 2 SSD RAID 1 nodes. Will the RAID 1 nodes slow down the entire network? How do the Galera cluster writes work? Does it have to wait ...
0
votes
1answer
876 views

2-host MariaDB Galera cluster with keepalived only, no HAproxy?

We're about to replace a legacy MySQL database using master-slave replication (only 2 hosts total - one master, one slave) with a MariaDB Galera master-master replication cluster to ensure more hassle-...
1
vote
2answers
633 views

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 ...
0
votes
0answers
62 views

Monitoring UUIDs of MariaDB servers in Galera cluster

I want to be able to monitor the UUIDS of several MariaDB servers on a regular basis to make sure that they haven't somehow been removed from the cluster. I have a command that I run to retrieve it ...
1
vote
0answers
45 views

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 ...
2
votes
0answers
457 views

High CPU usage on MariaDB Galera nodes

I have setup 3 cluster mariaDB using Galera for my web services which load balanced with haproxy. The cluster are working great and sync each other but when visitor on my website reach more than 3000 ...
2
votes
1answer
8k views

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'...
1
vote
1answer
1k views

Galera cluster - cannot start MariaDB (CentOS7)

I'm trying to install a Galera cluster with 3 mariadb VM's (all of them CentOS 7). I've never done this before, so I was following this guide: http://tunnelix.com/mariadb-galera-cluster-installation/ ...
1
vote
1answer
205 views

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

Cant add more servers to Galera Cluster --> [ERROR] /usr/sbin/mysqld: unknown option '--.'

Ive tried to setup a MariaDB cluster with Galera on my Debian 8 server. When I try to add servers to the one that already exist in the cluster with: systemctl start mysql I get this error: ...
0
votes
1answer
592 views

mariadb galera cluster don't intialize on debian wheezy

I meet some troubles with initiliazing a Galera cluster, the start of 2nd node always failed, without error message in log. I have two nodes for the moment, i will install the third later. Here are ...
1
vote
1answer
1k views

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....
0
votes
0answers
328 views

MariaDB galera, issue with node2 and node3

i have issue with MariaDB galera cluster. i have setup node1 and cluster is up. but when i try to add node2 to the cluster it fails, the log file on node1 shows: 2016-09-14 18:04:55 140684796253952 [...
1
vote
0answers
325 views

Configuring a corosync as a witness server

Is it possible to add a witness node to a corosync cluster The cluster is running a 3 node setup: 2 applications server running MariaDB with Galera cluster. 1 "witness" server running Galera ...
0
votes
1answer
3k views

Couldn't join MariaDB Galera Cluster node back to cluster after software update. wsrep_* options in my.cnf seem to be ignored

I've had run a Galera Cluster for a while, MariaDB version 10.0.20, Galera version 25.3.10, everything over Gentoo. That cluster worked fine, nodes restarted several times for maintenance and so on. ...
1
vote
1answer
559 views

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 ...