试题详情


Choose the best answer.
You have a MySQL system with 500 GB of data that needs frequent backups. You use a mix of MyISAM and InnoDB storage engines for your data.
Examine your backup requirements:
·The MySQL system being backed up can never be unavailable or locked to the client applications.
·The recovery from the backup must work on any system.
·Only 1 hour of data can be lost on recovery of the backup.
Which option fulfills all backup requirements?

ATake a physical backup of the MySQL system.

BTake a logical backup of the MySQL system.

CUse the Clone Plugin to copy the data to another MySQL system.

DTake your backup from a slave of the MySQL system.