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
2 answers

MariaDB Galera cluster servers running at 100% CPU and load rising

I have a Drupal application which has been running on a single MySQL database server for 12 months, and has been performing relatively well (apart from peak load events). We needed to be able to support much higher spikes than the current DB server…
nicksanta
  • 111
  • 3
  • 7
2
votes
1 answer

mysqli::query not returning FALSE or mysqli_result - PHP bug?

I'm not sure if this is a bug in PHP, MySQL or me being stupid but very occasionally (and it is very rare) we call mysqli::query and don't get FALSE or a mysqli_result object back. We are running: PHP 5.5.9-1ubuntu4.3 MySQL Ver 15.1 Distrib…
Luke Cousins
  • 2,068
  • 1
  • 20
  • 38
2
votes
1 answer

Master/Slave replication load balancing if master down with Galera

I'm kind of lost there, I want to setup a common MASTER/SLAVE replication on a MariaDB database. I choose MASTER/SLAVE over MASTER/MASTER to avoid complexifying things. The SLAVE will be used only if the MASTER server is down. I've setup MariaDB…
sf_tristanb
  • 8,725
  • 17
  • 74
  • 118
2
votes
2 answers

Failed to bootstrap Galera Cluster

I'm trying to set up multi-master replication between two servers according to this tutorial: http://tecadmin.net/setup-mariadb-galera-cluster-5-5-in-centos-rhel/ My /etc/my.cnf.d/server.cnf on 1st…
Radzikowski
  • 2,377
  • 4
  • 27
  • 39
2
votes
1 answer

MariaDB Galera nodes down after reboot

I'm using MariaDB with Galera replication on 3 Ubuntu 12.04 servers : Server version: 5.5.33a-MariaDB-1~precise mariadb.org binary distribution, wsrep_23.7.6.rXXXX They're all development servers, in the same local network, so there's no…
Guillaume
  • 25
  • 1
  • 6
2
votes
2 answers

WSREP: Failed to prepare for 'rsync' SST. Unrecoverable

I am using Percona Xtradb Cluster with 5 nodes. I am not able to start the node and am facing the following errors. I used the command mysqld --console to trace and view this error. WSREP: Failed to prepare for 'rsync' SST. Unrecoverable. 130320…
Kevin Nguyen
  • 1,759
  • 2
  • 16
  • 14
1
vote
1 answer

Custom PHP Session Handler locking with MariaDB cluster

Has anyone got a solution for implementing locking in a custom PHP session handler that stores sessions in the database when the database is a MariaDB cluster? The problem is that the session handler needs to implement locking (the default file…
Greenflash
  • 21
  • 2
1
vote
0 answers

Galera cluster perfomance degradation after node resync

I got Galera master-master cluster on MariaDB 10.4 and galera-4 as replication lib. It runs perfectly until some network issues happens between some node and the others. After node reconnect and resync it's state the whole cluster performance drops…
uzurik
  • 31
  • 3
1
vote
0 answers

maria db galera cluster problem with docker container node

I want to set up a MariaDB galera cluster with two nodes with different hosts having IP addresses 11.11.20.2 and 11.11.30.2. These two hosts can ping each other, and the databases have been launched via Docker-Compose and ports 4567 4444 4568 3306…
Hamid rsh
  • 11
  • 1
1
vote
1 answer

Why MariaDB Galera cluster thrown a deadlock instead of waiting?

I'm trying to move my application from a single server database to a Galera cluster, this application uses some FOR UPDATE locks. Consider this case: create table rooms ( id int not null, owner int null, PRIMARY KEY (`id`)); insert into rooms values…
Tobia
  • 9,165
  • 28
  • 114
  • 219
1
vote
1 answer

Mariadb Galera 10.5.13-16 Node Crash

I have a cluster with 2 galera nodes and 1 arbitrator. My node 1 crashed I don't understand why.. Here is the log of the node 1. It seems that it is a problem with the pthread library. Also every requests are proxied by 2 HAProxy. 2023-01-03…
Theo Cerutti
  • 779
  • 1
  • 10
  • 33
1
vote
1 answer

Is using ProxySQL a requirement to direct queries in Galera Cluster or MySQL Master-Slave?

I still don't have much experience using these tools (Galera Cluster and MySQL Master-Slave Cluster ) and I'm testing some scenarios in my Wordpress environment at Jelastic/Virtuozzo. My platform has a large volume of queries per minute, both from…
Daniel - Fisarmonica
  • 11
  • 1
1
vote
0 answers

Ansible module mysql_variables not fetching WSREP variables

I am using below block to fetch mysql variables. - name: Check for wsrep_cluster_status setting mysql_variables: login_user: '{{ mysql_root_user }}' login_password: '{{ mysql_root_pwd }}' variable: wsrep_ready register: v_wcs …
Srikanth Lingala
  • 31
  • 1
  • 4
1
vote
1 answer

Sharding with replication

Sharding with replication]1 I have a multi tenant database with 3 tables(store,products,purchases) in 5 server nodes .Suppose I've 3 stores in my store table and I am going to shard it with storeId . I need all data for all shards(1,2,3) available…
Behdad
  • 184
  • 3
  • 12
1
vote
1 answer

Galera cluster with 4 mysql nodes and 3 arbitrators

I have a Galera cluster with Geo-redundancy setup. First site : 2 Mysql nodes and 1 arbitrator Second site : 2 Mysql nodes and 1 arbitrator Third site : only one arbitrator. My First question is , in my.cnf file of each mysql node we…
gaurav_hodade
  • 11
  • 1
1 2 3
…
27 28