Skip to main content
Sep 27, 2022 8:58 AM UTC
Solved

Can we use RDS as complete DB for thingworx foundation?

I have a few applications which have heavy queries to read and write the stream data also complex services/mashups as well. Now, We have DB and TWX foundation both in the same EC2 instance. 

 

To reduce the load I would like to move my entire DB to AWS RDS PSQL.  It is good to proceed with this approach or should I create a separate EC2 instance to host my Postgres?

Also, We have manufacturing apps in the instance it has custom tables in the main DB. 

 

Changing the stream data to another DB is not helping I tried to use an external DB as ThingworxPersistenceProvider, it is reducing the load but still, due to a load of services and application model postgres service consumes high cpu utilization. 

sabhareesAnswer
Sep 28, 2022 3:42 PM UTC

I have received information from platform support team like AWS RDS is not officially supported by the support matrix of thingworx.

3 replies

Sep 28, 2022 3:39 PM UTC

AWS RDS should be fine, Just make sure you have a compatible version of Postgres provided.

sabhareesAuthorAnswer
Sep 28, 2022 3:42 PM UTC

I have received information from platform support team like AWS RDS is not officially supported by the support matrix of thingworx.

Sep 28, 2022 7:34 PM UTC

That is unfortunate, I do know it works (I've done some projects with AWS RDS) but if it is not officially supported, it would make it hard to get official technical support from PTC.