The tag has no usage guidance.

learn more… | top users | synonyms

0
votes
0answers
15 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
4 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 ...
0
votes
1answer
19 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
16 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
22 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
24 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
1answer
39 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
123 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
62 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 ...
2
votes
1answer
269 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
147 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
25 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
21 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
0answers
33 views

Limit Rsync bandwidth usage within Galera Replication

I would like to know, how can I limit the bandwidth usage of rsync within my MariaDB Galera Replication to avoid network choking. P.S. I can't find the rsyncd.conf in my Ubuntu 14.04. Is there any ...
0
votes
1answer
78 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
149 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
85 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
477 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
72 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
385 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
87 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
183 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
114 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
218 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
105 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 ...
1
vote
0answers
515 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 ...
0
votes
0answers
120 views

Running MariaDB Galera (5.5) Cluster on Debian failing to start

I am struggling to get a MariaDB Galera cluster running on my Debian 7 machine. I am trying to setup a cluster with two nodes both running on Debian 7. When I first install Galera I can run it find. ...
0
votes
0answers
108 views

What is causing PHP-FPM's connections to our galera cluster to be limited?

On our current live site, we have had a flood of page requests from a single IP over a ~60 second window, which caused PHP to start failing to connect to the database. Our error logs have a lot of ...
0
votes
0answers
110 views

WSREP galera cluster warning conflict state 7

I have started to use a pxc cluster, after a flow control deadlock I had to kill all but one instance. And now on this single instance I have the below warnings streaming in the log all the time: ...
-1
votes
1answer
81 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
60 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
120 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
808 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
532 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
562 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
502 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
692 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
304 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
92 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 ...
0
votes
2answers
2k views

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