I have a ESXi host with both Windows and CentOS virtual machines running. A couple of them are running SQL Databases (MSSQL and MySQL). I am trying to setup a backup strategy using the ghettoVCB script, I have successfully executed the backups and ready to test the restore functions. ghettoVCB takes backups of the VM without taking them offline by creating a snapshot of the running machine and then deleting it after a successful backup.
Since the resulting backup is an offline VM wouldn't that harm the consistency of the databases (and other applications running at the time of the snapshot) ? Is it reliable to use this snapshots as a backup ?