Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

Alteryx Server Discussions

Find answers, ask questions, and share expertise about Alteryx Server.
SOLVED

VM Snapshot of Active Alteryx Server = Restoring Snapshot to Alternate VM & validate

sgabriel62
7 - Meteor

Has anyone taken a VMWare level snapshot of the Alteryx Controller Server, taken its vmdk file and restored it to an alternate VM and brought up Alteryx?

I am looking to see or if anyone knows whether or not Alteryx is quiesced at time of the snapshot creation - or does it remain running producing a "fuzzy snapshot".

If the answer is yes to the the first - then I have a solution for DR we can potentially use - if the result is fuzzy how unusable is it?   Will it require a second MongoDB restore prior to starting the service.

Are there "online" or "hot backup" options vs running the complete dump process?

Steve

1 REPLY 1
KevinP
Alteryx Alumni (Retired)

@sgabriel62 It is not recommended to take snapshots of the VM while the AlteryxService is up and running this can cause issues with the service including crashes, and it could lead to data corruption as the database may have pending writes at the time the snapshot is taken. Instead of snapshots we recommend following the backup process outlined in the following KB article.

 

https://community.alteryx.com/t5/Alteryx-Server-Knowledge-Base/Alteryx-Server-Backup-amp-Recovery-Pa...

 

If you must take a snapshot per your corporate policy please schedule maintenance windows to do so and stop our services prior to the snapshot being performed.

 

To answer your additional questions on restoring the service from a snapshot or virtual disk this hasn't been tested and wouldn't be supported. However, that being said it is very likely these restores will be problematic for a number or reasons. As indicated above the database state will likely be inconsistent. Also if the machine information changes your license may become locked needing intervention to release/reuse it. Then there is the question of encrypted credential information in the database. This sensitive information is encrypted using a machine key specific to the server the data was created on. Unless some specific precautions are taken that data may become permanently locked. Also at this time there are no options for a live/hot backup of the server's database