Skip to main content
pshashipreetham
pshashipreetham19-Tanzanite
19-Tanzanite
Oct 25, 2023 9:34 AM UTC
Solved

Single DB for Two Thingworx Instances

Hi,

 

I look forward to doing a minimal Connection Server installation due to high traffic to the Thingworx Platform.

 

Present Scenario: 1 Thingworx Instance with 1 Postgres DB & 1 Influx DB

Required Scenario: 1 Connection Server with 2 Thingworx Platforms with 1 Postgres DB & 1 Influx DB

 

Can the required Scenario be achievable with 1 Postgres DB and 1 Influx DB for both Thingworx Instances? and is it a best practise?

 

Thanks,

 

 

pshashipreetham
pshashipreethamAnswer
19-Tanzanite
Nov 4, 2023 12:18 PM UTC

With the help of @Jimwang and after lots of documentation searches on the PTC Knowledge base, concluded below.

pshashipreetham_0-1699100313022.png

 

Shashi Preetham || +91 8099838801 || shashi@psptechhub.com
View in thread

6 replies

Jimwang16-Pearl
16-Pearl
Oct 25, 2023 10:00 AM UTC

Technically you can use one Postgresql for multiple Thingworx instances as long as the Thingworx instances are using different Database/schema. For example, your postgresql instance has two Databases dB1 and dB2, each Thingworx instance connects to its own database dB1 and dB2 respectively.

However, this is not a good best practices, especially for production system, for example, if you need to restart the postgresql, all the Thingworx instances are impacted.

 

Translate
    pshashipreetham
    pshashipreetham19-TanzaniteAuthor
    19-Tanzanite
    Oct 25, 2023 11:47 AM UTC

    hi @Jimwang ,

     

    Thanks for the quick response. Do we also need the Zoo keeper if we are using the Connection Server?

     

    Thanks,

    Translate
    Shashi Preetham || +91 8099838801 || shashi@psptechhub.com
    Jimwang16-Pearl
    16-Pearl
    Oct 26, 2023 12:27 AM UTC

    If your Thingworx Platforms are configured as High Availability Cluster, yes, it is required to install Zookeeper, otherwise, you don't need to use zookeeper

    Translate
      pshashipreetham
      pshashipreetham19-TanzaniteAuthorAnswer
      19-Tanzanite
      Nov 4, 2023 12:18 PM UTC

      With the help of @Jimwang and after lots of documentation searches on the PTC Knowledge base, concluded below.

      pshashipreetham_0-1699100313022.png

       

      Translate
      Shashi Preetham || +91 8099838801 || shashi@psptechhub.com
        Terms & ConditionsAccessibility statement