Changes between Version 26 and Version 27 of DatabaseBackups

Timestamp:

Aug 5, 2011, 9:29:20 AM (15 years ago)

Author:

Serge CHASTEL

Comment:

Link to replication howto

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).
+   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). Documentation about use of master coordinates can be found [http://svn.pan-starrs.ifa.hawaii.edu/trac/ipp/wiki/MySqlReplication there].
 
  * gpc1 on ippdb01 is replicated on ippdb03 and ipp001. 
@@ -21 +21 @@
    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).
+   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). Documentation about use of master coordinates can be found [http://svn.pan-starrs.ifa.hawaii.edu/trac/ipp/wiki/MySqlReplication there].
 
  * Backups of ippRequestServer, isp, ippadmin is /home/panstarrs/ipp/mysql-dump/ops_dump.csh (Manoa cluster).