Planning the DBMS backup
Gather information to prepare the PingDataMetrics server DBMS backup.
About this task
To prepare for backing up the PingDataMetrics DBMS, pick a time to backup, ensure you have enough space, and review additional data from sample deployments.
Steps
-
Choose a time window during which the PingDataMetrics server can be offline.
-
Ensure there is enough disk space to hold the new image.
The exact size of a DBMS table and its corresponding backup depends on the number of monitored servers, the number of tracked applications, the collected metrics, and the retention duration for each of the aggregation levels.
The following table provides values from installations used during testing.
Data 25 monitored servers 50 monitored servers 1 minute data retention
14 days
14 days
1 hour data retention
52 weeks
52 weeks
1 day data retention
20 years
20 years
1 second table size
22 G
42 G
1 minute table size
8 G
18 G
1 hour table size
4 G (estimated)
9 G (estimated)
1 day data retention
4 G (estimated)
7 G (estimated)
time to backup
15 minutes (estimated)
30 minutes (estimated)
time for import catchup
10 minutes
42 minutes
size of compressed backup image
3 G (estimated)
Step 5.5 G (estimated)
time to restore
1 hour (estimated)
2 h (estimated)
If no backups are performed and the DBMS is completely lost, reinitialize the DBMS, restart the PingDataMetrics server, and start collecting data again. All collected metric and event data are lost, but the configuration required to start collecting data again is retained.