The tag has no usage guidance.

learn more… | top users | synonyms

0
votes
1answer
13 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 ...
0
votes
0answers
5 views

Galera Rsync SST Secured via SSL/SSH

Is it possible to secure Galera Cluster SST via rsync with SSL/SSH? This page suggests it is not, specifically the following quote: Unlike rsync, xtrabackup includes support for SSL encryption ...
4
votes
1answer
65 views

Galera cluster (MariaDB) on Docker/CoreOS: second node doesn't work on first attempt

I'm trying to create an automatic deployment of Galera Cluster with MariaDB, running inside Docker containers on CoreOS. Software used: - MariaDB official Docker image, version 10.1.10 - CoreOS ...
-2
votes
0answers
33 views

MariaDB Galera Cluster during service window

We have a working 3-nodes mariadb galera cluster behind haproxy. It's been a while since those where patched. I'm afraid I'll break the cluster when applying patches. My thoughts about it is to bring ...
0
votes
1answer
16 views

MariaDB galera cluster fail when dumping or optimizing database

It seems that a Galera cluster deadlocks every time when I run a mysqldump or table optimize. I've ran a "mysqlcheck" and a "mysqldump" on my MariaDB 10.1 database server several times. (which runs ...
0
votes
0answers
38 views

8 minute timeout delay in starting MariaDB with galera turned on

I'm just trying to get one node up for testing, and at first I thought it wasn't working at all, until I left the terminal running for a bit. See the 8 min timeout in the middle of the logs? ...
0
votes
1answer
34 views

Secure galera cluster MariaDB

I'm using a Galera cluster between a few web servers over the WAN. I have the traffic encrypted with ipsec between the servers, but it just struck me that anyone can connect to my Galera cluster and ...
0
votes
0answers
4 views

MySQL Galera not returning MySQL error in some cases

I am running MySQL Galera 5.6.27 on a 3 node cluster since about a few weeks now in production. Since going live I found that once in a while I do get MySQL errors that previously did not ocure and ...
0
votes
1answer
213 views

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 ...
1
vote
0answers
19 views

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

Galera Cluster: system requirements for an Arbitrator?

I'm planning the deployment of a Drupal website running on Linux (CentOS 7) and Nginx in IaaS. I will be using two nodes for HA, and each will offer the exact same services (Nginx, PHP, Redis, ...
-1
votes
1answer
31 views

Best practice connecting to a galera cluster?

If I have 7 servers, with 7 IPs, what is the best way to connect to them? I have thought of: 1.) Pointing all my queries through one IP 2.) Using rand() to randomly select an IP and connect to it, ...
0
votes
0answers
71 views

How to share local IP within a cluster if server is bound to one IP?

I have a cluster with 3 nodes running in VMs on test setup. Now I want to take it to production and rented 3 dedicated root servers at Hetzner Online connected by a switch. As I found out, they do ...
2
votes
2answers
173 views

Why does MySQL Galera not replicate the user table?

I am running a 3 node MySQL 5.6 Galera Cluster. Everything is in sync and looks fine, but as I just found out the user table was not in sync. One particular user was not present on the other nodes ...
0
votes
0answers
66 views

Why does XtraBackup tell me my MySQL database is corrupt?

I am trying to backup data on a MySQL Galera node with XtraBackup. Unfortunatelly the tool tells me, that ibdata1 is corrupt. After double checking I indeed found some myisam tables I have importet by ...
0
votes
0answers
158 views

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

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

How to migrate MySQL Master/Master replication to MySQL Galera Cluster?

Currently our setup consists of two MySQL 5.6 servers on seperate Ubuntu 14.04 bare mettal machines. I am looking into migrating the system to a MySQL Galera Cluster on 3 nodes. Can I "patch" the ...
0
votes
0answers
83 views

MySQL Galera cluster nodes going out of sync

Please see http://pastebin.com/89u4jfzc However, on both nodes: mysql> SHOW STATUS LIKE 'wsrep_local_state_comment'; +---------------------------+--------+ | Variable_name | Value | ...
0
votes
1answer
112 views

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
vote
2answers
437 views

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

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

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 ...
3
votes
2answers
2k views

MariaDB Galera Cluster falls out of sync easily

We're trying to debug an issue with a MariaDB cluster. We're running Maria 10.0.19 on c4.large instances in Amazon EC2; the OS is Ubuntu 14.04 (Trusty). There are three machines clustered together, ...
2
votes
2answers
285 views

