Notes on the IPP Database Backup scheme

(Up to IPP for PS1)

Thanks to efforts by Cindy & Gavin, regular dumps of the two mysql databases being used by the processing system on maui (the ippdb and the nebulous database) are now being made available via the rsync server on ipp0002.ifa.hawaii.edu. These are dumped every 4 hours, and are available from the rsync location:

rsync://ipp0002.ifa.hawaii.edu/ippdb

if you want both, give a command like:

rsync -auv rsync://ipp0002.ifa.hawaii.edu/ippdb/ ippdb/

the database with the gpc1 processing information is in the file called ippdb01.dump.gz, while the nebulous database is in the dump called ippdb02.dump.gz. These gzip files are currently 2.8GB and 1.8GB, so be careful. They are also dumped every 4 hours, and the new one replaces the old name. If people are unable to retrieve these in less than the 4 hour period (~1Mbit/sec), then we can adjust the naming to keep more than one old version around.

If you want just one of the above databases, use a command like:

rsync rsync://ipp0002.ifa.hawaii.edu/ippdb/ippdb01.dump.gz .

For reference, all of the various ipp mysql databases are now being dumped to /data/ipp000.0/ipp/mysql-dumps (had been /data/ipp000.0/jhoblitt/mysql-dumps), and these above two 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:

all backups for the past 5 days (~20 copies) one backup per day for the previous ~10 days (~10 copies) one backup every 10 days for the previous 100 days (~10 copies) one backup every 100 days for the lifetime of the project (~15 copies)

(currently, we are keeping all of the old copies with a linear spacing...)