Back up a single database from a multi-database MySQL instance on a schedule. Backups must complete quickly and must not impact disk performance. How should you configure storage?
Choose an answer
Tap an option to check your answer.
Correct answer: Mount a Local SSD on the instance for backup output and move backups to Cloud Storage with gsutil after completion..
Why this is the answer
Mounting a Local SSD for backup output and then moving backups to Cloud Storage with gsutil is the best solution because Local SSDs offer extremely high IOPS and throughput, ensuring backups complete quickly without impacting the primary database's disk performance. After the fast local backup, gsutil efficiently transfers the data to cost-effective and durable Cloud Storage. Persistent disk snapshots (option 1) back up the entire disk, not just a single database, and can cause brief I/O pauses. Writing directly to a gcsfuse-mounted bucket (option 3) can be slow and impact database performance due to network latency. RAID10 with LVM snapshots (option 4) adds complexity and cost, and LVM snapshots still involve the primary disk, potentially impacting performance.
Pass your exam — without the endless answer hunt
Get every verified question and explanation for this exam in one place, and save hours of prep. 1,000+ certifications · 20+ languages · free to start.
Pass your exam faster → No card needed