Stack Overflow
Stack Overflow

Questions tagged [mysql-group-replication]

32 questions
6
votes
4 answers

ERROR 3098 (HY000): The table does not comply with the requirements by an external plugin

SETUP: Three mysql group replication nodes in master master master. All work fine. I can add users/dbs and insert/update data. Each node is bound to a private IP address. I created a bash script to connect to mysql to delete users. Deleting a…
Kyle Anderson
  • 1,820
  • 5
  • 21
  • 29
6
votes
2 answers

MySQL Group Replication plugin not found in version 5.7.19, 5.7.21

I am attempting to enable the MySQL group replication plugin on MySQL 5.7.21, which should be available in 5.7 as per the documentation (https://dev.mysql.com/doc/refman/5.7/en/group-replication.html) $ mysql --version mysql Ver 14.14 Distrib…
ninapavlich
  • 739
  • 2
  • 10
  • 30
4
votes
0 answers

Why the error: Neither --relay-log nor --relay-log-index were used

So i have this mysql innodb cluster of 3 mysql instances on docker that is always failing with the error group replication not active. Looking at the error logs, the only thing i can find is this warning: Neither --relay-log nor --relay-log-index…
eedideyahoocom
  • 143
  • 1
  • 8
3
votes
2 answers

A node in MySQL 5.7 innoDB cluster is crashed and unable to re-join the crashed node to the cluster

We have a MySQL innodb cluster in one of our environments. One of the nodes in the cluster was crashed. Though, we were able to bring the crashed node online we were unable to join it to the cluster. Can someone please help to recover/restore the…
Siva Dasari
  • 1,059
  • 2
  • 19
  • 40
3
votes
1 answer

Mysql group replication can't add instance

config file on 22.22.22.22: ... loose-group_replication_group_name="aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa" loose-group_replication_start_on_boot=off loose-group_replication_local_address= "127.0.0.1:33061" loose-group_replication_group_seeds=…
Rattrap
  • 295
  • 4
  • 13
3
votes
1 answer

MySQL node join group replication failed to due extra transactions after failover

I have a 3-node mysql InnoDB cluster deployed on kubernetes(k8s). Each mysql node is a k8s POD. To test the availability, I manually removed the docker container mysql primary node corresponding to(with command 'docker rm xxxx -f). As expected, k8s…
Tony Wen
  • 76
  • 1
  • 7
2
votes
1 answer

MySQL 8.0.13 Group Replication Recovery Error MY-002061

I have MySQL group replication with 3 servers. One of them experienced an error and was unable to recover its ONLINE status in the replication list due to an error connecting to a donor server. [Repl] Slave I/O for channel…
openyk
  • 65
  • 2
  • 9
2
votes
1 answer

Mysql group replication: stuck on RECOVERING forever

I have two MySQL server which are running on same group replication. The setup had been done by below steps: The first server is production server with lot of data. I set it readonly and dump the data, then restore it on the fallback MySQL…
DuongTC
  • 29
  • 1
  • 5
1
vote
0 answers

MySQL group replication insert statement time sometimes suddenly increases, how is this caused?

I used jmeter to stress test the table named test in my innodb cluster. I recorded all sql statements exceeding 1ms in the slow SQL log. I found that the time consumption of insert statements sometimes increased suddenly, but it was irregular.
Eden
  • 11
  • 1
1
vote
1 answer

Error Importing data to MySQL Group Replication

I'm taking a backup from a standalone database using the following command: mysqldump -u -p --databases --no-create-info --no-create-db --skip-triggers --single-transaction --compress --order-by-primary > data.sql When I'm…
Tal Ayalon
  • 21
  • 4
1
vote
1 answer

wso2 is and api manager database configuration for clustered mysql

I'm trying to setup IS as key manager (v3.0.0) and api manager (v3.0.0) using a HA mysql (v8.0) configuration. While running the sql scripts for db creation, I'm getting errors from mysql on the entries about foreign keys with ON DELETE CASCADE,…
kyriakos kouramenos
  • 23
  • 4
1
vote
1 answer

MySQL 8.0.16 (Windows) Group Replication Fresh Setup : Not able to add second member

I am trying to setup MySQL HA using Group Replication feature. Referred instruction from https://dev.mysql.com/doc/refman/8.0/en/group-replication.html. Read & tried all steps multiple times to ensure all steps are followed properly, but same…
Rajesh Verma
  • 31
  • 1
  • 3
1
vote
1 answer

Unable to start Group Replication for instance 'xxxxx:3306'?

I am trying to do a innodb cluster installation on mysql and it keeps showing this error message: 2019-11-13T18:39:04.599509Z 15 [ERROR] [MY-011640] [Repl] Plugin group_replication reported: 'Timeout on wait for view after joining group'…
Eesha U
  • 11
  • 2
1
vote
0 answers

Resolving hostname inside a container docker deploy with swarm

I deploy some service with swarm. When I ping the service label inside the corresponding container, it gives an IP not present in ifconfig. In my /etc/hosts I have only automatic names generates by docker. In swarm, I can't use 'name' option in…
Yvan Maillard
  • 11
  • 1
1
vote
2 answers

Is it necessary to know all hosts contained in ipWhitelist on cluster creation?

I am playing around with MySQL 8.0.14 and InnoDB cluster. I am currently stuck at creating the Group replication via mySQL shell. Since I want to use SSL, I am required to set ipWhitelist on dba.createCluster() which is shown below: var cluster =…
Philipp Reddigau
  • 125
  • 1
  • 7
1
2 3