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

[#2]

Hi Lakshmikandh,

I was wondering if you ever got this question answered as I am looking into it as well..

Currently we are planning to backup the production site and try to restore it on a Test server.

Any guidance or feedback on this would be most helpful.

Thanks

Simy

[reshma_km]

Hi,

I am also looking for this information. Could anyone please help?

[prashanthi_gn]

We have tried implementing the DR set up.

We have replicated the postgresql and set up a robocopy of the qliksense shared folder scheduled  ever night.

Follow the steps for database replication and failover.

https://help.qlik.com/en-US/sense/February2019/Subsystems/PlanningQlikSenseDeployments/Content/Sense...

[prashanthi_gn]

Now it's a manual process to flipover to Dr setup.

There is lot of manual intervention.

Has anyone tried automating the setup?

[s_kabir_rab]

It all depends on how you have deployed your environment, how many nodes are you using, are you using dedicated PostgreSQL server etc. For a true failover you will need dedicated PostgreSQL server. Having shared persistence set up using dedicated file server is the way to go.

We have automated deployment of Qlik Sense sites with DR in mind but the architecture patterns are different from site to site depending on your various factors (usually cost being the main factor..).

Kabir

[prashanthi_gn]

Kabir,

 Thank you very much for the response .

PostgreSQL db is local to central . We have 1 central and 5 rim nodes in prod and same as DR.

In our current setup we are replicating the db to DR central and Installed the application in the rim node  and set all the services to manual except DR PostgreSQL . At the time of Fail-over , we have to flip the DR load-balancing url and set all the services to auto delay and configure in the QMC.

Application data is scheduled daily to get copied to DR servers.

This is a laborious process. looking for a automation steps. PROD is in sync to DR. 

[Daniele_Purrone]

Hi @prashanthi_gn , I would say that one way to go would be to setup a standalone PostgreSQL server of your own and use any third party replication tool that you might find more suitable:
https://wiki.postgresql.org/wiki/Replication,_Clustering,_and_Connection_Pooling

[witty]

What files/data does actually need backing up? is Postgres enough or do we need local files on the shared file repository/the nodes?

Do you have a support documentation on how to restore a system to attempt testing using the backup?

[s_kabir_rab]

Hi,

I have wrote a blog on site backup automation. I will share the link once I get on my laptop. I will look at a replication pattern for you when I get on my laptop.