MariaDB Galera Cluster is a synchronous multi-master cluster.

learn more… | top users | synonyms

1
vote
0answers
20 views

Changing IP address from existing Mariadb10.1 Galera Cluster

I have a multimaster cluster with MariaDB Galera working properly, it is set to perform the replica through its WAN interface. This configuration was a result of a previous migration from another ...
0
votes
2answers
35 views

MariaDB/Galera Cluster with 3 nodes - Change ENGINE from MyISAM to InnoDB without crash

We have tables with MyISAM. The are out of sync, the number of records is different on each cluster node > select table_schema, table_name from tables where ENGINE = 'MyISAM' and table_schema != ...
0
votes
1answer
28 views

MariaDB Galera Cluster Replication

Does the replication between an async slave connected to a master withing the cluster affect the performance of the master in the cluster?
0
votes
1answer
20 views

How do I stop, tune and restart a MariaDB Galera cluster?

So I have 4 nodes running on some fast but smallist (ram wise) vps machines. This is very cool but they are using 100% of the memory available. I need to turn off performance schema and possibly lower ...
2
votes
1answer
57 views

How to get number of active users with one SQL-Query?

I am running a site similar to craigslist where users can create classifieds and write/reply messages. In order to get an idea of activity I would like to get the amount of active users per month. ...
1
vote
1answer
56 views

Duplicate keys error after switching to MySQL Galera

I recently switched from a single MySQL installation to MySQL Galera, running on 3 nodes addressed via HAProxy. Ever since switching I do get randomly "duplicate key" errors reported which ...
1
vote
1answer
48 views

Why does Table Definitions Opened differ this much between cluster nodes?

I have a Percona/Galera cluster and see this when i monitor the different cluster nodes. What does this really mean? And is this something erroneous that needs to be taken care of? This is how one of ...
0
votes
1answer
54 views

What's the best setup for a MySQL multi master replication for a POS in a restaurant?

We're in the process of implementing a point of sale (POS) solution where we have heavily modified an existing open source POS. The original POS was never created with replication/synchronization ...
0
votes
0answers
33 views

mariadb error transaction deadlock

I use galera cluster with 4 nodes, mariadb, we insert nearly 12million data. Insert task was finished. However we have lost 11000 data. I don't know where they go. In error log it writes; 151220 ...
0
votes
0answers
18 views

Can a Galera cluster be configured to allow reads-only while in a non-primary state?

If a node is unable to obtain a quorum, it goes into a non-primary state, where it will not accept any queries until it rejoins other nodes in primary state. There are config options to either ...
1
vote
1answer
70 views

Replicate only some tables of MariaDB database

I currently have a ready-made structure cluster with MariaDB Galera with two servers that keeps both updated database. However I now have the need to create a new similar structure but with one ...
0
votes
0answers
12 views

Galera 3 node cluster - force an online state transfer without downtime on existing node

We have 3 node Galera cluster. On node 3 I wish to force a state transfer. We have out of sync issues, because table was MyISAM. Now InnoDB. Howto do that? Delete data files and restart? The cluster ...
0
votes
0answers
31 views

Galera cluster: fix out of sync tables

I have a table XXX, this table has on all 3 nodes different number of records. This table uses auto_increment key. I wish to resync this table from master to slaves. # yum install ...
1
vote
0answers
144 views

WSREP: failed to report last committed and stop

I have galera cluster and I have 4 nodes. I'm importing some data. however one node gives error. Warning. The warning is; warning WSREP: Failed to report last committed 59102, -q (interrupted system ...
1
vote
0answers
70 views

mariadb galera cluster stop one node automaticly

I have Mariadb galera cluster. I have 4 nodes. but When one node become slow, it stop itself automaticly. that's the error. What should I do? 151030 17:17:14 [Note] WSREP: view((empty)) 151030 ...
0
votes
1answer
76 views

install Galera but mariadb existing on system

I try to install galera on ubuntu 14.04 system. It has already got mariadb and it's working. How can I install it? my command : sudo apt-get install -y rsync galera-3 mariadb-galera-server it ...
0
votes
0answers
53 views

Mariadb, Galera auto_increment_increment

I have a 3 node Galera cluster configured and as a temporary solution so I can re point a client at a time (for testing) I also have a master-master old style slave from the Galera cluster to the old ...
0
votes
0answers
44 views

Galera Cluster crashes because of “ALTER TABLE” statement?

