Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [group-replication]

34 questions
4
votes
2 answers

Mysql Group replication vs Mysql Cluster

[disclaimer] I'm not new to databases but totally novice about replication and cluster ... As you may know Mysql made available a new functionality : MySql Group Replication. Is anyone can explain me the fundamental difference between such…
tdaget
  • 825
  • 2
  • 12
  • 23
3
votes
1 answer

Clarification: Replication Filters for MySQL Group Replication

As I understand it, replication filters in MySQL are not allowed for MySQL Group Replication. Is this correct? Does this imply that all databases among the group replication instances must have the same state initially?
Albertus
  • 33
  • 2
3
votes
0 answers

MySQL Group Replication - Peer address is not valid

I have been trying to set up an MySQL Innodb Cluster, initially with two databases, both MySQL 8.0.19. But I keep getting the same errors. On the first one (username@1.2.3.4:3306), I have created the cluster, and that seems to be ok. then I…
IGGt
  • 2,266
  • 6
  • 35
  • 49
2
votes
2 answers

Unexplained MySQL memory usage

I am experiencing an issue with MySQL memory usage increasing over time to a point where OOM Killer kills the MySQL process. I have 3 servers configured with Group Replication (1 Primary and 2 secondary). The servers are running on AWS…
O Genthe
  • 21
  • 3
2
votes
0 answers

Cloning failing in Mysql Group replication

We have a 3-node MySQL group replication set up in K8s. After all the respective setups, during the cloning process from the primary node to rebuild or add a secondary node to the cluster, the process is automatically closing with the following…
Pravat Dash
  • 21
  • 1
2
votes
0 answers

MySQL multi-master group replication on kubernetes

We are trying to setup MySQL multi-master group replication (GR) on kubernetes Group replication configuring instances. GR is starting on one pod after all the configurations. However the second node goes to RECOVERING state when GR is started…
Raghavendra V
  • 21
  • 3
2
votes
1 answer

MySQL group replication plugin won't recognize host's IP address?

I have pulled the current mysql-server image (mysql-server) on 2 Ubuntu 18.04 machines and I want to set up group replication. This is how I start the mysql container on each machine (--server-id is 2 for the second machine): docker run -d…
towel
  • 121
  • 3
2
votes
1 answer

How to configure MySQL Router on two application servers?

I have three MySQL servers running with group replication and inside a InnoDB Cluster. I have two app servers that will be connecting to the cluster and I need to configure mysql router on both app servers. When I run router on server1 I use the…
Manuel
  • 91
  • 7
2
votes
1 answer

Relay log read fail, relay or master log currupt ,How to repair?

I am running mysql InnoDB cluster 8.0.17(group replication) During the repication the slave disk gets full and no space left at all the thread waits for the disk space to be freed at the same time this was happening the server restarted once server…
dan
  • 53
  • 5
2
votes
1 answer

MySQL, Group Replication not surviving after a single restart

Can anyone see where I am going wrong, as this is driving me round the bend. I have set up a clean install of MySQL 8.0.17 on my Windows 10 laptop. I have gone through the whole initialize process, logged in and set up a root user and set it up as a…
IGGt
  • 2,266
  • 6
  • 35
  • 49
2
votes
1 answer

How to setup two mysql servers with group replication to work individually, when no network

I have two mysql servers in two different places. Both servers must be able to read and write. All tables are designed to based on unique id (UUID) primary key. I want to sync these two databases live using a replication method when networks are…
LahiruTM
  • 146
  • 7
1
vote
1 answer

innodb cluster group replication Error_code: 1594

So we have an innodb cluster consisting of 4 nodes. one of the nodes crashed (OS crash), while starting the node it shows the following error: 2022-06-13T06:46:02.529058Z 491 [ERROR] Slave SQL for channel 'group_replication_applier': Relay log read…
Pavel
  • 11
  • 2
1
vote
1 answer

MySQL Group Replication consistency EVENTUAL vs BEFORE_ON_PRIMARY_FAILOVER

As far as I understand, BEFORE_ON_PRIMARY_FAILOVER is exactly behaving like EVENTUAL in normal scenarios until a failover happened, which the former will block all new transactions until the new primary node has applied its backlog while the latter…
Matthew Kwong
  • 113
  • 4
1
vote
0 answers

MySQL Group Replication add node to (long) existing cluster fails

I've got a working MySQL GROUP REPLICATION Cluster consisting of 2 Ubuntu 20.04 servers, running on IP's 192.168.1.2 and 192.168.1.3 (local network connection). This works great, however to get good availability (when a server goes down), I have to…
TVA van Hesteren
  • 111
  • 4
1
vote
1 answer

Cannot rejoin or add instance to MySQL InnoDB cluster

I have a MySQL InnoDB cluster running where I had added three nodes, one is having the Primary role and the others are Secondary. Today morning, the two secondary nodes were removed from the cluster after I restored a backup in a test database on…
Abdul Raheem Ghani
  • 562
  • 6
  • 13
  • 25
1
2 3