MySQL Forums
Forum List  »  InnoDB clusters

How to recover corrupted slave
Posted by: nj lcheng
Date: February 24, 2022 02:38AM

Hi,
We are using Innodb cluster, include 1 master and 2 slaves. Sometimes because of IO issue, one slave maybe down, and the group replication process could not be started again. When it tries to join group, it may reports some errors as below
2021-01-15T05:20:32.116649Z 21 [ERROR] Slave SQL for channel 'group_replication_recovery': Could not execute Write_rows event on table db1.table1; Duplicate entry '7352ce4f-9ff2-f74c-cea2-a15bd44b56a2-7fffffff-aef5-6280-7fff-fff' for key 'col1', Error_code: 1062; handler error HA_ERR_FOUND_DUPP_KEY; the event's master log binlog.000006, end_log_pos 996050607, Error_code: 1062.
Do we have any suggestion to this problem? If the current cluster has been running for a long time and has more than 200G data, and we have to keep the cluster running, is it possible to add one new slave node

Options: ReplyQuote


Subject
Views
Written By
Posted
How to recover corrupted slave
249
February 24, 2022 02:38AM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.