IPP Software Navigation Tools IPP Links Communication Pan-STARRS Links

Changes between Version 11 and Version 12 of DatabaseBackups


Ignore:
Timestamp:
Apr 7, 2011, 12:19:20 PM (15 years ago)
Author:
Serge CHASTEL
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • DatabaseBackups

    v11 v12  
    3232'''Note:''' The validity of the ippdb01-gpc1.dump.gz file can be asserted via its MD5 checksum (stored in ippdb01-gpc1.md5 and distributed in the same place rsync://ipp0012.ifa.hawaii.edu/ippdb/ippdb01-gpc1.md5)
    3333
    34 For reference, all of the various ipp mysql databases are now being dumped to /data/ipp001.0/ipp/mysql-dumps, and these above are linked into the 'distribution' subdirectory, which is made visible via the rsync server.  We are moving to a system of keeping a sampling of the old databases with the following timescales:
     34= Other =
     35
     36== For reference ==
     37All of the various ipp mysql databases are now being dumped to /data/ipp001.0/ipp/mysql-dumps, and these above are linked into the 'distribution' subdirectory, which is made visible via the rsync server.  We are moving to a system of keeping a sampling of the old databases with the following timescales:
    3538
    3639 * all backups for the past 5 days (~20 copies)
     
    4043
    4144(currently, we are keeping all of the old copies with a linear spacing...)
     45
     46== Monitoring ==
     47
     48Log files (the best is to check in the relevant crontab though):
     49
     50 * gcp1:
     51{{{
     52ippc02:/export/ippc02.0/mysql-dumps/gpc1_dump.log
     53ipp001:/home/panstarrs/ipp/mysql-dump/gpc1_install.log
     54}}}
     55
     56 * nebulous:
     57{{{
     58ippdb02:/export/ippdb02.0/mysql-dumps/neb_dump.log
     59ipp001:/home/panstarrs/ipp/mysql-dump/neb_copy.log
     60}}}
     61