Backup & Recovery — Concept Check
Questions on Backup & Recovery. mysqldump for logical backups; Percona XtraBackup for hot physical backups; binary log point-in-time recovery complements full backups to minimise data loss on failure.
Questions in this quiz
8 questions on Backup & Recovery — Concept Check. Work through them here, then start the quiz to answer them and see your score.
1.Your MySQL database is 200 GB and you need to perform a backup without downtime. Which tool should you use?
- Amysqldump with --single-transaction
- BManual file copy
- CPercona XtraBackup
- Dmysqldump without any options
2.A MySQL database backup is taken using mysqldump with --master-data=2. What does this option do?
- AEnables compression of the backup
- BLocks tables during the backup
- CExports data in CSV format
- DRecords the binary log position for PITR
3.You have a full backup and need to reduce the backup window for your 150 GB database. What should you do?
- ASwitch to mysqldump for faster backups
- BPerform manual backups more frequently
- CUse incremental backups with Percona XtraBackup
- DUse mysqldump with --quick option
4.After restoring a backup, you need to recover data up to a specific point in time. What should you use?
- ASlow query logs for point-in-time recovery
- BRedo logs for point-in-time recovery
- CError logs for point-in-time recovery
- DBinary logs for point-in-time recovery
5.You want to ensure minimal data loss in case of a failure. Which strategy should you adopt?
- ADaily logical backups with mysqldump only
- BMonthly physical backups with Percona XtraBackup only
- CNightly full backups with continuous binlog archiving
- DWeekly full backups with no binlog archiving
6.A colleague suggests using mysqldump for a 300 GB production database backup. Why might this be a poor choice?
- Amysqldump requires downtime
- Bmysqldump doesn't support InnoDB tables
- Cmysqldump is too slow for large databases
- Dmysqldump cannot export triggers
7.You notice that your binary logs are filling up disk space quickly. What configuration change can help manage this?
- ADisable binary logging
- BSet sync_binlog to 0
- CIncrease the binlog_format to STATEMENT
- DSet expire_logs_days in my.cnf
8.What is a potential risk of not enabling binary logging in a MySQL production environment?
- AIncreased risk of data corruption
- BSlower query performance
- CIncreased storage requirements
- DInability to perform point-in-time recovery