The tag has no wiki summary.

learn more… | top users | synonyms

0
votes
1answer
18 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
20 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
97 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 ...
2
votes
1answer
33 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
0answers
95 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
47 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
78 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
0answers
52 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
322 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
86 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
77 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
72 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
53 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
53 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
100 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
528 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
368 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
440 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
338 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
430 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
242 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
68 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 ...
1
vote
1answer
1k 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 ...