Backup and recovery with MySQL community edition: expectations and reality

This publication explores backup and recovery capabilities of the most popular database management system - MySQL Community Edition. Available backup types are categorized and compared theoretically. Experiments are conducted to measure the capabilities of each backup and recovery method. Knowing these characteristics could help choosing backup type, storage engine (MyISAM or InnoDB) and MySQL settings that would be most suitable for business needs. Conducted experiments combined with analytical approach can lead to building effective backup and recovery strategies