Skip to main content
Best answer by mnarang

Even there is mention about other DB as well (MSSQL) - https://support.ptc.com/help/thingworx/platform/r9/en/#page/ThingWorx%2FHelp%2FThingWorxHighAvailability%2FMicrosoftSQLServerHighAvailability.html%23

ThingWorx 9.x HA active active can have MSSQL as persistence provider.

2 replies

5-Regular Member
February 9, 2021

@svisveswaraiya_285988 Thanks for opening this post on community.

 

You can refer ThingWorx Hing Availability setup guide for this. Check the below help center link:

https://support.ptc.com/help/thingworx/platform/r9/en/index.html#page/ThingWorx%2FHelp%2FThingWorxHighAvailability%2FOverviewOfThingworxHighAvailability.html%23

 

Do let me know in case of any question.

Regards,

Mohit

1-Visitor
February 9, 2021

Hi @mgoel ,

Thanks for your swift response. We have two server in which there are two different version of ThingWorx (9.0 and 9.1). Does it support when there are two different versions?

5-Regular Member
February 9, 2021

Just to clear there are two HA architecture, the link which is shared above is for HA active-active (introduced from ThingWorx 9.0) in which you can have multiple ThingWorx nodes running in parallel. And this architecture have same DB (schema) for all the nodes, so that all the nodes are in sync( using distributed cache -ignite). So the answer is if you want to implement this architecture you should have same ThingWrox versions on all the nodes.

Community Manager
February 18, 2021

Hi @svisveswaraiya_285988

 

If you feel your question has been answered, please mark the appropriate response as the Accepted Solution for the benefit of others with the same question.

 

Regards.

 

--Sharon