No-downtime MySQL backup (InnoDB/InnoBackupEx)
The high prevalence of MySQL databases leads to their usage in increasingly diverse projects, including those that require nonstop operation and minimal recovery time. Standard tools, such as mysqldump are inconvenient for the use in large databases that can reach tens of gigabytes. If you can still export the data in the reasonable time of a few hours, the restore operation can take tens of hours. Also, using mysqldump to backup causes table locks (making downtime during backup) and can be followed by data inconsistency in backup copy.