Re:Imaging mounted disk volumes under duress
by rwmj on Wednesday September 22, 2021 @06:38AM
(#28614845)
No one is doubting that databases are crash consistent. But if you read the other replies in this thread you can see there are still advantages to doing the backup in cooperation with the userspace programs, eg in time taken to restore instead of having to do full WAL replay. That's ignoring the non-database cases too.
[ Parent
| on HN ]
Re:Imaging mounted disk volumes under duress
by rfjakob on Wednesday September 22, 2021 @07:08AM
(#28615039)
I think I saw Oracle mentioned earlier, this has some info about the VSS integration. It's called 'Oracle VSS Writer': https://docs.oracle.com/database/121/NTQRF/vss.htm#BEIJJCAE
I guess MS-SQL does something similar, and that does seem useful beyond what LVM does.
Also VSS apparently can offload the snapshotting to a SAN ('VSS Hardware Provider'): https://docs.microsoft.com/en-us/windows-server/storage/file...