Changes between Version 95 and Version 96 of Moped_accident

Timestamp:

Jun 7, 2012, 9:21:22 AM (14 years ago)

Author:

Serge CHASTEL

Comment:

--

Moped_accident

@@ -174 +174 @@
    * Further ingestions executed with: {{{'mysqlbinlog <binlog> | grep -v 'COMMIT/*!*/' | grep -v BEGIN | mysql -u root -p nebulous'}}}.
    * Note: There are between 40 and 45 millions lines in each binlog when shown as text. There are roughly: SET statements: 7-8M; INSERT: 1.5-2.5M; DELETE: 0.2-0.5M; UPDATE: 1M; REPLACE: 0.1-0.3M). The rest is either COMMIT, BEGIN or comments.
+   * Note: There were offending statements in 695: "CREATE USER" (I restarted nebdiskd and had to use that statement) as well as "use nebulous" (I don't see why it's offending but it crashed the replay). The best seems to filter those two statements too (as well as commit and begin).
  * '''DONE''' compress all possible logs on ippdb00: I compressed the mysql slowlog. I didn't find the nebdiskd log though...
+ * write down new master coordinates
+ * stop pantasks, apache on ippc17, apache servers
  * ask gavin to change dns so that nebulous.ipp.ifa.hawaii.edu points to ippdb00 again
- * write down new master coordinates
- * restart nebdiskd
+ * '''DONE''' restart nebdiskd
  * '''DONE''' restore apache configuration files on ippc01-ippc10 (backup files are called /etc/apache2/modules.d/apache2-mod_perl-startup.pl.20120529_ippdb00)
  * restart apache servers (jt scripts should be finished?!)
  * restart ipp
  * delete neb dump on ippdb00
-
 == Once everything seems fine, *** on ippb02 *** ==
  * comment neb dump in root crontab