Do I need to backup the MTP database?

Document ID : KB000045425
Last Modified Date : 14/02/2018
Show Technical Document Details

Introduction: 

The MTP database consists of the MySQL database that stores data related to the ADA/SSO integration and Vertica that stores the actual data provided my the MTP.

Question: 

Do I need to backup the MTP database?

Environment:  

MTP, any version

Answer: 

Currently, there is no support in the MTP software for performing a backup of the Vertica data nor are there any best practices documented if you want to try it yourself.  The main considerations for this are:

  • The huge amount of data involved.
  • The data changes rapidly and is not kept for extended periods of time (default is 7 days).
  • It’s not clear that a backup could be reliably done without shutting down the database.
  • If it is attempted without shutting down the database, performing the backup could cause a significant performance hit to storing new metrics or running the Analysis tab queries.