MariaDB Galera Cluster is a synchronous multi-master cluster.

learn more… | top users | synonyms

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

Can't bring up second MySQL Galera node - 2015-08-27 21:53:13 32140 [ERROR] WSREP: Failed to read 'ready <addr>'

I am trying to migrate from MySQL m/m replication to MySQL Galera. After successfully installing MySQL Galera on node no. 3, I configured it as the first node in the cluster and have imported the ...
1
vote
1answer
35 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
31 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
29 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 ...
1
vote
0answers
28 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
45 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
28 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
30 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
74 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
40 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
33 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
75 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
132 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
31 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
63 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
82 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
0answers
63 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
61 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 ...
2
votes
1answer
231 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
75 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
79 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
256 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
82 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
299 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
242 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 ...
0
votes
0answers
55 views

What are the important notes when upgrade mariadb galera cluster from 10.0.14 to 10.0.16

I have a plan to upgrade mariadb galera cluster 10.0.14 to 10.0.16 Detail plan: I will do rolling upgrade (one by one) Step 1: Forward all queries to one node and stop other node (Node will be ...
2
votes
1answer
87 views

Why does most Galera cluster documentation recommend having at least 3 nodes as the typical set up?

The Galera documentation and most experts implementing this type of setup, recommend having at least 3 nodes in the Galera cluster. What is the reasoning behind this? Is a cluster setup with only two ...
1
vote
1answer
39 views

How to transition from a statement based log to row based log for Galera replication?

I'm new to clustering and I'm trying to implement a Galera cluster. I'm transitioning from a standalone MySQL instance to a MariaDB Galera Cluster consisting of (at the moment) 2 nodes. I have ...
0
votes
0answers
48 views

How to improve the speed of point in time recovery using mysqlbinlog?

I am backuping database by online backup percona xtrabackup and binlog. My data is about 16G. I scheduled to do a full backup by xtrabackup. Binlog is for point in time recovery. Backup is OK. When ...
0
votes
1answer
54 views

Is there any way to graceful restart mysqld? [duplicate]

I think my question is impossible but I sure I do not know everything. In my opinion, when mysqld restart, some transaction is not still completed will be rollback on startup. Mysqld use undo log to ...
0
votes
0answers
204 views

Galera: WSREP: gcs connect failed: Socket type not supported

I am having a problem when trying to start the 2nd and 3th nodes. The node number 1 has started ok with no problem: I use the same configuration file for galena.cnf and my.cnf : change the ...
0
votes
0answers
19 views

high cpu load because high CPU time for sys [duplicate]

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
38 views

What is exactly a uniform server in a galera cluster setup?

In many manuals about performance tuning and avoid Galera's MySQL cluster limitations they write the below suggestion. It is possible for a slow/overloaded master node to affect performance of ...
0
votes
1answer
65 views

Does Galera Cluster rsync only updated files or all files

We're currently setting up a galera cluster using rsync for sst. The datadir is currently 20Gig and right now we're only updating about 4 (very large) tables. I know that rsync normally only ...
0
votes
0answers
56 views

How to prevent thread_created and Innodb_master_thread_active_loops grow up very quickly?

I am using maria galera cluster include three nodes: two cluster node and one garbd. I notice Threads_created and Innodb_master_thread_active_loops increase very quickly. My information system: ...
1
vote
0answers
161 views

Galera cluster consume many CPU percent and CPU high load

I have implemented a cluster include three nodes: two stored nodes and one garbd (also haproxy - load balancer). Some information about servers: SSD 480G Raid1 Memory 32G Swap 16G 2xCPU, number of ...
1
vote
1answer
686 views

MariaDB Galera Cluster wsrep_cluster_address not working

I have configured MariaDB galera cluster with three nodes on CentOS-6.5 64bits: db1 - 192.168.1.111 db2 - 192.168.1.112 db3 - 192.168.1.113 My /etc/my.cnf.d/server.cnf file is configured as ...
0
votes
0answers
204 views

MariaDB Galera cluster nod won't start

I have configured a MariaDB Galera cluster with three nodes. The master node and one of the slave-master node is up and running, but the third node just won't run. The system specs and cluster config ...
1
vote
1answer
465 views

MariaDB Galera Cluster - nodes fail to start

This is a new installation (fresh VM and MariaDB install). For some reason, the nodes are having trouble joining the master server. The master server would pause at Preparing binlog files for ...
1
vote
1answer
67 views

Importance of uniformity of hardware for Galera cluster

How important is it for the nodes in a Galera cluster to be identical? I've found this answer which says they should be the same: http://dba.stackexchange.com/a/55224/770 I understand that you ...
1
vote
1answer
301 views

Integrity constraint violation in Percona XtraDB Cluster

We have a PHP application that uses AWS Load Balancer that connects to 3 Percona Servers. Before we used a single standard Percona Server and that never happened. The cluster starts throwing Primary ...
0
votes
0answers
41 views

Understanding flow control in MariaDB Galera Cluster?

I am not clear how node state changed. What is the different between node state: JOINED, SYNCED, DONOR/DESYNCED, CLOSED, DESTROYED. These are all state I see in log. I am using MariaDB Galera Cluster ...
2
votes
1answer
2k views

what is the right way to restart a mariadb galera cluster?

I am trying to restart cluster. I have two problems in stopping cluster and starting cluster In stopping cluster, I follow the instruction ...
0
votes
1answer
468 views

Upgrading MariaDB Galera cluster from 5.5 to 10.0 - rolling upgrade possible?

I've had a good search around and cannot find much on the topic. We want to upgrade our live MariaDB 5.5 Galera cluster to the MariaDB 10.0 branch, ideally without any downtime. We installed ...
3
votes
1answer
1k views

Does it make sense to run a cluster of database servers in docker containers?

I'm currently looking into setting up a database cluster (MySQL Galera or Percona) but I have only 2 machines. However, according to many sources I've read (This article from the Mariadb KB), the ...
1
vote
2answers
957 views

Galera Cluster with MariaDB 10 and asynchronous slave

So, as it's easier to understand what I'm trying to accomplish with a picture. Here's a picture: I'm really not an expert in database administration, so please be patient. I am working on a setup ...
0
votes
2answers
513 views

What is the best choice for MySQL high availability (zero downtime)? [closed]

As I know there are many solutions for MySQL HA, but most of them are congenitally not zero downtime solution, like MHA, AWS RDS... That said, if zero downtime is "must have", the only choice is ...
1
vote
2answers
123 views

How can I perform this database backup/sanitization task?

I have a 3-node MariaDB/Galera cluster. I need to do two things: Back up the database regularly (multiple gigs in size) for a normal, in-case-everything-crashes-I-can-restore-from-this backup. Have ...
0
votes
1answer
1k views

Using Galera for simple master-master replication

I was reading the documentation and it specifically mentions that a Galera DB cluster must have at least three nodes to achieve Quorum, although our current setup is working with two. I am tasked ...