Skip to main content
Share Your Experience: Take the 2024 Developer Survey

Questions tagged [group-replication]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0 votes
0 answers
27 views

Using Clone for addInstance on MySQL Innodb Cluster uses 100% Memory

When trying to add a new node to a MySQL Innodb cluster using Cluster.addInstance() and selecting the Clone option, within 2 or 3 minutes the donor nodes memory usages hits 100% on a server with 36Gb ...
mwarble's user avatar
2 votes
2 answers
216 views

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 ...
O Genthe's user avatar
2 votes
0 answers
18 views

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 ...
Pravat Dash's user avatar
0 votes
1 answer
88 views

How to configure mysql group replication with different ports?

I have a k8s cluster and each mysql instance is well connected together! But I have another mysql server outside the cluster! Each mysql inside the cluster has a default mysql port, which is 3306 and ...
Hasan Parasteh's user avatar
1 vote
1 answer
118 views

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 ...
Pavel's user avatar
  • 11
0 votes
2 answers
671 views

What is the best solution for synchronous sync and load balancing an InnoDB database

I'm trying to find the best setup to horizontally scale an ecommerce which is currently on a single dedicated server, but even reading some of the replies here on DBA I'm still confused on what is the ...
matrix's user avatar
  • 1
0 votes
1 answer
125 views

MySQL Group replication failover detection while node is recovering

I'm trying to get a solid MySQL group replication load balancing / failover set-up. Currently I use keepalived to share one private IP to connect to the loadbalanced MySQL GROUP REPLICATION cluster, ...
Thomas van Hesteren's user avatar
0 votes
1 answer
638 views

MySQL group replication error: Transaction rollback (3101)

I've been looking for a solution to the following issue. I have a group replication up and running on 3 MySQL nodes: SELECT * FROM performance_schema.replication_group_members; +-----------------------...
Thomas van Hesteren's user avatar
3 votes
1 answer
52 views

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 ...
Albertus's user avatar
0 votes
1 answer
695 views

Why slave_parallel_workers affects TPM

I ran a few HammerDB benchmarks and mess with the configurations. And I notice different values of slave_parallel_workers have a considerable impact on TPM. As far as I understand, ...
Matthew Kwong's user avatar
1 vote
1 answer
297 views

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 ...
Matthew Kwong's user avatar
1 vote
0 answers
893 views

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 ...
TVA van Hesteren's user avatar
2 votes
0 answers
1k views

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 ...
Raghavendra V's user avatar
0 votes
0 answers
156 views

ER_TRANSACTION_ROLLBACK_DURING_COMMIT MySQL error when querying

I've recently seen a high number of errors on my Bugsnag integration of my web app which occur when both reading or writing to my MySQL server. ER_TRANSACTION_ROLLBACK_DURING_COMMIT: Plugin instructed ...
helloitsdann's user avatar
0 votes
2 answers
3k views

What contributes to the transaction size on a MySQL UPDATE?

Background We're running a MySQL 8 INNODB cluster behind some Java services. We received an error from the application because we'd exceeded the group replication transaction size limit (“Error on ...
scarba05's user avatar
  • 103
1 vote
1 answer
2k views

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 ...
Abdul Raheem Ghani's user avatar
2 votes
1 answer
1k views

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 ...
towel's user avatar
  • 121
0 votes
1 answer
2k views

MySQL Group Replication - Offline Node with cluster Metadata 1.0.1

I have a production MySQL Group Replication setup out of three Nodes. The cluster has Metadata Version 1.0.1. Today, one node went down an during rejoin phase, it says, it cannot connect to the ...
t2m's user avatar
  • 11
1 vote
1 answer
1k views

MySQL Group Replication Multi-Primary Setup

We are running three MySQL Servers in a Group Replication Multi-Primary Setup. Here are is one of my configuration of one member of that GR group: # General replication settings gtid_mode = ON ...
stoney's user avatar
  • 11
3 votes
0 answers
2k views

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 ([email protected]:3306), I have created ...
IGGt's user avatar
  • 2,126
2 votes
1 answer
948 views

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 ...
Manuel's user avatar
  • 71
0 votes
1 answer
1k views

Mysql binary logs are not deleted after expiration

I have 3 Mysql 5.6 nodes in one galera cluster in the first DC and 3 MariaDB 10.3 nodes in another galera cluster in the DR site. One node on the 1st DC is the master for one slave node on the DR site....
Manos K's user avatar
2 votes
1 answer
2k views

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 ...
dan's user avatar
  • 53
2 votes
1 answer
3k views

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, ...
IGGt's user avatar
  • 2,126
0 votes
2 answers
1k views

MySQL Group Replication fails to understand "::ffff:" IP Address

I'm trying to set up group replication using 3 x MySQL 8.0.16 databases, but when I start up the second Node it fails. The error log reports: [GCS] Connection attempt from IP address ::ffff:10.12.1.2 ...
IGGt's user avatar
  • 2,126
0 votes
0 answers
1k views

mysql 8 innodb clustering - adding instance fails with error "Unknown database 'mysql_innodb_cluster_metadata'"

I'm setting up my first mysql innodb cluster, following the instructions here: https://dev.mysql.com/doc/refman/8.0/en/mysql-innodb-cluster-production-deployment.html I've configured the instances ...
Jonah's user avatar
  • 1
0 votes
0 answers
68 views

Mysql Shell doesn't change the configuration of my database for group replication

I am attempting to use a preexisting database on multiple nodes in a group replication setting. I am using mysqlsh 8.0.16, mysql server 5.7.24 and ubuntu 16.04 as the host. When I attempt to ...
gabwil's user avatar
  • 1
0 votes
1 answer
294 views

how the mysql server settings replicatd in innodb cluster

I just started learning about cluster so I don't have much knowledge if question is not appropriate please forgive me. I have a 3 node InnoDB cluster running .suppose if I want to tune my server by ...
dan's user avatar
  • 53
2 votes
1 answer
541 views

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 ...
LahiruTM's user avatar
  • 146
0 votes
4 answers
767 views

Group Replication plugin crashes MySQL 8.0

Problem description: INSTALL PLUGIN group_replication SONAME 'group_replication.so'; results in ERROR 2013 (HY000): Lost connection to MySQL server during query Specs: MySQL version: 8.0.13 ...
insideClaw's user avatar
0 votes
1 answer
680 views

Application considerations when using a multi-primary innodb cluster

I'm developing a scalable cloud application and I wish to use a multi-primary cluster to be better able to scale horizontally when needed. I have experience with a single primary cluster configuration....
Dylan James McGannon's user avatar
0 votes
1 answer
667 views

Why does my Group Replication plugin fail in MySQL 5.7.24?

I've been using the group_replication plugin with MySQL without issues before 5.7.24. With this version, the server starts up without the plugin because of failure. I confirmed it manually (see steps ...
insideClaw's user avatar
4 votes
2 answers
9k views

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 ...
tdaget's user avatar
  • 813