You have an InnoDB Cluster configured with three servers.

Oracle 1z0-908 Question Answer

Examine this command, which executes successfully:

mysqldump -uroot -p -d mydatabase > mydatabase_backup.sql

Due to data loss, the cluster is initialized and a restore is attempted resulting in this error:

ERROR 13176 (HY000) at line 23: Cannot update GTID_PURGED with the Group Replication plugin running

Which two actions, either one of which, can fix this error and allow a successful restore of the cluster? (Choose two.)

Stop all instances except the primary read/write master instance and run the restore.

Remove the @@GLOBAL.gtid_purged statement from the dump file.

Create the backup by using the --set-gtid-purged=OFF option.

Remove the group replication plugin from each instance before restoring.

Remove the @@GLOBAL.gtid_executed statement from the dump file.

Restore using the --set-gtid-purged=OFF option.

1z0-908 PDF/Engine

Get 65% Discount on All Products, Use Coupon: "ac4s65"