Snapshoting virtual machine running mysql database

Backup in virtualized enviroment is mostly based on snapshoting entire virtual machine and saving this state to backup repository. This snapshot does not include memory of virtual machine. When you restore virtual machine from this snapshot filesystem is in unclean state, but journal filesystem can handle this. From mysql point of view server crash happended and database can be corrupted and unrecoverable, depending on what queries where running during snapshot. This unpredicted and unconsistent state you don’t want to have as a backup of your data. Continue reading

VMware backup script

I have been searching for simple and easy script to backup selected virtual machines running on esxi server, which will:

  • run on linux – do not require windows machine; can’t use PowerCLI
  • do not require direct access to esxi host using ssh (as other backups scripts likeĀ ghettoVCB.sh do) and will use API
  • support multiple esxi hosts managed by vcenter
  • have clear code – that means no perl hell (including big vsphere perl sdk)
  • have short code
  • can be put into cron

I was unable to find any to comply my requirements. I’m learning python, so I searched for some python vsphere libs and found psphere. ThenĀ backup.py has born.

Continue reading