What would be a stable, failproof, scalable galera cluster implementation

Context: We are using a MariaDB Gallera cluster with (only) 2 master nodes for a web application. Last night we had a power failure and now we can't seem to recover the data and found out the database ...
0
votes
1answer
38 views

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

mysql galera 2-way cross-cluster replication

Scenario and setup Two mysql galera clusters in two datacenters with 2-way multi-master replication Each cluster has 3 nodes: 2 full nodes and 1 garbd node Example host names: dc1-sql1 --> ...
0
votes
1answer
254 views

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

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

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

How to monitor MariaDB Galera cluster status from command line

I know to check the Galera cluster status, the command that should be used after login to the mysql client is: SHOW STATUS LIKE 'wsrep%'; but, how to get the output directly from the command line? ...
0
votes
0answers
118 views

Lot's of dealocks since migrating to galera cluster

I recently migrated from a 1 node MySQL server, to a 2 nodes mariadb Galera cluster. (I know, 2 nodes is not recommended). At first, I enabled writes to both of the nodes, but realized it increased ...
0
votes
1answer
600 views

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 ...
3
votes
1answer
142 views

Galera: Run slow ALTER without locking entire server

I have a 3-node galera cluster with a few hundred databases servicing various clients. I'm only using galera as an easy way to handle replication and fallover. I'm not actually using multiple masters ...
0
votes
1answer
272 views

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 configuration [mysqld] ...
0
votes
0answers
155 views

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

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

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 ...
2
votes
1answer
761 views

Installing MariaDB + Galera via yum fails with “No package MariaDB-Galera-server available”

I'm spun up a brand new Cento OS 7 virtual machine and I'm following this tutorial to install a MariaDB + Galera cluster. I've added the MariaDB repos as follows: vi /etc/yum.repos.d/MariaDB.repo ...
-1
votes
1answer
106 views

Setup Galera Cluster with two servers

Can I Create Gallera Cluster with two servers ?? Actually I have 6 servers: 2 Server for Load Balancer 2 Server for Apache Or anyone here can suggest me how to create High Availability Web Server ...
0
votes
0answers
62 views

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

HAProxy's Flooding MySQL Connections

I have a setup of 2 HAProxy servers using the KeepAlived process for failover, and each HAProxy is configured to load balance mysql connections to my MariaDB Galera cluster of 3 nodes. I'm trying to ...
2
votes
1answer
1k views

MariaDB, Galera, xtrabackup - do I need the binary log?

We are using a MariaDB Galera Cluster with 3 nodes. For the state transfer we are using xtrabackup. We have some problems with the binary logs - they got too big and crashed the server. We can ...
1
vote
1answer
712 views

Configuring resources for Galera and Corosync/Pacemaker

I can't seem to find a proper way of setting up resources in pacemaker to manager my Galera cluster. I want a VIP that will failover betwen 5 boxes ( this works ), but I would also like to tie this ...
1
vote
1answer
655 views

Error when i install mysql + galera

I want install mysql server + galera in my vps Centos 6.5. When I install yum update -y && yum install wget libevent perl mysql-y wget ...
1
vote
2answers
694 views

Query cache for MariaDB Galera cluster

I've read from multiple sources now that you can't have query caches with Galera, but my current application could really benefit from a query cache. I'm load-balancing this cluster with HAProxy and ...
2
votes
1answer
849 views

MariaDB how to handle 2/3 node failure in multi master cluster.

I run 3 node multi master MariaDB galera cluster. It basically works for me how it is. When one node fails, two other work and it's fine. But I'm wondering is there a way for it to keep working on ...
1
vote
0answers
344 views

Bootstrapping Galera Cluster

We would like to use a MariaDB Galera cluster for our project. The Galera cluster works and seems to work fine. If some nodes of cluster are down the cluster continues to work. But after a complete ...
-2
votes
1answer
110 views

Does Galera Arbitrator require a SST?

Does Galera Arbitrator require a SST? It says it's stateless but it's not clear if a SST i required. The reason for asking is that I'm having a large database and would like to skip the SST if ...
2
votes
1answer
2k views

Deadlock trigger on MariaDB Galera cluster

I can trigger a deadlock on our (test) Galera cluster when updating a row with the same data. INSERT INTO test (id, val) VALUES (1, 42), (2, 47); -- Query OK, 2 rows affected (0.01 sec) -- Records: 2 ...