cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

DB backup

SOLVED
rleir
Amethyst

DB backup

Hi all,

We need to decide whether to put the DB for TWX Navigate on a separate server, and how often to back it up. It would be helpful if we knew what sort of info gets stored, and how big it will be.  At a guess, the data is role based user configuration and possibly some mashup config. Does any Windchill data get cached here? What else does the DB contain?

 

We will be using Postgressql. If the DB is small we can keep it local in the Navigate server, which would be convenient.  

Thanks -- Rick

Tags (2)
1 ACCEPTED SOLUTION

Accepted Solutions

Re: DB backup

The ThingWorx database stores the configuration data for ThingWorx and Navigate, users and groups, the Navigate extensions and related data such as mashups and customizations. One of the most important things is the ThingWorx encryption keystore and password, which are necessary to access anything in ThingWorx that uses a password. If you lose those, that instance of ThingWorx fails.

 

No Windchill data is permanently stored on the ThingWorx database. Some minimal temporary information is probably stored so the “RECENT” tab in the OOTB apps can be populated, but this changes with use.

 

The ThingWorx database is relatively small, and so many customers choose to install it on the same server with ThingWorx. On my own installation of Navigate 1.8 (PostgreSQL 9.4) that has been up over a year, the PostgreSQL folder (including the software as well as the data) takes up 988 MB. On my Navigate 8.5.0 using PostgreSQL 10 it is 650 MB.

 

Another consideration is performance. In extreme cases where ThingWorx and the database are installed on separate servers, in separate datacenters, at opposite ends of the country, Internet lag sometimes makes performance atrocious. Being in the same datacenter greatly improves that issue, and being on the same server may provide a small improvement over that. The same goes for where ThingWorx is installed in relation to Windchill. Cross-country datacenters have caused some serious lag issues.

 

Backup frequency is really a matter for your Disaster Recovery policy and risk management. While you don’t have any “business data” stored in the ThingWorx DB (its all in Windchill), how long it would take to restore the DB and update anything since the last backup would determine (in part) how long the system was down for users. The most critical information for that purpose is the encryption keystore/password. If you don’t have a backup of those that is current and reliable, you will most likely be doing a re-install from scratch if you lose the database. Customizations in particular could take a substantial amount of time to redevelop.

 

A typical corporate policy for a Production environment is a weekly full backup with daily incremental backups, but policies vary. It’s a balance between risk and cost, and only you can evaluate that.

 

View solution in original post

2 REPLIES 2

Re: DB backup

The ThingWorx database stores the configuration data for ThingWorx and Navigate, users and groups, the Navigate extensions and related data such as mashups and customizations. One of the most important things is the ThingWorx encryption keystore and password, which are necessary to access anything in ThingWorx that uses a password. If you lose those, that instance of ThingWorx fails.

 

No Windchill data is permanently stored on the ThingWorx database. Some minimal temporary information is probably stored so the “RECENT” tab in the OOTB apps can be populated, but this changes with use.

 

The ThingWorx database is relatively small, and so many customers choose to install it on the same server with ThingWorx. On my own installation of Navigate 1.8 (PostgreSQL 9.4) that has been up over a year, the PostgreSQL folder (including the software as well as the data) takes up 988 MB. On my Navigate 8.5.0 using PostgreSQL 10 it is 650 MB.

 

Another consideration is performance. In extreme cases where ThingWorx and the database are installed on separate servers, in separate datacenters, at opposite ends of the country, Internet lag sometimes makes performance atrocious. Being in the same datacenter greatly improves that issue, and being on the same server may provide a small improvement over that. The same goes for where ThingWorx is installed in relation to Windchill. Cross-country datacenters have caused some serious lag issues.

 

Backup frequency is really a matter for your Disaster Recovery policy and risk management. While you don’t have any “business data” stored in the ThingWorx DB (its all in Windchill), how long it would take to restore the DB and update anything since the last backup would determine (in part) how long the system was down for users. The most critical information for that purpose is the encryption keystore/password. If you don’t have a backup of those that is current and reliable, you will most likely be doing a re-install from scratch if you lose the database. Customizations in particular could take a substantial amount of time to redevelop.

 

A typical corporate policy for a Production environment is a weekly full backup with daily incremental backups, but policies vary. It’s a balance between risk and cost, and only you can evaluate that.

 

View solution in original post

Re: DB backup

I found these references in PTC Support.

 

PTC ThingWorx Platform Backup and Recovery Planning https://www.ptc.com/support/-/media/468B44269D8041499B0161920CFE02C7.pdf?sc_lang=en

 

ThingWorx Backup and Recovery Expert Session (YouTube video) https://www.youtube.com/watch?v=iJHmGC9HfPk&list=PLz1ppcU_kaneagUT9qgQfz3HByf6-9zTF&index=20

 

These Knowledge Base articles are also available:

 

ThingWorx PostgreSQL: Best practices of Backup and Restore of the platform https://www.ptc.com/en/support/article?n=CS246598

 

Thingworx: Database corruption plan of action and precautions https://www.ptc.com/en/support/article?n=CS213733

This expert session goes over some basic backup and recovery principles, and provides details on how these principles can be applied to backing up a ThingWor...
Announcements

Check out the upcoming Expert Session: Understanding ThingWorx Navigate Licensing in Community "Customer Events" section.