Stack Overflow
Stack Overflow

Questions tagged [galera]

Galera Cluster is a synchronous multi-master cluster for MySQL.

From the project home page, Galera Cluster's features include:

  • Synchronous replication
  • Active-active multi-master topology
  • Read and write to any cluster node
  • Automatic membership control, failed nodes drop from the cluster
  • Automatic node joining
  • True parallel replication, on row level
  • Direct client connections, native MySQL look & feel


410 questions
2
votes
1 answer

How can I create a sequence number (like in ORACLE) using MariaDB and Galera Cluster

I need to have a sequence number (not for primary key nor auto_increment) in MariaDB using Galera Cluster. I was thinking of having a table with sequence name, current value and using stored procedures to return the next value. I am not sure a…
supercoco
  • 512
  • 2
  • 7
  • 25
2
votes
1 answer

Galera clusters with too many connections issue

When I run a command to see our database variables: show status like "%onn%" I found that there are way too many connections for 2 people connecting to: MariaDB [(none)]> show status like…
ln9187
  • 730
  • 1
  • 7
  • 23
2
votes
1 answer

Unable to bootstrap MariaDB 10.1 Galera Cluster on Centos 7

I follow this instruction https://tunnelix.com/mariadb-galera-cluster-installation/ for installing MariaDB 10.1 Galera Cluster on CentOS 7. The following is my galera configuration in /etc/my.cnf.d/server.cnf [galera] # Mandatory…
Osh Mansor
  • 1,232
  • 2
  • 20
  • 42
2
votes
0 answers

Java application connecting to MariaDB servers using Pacemaker

I'm trying to test out MariaDB, Galera, and Corosync/Pacemaker to understand clustering with high-availability using CentOS 7 servers. The cluster size I am using for testing is 3 servers to prevent quorum issues for the most part. My tests and…
Mikey G
  • 31
  • 5
2
votes
1 answer

MariaDB Galera Cluster referential integrity constraint

We are in the process of evaluating MariaDB Galera cluster for our application. As I understand the cluster supports row level and statement level replication. We are leaning towards the row level replication. Our data model has multiple entities…
TechEnthusiast
  • 1,795
  • 2
  • 17
  • 32
2
votes
2 answers

Error Galer Cluster : Failed to read 'ready ' from: wsrep_sst_rsync --role 'joiner'

may you help me.. I'm newbie for mariadb cluster. When i was developing new galera cluster, i have an error when i restart one of them : Failed to read 'ready ' from: wsrep_sst_rsync --role 'joiner' Thera are fives server This is my…
Tohir
  • 31
  • 1
  • 4
2
votes
1 answer

Deadlock only with Galera MYSQL cluster

When using a Galera, I am getting - works even fine, when pointing to a remote DB (not just local). Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLTransactionRollbackException: Deadlock found when trying to get lock; try restarting transaction …
user1713999
  • 61
  • 4
2
votes
1 answer

MariaDB Galera Cluster: INSERT ... SELECT locking broken?

I have found an inconsistency in behaviour between a regular MariaDB installation and a MariaDB Galera cluster. Locking does not work as expected for INSERT ... SELECT statements with the Galera cluster. This causes duplicate IDs in our…
StaticNoiseLog
  • 1,370
  • 17
  • 27
2
votes
2 answers

How to scale up write speed on galera cluster? using maxscale as db proxy

Currently, i am researching about galera cluster using many of servers(linux centos). Scaling up read traffic is very effective and easy, but scaling for write seems difficult(not improved). I have used many servers, using maxscale as…
tesmojones
  • 2,496
  • 2
  • 21
  • 40
2
votes
1 answer

Set up GTID replication between Galera Cluster and standalone MySQL slave

Anybody has experience with setting up replication between Galera Cluster and standalone MySQL slave? I have a three nodes in Galera Cluster and I want to set up gtid replication to MySQL slave. The problem that is all Galera nodes write their own…
jumpy
  • 317
  • 1
  • 12
2
votes
1 answer

I use haproxy as banlancer for mariadb cluster，but got lost connection during query

I use haproxy as banlancer for mariadb galera cluster, it can connect and do some operation normally,but after serval seconds I want to do some search again but a got lost connection during query error.see the error below image. lost connection…
尹雪松
  • 71
  • 1
  • 6
2
votes
0 answers

Automatically generating sequential ids in a Galera cluster

I have a Galera cluster with 3 nodes. On it, there are several tables, let's for the sake of argument assume some of them are: CREATE TABLE customer (id INT PRIMARY KEY AUTO_INCREMENT, name TEXT); CREATE TABLE item (id INT PRIMARY KEY…
Karol S
  • 9,028
  • 2
  • 32
  • 45
2
votes
0 answers

Percona Cluster node wont start after crashing

We have a Percona Xtradb cluster with about 11 nodes. One of the nodes crashed about 2 days ago, but now failing to start again even after the donor indicates that the SST process is complete and the node has now JOINED the cluster. When i check the…
The Georgia
  • 1,005
  • 7
  • 23
  • 59
2
votes
1 answer

How to work with MySQL temp tables in a Galera Cluster?

I am scaling my application from one MySQL server to a 3 node MySQL Galera Gluster. Aparently temporary tables do not get replicated. Is there a common workaround this problem? My current code looks like this: $stmt = " CREATE…
merlin
  • 2,717
  • 3
  • 29
  • 59
2
votes
1 answer

hugepages not working with mariadb

We tried to setup the hugepage for mariabdb running with galera cluster. We had allocated hugepages high enough to accommodate the innodb buffer. server.conf [mysqld] large-pages innodb_buffer_pool_size =4G /etc/sysctl.conf # hugepages…
user1595858
  • 3,700
  • 15
  • 66
  • 109
1 2 3
…
27 28