mysql8.0英文考试第1-5题

Q1.   Examine this command, which executes successfully:

mysqlbackup --user=dba --password --port=3306 --with-timestamp --backup-dir=/export/backups backup-and-apply-log

Which statement is true?

A)The backup accesses the MySQL server files by using a pre-existing connection.

B)The database server is put into a read-only state for the duration of the backup.

C)An offline backup of InnoDB tables is taken.

D)The backup can be impacted when DDL operations run during the backup.

详解：

参见《MySQL8.0 for Database Administrators studentGuide 2》243页

While the non-InnoDB backup runs:

— Prior to version 8.0.16, the database cannot be modified

— As of version 8.0.16, only non-InnoDB tables cannot be modified and InnoDB tables allow DML operations but not DDL operations

Answer:D

Q2.You reconfigure and start a slave that was not replicating for several days.

The configuration file and CHANGE MASTER command are correct. Examine the GTID information from both master and slave:

Master:

Gtids_executed:  aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-321,

                 bbbbbbbb-bbbb-bbbb-bbbbbbbbbbbb:1-50,

                 Cccccccc-cccc-cccc-cccc-cccccccccccc:1234-1237

Gtids_purged:  aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-100,

bbbbbbbb-bbbb-bbbb-bbbbbbbbbbbb:1-10,

                cccccccc-cccc-cccc-cccc-cccccccccccc:1234-1237

Slave:

Gtids_executed:  aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-160,

                 cccccccc-cccc-cccc-cccc-cccccccccccc:1234-1237

Gtids_purged:  aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-70,