多选题

Choose two.
You have an InnoDB Cluster configured with three servers. 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?

ARemove the group replication plugin from each instance before restoring.

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

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

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

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

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

查看答案

正确答案：A （备注：此答案有误）

相似试题

单选题

You should choose a dentist in _____ the same way as you choose a physician, get the names of two or three dentists from friends and relatives and have a preliminary visit with each.

答案解析
单选题

Choose two.You have an installation of MySQL 8 on Oracle Linux.Which statement is true about disk temporary tables for this installation?

答案解析
多选题

Choose two.You are investigating performance problems in a MySQL database; all data fits in memory. You determine that SELECT queries to one table is the main cause for poor response times. Which two have the biggest potential for eliminating the problem?

答案解析
单选题

You have failed two tests. You’d better start working harder , you won’t pass the course.

答案解析
多选题

Choose two.You are using mysqlcheck for server maintenance. Which two statements are true?

答案解析