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

How can I remove a node from my galera cluster?

Is there any better way of doing it,apart from setting 'wsrep_cluster_address='gcomm://' for each node that I want to remove?
user5312201
5
votes
1 answer

Executing MySQL replace into select using multiple DB results to deadlock

I'd checked other similar kind of issues e.g. "deadlock in MySQL" in stack overflow but nothing leads to the solution. REPLACE INTO db2.table2 (id, some_identifier_id, name, created_at, updated_at) (SELECT id, some_identifier_id, name, created_at,…
Kuntal Chandra
  • 91
  • 2
  • 7
4
votes
1 answer

HAProxy in kubernetes to connect galera cluster

I want to connect Galera cluster from haproxy pod deployed in kubernetes. Docker file for the image. FROM haproxy:2.3 COPY haproxy.cfg /usr/local/etc/haproxy/haproxy.cfg haproxy.cfg File defaults log global mode tcp retries 10 …
Sachith Muhandiram
  • 2,819
  • 10
  • 45
  • 94
4
votes
1 answer

How to convert a string of "key = value;" pairs to a dictionary in ansible?

Essentially I'm looking for exactly this, but for ansible/jinja2: Convert a comma separated string of key values pairs to dictionary I'm getting a semi-colon separated list of key=value pairs from a mariadb galera server…
haydenseitz
  • 43
  • 5
4
votes
1 answer

How to stop a deadlock on one node from crashing entire cluster?

I'm running a 3x node Galera Cluster under MariaDB. The application is in PHP using the mysqli extension. Very occasionally I get a Deadlock on write. I'm working on improving my application to handle or avoid that kind of failure, but in the mean…
Tim
  • 8,036
  • 2
  • 36
  • 52
4
votes
0 answers

MariaDB Galera Cluster: change wresp_sst_method in production server

I have a MariaDB Galera Cluster with 3 nodes and multi-master setup. my current configuration for State Snapshot Transfer method is rsync. How to change this method to xtrabackup-v2 without downtime and data loss? Can I shutdown and setup nodes one…
Ghasem Pahlavan
  • 661
  • 9
  • 20
4
votes
1 answer

Clustering MySQL for Magento 2.0 installation

I'm planning to setup a Magento 2.0 installation using MySQL Cluster o MySQL Galera Cluster for a highly available DB. One of the restrictions for these is that every table should have a PK. To my surprise, not every table on Magento 2.0 Community…
manugarciac
  • 185
  • 1
  • 12
4
votes
1 answer

Galera first node won´t start

Ive been trying to set up a Galera Cluster. Since Im new to Linux I used the guide from mariadb (Link). I made everything as it stands there but the first node just won´t start when I use the command "service mysql start --wsrep-new-cluster". Im…
D. Adam
  • 53
  • 5
4
votes
2 answers

'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (111 "Connection refused")'

I am trying to setup mariadb galera cluster on Debian Wheezy 7.5. I have found many different instructions, all a bit different, but none have worked thus far. I am trying to setup a two node cluster. On the primary node, I am using the default…
Levon Tamrazov
  • 530
  • 2
  • 9
  • 20
4
votes
1 answer

Additional Nodes on Galera MySQL failing to add

Ok so I have a second node I am trying to add to a working galera mysql server as another node...configs here Node A(working) [server] [mysqld] [embedded] [mysqld-5.5] [mariadb] binlog_format=ROW …
ThatGuy
  • 303
  • 2
  • 14
3
votes
0 answers

Communication link failure: 1047 WSREP has not yet prepared node for application use in

We had a three-node cluster with MariaDB 10.4. We had an outage and the servers all rebooted with one having an irrecoverable network issue at the time. We set up another server and added it to the cluster as a third member later. However, ever…
Kashif
  • 495
  • 1
  • 5
  • 16
3
votes
2 answers

Session Variables different to global Variables in MariaDB

I'm running a Galera Cluster with a HAProxy-LB in front. However my users reporting that the session variable wait_timeout is set to 60. I checked that with SHOW SESSION VARIABLES LIKE "%wait_timeout%" and for me the result is wait_timeout 610. In…
moTHO.
  • 364
  • 3
  • 21
3
votes
0 answers

Data inconsistency when writing to Galera-clustered MariaDB with go-sql-driver/mysql

Description Data inconsistency is observed when two golang program are concurrently writing to the same DB tables through different MariaDB instances. The MariaDB instances are clustered using Galera. The test database looks like as follows: CREATE…
JAE HOON KO
  • 51
  • 2
3
votes
2 answers

Unable to restart MySQL server

I restarted MySQL server in one of the nodes in Percona Cluster. Since the restart took much time, I interrupted the process. I tried restarting the MySQL server again. I got the following error: Stale sst_in_progress file in datadir I followed…
Shriram Balakrishnan
  • 439
  • 5
  • 15
3
votes
1 answer

Percona replication not sync

we use percona cluster 5.7.20 my wsrep configuration. max_connections = 10000 open_files_limit =…
ureyni
  • 71
  • 6
1
2
3
…
27 28