AnsweredAssumed Answered

R80.x Multi-Domain backup size

Question asked by Kaspars Zibarts on Aug 21, 2017
Latest reply on Feb 7, 2018 by Kaspars Zibarts

Another question regarding R80 MDM backups. Ours has grown at the rate of 1GB per month since upgrade to R80 which seems excessive. The very first backup directly after R80 upgrade was just over 5GB and last one taken is over 11GB. Checkpoint has always been rather complacent regarding backup and it's contents - seems like directories are added in without any analyses if it's really needed or not. And no one can be bothered to make any improvements. I used to manually exclude lots of tmp files and directories to keep the backup size reasonable and even raised couple of service requests. But with R80 it got much more difficult as the main culprit is the PostgreSQL DB dump. The very first backup compressed DB was just under 300MB (mds_backup_dump.gz file within the MDS archive):

 

[Expert@mdms01:0]# ls -lh

total 5.3G
-rw-r--r-- 1 admin root 11M Mar 20 14:06 CPSmartLog-R80_opt.tgz
-rwxr-xr-x 1 admin root 261K Mar 20 13:51 gtar
-rwxr-xr-x 1 admin root 73K Mar 20 13:51 gzip

-rw-r--r-- 1 admin root 276M Mar 20 13:55 mds_backup_dump.gz
-rw-r--r-- 1 admin root 1.1G Mar 20 13:53 mds_backup_opt.tgz
-rw-r--r-- 1 admin root 129M Mar 20 14:06 mds_backup_opt_compkgs.tgz
-rw-r--r-- 1 admin root 457 Mar 20 14:05 mds_backup_supkgs.tgz
-rw-r--r-- 1 admin root 2.2K Mar 20 14:06 mds_backup_var_compkgs.tgz
-rw-r--r-- 1 admin root 3.8G Mar 20 14:05 mds_backup_varopt.tgz
-rwxr-x--- 1 admin root 18K Mar 20 13:51 mds_restore

 

and 5 months later it has grown to almost 5GB!

 

[Expert@mdms01:0]# ls -lh 

total 11G
-rw-r--r-- 1 admin root 13M Aug 15 15:06 CPSmartLog-R80_opt.tgz
-rwxr-xr-x 1 admin root 261K Aug 15 14:40 gtar
-rwxr-xr-x 1 admin root 73K Aug 15 14:40 gzip

-rw-r--r-- 1 admin root 4.6G Aug 15 14:54 mds_backup_dump.gz
-rw-r--r-- 1 admin root 1.5G Aug 15 14:43 mds_backup_opt.tgz
-rw-r--r-- 1 admin root 129M Aug 15 15:05 mds_backup_opt_compkgs.tgz
-rw-r--r-- 1 admin root 1.1K Aug 15 15:05 mds_backup_supkgs.tgz
-rw-r--r-- 1 admin root 2.2K Aug 15 15:05 mds_backup_var_compkgs.tgz
-rw-r--r-- 1 admin root 4.1G Aug 15 15:05 mds_backup_varopt.tgz
-rwxr-x--- 1 admin root 18K Aug 15 14:40 mds_restore

 

And this is running manual mds_backup trying to exclude as much as you can. 

Anyone with good tips to resolve this?

Outcomes