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
1
vote
1 answer

Galera cluster one of the node desyncs and resyncs periodically

I have three node Galera cluster setup with MariaDB, I see a repeating message for one of the node where it desyncs itself from cluster and resyncs within few seconds. This message is repeating every hour. Though it is just a notice, I would like to…
Amit P
  • 467
  • 6
  • 20
1
vote
0 answers

How can I configure two datacentres in master-slave topology

I am trying to insert data between two datacenters using mariadb, galera and maxscale. each data centre has three nodes, one as master and other two as slave. Now I want my data to be inserted to second data centre in case if my 1st datacentre…
rajeev
  • 11
  • 2
1
vote
1 answer

How to create non-primary component in Galera cluster to test

I have already setup properly 3 node (mariadb) Galera cluster with maxscale load balancing. maxscale is on different server. All the nodes are Primary component. I want to test the non-primary component situation. How can I create this situation in…
Anup_Tripathi
  • 2,817
  • 3
  • 26
  • 37
1
vote
2 answers

2013 - Lost connection to MySQL server at 'reading initial communication packet' system error: 0 while trying to connect to MariaDB over HAProxy

I am trying to connect to MariaDB with using HAProxy load balancer, but when I try to connect to HAProxy it returns that error. I tried all the links on the stackoverflow about this error but they did not work for me. What should I do? 2013 - Lost…
Emrah Tema
  • 335
  • 3
  • 9
1
vote
1 answer

How to avoid SST in Mariadb Galera

I want to add a new node to galera without affecting existing node (donor). For example: node 1 is receive inserted data, and then node 2 join to cluster, node 1 is stuck and can't receive inserted data. How could I let node 1 receive inserted data…
trangtriqc
  • 11
  • 2
1
vote
1 answer

galera puppet code creating two clusters instead of one cluster

I have a puppet code that supposed to create one galera cluster that contains two nodes but instead, it is creating two clusters with one node each. the name of the two nodes are testbox1 and testbox2 the following is my…
Salem Masoud
  • 411
  • 11
  • 32
1
vote
2 answers

Galera: expected use is multi-master or write one and read all?

I'm facing for the first time to a real scaling problem with a db-heavy webapp. We are studying Galera and other cluster systems. I ask you what is the ideal way to use Galera. I ipothize having 3 nodes write on only one node and read from other…
realtebo
  • 23,922
  • 37
  • 112
  • 189
1
vote
0 answers

Service not starring after mariadb default 'datadir' changing. In Redhat server linux 7.7 has Mariadb(10.4) galera cluster

In windows, I can able to change MariaDB 'datadir' and service also restarting smoothly. In RedHat server Linux, I am unable to change the default of 'datadir'(under [mysqld] in my.cnf file) for MariaDB when I am trying to start service its showing…
kota
  • 41
  • 5
1
vote
1 answer

Is there an efficient, reliable way to determine the last update time for a collection of tables in mysql?

Classic problem: I have many many client applications (native and web apps) connected to a system, all of which need to get updates in real-time as information changes. Most of the information changes rarely. When it does, the client systems need…
Shane McCarron
  • 11
  • 2
1
vote
1 answer

Failed to start LSB: Start and stop the mysql (Percona XtraDB Cluster) daemon

I am using MySQL Percona XtraDB Cluster with 3 node and MySQL service in one node did not work because of disk full. after fix the issue we try to start MySQL on this node but the following error occur: (before this issue all node had been working…
Benyamin
  • 11
  • 1
  • 3
1
vote
0 answers

Convert single MariaDB to a Galera Cluster

I have the next question that I don't know how to solve. I currently have a server running mariadb version 10.1 on a Debian 9.8. This server is for test environments so it is not a real production environment. Now I need to create a cluster using a…
admatlantis
  • 45
  • 2
  • 4
1
vote
1 answer

Failing to connect applications via MaxScale

I have 3 node Galera Cluseter and a node for maxscale. the problem is only maxscale user i have defined in maxscale.cnf can connect to cluster via listener service. all nodes are in local network and can see each…
haj_baba
  • 117
  • 4
  • 13
1
vote
0 answers

How to isolate a Galera node for update?

I’m setting up new hosting for a client who is currently with one of the large hosting companies. The new setup includes three Lamp stack servers, A, B and C. Server A will be the live server, with B and C as failover backups. MariaDB servers are…
John Rand
  • 995
  • 2
  • 10
  • 20
1
vote
0 answers

Reset root password in mysql galera cluster

Pls enlight me, i have mysql cluster and have issue the previous DBA forgot pass root mysql of one node, if i reset this root pass would it be impact to galera cluster ? if galera cluster using root ? and how do i reset the root pass in galera…
Tigerpig
  • 13
  • 1
  • 4
1
vote
1 answer

Backup Galera cluster using mysqldump

I have a 3-node Galera MariaDB cluster and I want to have a supplementary backup using mysqldump for restore of individual tables in the event of any user errors. Currently Node1 is being used by all applications while node2 and node3 are just kept…
user10523182
  • 13
  • 3
1 2 3
…
27 28