Disaster Recovery setup for Qliksense server

[lakshmikandh]

Hi All,

Does any one have Document for Qliksense Server DR setup ?

Please share the document,If you made any such type of setup.

Thanks,

Lakshmikandh

[s_kabir_rab]

Hi
@witty - Please read this blog if you are interested in blacking up a Qlik Site. I have post a PowerShell script and instruction on how this can be used to automate the Qlik Sense site backup.

https://kabonline.net/2018/05/30/qlik-sense-enterprise-backup-automation-via-powershell/

Please note - This is for shared persistence Qlik Sense deployment, where this script will allow you to back the file share and the repository database.

Hope this helps.

[s_kabir_rab]

Hi @prashanthi_gn 
Is it shared persistence? (I am presuming it is). If it is then I will look to do the following. Move the PostgreSQL to its' own dedicated environment (move it away from central node). You can set up replication of that DB to a slave node. 

Official Documentation on the replication streaming - https://www.postgresql.org/docs/9.6/protocol-replication.html

A great blog on how to achieve it - https://blog.raveland.org/post/postgresql_sr/.

Also move your file share to a dedicated file storage (if its not already set up that way). If you are on public cloud such as Azure - you can use Azure File Share, which allows you to create and automate backup of the storage in relatively simple steps . Idea is to isolate the File Storage and the DB so you can keep them in isolation of your central nodes, in case any issues with central node, you still have access to them.

This will move the headache of importing the application to the rim nodes manually. 

Hope this helps you with you setup. 

[witty]

So basically the datasources to backup are:

• actual app datasource (any DB server)
• the management Postgres (remote or local; pending the setup)
• the fileshare setup/added during installation

Is that correct?

[s_kabir_rab]

@witty - Yes, The PostgreSQL DB and the File share. Data source is not usually part of the Qlik Sense site backup process, but if they are in your environment (QVD, Flat Files etc) then yes you can back them up at the same time.