1.

Which of the following is the final method to create MySQL backups?(a) LVM snapshots(b) SQL backups(c) CSV backups(d) File backupsThis question was addressed to me in an online interview.This is a very interesting question from Web Performance Optimization in portion HTML Images & Web Page Files of HTML

Answer»

Right answer is (a) LVM snapshots

Explanation: Copy of data or else DATABASE is known as backup. The final method for creating MySQL BACKUPS is LVM snapshots. It uses a copy-on-write feature of storage SYSTEMS in which LVM i.e. Logical Volume Management is the most popular in Linux. It is very quick as it creates the snapshots. CSV stands for Cluster Shared VOLUMES backups. File backup is the backup of MySQL database which creates a copy of files from MySQL data directory. SQL backups are alternate to File backups.



Discussion

No Comment Found

Related InterviewSolutions