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.
Do I need to backup the MTP database?
MTP, any version
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.