1Z0-908: MySQL 8.0 Database AdministratorDemo

By Oracle · Question Mode

QuestionQ213

Backup and Recovery

You have a MySQL system containing 500 GB of data that requires frequent backups.

You use a combination of MyISAM and InnoDB storage engines for the data.

Review the backup requirements:

  • The MySQL system being backed up must never be unavailable or locked to client applications.
  • Recovery from the backup must function on any system.
  • No more than 1 hour of data may be lost when recovering from the backup.

Which option meets all backup requirements?

  • A Take a physical backup of the MySQL system.
  • B Use the Clone Plugin to copy the data to another MySQL system.
  • C Take a logical backup of the MySQL system.
  • D Take your backup from a slave of the MySQL system.
Explanation

A replica can be taken offline or locked for a consistent backup without disrupting client access to the source MySQL system. A logical backup made from that replica is portable because it contains SQL definitions and data rather than server-specific data files. Running the replica backup at least every hour limits the potential data loss to one hour. MySQL documentation identifies replication as a way to create backups with no impact on the source, while consistent logical backups that include nontransactional MyISAM tables cannot rely on lock-free transactional snapshots alone.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!