OpenVZ Forum: Support » openvz6 ploop backups and mysql innodb corruption

Home » General » Support » openvz6 ploop backups and mysql innodb corruption

Show: Today's Messages :: Show Polls :: Message Navigator
E-mail to friend

Re: openvz6 ploop backups and mysql innodb corruption [message #53206 is a reply to message #53204]

Tue, 13 March 2018 03:35

Jcats
Messages: 15
Registered: May 2011
Location: FL

Junior Member

Follow up question on this and sorry if this is a dumb question but..

In https://openvz.org/Ploop/Backup#Image-based_backup

vzctl snapshot $CTID --id $ID --skip-suspend --skip-config
cp $VE_PRIVATE/root.hdd/* $BACKUPPATH/

Should we be including the snapshot in the backup itself? Wouldn't copying the snapshot be copying where any new data is taking place which is possibly why we are seeing the corruption? Maybe I'm not understand the snapshot but if we instead did..

vzctl snapshot $CTID --id $ID --skip-suspend --skip-config
tar -cvf backup.tar --exclude='./dump' --exclude='./root.hdd/root.hdd.*' $VE_PRIVATE/root.hdd/

then deleted the snapshot.

Wouldn't this method 'freeze' root.hdd basically ensuring no data will change within it while we backup the image to ensure the db integrity?

Report message to a moderator

[Message index]

		openvz6 ploop backups and mysql innodb corruption By: Jcats on Mon, 12 March 2018 19:06
		Re: openvz6 ploop backups and mysql innodb corruption By: Jcats on Tue, 13 March 2018 03:35
		Re: openvz6 ploop backups and mysql innodb corruption By: wsap on Sun, 29 April 2018 20:06
		Re: openvz6 ploop backups and mysql innodb corruption By: wsap on Sat, 19 May 2018 01:33

Previous Topic:	OpenVZ7 - Migrate options: vzmigrate, ovztransfer.sh or prlctl migrate?
Next Topic:	OpenVZ Maintenance Partnership program

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Sat Dec 06 09:41:12 GMT 2025

Total time taken to generate the page: 0.09019 seconds