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 requirement:
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?
To fulfill all the backup requirements for your MySQL system, taking your backup from a slave of the MySQL system is the best option. This ensures that the primary MySQL system remains available and unlocked for client applications, adhering to the requirement that the system can never be unavailable or locked. Since the backup is performed on a slave, it naturally supports recovery on another system and aligns with only losing at most one hour of data, given that MySQL replication typically handles this efficiently. This approach avoids the limitations and potential downtime associated with physical and logical backups and the challenges of the Clone Plugin.
B or D, but clone has limitations, so D
Answer should be D