-
- Veteran
- Posts: 283
- Liked: 11 times
- Joined: May 20, 2010 4:17 pm
- Full Name: Dave DeLollis
- Contact:
Backing up MYSQL databases and VSS
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?
Any thoughts?
-
- 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
Hello Dave,
Try running the following two commands in the VM and see if output contains any MySQL VSS related writers and 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!
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
Here is a existing thread that that should be relevant for you:
http://www.veeam.com/forums/viewtopic.p ... sql#p15101
Hope it helps!
-
- 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
[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?
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?
-
- Veeam ProPartner
- Posts: 71
- Liked: 12 times
- Joined: Jun 11, 2012 12:04 pm
- Contact:
[MERGED] Is there Support for DB2 & MySQL ?
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.
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
@shatztal
Blog: http://www.terasky.com
-
- 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
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.
Same approach should be used for Windows instance as well, without any differences (same prefreeze/postthaw scripts as described).
Hope this helps.
Thanks.
-
- Lurker
- Posts: 1
- Liked: never
- Joined: Jan 24, 2013 10:34 pm
- Full Name: Mike
- Contact:
Re: Backing up MYSQL databases and VSS
The link seems to be broken.
Who is online
Users browsing this forum: Bing [Bot], Google [Bot], Semrush [Bot] and 96 guests