The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.
Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!
Can you put a vertica host in hot-backup mode ? (quiesce)
Hi,
we have a customer that would like to backup his vertica databases with our netapp snapshot technology. We basicly are able to capture the database files as a whole within a few seconds. Typically databases like sql, mysql, oracle, etc... allow to put the host in hot-backup mode or quiesce mode. The host would then temporarily freeze, flush memory to disks. We take a snapshot withing a second. and then request the host to unquiesce and proceed to normal. Any client would just have a freeze of a few seconds and a full backup would have been taken. Additionally, if the database uses log-files, a snapshot of the log files can also be taken. would vertica be able to do this ? with an api, a script, cli, ... ?
1
Answers
I think you can do this for EON mode DB, check https://www.vertica.com/docs/9.2.x/HTML/Content/Authoring/AdministratorsGuide/BackupRestore/CommonUseCases.htm