How does MySQL act during the PBS backup process?
- Thread starter tomassim
- Start date
Hello,
you should use a hookscript that tells MySQL to flush the tables like
As Proxmox uses various phases during the backup you could issue this command in the backup-start phase and in post-restart you should call something like
The qemu-ga needs to be running in the vm to issue commands like that via hookscript:
Depending on MySQL configuration you might need to add a user (
you should use a hookscript that tells MySQL to flush the tables like
mysql -e "FLUSH TABLES WITH READ LOCK;"As Proxmox uses various phases during the backup you could issue this command in the backup-start phase and in post-restart you should call something like
mysql -e "UNLOCK TABLES;"The qemu-ga needs to be running in the vm to issue commands like that via hookscript:
qm guest exec $VMID --timeout 300 -- mysql -e "FLUSH TABLES WITH READ LOCK;";Depending on MySQL configuration you might need to add a user (
-u <user>) which is allowed to execute these command to the databases.
Another (and for consistency propably better variant) would be to do a mysqldump on the vm before starting the actual backup on PBS.