API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Jul 21st, 2016
72
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 6.13 KB | None | 0 0
raw download clone embed print report
  1. Thu Jul 21 14:34:16 2016 - [info] MHA::MasterRotate version 0.56.
  2. Thu Jul 21 14:34:16 2016 - [info] Starting online master switch..
  3. Thu Jul 21 14:34:16 2016 - [info]
  4. Thu Jul 21 14:34:16 2016 - [info] * Phase 1: Configuration Check Phase..
  5. Thu Jul 21 14:34:16 2016 - [info]
  6. Thu Jul 21 14:34:16 2016 - [warning] Global configuration file /etc/masterha_default.cnf not found. Skipping.
  7. Thu Jul 21 14:34:16 2016 - [info] Reading application default configuration from /etc/mha_mukkannnn.cnf..
  8. Thu Jul 21 14:34:16 2016 - [info] Reading server configuration from /etc/mha_mukkannnn.cnf..
  9. Thu Jul 21 14:34:16 2016 - [info] GTID failover mode = 0
  10. Thu Jul 21 14:34:16 2016 - [info] Current Alive Master: 10.77.24.236(10.77.24.236:3306)
  11. Thu Jul 21 14:34:16 2016 - [info] Alive Slaves:
  12. Thu Jul 21 14:34:16 2016 - [info] 10.77.24.111(10.77.24.111:3306) Version=5.6.31-77.0-log (oldest major version between slaves) log-bin:enabled
  13. Thu Jul 21 14:34:16 2016 - [info] Replicating from 10.77.24.236(10.77.24.236:3306)
  14.  
  15. It is better to execute FLUSH NO_WRITE_TO_BINLOG TABLES on the master before switching. Is it ok to execute on 10.77.24.236(10.77.24.236:3306)? (YES/no): yes
  16. Thu Jul 21 14:34:20 2016 - [info] Executing FLUSH NO_WRITE_TO_BINLOG TABLES. This may take long time..
  17. Thu Jul 21 14:34:20 2016 - [info] ok.
  18. Thu Jul 21 14:34:20 2016 - [info] Checking MHA is not monitoring or doing failover..
  19. Thu Jul 21 14:34:20 2016 - [info] Checking replication health on 10.77.24.111..
  20. Thu Jul 21 14:34:20 2016 - [info] ok.
  21. Thu Jul 21 14:34:20 2016 - [info] 10.77.24.111 can be new master.
  22. Thu Jul 21 14:34:20 2016 - [info]
  23. From:
  24. 10.77.24.236(10.77.24.236:3306) (current master)
  25. +--10.77.24.111(10.77.24.111:3306)
  26.  
  27. To:
  28. 10.77.24.111(10.77.24.111:3306) (new master)
  29. +--10.77.24.236(10.77.24.236:3306)
  30.  
  31. Starting master switch from 10.77.24.236(10.77.24.236:3306) to 10.77.24.111(10.77.24.111:3306)? (yes/NO): yes
  32. Thu Jul 21 14:34:35 2016 - [info] Checking whether 10.77.24.111(10.77.24.111:3306) is ok for the new master..
  33. Thu Jul 21 14:34:35 2016 - [info] ok.
  34. Thu Jul 21 14:34:35 2016 - [info] 10.77.24.236(10.77.24.236:3306): SHOW SLAVE STATUS returned empty result. To check replication filtering rules, temporarily executing CHANGE MASTER to a dummy host.
  35. Thu Jul 21 14:34:35 2016 - [info] 10.77.24.236(10.77.24.236:3306): Resetting slave pointing to the dummy host.
  36. Thu Jul 21 14:34:35 2016 - [info] ** Phase 1: Configuration Check Phase completed.
  37. Thu Jul 21 14:34:35 2016 - [info]
  38. Thu Jul 21 14:34:35 2016 - [info] * Phase 2: Rejecting updates Phase..
  39. Thu Jul 21 14:34:35 2016 - [info]
  40. Thu Jul 21 14:34:35 2016 - [info] Executing master ip online change script to disable write on the current master:
  41. Thu Jul 21 14:34:35 2016 - [info] /usr/local/sbin/master_ip_online_change.sh --command=stop --orig_master_host=10.77.24.236 --orig_master_ip=10.77.24.236 --orig_master_port=3306 --orig_master_user='mha' --orig_master_password='xxx' --new_master_host=10.77.24.111 --new_master_ip=10.77.24.111 --new_master_port=3306 --new_master_user='mha' --new_master_password='xxx' --orig_master_ssh_user=root --new_master_ssh_user=root --orig_master_is_new_slave
  42. ===> setting read_only=ON on current master
  43. Warning: Using a password on the command line interface can be insecure.
  44. Thu Jul 21 14:34:36 2016 - [info] ok.
  45. Thu Jul 21 14:34:36 2016 - [info] Locking all tables on the orig master to reject updates from everybody (including root):
  46. Thu Jul 21 14:34:36 2016 - [info] Executing FLUSH TABLES WITH READ LOCK..
  47. Thu Jul 21 14:34:36 2016 - [info] ok.
  48. Thu Jul 21 14:34:36 2016 - [info] Orig master binlog:pos is mysql-bin.000001:120.
  49. Thu Jul 21 14:34:36 2016 - [info] Waiting to execute all relay logs on 10.77.24.111(10.77.24.111:3306)..
  50. Thu Jul 21 14:34:36 2016 - [info] master_pos_wait(mysql-bin.000001:120) completed on 10.77.24.111(10.77.24.111:3306). Executed 0 events.
  51. Thu Jul 21 14:34:36 2016 - [info] done.
  52. Thu Jul 21 14:34:36 2016 - [info] Getting new master's binlog name and position..
  53. Thu Jul 21 14:34:36 2016 - [info] mysql-bin.000002:120
  54. Thu Jul 21 14:34:36 2016 - [info] All other slaves should start replication from here. Statement should be: CHANGE MASTER TO MASTER_HOST='10.77.24.111', MASTER_PORT=3306, MASTER_LOG_FILE='mysql-bin.000002', MASTER_LOG_POS=120, MASTER_USER='rdsrepladmin', MASTER_PASSWORD='xxx';
  55. Thu Jul 21 14:34:36 2016 - [info] Executing master ip online change script to allow write on the new master:
  56. Thu Jul 21 14:34:36 2016 - [info] /usr/local/sbin/master_ip_online_change.sh --command=start --orig_master_host=10.77.24.236 --orig_master_ip=10.77.24.236 --orig_master_port=3306 --orig_master_user='mha' --orig_master_password='xxx' --new_master_host=10.77.24.111 --new_master_ip=10.77.24.111 --new_master_port=3306 --new_master_user='mha' --new_master_password='xxx' --orig_master_ssh_user=root --new_master_ssh_user=root --orig_master_is_new_slave
  57. Thu Jul 21 14:34:36 2016 - [info] ok.
  58. Thu Jul 21 14:34:36 2016 - [info] Setting read_only=0 on 10.77.24.111(10.77.24.111:3306)..
  59. Thu Jul 21 14:34:36 2016 - [info] ok.
  60. Thu Jul 21 14:34:36 2016 - [info]
  61. Thu Jul 21 14:34:36 2016 - [info] * Switching slaves in parallel..
  62. Thu Jul 21 14:34:36 2016 - [info]
  63. Thu Jul 21 14:34:36 2016 - [info] Unlocking all tables on the orig master:
  64. Thu Jul 21 14:34:36 2016 - [info] Executing UNLOCK TABLES..
  65. Thu Jul 21 14:34:36 2016 - [info] ok.
  66. Thu Jul 21 14:34:36 2016 - [info] Starting orig master as a new slave..
  67. Thu Jul 21 14:34:36 2016 - [info] Resetting slave 10.77.24.236(10.77.24.236:3306) and starting replication from the new master 10.77.24.111(10.77.24.111:3306)..
  68. Thu Jul 21 14:34:36 2016 - [info] Executed CHANGE MASTER.
  69. Thu Jul 21 14:34:36 2016 - [info] Slave started.
  70. Thu Jul 21 14:34:36 2016 - [info] All new slave servers switched successfully.
  71. Thu Jul 21 14:34:36 2016 - [info]
  72. Thu Jul 21 14:34:36 2016 - [info] * Phase 5: New master cleanup phase..
  73. Thu Jul 21 14:34:36 2016 - [info]
  74. Thu Jul 21 14:34:36 2016 - [info] 10.77.24.111: Resetting slave info succeeded.
  75. Thu Jul 21 14:34:36 2016 - [info] Switching master to 10.77.24.111(10.77.24.111:3306) completed successfully.
  76. -------------------------------
  77.  
  78. Current value: 10.77.24.111 -> read_only = 0
  79. -------------------------------
  80.  
  81. Current value: 10.77.24.236 -> read_only = 1
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!