Changes between Version 6 and Version 7 of DatabaseBackups

Timestamp:

Apr 6, 2011, 5:01:20 PM (15 years ago)

Author:

Serge CHASTEL

Comment:

--

DatabaseBackups

@@ -3 +3 @@
 
 (Last update: 2011-04-06)
- * Backup scripts can be found here: https://svn.pan-starrs.ifa.hawaii.edu/repo/ipp/trunk/tools/mysql-dump. They are installed in ~ipp/mysql-dump.
- * nebulous on ippdb00 is replicated on ippdb02. 
+ * 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.
+ * nebulous on ippdb00 is replicated on ippdb02.
+
    The database on the replication slave database is backed up twice a day at 0:30 and 12:30 (see the local crontab). Dumping the complete database takes about 3 hours. 
+
    Every day at 3:05 and 15:05 the last nebulous dump is copied on ipp001 by the neb_copy.sh script running on ipp001 (documentation is in the script). neb_copy.sh verifies that the copy is fine otherwise sends an e-mail (while in dev mode, only to me, i.e. serge).
  * gpc1 on ippdb01 is replicated on ippc02. 
+
    The database on the replication slave database 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).
+
    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.
  * Backups of ippRequestServer, isp, ippadmin is /home/panstarrs/ipp/mysql-dump/ops_dump.csh (Manoa cluster).