Changes between Version 39 and Version 40 of PS1_IPP_Czarlog_20141208

Timestamp:

Dec 10, 2014, 1:40:50 PM (12 years ago)

Author:

Serge CHASTEL

Comment:

--

PS1_IPP_Czarlog_20141208

@@ -66 +66 @@
  * 12:40 CZW: all pantasks stopped, czar/monitor scripts stopped as well.
  * 13:15 CZW: ipp034 has died again.  I'm power cycling it again, so when processing resumes, it can try to limp along.
+ * 13:00 SC:
+   * Replication stopped on ippc17, ipp001, ippdb03, ippdb05
+   * ippdb01: Users not root all deleted
+   * ippdb05: Added ipp user tomysql
+   * ippdb01: mysql shutdown
+   * ippdb05: slave information deleted (RESET SLAVE + /etc/mysql/my.cnf)
+   * ippdb05: server restart (no slave info)
+   * ippdb05:
+mysql> SHOW MASTER STATUS;
++-------------------+----------+--------------+------------------+
+| File              | Position | Binlog_Do_DB | Binlog_Ignore_DB |
++-------------------+----------+--------------+------------------+
+| mysqld-bin.000243 |       98 |              |                  |
++-------------------+----------+--------------+------------------+
+1 row in set (0.00 sec)
+
+CHANGE MASTER TO MASTER_HOST='ippdb05.ifa.hawaii.edu', MASTER_USER='repl_gpc1', MASTER_PASSWORD='gpc1_repl', MASTER_LOG_FILE='mysqld-bin.000243', MASTER_LOG_POS=98;
+
+   * ippdb03 is now a slave of ippdb05
+   * issue with isp on ippc17
+   * can't check from ipp001 since ippdb05 not visible
+   * ippdb01 is now a slave of ippdb05
+   * root password changed on ippdb01
+   * mysql servers stopped on ippdb01 and ippdb05
+   * Gavin can change dns/ip
 === Thursday : YYYY.MM.DD ===