Qlik Community

Deployment & Management

Discussion board where members learn more about Qlik Sense Installation, Deployment and Management.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
lakshmikandh
Specialist II
Specialist II

Disaster Recovery setup for Qliksense server

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

13 Replies
Not applicable

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
Partner
Partner

Hi,

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

prashanthi_gn
Contributor III
Contributor III

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
Contributor III
Contributor III

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
Luminary Alumni
Luminary Alumni

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
Kabir
Please do not forget to the mark the post if you find it useful or provides you the solutions 🙂
prashanthi_gn
Contributor III
Contributor III

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
Support
Support

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

Daniele - Senior Technical Support Engineer & SaaS Support Coordinator at Qlik
If a post helps to resolve your issue, please accept it as a Solution.
witty
Contributor III
Contributor III

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
Luminary Alumni
Luminary Alumni

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.
Kabir
Please do not forget to the mark the post if you find it useful or provides you the solutions 🙂