Comprehensive data protection for all workloads
Post Reply
Daveyd
Veteran
Posts: 283
Liked: 11 times
Joined: May 20, 2010 4:17 pm
Full Name: Dave DeLollis
Contact:

Backing up MYSQL databases and VSS

Post by Daveyd »

I am in a trial version of Veeam and have several Windows 2008 x64 VMs that use MYSQL databases pretty hard. I would like to backup the enire VMs with precautions since theses are very important VMs. I was not sure is MYSQL is VSS aware or not and was not sure what option in Veeam to choose when doing the VM level backups...Enable VM Tools quiescence or Enable Veeam VSS integration. I would like a transactionally consistent backup if possible but don't know if that is possible for MYSQL.

Any thoughts?
Vitaliy S.
VP, Product Management
Posts: 27365
Liked: 2794 times
Joined: Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov
Contact:

Re: Backing up MYSQL databases and VSS

Post by Vitaliy S. »

Hello Dave,

Try running the following two commands in the VM and see if output contains any MySQL VSS related writers and providers:

Code: Select all

vssadmin list writers
vssadmin list providers
But as far as I know, MySQL doesn't have any VSS writers, so you should you use VMware Tools quiescence with pre-freeze and post-thaw scripts to keep your application in consistent state.

Here is a existing thread that that should be relevant for you:
http://www.veeam.com/forums/viewtopic.p ... sql#p15101

Hope it helps!
habibalby
Veteran
Posts: 392
Liked: 33 times
Joined: Jul 18, 2011 9:30 am
Full Name: Hussain Al Sayed
Location: Bahrain
Contact:

Backing Up MySQL on Windows Server

Post by habibalby »

[merged]

Hi Guys,

I have several Windows Servers installed with MYSQL, when I back them up using Application-Aware feature, will VSS consider MYSQL for the backup or I have to go through the batch script to backup the DB or VMToos post-script?
skydok
Veeam ProPartner
Posts: 71
Liked: 12 times
Joined: Jun 11, 2012 12:04 pm
Contact:

[MERGED] Is there Support for DB2 & MySQL ?

Post by skydok »

Hello,
i Have a Customer with MySQL& DB2 Databases on Windows Servers and wanted to know if Veeam does know how to create a Consistent Backup? Also Regarding Replication.
Veeam FAN
@shatztal
Blog: http://www.terasky.com
veremin
Product Manager
Posts: 20385
Liked: 2295 times
Joined: Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin
Contact:

Re: Backing up MYSQL databases and VSS

Post by veremin »

Additionally, there is a dedicated white paper regarding backing up MySQL server residing on Linux VM. It can be found here.

Same approach should be used for Windows instance as well, without any differences (same prefreeze/postthaw scripts as described).

Hope this helps.
Thanks.
mikents
Lurker
Posts: 1
Liked: never
Joined: Jan 24, 2013 10:34 pm
Full Name: Mike
Contact:

Re: Backing up MYSQL databases and VSS

Post by mikents »

The link seems to be broken.
Post Reply

Who is online

Users browsing this forum: Bing [Bot], Google [Bot], Semrush [Bot] and 96 guests