Changes between Version 3 and Version 4 of DatabaseBackups

Timestamp:

Oct 15, 2009, 5:30:26 PM (17 years ago)

Author:

bills

Comment:

--

DatabaseBackups

@@ -3 +3 @@
 (Up to [wiki:IPP_for_PS1 IPP for PS1])
 
+'''Updated (2009.10.14): The rsync server for the database dumps has changed from ipp0002 to ipp0012. The text below reflects this change.'''
+
 '''Updated: We have recently (2009.09.16) changed the dump scheme to only dump the specific databases of interest.  The text below reflects this change.'''
 
-Thanks to efforts by Cindy & Gavin, regular dumps of the mysql databases being used by the processing system on Maui are now being made available via the rsync server on ipp0002.ifa.hawaii.edu.  The three databases distributed are the gpc1 processing database, the isp processing database, and the ippadmin database describing the database schema.  These are dumped every 4 hours, and are available from the rsync location:
+Thanks to efforts by Cindy & Gavin, regular dumps of the mysql databases being used by the processing system on Maui are now being made available via the rsync server on ipp0012.ifa.hawaii.edu.  The three databases distributed are the gpc1 processing database, the isp processing database, and the ippadmin database describing the database schema.  These are dumped every 4 hours, and are available from the rsync location:
 
-rsync://ipp0002.ifa.hawaii.edu/ippdb
+rsync://ipp0012.ifa.hawaii.edu/ippdb
 
 if you want all three, give a command like:
 
-rsync -auv rsync://ipp0002.ifa.hawaii.edu/ippdb/ ippdb/
+rsync -auv rsync://ipp0012.ifa.hawaii.edu/ippdb/ ippdb/
 
 The databases have names of the form ippdb01-DBNAME.dump.gz, eg, the GPC1 processing information is in the file called ippdb01-gpc1.dump.gz.  The GPC1 gzip file is currently 0.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 (~0.4 Mbit/sec), then we can adjust the naming to keep more than one old version around.  
@@ -17 +19 @@
 If you want just one of the above databases, use a command like: 
 
-rsync rsync://ipp0002.ifa.hawaii.edu/ippdb/ippdb01-gpc1.dump.gz .
+rsync rsync://ipp0012.ifa.hawaii.edu/ippdb/ippdb01-gpc1.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: