IPP Software Navigation Tools IPP Links Communication Pan-STARRS Links

Changes between Version 8 and Version 9 of DatabaseBackups


Ignore:
Timestamp:
Apr 7, 2011, 9:17:19 AM (15 years ago)
Author:
Serge CHASTEL
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • DatabaseBackups

    v8 v9  
    22(Up to [wiki:IPP_for_PS1 IPP for PS1])
    33
    4 (Last update: 2011-04-06)
     4(Last update: 2011-04-07)
    55 * Backup scripts can be found here: https://svn.pan-starrs.ifa.hawaii.edu/repo/ipp/trunk/tools/mysql-dump. The README file and each script contain documentation. They are installed in ~ipp/mysql-dump.
    66 * nebulous on ippdb00 is replicated on ippdb02.
     
    1313   The database on the replication slave is backed up every 4 hours (at 0:05, 4:05, 8:05, 12:05, 16:05, and 20:05). Dumping the database takes about one hour (TODO: maybe shorter. When I looked at that ippc02 was doing another backup that I didn't want to stop). The script responsible for the dump (gpc1_dump) is also responsible for the copy onto ipp001 (it is then different from the previous one).
    1414
    15    Every 4 hours (at 1:30, 5:30, 9:30, 13:30, 17:30, and 21:30), gpc1 is verified, alternatively "installed" on gpc1_0 or gpc1_1, and distributed with its md5 checksum on the rsync server.
     15   Every 4 hours (at 1:30, 5:30, 9:30, 13:30, 17:30, and 21:30), gpc1 is verified, alternatively "installed" on gpc1_0 or gpc1_1 (once a day between 0:00 and 4:00), and distributed with its md5 checksum on the rsync server.
    1616 * Backups of ippRequestServer, isp, ippadmin is /home/panstarrs/ipp/mysql-dump/ops_dump.csh (Manoa cluster).
    1717   * They are backed up every four hours at 0:00, 4:00, 8:00, 12:00, 16:00, and 20:00).