We use on RHEL7 # rpm -qa | grep maria mariadb-5.5.41-2.el7_0.x86_64 mariadb-galera-common-5.5.41-2.el7ost.x86_64 mariadb-galera-server-5.5.41-2.el7ost.x86_64 Do I analyze logs correct that Galera ...
0
votes
1answer
37 views

Using Galera Cluster(Percona XtraDB Cluster, MariaDB Cluster) for setting up multi master

Before i gotta use one I want to know if it is working in windows OS cause I saw a lot using it in linux OS. Does using galera (Percona XtraDB Cluster, MariaDB Cluster) cluster works in windows?
0
votes
1answer
57 views

How to change the replication State Transfer SST to IST in Galera Config

I would like to migrate 700GB data to galera cluster(2node+1arbitrator). I found that IST is the best method for huge DBs.So how to forecfully change the replication from SST to IST in Galera Config. ...
1
vote
1answer
70 views

How (if at all) does Galera enforce authentication for SST via rsync when adding a node?

I have to be missing something here. It just hit me as added a new node to my cluster in order to prepare for the removal of a different node: "How does the cluster know that it is okay to send the ...
1
vote
0answers
57 views

wsrep_slave_threads and tmpdir space usage

After increasing wsrep_slave_threads at Galera nodes I have experienced that the mysql tmpdir, which is a ramdisk, was using much more resources. Especially notable during xtrabackup-v2 STTs. Also ...
1
vote
0answers
85 views

Understanding Galera Status wsrep_local_recv_queue_avg

Does wsrep_local_recv_queue_avg really represent the average size of the wsrep_local_recv_queue? For the MariaDB version below I have problems to understand the status value of it, because the ...
1
vote
0answers
50 views

What causes the creation of such a large number of Galera cache files?

I manage a Percona XtraDB 3-node cluster. Recently the MySQL datadir of one of the nodes (not the one from which the cluster has been bootstrapped) started being filled up with gcache.page.00nnnn ...
1
vote
1answer
74 views

Question about a two-node MariaDB Galera Cluster

Hypothetical situation: Node1 is where data gets written to by the app server ... it was where the cluster was bootstrapped from. Node 2 is the second node in the cluster. Both these nodes run in the ...
0
votes
2answers
370 views

Percona XtraDB - Random deadlock

Randomly my database gets locked completely and queries hang and they pile up until it gets "Too many connections". Below is my mysql log file, I couldn't find anything related to the error system ...
1
vote
1answer
1k views

InnoDB: Error: Table “mysql”.“innodb_table_stats” not found

I've got the same error, although I'm running galera cluster with 3 nodes. I tried following the instructions from InnoDB: Error: Table "mysql"."innodb_table_stats" not found after ...
2
votes
1answer
317 views

Mariadb galera cluster nodes won't stay joined

I have a fresh install on Mariadb 10.0.20 on three servers. I'm using the same my.cnf from another running cluster, just changed the cluster name and the IPs. I bootstrap the first node, and I get a ...
1
vote
1answer
254 views

MariaDB Galera Cluster without HAProxy, MYSQL Proxy, etc

I'm looking to deploy a MariaDB galera cluster across three servers. However, I've noticed that the documentation often references HAProxy or the like. Does this not cause a single point of failure ...
2
votes
1answer
146 views

grastate.dat with seqno -1 on a healthy cluster. Why?

We use those versions: # rpm -qa | egrep '(galera|maria)' mariadb-libs-5.5.41-2.el7_0.x86_64 mariadb-galera-common-5.5.40-6.el7ost.x86_64 mariadb-galera-server-5.5.40-6.el7ost.x86_64 ...
0
votes
1answer
79 views

Galera and in-memory

i've got a question about Galera cluster + mysql/mariadb and RAM. Basically, mysql cluster needs to run in-memory (https://dev.mysql.com/doc/refman/5.1/en/mysql-cluster-basics.html). But we have a 3 ...
0
votes
0answers
65 views

Galera Cluster backup and point in time recovery

Currently we have a 3 node Percona Galera Cluster, and all our writes go to node 1 and we run binary logs on this node also. We run xtrabackup backups on node1 every morning and move these off site ...
1
vote
1answer
34 views

MariaDB cluster and external data feed

I've just finished setting up the 3 nodes mariadb (galera) cluster (let's call the nodes node1, node2 and node3). In order to have the cluster up to date with currently working mariadb database (let's ...
0
votes
3answers
154 views

9 node percona xtradb cluster

We are looking to launch a 9 node percona xtradb cluster on Amazon where each ec2 node uses 20k iops disks. I was afraid if a 9 node cluster will work and mostly what I see is 3 node clusters. We ...
1
vote
1answer
54 views

Will “bridge” storage engines work with MariaDB Galera Cluster?

Galera states that it only supports InnoDB. The reason is quite clear, and it is related with the way synchronous replication is implemented in Galera. However, some storage engines are just ...
0
votes
0answers
44 views

Does galera cluster works in thecloud (Azure IAAS)

We are moving our infrastructure into the cloud (Microsoft) Our current MySQL master-Slave environments will be moved as Infrastructure as a service. At the same time I have been asked to look to ...
1
vote
1answer
242 views

Galera, MariaDB and multiple datacenter

Looking into using Galera and MariaDB across 3 data centers. We have a metroE comnection between the sites. Connectivity is pretty stable, but my concern is if a WAN link goes down at one of the ...
0
votes
2answers
633 views

Percona xtradb cluster node2 won't start

I have configured Percona Xtradb cluster 5.6. The first node starts fine when bootstrapped, but the second node seems to have an issue with this variable setting: ...
0
votes
1answer
51 views

How do I determine which IP I should use for my MariaDB Galera Cluster?

I have set up MariaDB Galera Cluster (let's say 3-4 nodes). Which IP should I specify in the configuration of my application? Should I specify all of them or I should have some proxy in front of ...
0
votes
0answers
118 views

Are these slow query and locks make database server get high load sys CPU two times in a week?

As title I mention, my database server sometime get high sys CPU. I do some troubleshooting I am possible. We built database using mariadb galera. We use two nodes(db1, db2) + one garbd. When db2 ...
1
vote
1answer
160 views

percona cluster 5.6 - handshake with remote endpoint failed, but endpoint is not part of config

I set up a cluster of 3 database nodes using a percona 5.6 cluster. Everything works, all nodes are replicated. I configured SSL for state transfer. The cluster recently changed its topography, ...
0
votes
1answer
191 views

indexable JSON datatype in MySQL/MariaDB

In PostgreSQL 9.4 there is a JSONB datatype which allows you to index on fields in the stored JSON objects. Does MySQL/MariaDB have an equivalent? I'm specifically interested in the MariaDB Galera ...
1
vote
0answers
111 views

what are best practices to setup mariadb galera 10.0 on shared nfs storage (emc vnx) [closed]

As the subject states, I'm interested in setting up a MariaDB Galera cluster, using a shared nfs storage to host the db data. I've searched but couldn't find any resources with "best practices" for ...
3
votes
1answer
533 views

SELECT performance on MariaDB Galera cluster vs. MariaDB is terrible

We are evaluating a Galera setup and so far we have not noticed to many drawbacks except a few queries that have terrible READ performance I cannot put my finger on it. The query by itself isn't ...
0
votes
0answers
175 views

Help with Galera Cluster Auto_Increment

We're currently running a Galera cluster of 3 DB nodes. The way we're set up (due to ORM and automagical locking), we only have one of the 3 DB nodes being written to, and the other two provisioned ...
2
votes
1answer
149 views

Will large inserts crash a 3-node MySQL database cluster?

We have a 3 node MySQL database cluster than runs on Percona. I have a stored procedure that inserts a lot of rows in one hit, potentially over a million rows. I've been warned (by our DBA) this ...
1
vote
1answer
613 views

MariaDB Galera Cluster (master-master) does sync Tables but no data

I'm currently experiencing some sync-issues on my MariaDB Galera Cluster which is a master-master scenario. I've got everything set up properly and the cluster is syncing the DDL changes flawless. ...
1
vote
2answers
143 views

Force MariaDB Galera to only create InnoDB tables

I successfully run a cluster of 3 DB servers using MariaDB Galera 10.0.16. This setup handels a couple of web apps we have created, plus a dozen medium traffic Joomla websites. My problem is that ...
0
votes
1answer
487 views

Mariadb Galera Cluster using Xtradb backup is not working

I am trying out the first test of MariaDB Galera cluster setup without success. This is the error in the log innobackupex: Created backup directory /tmp tar: -: Cannot write: Broken pipe tar: Error ...
1
vote
1answer
541 views

MySQL 5.5 Replication to Galera/Percona XtraDB Cluster

We are currently investigating moving our current MySQL 5.5 Master > 5 x Slaves (with Statement Based Replication, apx 250GB data and growing) to a HA clustering option. Mainly to provide greater ...