Professional Cloud ArchitectDemo

By Google · Question Mode

QuestionQ339

Managing and provisioning a cloud solution infrastructure

A company operates several databases on a single MySQL instance. It needs to back up a particular database at regular intervals. Backup operations must finish as quickly as possible and must not affect disk performance.

How should the storage be configured?

  • A Configure a cron job to use the gcloud tool to take regular backups using persistent disk snapshots.
  • B Mount a Local SSD volume as the backup location. After the backup is complete, use gsutil to move the backup to Google Cloud Storage.
  • C Use gcsfise to mount a Google Cloud Storage bucket as a volume directly on the instance and write backups to the mounted location using mysqldump.
  • D Mount additional persistent disk volumes onto each virtual machine (VM) instance in a RAID10 array and use LVM to create snapshots to send to Cloud Storage
Explanation

Cloud Storage FUSE mounts a Cloud Storage bucket as a local filesystem path and supports writing objects through standard filesystem operations. Directing mysqldump output to that mount stores the selected database backup in Cloud Storage without first creating the backup on a local persistent disk or Local SSD, avoiding backup-related local disk performance impact.

Learn more

Community Discussion

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