Issue creating a mysql community cluster 8.0.26 from an xtrabackup restoration

MySQL & MariaDB Percona XtraBackup
1

Hello team, I am a newbie here, so please bear with me.
First of all thanks so much to Percona for the xtrabackup, is just great.
Always using 8.0.26 in ALL machines.

Let me expose my problem:
I can OK backup and restore from a 8.0.26 cluster machine to a standalone 8.0.26. That is fine.
Now, I have a different cluster and I am trying to create that second cluster with the info of the first cluster.
My idea was to restore the backups in the 3 machines in standalone, and then later clear the cluster using incremental mode.

But I cannot create the cluster normally, see error trace below.
Is like if the backup from a cluster cannot be used again to create a cluster


Thanks so much for any hint or help.
BR

MySQL DB1DRINT:3306 ssl JS > dba.checkInstanceConfiguration()
Validating local MySQL instance listening at port 3306 for use in an InnoDB cluster


This instance reports its own address as DB1DRINT:3306
Clients and other cluster members will communicate with it through this address by default. If this is not correct, the report_host MySQL system variable should be changed.

Checking whether existing tables comply with Group Replication requirements

No incompatible tables detected

Checking instance configuration

Instance configuration is compatible with InnoDB cluster

The instance ‘DB1DRINT:3306’ is valid to be used in an InnoDB cluster.

{
“status”: “ok”
}

MySQL DB1DRINT:3306 ssl JS > cluster = dba.createCluster(‘mysqlClusterOTAP’);
A new InnoDB cluster will be created on instance ‘DB1DRINT:3306’.

Validating instance configuration at DB1DRINT:3306


This instance reports its own address as DB1DRINT:3306

Instance configuration is suitable.
NOTE: Group Replication will communicate with other members using ‘DB1DRINT:33061’. Use the localAddress option to override.

Creating InnoDB cluster ‘mysqlClusterOTAP’ on ‘DB1DRINT:3306’


Adding Seed Instance

ERROR: Unable to start Group Replication for instance ‘DB1DRINT:3306’.
The MySQL error_log contains the following messages:
2021-12-16 08:13:41.831832 [System] [MY-013587] Plugin group_replication reported: ‘Plugin ‘group_replication’ is starting.’
2021-12-16 08:13:41.834138 [System] [MY-010597] ‘CHANGE MASTER TO FOR CHANNEL ‘group_replication_applier’ executed’. Previous state master_host=‘’, master_port= 0, master_log_file=‘’, master_log_pos= 4, master_bind=‘’. New state master_host=‘’, master_port= 0, master_log_file=‘’, master_log_pos= 4, master_bind=‘’.
2021-12-16 08:13:41.841714 [Error] [MY-013124] Slave SQL for channel ‘group_replication_applier’: Slave failed to initialize relay log info structure from the repository, Error_code: MY-013124
2021-12-16 08:13:41.841743 [Error] [MY-011534] Plugin group_replication reported: ‘Error while starting the group replication applier thread’
2021-12-16 08:13:41.841852 [Error] [MY-011669] Plugin group_replication reported: ‘Unable to initialize the Group Replication applier module.’
2021-12-16 08:13:41.841955 [Error] [MY-011735] Plugin group_replication reported: ‘[GCS] The member is leaving a group without being on one.’
Dba.createCluster: Group Replication failed to start: MySQL Error 3094 (HY000): DB1DRINT:3306: The START GROUP_REPLICATION command failed as the applier module failed to start. (RuntimeError)
MySQL DB1DRINT:3306 ssl JS >

1 Like
2

Hi @vic1972

This seems like you have some left over configuration from the source server. Can you please execute:

STOP SLAVE;
RESET SLAVE ALL;

Then try to create your cluster?

2 Likes
3

Great!! You made my day!!

Thanks very much!!

Is its working now.

Now I can continue with the setup.

Thanks again one more time.

MySQL DB1DRINT:3306 ssl JS > cluster = dba.createCluster(‘mysqlClusterOTAP’);

A new InnoDB cluster will be created on instance ‘DB1DRINT:3306’.

Validating instance configuration at DB1DRINT:3306


This instance reports its own address as DB1DRINT:3306

Instance configuration is suitable.

NOTE: Group Replication will communicate with other members using ‘DB1DRINT:33061’. Use the localAddress option to override.

Creating InnoDB cluster ‘mysqlClusterOTAP’ on ‘DB1DRINT:3306’


Adding Seed Instance


NOTE: Metadata schema found in target instance

Cluster successfully created. Use Cluster.addInstance() to add MySQL instances.

At least 3 instances are needed for the cluster to be able to withstand up to

one server failure.

Cluster:mysqlClusterOTAP

MySQL DB1DRINT:3306 ssl JS >

1 Like