Changes between Version 25 and Version 26 of DatabaseBackups

Timestamp:

Aug 5, 2011, 9:23:32 AM (15 years ago)

Author:

Serge CHASTEL

Comment:

Master coordinates have been made avalable: how to use them

DatabaseBackups

@@ -11 +11 @@
    The log file can be found at /export/ippdb02.0/mysql-dumps/neb_dump.log
 
+   The backup file can be ingested to create a replication slave of the master (ippdb00). The master coordinates are dumped just before the actual mysqldump and are written to /export/ippdb02.0/mysql-dumps/mysql-neb-coordinates-ippdb02-*.txt (take the coordinates that corresponds to the dump). Use those coordinates '''after''' the mysqldump has been ingested (there are other coordinates in the mysqldump file but they cannot be used to create a replication slave).
+
  * gpc1 on ippdb01 is replicated on ippdb03 and ipp001. 
 
@@ -18 +20 @@
 
    The log file can be found at /export/ippdb03.0/mysql-dumps/gpc1_dump.log
+
+   The backup file can be ingested to create a replication slave of the master (ippdb01). The master coordinates are dumped just before the actual mysqldump and are written to /export/ippdb03.0/mysql-dumps/mysql-gpc1-coordinates-ippdb03-*.txt (take the coordinates that corresponds to the dump). Use those coordinates '''after''' the mysqldump has been ingested (there are other coordinates in the mysqldump file but they cannot be used to create a replication slave).
 
  * Backups of ippRequestServer, isp, ippadmin is /home/panstarrs/ipp/mysql-dump/ops_dump.csh (Manoa cluster).