Bug #35668 add support for microsoft volume shadow copy services as windows backup method
Submitted: 29 Mar 2008 11:03 Modified: 30 Mar 2008 19:36
Reporter: Shane Bester (Platinum Quality Contributor) Email Updates:
Status: Verified Impact on me:
Category:MySQL Server: Windows Severity:S4 (Feature request)
Version:5.7 OS:Windows
Assigned to: Assigned Account CPU Architecture:Any
Tags: volume shadow copy services, vss

[29 Mar 2008 11:03] Shane Bester
this is a request to make mysql server vss-aware on windows.

add support for microsoft's volume shadow copy services as backup method on windows platforms.

How to repeat:
some info about vss:


Suggested fix:
[30 Mar 2008 19:36] Valeriy Kravchuk
Thank you for a reasonable feature request.
[25 Mar 2010 4:25] Roel Van de Paar
Ideally an application takes a "stop all writes" instruction (i.e. "VSS Aware"), but pending that (i.e. this bug), there are some other things that can be done. If anyone is interested, add a note and I will provide some instructions.
[28 Nov 2013 20:07] MySQL Verification Team
[7 Mar 2015 14:59] David Spector
This is a verified bug from 7 years ago, not marked as fixed. Can I infer that MySQL version 5 still will not flush its buffers to disk when a backup program requests a Volume Shadow Copy? This could produce old or inconsistent backup files for MySQL on a Windows computer without a manual flush by the user or computer operator. Seems pretty serious to me.
[3 Sep 2018 12:26] robert ivanc
it's now more than 10 years since the opening of this bug, perhaps we could see some progress?
[3 Sep 2018 13:30] Marcus Bianchy
I am using "flush tables with read lock;" before a volume snapshot (either Windows VSS or Linux LVM) and "unlock tables;" after to have a consistent backup where I can use filecopy/mysqldump/whatever-tools-suits. 

I wonder there is a need for more than that? 
(P.S.: I'm backing up MySQL databases for more than 10 years with this)
[3 Sep 2018 13:46] David Spector
Marcus, I do that too. But it would be nice if the MySQL maintainers would update MySQL to coexist with Windows.
[3 Sep 2018 14:09] Marcus Bianchy
But wouldn't that mean any other snapshot integration (LVM or any filesystem supporting it) on any platform (well, the most usual platforms) should also be supported? In my opinion too much overhead while a platform independent solution already exists for ages?
[3 Sep 2018 14:36] David Spector
Shane, Such a discussion is off-topic for a bug reporting system. I will observe, though, that only the most popular OSs tend to impose such difficult requirements on their applications. That has benefits and drawbacks and it's part of life.