Upgrade to Pro — share decks privately, control downloads, hide ads and more …

mysql_replication

 mysql_replication

MySQLサーバーを複製し、私が死んでも代わりは(略)するお話

3c9c5f9a91cac73073db8bb2903bd968?s=128

mamy1326

April 20, 2017
Tweet

Transcript

  1. .Z42-αʔόʔΛ ϨϓϦέʔγϣϯ Λ࣮ߦ͢Δ͓࿩ ·Έ΍ͳ͓͖ !NBNZ  "QS !ୈճ1)1ษڧձˏ౦ژ

  2. .Z42- Λ ෳ ੡ ͠ αʔόʔ 1)1ษڧձ!౦ژୈ࿩ ࢲ͕ ˓ΜͰ΋ ୅ΘΓ͸

    ུ ͢Δ ͓࿩ ·Έ΍ͳϮ͖ !NBNZ
  3. ࠓ೔ͷςʔϚ ࢲͷ୅ΘΓ͸ ͍͘ΒͰ΋͍ΔΘ ͱݴͬͯ

  4. ࠓ೔ͷςʔϚ ࣮ࡍ͸ ࢮΜͩΒऴΘΔ .Z42-Λ

  5. ࠓ೔ͷςʔϚ ෳ੡ ϨϓϦέʔγϣϯ  ͢Δ͓࿩

  6. ੢ྐྵ೥݄

  7. ϑΝʔετ ΠϯύΫτ

  8. NZDOG͕ σϑΥϧτ

  9. લճ·Ͱͷվળ ⾣νϡʔχϯάͰඵؒˠ ⾣ςʔϒϧݸผͰߋ৽ܥ͕଎͘ʂ ⾣ϝϞϦ͕ద੾ʹ࢖ΘΕΔΑ͏ʹʂ

  10. લճ·Ͱͷվળ ⾣νϡʔχϯάͰඵؒˠ ⾣ςʔϒϧݸผͰߋ৽ܥ͕଎͘ʂ ⾣ϝϞϦ͕ద੾ʹ࢖ΘΕΔΑ͏ʹʂ

  11. લճ·Ͱͷվળ ⾣νϡʔχϯάͰඵؒˠ ⾣ςʔϒϧݸผͰߋ৽ܥ͕଎͘ʂ ⾣ϝϞϦ͕ద੾ʹ࢖ΘΕΔΑ͏ʹʂ

  12. લճ·Ͱͷվળ ⾣νϡʔχϯάͰඵؒˠ ⾣ςʔϒϧݸผͰߋ৽ܥ͕଎͘ʂ ⾣ϝϞϦ͕ద੾ʹ࢖ΘΕΔΑ͏ʹʂ

  13. ੢ྐྵ೥݄

  14. ηΧϯυ ΠϯύΫτ

  15. ՝୊

  16. ՝୊ Ϛελʔ͕ࢮ͵ͱ σʔλ͕શ෦ࢮ͵

  17. ՝୊ Ϛελʔ͕ࢮ͵ͱ σʔλ͕શ෦ࢮ͵

  18. ՝୊ Ϛελʔ͕ࢮ͵ͱ σʔλ͕શ෦ࢮ͵ ·͔͞ͷ େരൃ

  19. ෳ੡ Ϛελʔ͔͠ͳ͍ ݱঢ়ʹ εϨʔϒΛ࡞Γ

  20. ෳ੡ ϨϓϦέʔγϣϯ ΛՔಇ͠·͢

  21. ɹϨϓϦέʔγϣϯͱ͸

  22. ɹϨϓϦέʔγϣϯͱ͸ ⾣σʔλϕʔεશମͷෳ੡ ϨϓϦΧ  ⾣ผͷαʔόʔʹෳ੡ʢεϨʔϒʣ ⾣.Z42-ͷඪ४ػೳͰ͓खܰ ⾣΄΅࣌ؒࠩͳ͠ʹಉظ

  23. ɹϨϓϦέʔγϣϯͱ͸ ⾣σʔλϕʔεશମͷෳ੡ ϨϓϦΧ  ⾣ผͷαʔόʔʹෳ੡ʢεϨʔϒʣ ⾣.Z42-ͷඪ४ػೳͰ͓खܰ ⾣΄΅࣌ؒࠩͳ͠ʹಉظ

  24. ɹϨϓϦέʔγϣϯͱ͸ ⾣σʔλϕʔεશମͷෳ੡ ϨϓϦΧ  ⾣ผͷαʔόʔʹෳ੡ʢεϨʔϒʣ ⾣.Z42-ͷඪ४ػೳͰ͓खܰ ⾣΄΅࣌ؒࠩͳ͠ʹಉظ

  25. ɹϨϓϦέʔγϣϯͱ͸ ⾣σʔλϕʔεશମͷෳ੡ ϨϓϦΧ  ⾣ผͷαʔόʔʹෳ੡ʢεϨʔϒʣ ⾣.Z42-ͷඪ४ػೳͰ͓खܰ ⾣΄΅࣌ؒࠩͳ͠ʹಉظ

  26. ߏ੒ Ϛελʔ ʢ୯Ұʣ εϨʔϒ ʢʣ εϨʔϒ ʢOʣ ɾɾɾ

  27. Ϛελʔ

  28. Ϛελʔ ⾣σʔλΛߋ৽͢Δଆ ⾣ߋ৽಺༰ΛεϨʔϒ͕औΓʹདྷΔ ɹˠεϨʔϒʹର͠ߋ৽ΠϕϯτΛ௨஌ ⾣ෳ਺ͷεϨʔϒΛ࣋ͯΔ

  29. Ϛελʔ ⾣σʔλΛߋ৽͢Δଆ ⾣ߋ৽಺༰ΛεϨʔϒ͕औΓʹདྷΔ ɹˠεϨʔϒʹର͠ߋ৽ΠϕϯτΛ௨஌ ⾣ෳ਺ͷεϨʔϒΛ࣋ͯΔ

  30. Ϛελʔ ⾣σʔλΛߋ৽͢Δଆ ⾣ߋ৽಺༰ΛεϨʔϒ͕औΓʹདྷΔ ɹˠεϨʔϒʹର͠ߋ৽ΠϕϯτΛ௨஌ ⾣ෳ਺ͷεϨʔϒΛ࣋ͯΔ

  31. Ϛελʔ ⾣σʔλΛߋ৽͢Δଆ ⾣ߋ৽಺༰ΛεϨʔϒ͕औΓʹདྷΔ ɹˠεϨʔϒʹର͠ߋ৽ΠϕϯτΛ௨஌ ⾣ෳ਺ͷεϨʔϒΛ࣋ͯΔ

  32. εϨʔϒ

  33. εϨʔϒ ⾣ߋ৽༻Ͱ͸ͳ͘ࢀর༻ ⾣Ϛελʔͷߋ৽಺༰Λड͚औΔ ⾣ϚελʔͷόΠφϦϩάΛऔಘ ⾣ߋ৽಺༰Λ%#ʹ൓ө ⾣ͭͷϚελʔͷΈ࣋ͯΔ

  34. εϨʔϒ ⾣ߋ৽༻Ͱ͸ͳ͘ࢀর༻ ⾣Ϛελʔͷߋ৽಺༰Λड͚औΔ ⾣ϚελʔͷόΠφϦϩάΛऔಘ ⾣ߋ৽಺༰Λ%#ʹ൓ө ⾣ͭͷϚελʔͷΈ࣋ͯΔ

  35. εϨʔϒ ⾣ߋ৽༻Ͱ͸ͳ͘ࢀর༻ ⾣Ϛελʔͷߋ৽಺༰Λड͚औΔ ⾣ϚελʔͷόΠφϦϩάΛऔಘ ⾣ߋ৽಺༰Λ%#ʹ൓ө ⾣ͭͷϚελʔͷΈ࣋ͯΔ

  36. εϨʔϒ ⾣ߋ৽༻Ͱ͸ͳ͘ࢀর༻ ⾣Ϛελʔͷߋ৽಺༰Λड͚औΔ ⾣ϚελʔͷόΠφϦϩάΛऔಘ ⾣ߋ৽಺༰Λ%#ʹ൓ө ⾣ͭͷϚελʔͷΈ࣋ͯΔ DPNNJUϩά *0εϨου

  37. εϨʔϒ ⾣ߋ৽༻Ͱ͸ͳ͘ࢀর༻ ⾣Ϛελʔͷߋ৽಺༰Λड͚औΔ ⾣ϚελʔͷόΠφϦϩάΛऔಘ ⾣ߋ৽಺༰Λ%#ʹ൓ө ⾣ͭͷϚελʔͷΈ࣋ͯΔ

  38. εϨʔϒ ⾣ߋ৽༻Ͱ͸ͳ͘ࢀর༻ ⾣Ϛελʔͷߋ৽಺༰Λड͚औΔ ⾣ϚελʔͷόΠφϦϩάΛऔಘ ⾣ߋ৽಺༰Λ%#ʹ൓ө ⾣ͭͷϚελʔͷΈ࣋ͯΔ DPNNJUϩάͷ 42-࣮ߦ 42-εϨου

  39. εϨʔϒ ⾣ߋ৽༻Ͱ͸ͳ͘ࢀর༻ ⾣Ϛελʔͷߋ৽಺༰Λड͚औΔ ⾣ϚελʔͷόΠφϦϩάΛऔಘ ⾣ߋ৽಺༰Λ%#ʹ൓ө ⾣ͭͷϚελʔͷΈ࣋ͯΔ

  40. ϝϦοτ ⾣ࢀর 4&-&$5 ੑೳͷ޲্ ݕࡧॲཧ͕ॏ͍৔߹ εϨʔϒΛࢀরܥʹͯ͠ ෛՙ෼ࢄ

  41. ϝϦοτ ⾣ࢀর 4&-&$5 ੑೳͷ޲্ ݕࡧॲཧ͕ॏ͍৔߹ εϨʔϒΛࢀরܥʹͯ͠ ෛՙ෼ࢄ

  42. ϝϦοτ ⾣ࢀর 4&-&$5 ੑೳͷ޲্ ݕࡧॲཧ͕ॏ͍৔߹ εϨʔϒΛࢀরܥʹͯ͠ ෛՙ෼ࢄ

  43. ϝϦοτ ⾣Մ༻ੑͷߴ͍ߏ੒ͷ࣮ݱ Ϛελʔো֐ͷ৔߹ εϨʔϒΛϚελʔʹঢ֨ μ΢ϯλΠϜ୹ॖ

  44. ϝϦοτ ⾣Մ༻ੑͷߴ͍ߏ੒ͷ࣮ݱ Ϛελʔো֐ͷ৔߹ εϨʔϒΛϚελʔʹঢ֨ μ΢ϯλΠϜ୹ॖ

  45. ϝϦοτ ⾣Մ༻ੑͷߴ͍ߏ੒ͷ࣮ݱ Ϛελʔো֐ͷ৔߹ εϨʔϒΛϚελʔʹঢ֨ μ΢ϯλΠϜ୹ॖ

  46. ϝϦοτ ⾣Մ༻ੑͷߴ͍ߏ੒ͷ࣮ݱ Ϛελʔো֐ͷ৔߹ εϨʔϒΛϚελʔʹঢ֨ μ΢ϯλΠϜ୹ॖ ͨͩ͠ɾɾɾ

  47. ϝϦοτ ⾣Մ༻ੑͷߴ͍ߏ੒ͷ࣮ݱ Ϛελʔো֐ͷ৔߹ εϨʔϒΛϚελʔʹঢ֨ μ΢ϯλΠϜ୹ॖ ϑΣΠϧΦʔόʔ ࣗಈԽ ͷ ࢓૊Έ͕ඞཁ

  48. ϝϦοτ ⾣όοΫΞοϓαʔόʔ εϨʔϒͰόοΫΞοϓ ϚελʔʹӨڹͳ͘ όοΫΞοϓऔಘ

  49. ϝϦοτ ⾣όοΫΞοϓαʔόʔ εϨʔϒͰόοΫΞοϓ ϚελʔʹӨڹͳ͘ όοΫΞοϓऔಘ

  50. ɹϨϓϦέʔγϣϯͷঢ়گ νϡʔχϯάલ͸ ਺೔ʹҰ౓ Ϛελʔ͕μ΢ϯ͍ͯͨ͠

  51. ɹϨϓϦέʔγϣϯͷঢ়گ νϡʔχϯάલ͸ ਺೔ʹҰ౓ Ϛελʔ͕μ΢ϯ͍ͯͨ͠

  52. ɹϨϓϦέʔγϣϯͷঢ়گ νϡʔχϯάલ͸ ਺೔ʹҰ౓ Ϛελʔ͕μ΢ϯ͍ͯͨ͠

  53. ɹϨϓϦέʔγϣϯͷঢ়گ Ϛελʔ࠶ىಈͷ౎౓ εϨʔϒͷ ઃఆΛ͠௚͍ͯͨ͠

  54. ɹϨϓϦέʔγϣϯͷঢ়گ Ϛελʔ࠶ىಈͷ౎౓ εϨʔϒͷ ઃఆΛ͠௚͍ͯͨ͠

  55. ɹϨϓϦέʔγϣϯͷঢ়گ Ϛελʔ࠶ىಈͷ౎౓ εϨʔϒͷ ઃఆΛ͠௚͍ͯͨ͠ ͭΒ͍

  56. ɹϨϓϦέʔγϣϯͷঢ়گ ͋·Γʹ΋໘౗Ͱ εϨʔϒΛ

  57. ɹϨϓϦέʔγϣϯͷঢ়گ ͋·Γʹ΋໘౗Ͱ εϨʔϒΛ 4501ʂ

  58. ͭ·Γ

  59. ͭ·Γ ӡ༻͔Β ಀ͍͛ͯͨ

  60. Ͱ΋

  61. Ͱ΋ ಀ͛ͪΌବ໨ͩɺ ಀ͛ͪΌବ໨ͩɺ ಀ͛ͪΌବ໨ͩɺ ಀ͛ͪΌବ໨ͩɺ ಀ͛ͪΌବ໨ͩɺ ಀ͛ͪΌବ໨ͩɻ

  62. Ͱ΋ ಀ͛ͪΌବ໨ͩɺ ಀ͛ͪΌବ໨ͩɺ ಀ͛ͪΌବ໨ͩɺ ಀ͛ͪΌବ໨ͩɺ ಀ͛ͪΌବ໨ͩɺ ಀ͛ͪΌବ໨ͩɻ

  63. Ͱ΋ ಀ͛ͪΌବ໨ͩɺ ಀ͛ͪΌବ໨ͩɺ ಀ͛ͪΌବ໨ͩɺ ಀ͛ͪΌବ໨ͩɺ ಀ͛ͪΌବ໨ͩɺ ಀ͛ͪΌବ໨ͩɻ

  64. Ͱ΋ ಀ͛ͪΌବ໨ͩɺ ಀ͛ͪΌବ໨ͩɺ ಀ͛ͪΌବ໨ͩɺ ಀ͛ͪΌବ໨ͩɺ ಀ͛ͪΌବ໨ͩɺ ಀ͛ͪΌବ໨ͩɻ

  65. Ͱ΋ ಀ͛ͪΌବ໨ͩɺ ಀ͛ͪΌବ໨ͩɺ ಀ͛ͪΌବ໨ͩɺ ಀ͛ͪΌବ໨ͩɺ ಀ͛ͪΌବ໨ͩɺ ಀ͛ͪΌବ໨ͩɻ

  66. Ͱ΋ ಀ͛ͪΌବ໨ͩɺ ಀ͛ͪΌବ໨ͩɺ ಀ͛ͪΌବ໨ͩɺ ಀ͛ͪΌବ໨ͩɺ ಀ͛ͪΌବ໨ͩɺ ಀ͛ͪΌବ໨ͩɻ

  67. ๻͕ ΍Γ·͢

  68. ࣄલ४උ ⾣ϨϓϦέʔγϣϯϢʔβʔ࡞੒ ⾣ϚελʔՔಇঢ়ଶͷ֬ೝ ⾣ϚελʔόΠφϦϩάͷ֬ೝ ⾣εϨʔϒͷઃఆ֬ೝ

  69. ࣄલ४උ ⾣ϨϓϦέʔγϣϯϢʔβʔ࡞੒ ⾣ϚελʔՔಇঢ়ଶͷ֬ೝ ⾣ϚελʔόΠφϦϩάͷ֬ೝ ⾣εϨʔϒͷઃఆ֬ೝ

  70. ɹɹϨϓϦέʔγϣϯϢʔβʔ࡞੒ ⾣ఆٛ ɹɾϚελʔଆʹ࡞੒ ɹɾεϨʔϒ͔Β઀ଓ͢Δ ɹɾϨϓϦέʔγϣϯઐ༻Ϣʔβʔ

  71. ɹɹϨϓϦέʔγϣϯϢʔβʔ࡞੒ ⾣ఆٛ ɹɾϚελʔଆʹ࡞੒ ɹɾεϨʔϒ͔Β઀ଓ͢Δ ɹɾϨϓϦέʔγϣϯઐ༻Ϣʔβʔ

  72. ɹɹϨϓϦέʔγϣϯϢʔβʔ࡞੒ ⾣ఆٛ ɹɾϚελʔଆʹ࡞੒ ɹɾεϨʔϒ͔Β઀ଓ͢Δ ɹɾϨϓϦέʔγϣϯઐ༻Ϣʔβʔ

  73. ɹɹϨϓϦέʔγϣϯϢʔβʔ࡞੒ ⾣ఆٛ ɹɾϚελʔଆʹ࡞੒ ɹɾεϨʔϒ͔Β઀ଓ͢Δ ɹɾϨϓϦέʔγϣϯઐ༻Ϣʔβʔ

  74. ɹɹϨϓϦέʔγϣϯϢʔβʔ࡞੒ ⾣࣮͸ɾɾɾ ɹɹϚελʔଆͷطଘϢʔβʔͰ΋ ɹɹ઀ଓ͕Մೳ ͔͠͠ɾɾɾ

  75. ɹɹϨϓϦέʔγϣϯϢʔβʔ࡞੒ ⾣࣮͸ɾɾɾ ɹɹϚελʔଆͷطଘϢʔβʔͰ΋ ɹɹ઀ଓ͕Մೳ ͔͠͠ɾɾɾ

  76. ɹɹϨϓϦέʔγϣϯϢʔβʔ࡞੒ TVEPDBUWBSMJCNZTRMNBTUFSJOGP  NZTRMCJO  <Ϛελʔͷ*1ΞυϨε·ͨ͸ϗετ໊> <Ϛελʔʹ઀ଓ͢ΔNZTRMϢʔβʔ໊> <Ϛελʔʹ઀ଓ͢ΔNZTRMύεϫʔυ>  

    ʜ
  77. ɹɹϨϓϦέʔγϣϯϢʔβʔ࡞੒ TVEPDBUWBSMJCNZTRMNBTUFSJOGP  NZTRMCJO  <Ϛελʔͷ*1ΞυϨε·ͨ͸ϗετ໊> <Ϛελʔʹ઀ଓ͢ΔNZTRMϢʔβʔ໊> <Ϛελʔʹ઀ଓ͢ΔNZTRMύεϫʔυ>  

    ʜ ઀ଓ৘ใ͕ ϓϨʔϯςΩετ
  78. ɹɹϨϓϦέʔγϣϯϢʔβʔ࡞੒ TVEPDBUWBSMJCNZTRMNBTUFSJOGP  NZTRMCJO  <Ϛελʔͷ*1ΞυϨε·ͨ͸ϗετ໊> <Ϛελʔʹ઀ଓ͢ΔNZTRMϢʔβʔ໊> <Ϛελʔʹ઀ଓ͢ΔNZTRMύεϫʔυ>  

    ʜ ηΩϡϦςΟͷͨΊ ઐ༻Ϣʔβ࡞੒
  79. ͜͏͍͏࣌ ͋Γ·ͤΜ͔ʁ

  80. ·͋ɺ ͍͍͡Όͳ͍Ͱ͔͢ ಈ͘Μ͔ͩΒ

  81. ݴΘΕΕ͹ ΍Γ·͢Α

  82. ऑ͍ ఒγϯδ Έ͍ͨͳࣗ෼͸ ๾໓͠·͠ΐ͏

  83. ɹɹϨϓϦέʔγϣϯϢʔβʔ࡞੒ ⾣࡞੒ίϚϯυ NZTRM NBTUFS $3&"5&64&3 NZTRM NBTUFS `SFQM`!`<εϨʔϒͷϗετ໊>` NZTRM NBTUFS

    *%&/5*'*&%#:1"44803%` `
  84. ɹɹϨϓϦέʔγϣϯϢʔβʔ࡞੒ ⾣ݖݶίϚϯυ NZTRM NBTUFS (3"/53&1-*$"5*0/4-"7& NZTRM NBTUFS 0/  50

    NZTRM NBTUFS `SFQM`!`<εϨʔϒͷϗετ໊>`
  85. ࣄલ४උ ⾣ϨϓϦέʔγϣϯϢʔβʔ࡞੒ ⾣ϚελʔՔಇঢ়ଶͷ֬ೝ ⾣ϚελʔόΠφϦϩάͷ֬ೝ ⾣εϨʔϒͷઃఆ֬ೝ

  86. ϚελʔͷNZDOG

  87. ϚελʔͷNZDOG DPNNJUΛ௨஌ޙ εϨʔϒ͕઀ଓͯ͠औಘ WBSMJCNZTRM NZTRMCJO999999

  88. ϚελʔͷNZDOG εϨʔϒ͔Βݟͨ Ϛελʔͷ*%

  89. ϚελʔͷNZDOG ଟ͗͘͢͠Δͱ ετϨʔδѹഭ

  90. ࣄલ४උ ⾣ϨϓϦέʔγϣϯϢʔβʔ࡞੒ ⾣ϚελʔՔಇঢ়ଶͷ֬ೝ ⾣ϚελʔόΠφϦϩάͷ֬ೝ ⾣εϨʔϒͷઃఆ֬ೝ

  91. ɹɹϚελʔόΠφϦϩάͷ֬ೝ ⾣όΠφϦϩάͱҐஔ৘ใ ɹɾόΠφϦϩάͱ͸ ɹɹɹˠϚελʔ͕DPNNJUͨ͠ཤྺ ɹɾϩʔςʔτ͞ΕΔ ɹɹɹˠݱࡏͷϑΝΠϧ໊Λ֬ೝ ɹɾͲ͜·ͰDPNNJUͰ͖ͯΔ͔ ɹɹɹˠҐஔ৘ใΛ֬ೝ

  92. ɹɹϚελʔόΠφϦϩάͷ֬ೝ ⾣όΠφϦϩάͱҐஔ৘ใ ɹɾόΠφϦϩάϑΝΠϧͱ͸ ɹɹɹˠϚελʔ͕DPNNJUͨ͠ཤྺ ɹɾϩʔςʔτ͞ΕΔ ɹɹɹˠݱࡏͷϑΝΠϧ໊Λ֬ೝ ɹɾͲ͜·ͰDPNNJUͰ͖ͯΔ͔ ɹɹɹˠҐஔ৘ใΛ֬ೝ

  93. ɹɹϚελʔόΠφϦϩάͷ֬ೝ ⾣όΠφϦϩάͱҐஔ৘ใ ɹɾόΠφϦϩάϑΝΠϧͱ͸ ɹɹɹˠϚελʔ͕DPNNJUͨ͠ཤྺ ɹɾϩʔςʔτ͞ΕΔ ɹɹɹˠݱࡏͷϑΝΠϧ໊Λ֬ೝ ɹɾͲ͜·ͰDPNNJUͰ͖ͯΔ͔ ɹɹɹˠҐஔ৘ใΛ֬ೝ

  94. ɹɹϚελʔόΠφϦϩάͷ֬ೝ ⾣όΠφϦϩάͱҐஔ৘ใ ɹɾόΠφϦϩάϑΝΠϧͱ͸ ɹɹɹˠϚελʔ͕DPNNJUͨ͠ཤྺ ɹɾϩʔςʔτ͞ΕΔ ɹɹɹˠݱࡏͷϑΝΠϧ໊Λ֬ೝ ɹɾͲ͜·ͰDPNNJUͰ͖ͯΔ͔ ɹɹɹˠҐஔ৘ใΛ֬ೝ

  95. ɹɹϚελʔόΠφϦϩάͷ֬ೝ mysql> SHOW MASTER STATUS\G ********* 1. row ********* File:

    mysql-bin.000075 Position: 588201136 Binlog_Do_DB: Binlog_Ignore_DB: 1 row in set (0.01 sec)
  96. ɹɹϚελʔόΠφϦϩάͷ֬ೝ mysql> SHOW MASTER STATUS\G ********* 1. row ********* File:

    mysql-bin.000075 Position: 588201136 Binlog_Do_DB: Binlog_Ignore_DB: 1 row in set (0.01 sec) DPNNJUΛ௨஌ޙ εϨʔϒ͕઀ଓͯ͠औಘ WBSMJCNZTRM NZTRMCJO999999
  97. ɹɹϚελʔόΠφϦϩάͷ֬ೝ mysql> SHOW MASTER STATUS\G ********* 1. row ********* File:

    mysql-bin.000075 Position: 588201136 Binlog_Do_DB: Binlog_Ignore_DB: 1 row in set (0.01 sec) ϚελʔͰ DPNNJU͕࣮ߦ͞Εͨ ϙδγϣϯ
  98. ɹɹϚελʔόΠφϦϩάͷ֬ೝ mysql> SHOW MASTER STATUS\G ********* 1. row ********* File:

    mysql-bin.000075 Position: 588201136 Binlog_Do_DB: Binlog_Ignore_DB: 1 row in set (0.01 sec) εϨʔϒઃఆͰ࢖༻͢ΔͨΊ ϝϞ͓͖ͯ͠·͠ΐ͏
  99. ⾣εϨʔϒΛ࡞Δࡍͷ஫ҙ ɹ௨ৗɺϚελʔΛࢭΊͯEVNQ͠ ɹಉҰͷঢ়ଶͰϦετΞͯ͠ ɹϑΝΠϧɾϙδγϣϯΛ߹ΘͤΔ ࠩ෼ͳ͘ϨϓϦέʔγϣϯ։࢝ ɹɹϚελʔόΠφϦϩάͷ֬ೝ

  100. ⾣εϨʔϒΛ࡞Δࡍͷݪଇ ɹ௨ৗɺϚελʔΛࢭΊͯEVNQ͠ ɹಉҰͷঢ়ଶͰϦετΞͯ͠ ɹϑΝΠϧɾϙδγϣϯΛ߹ΘͤΔ ࠩ෼ͳ͘ϨϓϦέʔγϣϯ։࢝ ɹɹϚελʔόΠφϦϩάͷ֬ೝ

  101. ࣄલ४උ ⾣ϨϓϦέʔγϣϯϢʔβʔ࡞੒ ⾣ϚελʔՔಇঢ়ଶͷ֬ೝ ⾣ϚελʔόΠφϦϩάͷ֬ೝ ⾣εϨʔϒͷઃఆ֬ೝ

  102. ɹɹεϨʔϒͷઃఆ֬ೝ mysql> SHOW SLAVE STATUS\G **************** 1. row **************** Slave_IO_State:

    Master_Host: [Ϛελʔͷϗετ໊] Master_User: repl Master_Log_File: mysql-bin.000009 Read_Master_Log_Pos: 303456264 Slave_IO_Running: No Slave_SQL_Running: No Seconds_Behind_Master: NULL Master_Server_Id: 0 1 row in set (0.01 sec)
  103. ɹɹεϨʔϒͷઃఆ֬ೝ ⾣4MBWF@*0@4UBUFɿۭจࣈ ɹεϨʔϒͷݱࡏͷεςʔλε ɹϨϓϦέʔγϣϯ్͕੾Ε͍ͯΔͨΊ ɹۭจࣈͱͳ͍ͬͯΔ ࣮ߦ͞Ε͍ͯΕ͹ 8BJUJOHGPSNBTUFSUPTFOEFWFOU

  104. ɹɹεϨʔϒͷઃఆ֬ೝ ⾣4MBWF@*0@4UBUFɿۭจࣈ ɹεϨʔϒͷݱࡏͷεςʔλε ɹϨϓϦέʔγϣϯ్͕੾Ε͍ͯΔͨΊ ɹۭจࣈͱͳ͍ͬͯΔ ࣮ߦ͞Ε͍ͯΕ͹ 8BJUJOHGPSNBTUFSUPTFOEFWFOU

  105. ɹɹεϨʔϒͷઃఆ֬ೝ ⾣.BTUFS@)PTUɿϚελʔϗετ໊ Ϛελʔͷϗετ໊ ʢ·ͨ͸*1ΞυϨεʣ ɹ มߋ͞Ε͍ͯΕ͹ ࠶ઃఆ͕ඞཁ

  106. ɹɹεϨʔϒͷઃఆ֬ೝ ⾣.BTUFS@)PTUɿϚελʔϗετ໊ Ϛελʔͷϗετ໊ ʢ·ͨ͸*1ΞυϨεʣ ɹ มߋ͞Ε͍ͯΕ͹ ࠶ઃఆ͕ඞཁ

  107. ɹɹεϨʔϒͷઃఆ֬ೝ ⾣.BTUFS@6TFSɿSFQM εϨʔϒ͔ΒϚελʔʹ ઀ଓ͢ΔϢʔβʔ໊ ɹ ઌ΄Ͳઃఆͨ͠ઐ༻Ϣʔβʔ

  108. ɹɹεϨʔϒͷઃఆ֬ೝ ⾣.BTUFS@6TFSɿSFQM εϨʔϒ͔ΒϚελʔʹ ઀ଓ͢ΔϢʔβʔ໊ ɹ ϚελʔͰ࡞੒ͨ͠ઐ༻Ϣʔβʔ

  109. ɹɹεϨʔϒͷઃఆ֬ೝ ⾣.BTUFS@-PH@'JMFɿNZTRMCJO εϨʔϒ͕Ϛελʔ͔Β औಘ͢ΔόΠφϦϩά ɹ Քಇ͍ͯ͠ͳ͔ͬͨͷͰ ζϨ͍ͯΔ

  110. ɹɹεϨʔϒͷઃఆ֬ೝ ⾣.BTUFS@-PH@'JMFɿNZTRMCJO εϨʔϒ͕Ϛελʔ͔Β औಘ͢ΔόΠφϦϩά ɹ Քಇ͍ͯ͠ͳ͔ͬͨͷͰ ζϨ͍ͯΔ

  111. ɹɹϚελʔόΠφϦϩάͷ֬ೝ mysql> SHOW MASTER STATUS\G ********* 1. row ********* File:

    mysql-bin.000075 Position: 588201136 Binlog_Do_DB: Binlog_Ignore_DB: 1 row in set (0.01 sec) ϩʔςʔτ͞Εͯ ϑΝΠϧ͕ͳ͍ͷͰ औಘͰ͖ͳ͍
  112. ɹɹεϨʔϒͷઃఆ֬ೝ ⾣3FBE@.BTUFS@-PH@1PTɿ εϨʔϒͷ*0εϨου͕ ࠷ޙʹಡΈऔͬͨҐஔ ɹ ͔͜͜ΒϨϓϦέʔγϣϯ࠶։͕ͩ େ͖͘ζϨ͍ͯΔ

  113. ɹɹεϨʔϒͷઃఆ֬ೝ ⾣3FBE@.BTUFS@-PH@1PTɿ εϨʔϒͷ*0εϨου͕ ࠷ޙʹಡΈऔͬͨҐஔ ɹ ͔͜͜ΒϨϓϦέʔγϣϯ࠶։͕ͩ େ͖͘ζϨ͍ͯΔ

  114. ɹɹϚελʔόΠφϦϩάͷ֬ೝ mysql> SHOW MASTER STATUS\G ********* 1. row ********* File:

    mysql-bin.000075 Position: 588201136 Binlog_Do_DB: Binlog_Ignore_DB: 1 row in set (0.01 sec) ͕ࠩ͋Γ͗͢Δͱ ಉظͷࡍʹ ෛՙ͕͔͔Δ
  115. ɹɹεϨʔϒͷઃఆ֬ೝ ⾣4MBWF@*0@3VOOJOHɿ/0 εϨʔϒͷ*0εϨου͕ ࣮ߦ͞Ε͍ͯͳ͍ ɹ ϚελʔͷόΠφϦϩά͕ҧ͏ͷͰ ઀ଓͰ͖͍ͯͳ͍

  116. ɹɹεϨʔϒͷઃఆ֬ೝ ⾣4MBWF@*0@3VOOJOHɿ/0 εϨʔϒͷ*0εϨου͕ ࣮ߦ͞Ε͍ͯͳ͍ ɹ ϚελʔͷόΠφϦϩά͕ҧ͏ͷͰ ઀ଓͰ͖͍ͯͳ͍

  117. ɹɹεϨʔϒͷઃఆ֬ೝ ⾣4MBWF@42-@3VOOJOHɿ/0 εϨʔϒͷ42-εϨου͕ ࣮ߦ͞Ε͍ͯͳ͍ ɹ εϨʔϒͷ%#͕ ߋ৽͞Ε͍ͯͳ͍

  118. ɹɹεϨʔϒͷઃఆ֬ೝ ⾣4MBWF@42-@3VOOJOHɿ/0 εϨʔϒͷ42-εϨου͕ ࣮ߦ͞Ε͍ͯͳ͍ ɹ εϨʔϒͷ%#͕ ߋ৽͞Ε͍ͯͳ͍

  119. ɹɹεϨʔϒͷઃఆ֬ೝ ⾣4FDPOET@#FIJOE@.BTUFSɿ/6-- Ϛελʔʹൺ΂ͯ ஗Ԇ͍ͯ͠Δඵ਺ ɹ ϨϓϦέʔγϣϯ࣮ߦ͞Ε͍ͯͳ͍

  120. ɹɹεϨʔϒͷઃఆ֬ೝ ⾣4FDPOET@#FIJOE@.BTUFSɿ/6-- Ϛελʔʹൺ΂ͯ ஗Ԇ͍ͯ͠Δඵ਺ ɹ ϨϓϦέʔγϣϯ࣮ߦ͞Ε͍ͯͳ͍

  121. ɹɹεϨʔϒͷઃఆ֬ೝ ⾣4FDPOET@#FIJOE@.BTUFSɿ/6-- Ϛελʔʹൺ΂ͯ ஗Ԇ͍ͯ͠Δඵ਺ ɹ ϨϓϦέʔγϣϯ࣮ߦ͞Ε͍ͯͳ͍ ྫɿϚελʔͰඵ͔͔Δ ɹɹτϥϯβΫγϣϯ࣮ߦ εϨʔϒͰಉ͡42-͕࣮ߦ ͞ΕΔͷͰɺඵ஗Ԇ͢Δ

  122. ɹɹεϨʔϒͷઃఆ֬ೝ ⾣4FDPOET@#FIJOE@.BTUFSɿ/6-- Ϛελʔʹൺ΂ͯ ஗Ԇ͍ͯ͠Δඵ਺ ɹ ϨϓϦέʔγϣϯ࣮ߦ͞Ε͍ͯͳ͍ ྫɿϚελʔͰඵ͔͔Δ ɹɹτϥϯβΫγϣϯ࣮ߦ εϨʔϒͰಉ͡42-͕࣮ߦ ͞ΕΔͷͰɺඵ஗Ԇ͢Δ

  123. ɹɹεϨʔϒͷઃఆ֬ೝ ⾣.BTUFS@4FSWFS@*Eɿ ઀ଓ͍ͯ͠Δ Ϛελʔͷ*% ɹ ઀ଓͰ͖͍ͯͳ͍

  124. ɹɹεϨʔϒͷઃఆ֬ೝ ⾣.BTUFS@4FSWFS@*Eɿ ઀ଓ͍ͯ͠Δ Ϛελʔͷ*% ɹ ઀ଓͰ͖͍ͯͳ͍

  125. ϚελʔͷNZDOG ϨϓϦέʔγϣϯ͞Ε͍ͯΕ͹ ͜ͷ஋ʹͳΔ

  126. ɹϨϓϦέʔγϣϯखॱ

  127. ɹϨϓϦέʔγϣϯखॱ ⾣ϚελʔͷEVNQΛऔಘ ⾣ϚελʔͷόΠφϦϩά໊ɺϙδγϣϯΛه࿥ ⾣εϨʔϒͷNZDOGઃఆ ⾣εϨʔϒʹϦετΞ ⾣εϨʔϒઃఆมߋ ⾣ϨϓϦέʔγϣϯ࣮ߦ ⾣࣮ߦঢ়گΛ؂ࢹ

  128. ɹϨϓϦέʔγϣϯखॱ ⾣ϚελʔͷEVNQΛऔಘ ⾣ϚελʔͷόΠφϦϩά໊ɺϙδγϣϯΛه࿥ ⾣εϨʔϒͷNZDOGઃఆ ⾣εϨʔϒʹϦετΞ ⾣εϨʔϒઃఆมߋ ⾣ϨϓϦέʔγϣϯ࣮ߦ ⾣࣮ߦঢ়گΛ؂ࢹ

  129. ɹɹϚελʔͷEVNQΛऔಘ ⾣ϚελʔΛࢭΊͣʹ࣮ߦ ɹɾόΠφϦϩάϑΝΠϧ໊ϝϞ ɹɾDPNNJUϙδγϣϯϝϞ ɹɹˠؼ୐લʹ࣮ࢪ ɹɾਂ໷όονͰEVNQ࣮ߦ

  130. ɹɹϚελʔͷEVNQΛऔಘ ⾣ϚελʔΛࢭΊͣʹ࣮ߦ ɹɾόΠφϦϩάϑΝΠϧ໊ϝϞ ɹɾDPNNJUϙδγϣϯϝϞ ɹɹˠؼ୐લʹ࣮ࢪ ɹɾਂ໷όονͰEVNQ࣮ߦ

  131. ɹɹϚελʔͷEVNQΛऔಘ ⾣ϚελʔΛࢭΊͣʹ࣮ߦ ɹɾόΠφϦϩάϑΝΠϧ໊ϝϞ ɹɾDPNNJUϙδγϣϯϝϞ ɹɹˠؼ୐લʹ࣮ࢪ ɹɾਂ໷όονͰEVNQ࣮ߦ

  132. ɹɹϚελʔͷEVNQΛऔಘ ⾣ϚελʔΛࢭΊͣʹ࣮ߦ ɹɾόΠφϦϩάϑΝΠϧ໊ϝϞ ɹɾDPNNJUϙδγϣϯϝϞ ɹɹˠؼ୐લʹ࣮ࢪ ɹɾਂ໷όονͰEVNQ࣮ߦ

  133. ɹɹϚελʔόΠφϦϩάͷ֬ೝ mysql> SHOW MASTER STATUS\G ********* 1. row ********* File:

    mysql-bin.000075 Position: 588201136 Binlog_Do_DB: Binlog_Ignore_DB: 1 row in set (0.01 sec) εϨʔϒઃఆͰ࢖༻͢ΔͨΊ ϝϞ͓͖ͯ͠·͠ΐ͏
  134. ɹϨϓϦέʔγϣϯखॱ ⾣ϚελʔͷEVNQΛऔಘ ⾣ϚελʔͷόΠφϦϩά໊ɺϙδγϣϯΛه࿥ ⾣εϨʔϒͷNZDOGઃఆ ⾣εϨʔϒʹϦετΞ ⾣εϨʔϒઃఆมߋ ⾣ϨϓϦέʔγϣϯ࣮ߦ ⾣࣮ߦঢ়گΛ؂ࢹ

  135. ɹɹεϨʔϒͷNZDOGઃఆ

  136. ɹɹεϨʔϒͷNZDOGઃఆ ϚελʔɺεϨʔϒ શͯ߹Θͤͯ Ұҙͷ*%

  137. ɹɹεϨʔϒͷNZDOGઃఆ όΠφϦϩάઃఆ Ϛελʔʹঢ֨ͨ͠৔߹ εϨʔϒʹ௨஌͢Δ

  138. ɹɹεϨʔϒͷNZDOGઃఆ ϩʔςʔτͯ͠ ༰ྔѹഭ͠ͳ͍Α͏ʹ

  139. ɹɹεϨʔϒͷNZDOGઃఆ εϨʔϒͰ΋ όΠφϦϩάΛग़ྗ͠ Ϛελʔঢ֨Մೳʹ

  140. ɹɹεϨʔϒͷNZDOGઃఆ ಉظ࣌ɺ 1,͕ॏෳ͢ΔϨίʔυΛ ඈ͹͢

  141. ɹɹεϨʔϒͷͦͷଞͷ࡞ۀ

  142. ɹɹεϨʔϒͷͦͷଞͷ࡞ۀ ⾣NZTRM࠶ىಈ ⾣ϦετΞର৅ͷ ɹɹɹσʔλϕʔε࡟আɾ࠶࡞੒

  143. ɹɹεϨʔϒͷͦͷଞͷ࡞ۀ ⾣NZTRM࠶ىಈ ⾣ϦετΞର৅ͷ ɹɹɹσʔλϕʔε࡟আɾ࠶࡞੒

  144. ɹϨϓϦέʔγϣϯखॱ ⾣ϚελʔͷEVNQΛऔಘ ⾣ϚελʔͷόΠφϦϩά໊ɺϙδγϣϯΛه࿥ ⾣εϨʔϒͷNZDOGઃఆ ⾣εϨʔϒʹϦετΞ ⾣εϨʔϒઃఆมߋ ⾣ϨϓϦέʔγϣϯ࣮ߦ ⾣࣮ߦঢ়گΛ؂ࢹ

  145. ɹɹεϨʔϒʹϦετΞ ⾣ਂ໷όονͷঢ়ଶͰϦετΞ ɹɾEVNQϑΝΠϧऔಘˍల։ ɹɾϦετΞ࣮ߦ ɹɾετϨʔδ༰ྔʹ஫ҙʂ ɹɹˠ(୯ҐͷόΠφϦϩά͕ ɹɹɹɹͲΜͲΜͰ͖ͯ༰ྔΛѹഭ

  146. ɹɹεϨʔϒʹϦετΞ ⾣ਂ໷όονͷঢ়ଶͰϦετΞ ɹɾEVNQϑΝΠϧऔಘˍల։ ɹɾϦετΞ࣮ߦ ɹɾετϨʔδ༰ྔʹ஫ҙʂ ɹɹˠ(୯ҐͷόΠφϦϩά͕ ɹɹɹɹͲΜͲΜͰ͖ͯ༰ྔΛѹഭ

  147. ɹɹεϨʔϒʹϦετΞ ⾣ਂ໷όονͷঢ়ଶͰϦετΞ ɹɾEVNQϑΝΠϧऔಘˍల։ ɹɾϦετΞ࣮ߦ ɹɾετϨʔδ༰ྔʹ஫ҙʂ ɹɹˠ(୯ҐͷόΠφϦϩά͕ ɹɹɹɹͲΜͲΜͰ͖ͯ༰ྔΛѹഭ

  148. ɹɹεϨʔϒʹϦετΞ ⾣ਂ໷όονͷঢ়ଶͰϦετΞ ɹɾEVNQϑΝΠϧऔಘˍల։ ɹɾϦετΞ࣮ߦ ɹɾετϨʔδ༰ྔʹ஫ҙʂ ɹɹˠ(୯ҐͷόΠφϦϩά͕ ɹɹɹɹͲΜͲΜͰ͖ͯ༰ྔΛѹഭ

  149. ɹɹεϨʔϒʹϦετΞ ⾣ਂ໷όονͷঢ়ଶͰϦετΞ ɹɾEVNQϑΝΠϧऔಘˍల։ ɹɾϦετΞ࣮ߦ ɹɾετϨʔδ༰ྔʹ஫ҙʂ ɹɹˠ(୯ҐͷόΠφϦϩά͕ ɹɹɹɹͲΜͲΜͰ͖ͯ༰ྔΛѹഭ 163(&."45&3-0(450 bNZTRMCJOYYYYYY` ద੾ʹύʔδ͠·͠ΐ͏

  150. ɹϨϓϦέʔγϣϯखॱ ⾣ϚελʔͷEVNQΛऔಘ ⾣ϚελʔͷόΠφϦϩά໊ɺϙδγϣϯΛه࿥ ⾣εϨʔϒͷNZDOGઃఆ ⾣εϨʔϒʹϦετΞ ⾣εϨʔϒઃఆมߋ ⾣ϨϓϦέʔγϣϯ࣮ߦ ⾣࣮ߦঢ়گΛ؂ࢹ

  151. ɹεϨʔϒઃఆมߋ ⾣ϚελʔͰϝϞͨ͠಺༰Λઃఆ mysql> STOP SLAVE; mysql> RESET SLAVE; mysql> CHANGE

    MASTER TO -> master_log_file = ’mysql-bin.000075’, -> master_log_pos = 588201136;
  152. mysql> STOP SLAVE; mysql> RESET SLAVE; mysql> CHANGE MASTER TO

    -> master_log_file = ’mysql-bin.000075’, -> master_log_pos = 588201136; ɹεϨʔϒઃఆมߋ ⾣ϚελʔͰϝϞͨ͠಺༰Λઃఆ ೦ͷͨΊ εϨʔϒΛࢭΊ·͢
  153. mysql> STOP SLAVE; mysql> RESET SLAVE; mysql> CHANGE MASTER TO

    -> master_log_file = ’mysql-bin.000075’, -> master_log_pos = 588201136; ɹεϨʔϒઃఆมߋ ⾣ϚελʔͰϝϞͨ͠಺༰Λઃఆ εϨʔϒ͕อ͍࣋ͯͨ͠ ϨϓϦέʔγϣϯҐஔΛ Ϧηοτ͠·͢
  154. mysql> STOP SLAVE; mysql> RESET SLAVE; mysql> CHANGE MASTER TO

    -> master_log_file = ’mysql-bin.000075’, -> master_log_pos = 588201136; ɹεϨʔϒઃఆมߋ ⾣ϚελʔͰϝϞͨ͠಺༰Λઃఆ ϚελʔͷόΠφϦϩάɺ ϙδγϣϯΛઃఆ
  155. ɹϨϓϦέʔγϣϯखॱ ⾣ϚελʔͷEVNQΛऔಘ ⾣ϚελʔͷόΠφϦϩά໊ɺϙδγϣϯΛه࿥ ⾣εϨʔϒͷNZDOGઃఆ ⾣εϨʔϒʹϦετΞ ⾣εϨʔϒઃఆมߋ ⾣ϨϓϦέʔγϣϯ࣮ߦ ⾣࣮ߦঢ়گΛ؂ࢹ

  156. ɹϨϓϦέʔγϣϯ࣮ߦ ⾣ϨϓϦέʔγϣϯͷ։࢝ mysql> START SLAVE;

  157. ɹϨϓϦέʔγϣϯ࣮ߦ ⾣ϨϓϦέʔγϣϯͷ։࢝ mysql> START SLAVE; ઃఆͨ͠ϙδγϣϯ͔Β ಉظ͕࣮ߦ͞Ε·͢

  158. ɹϨϓϦέʔγϣϯ࣮ߦ ⾣ϨϓϦέʔγϣϯͷ֬ೝ

  159. ɹϨϓϦέʔγϣϯ࣮ߦ ⾣ϨϓϦέʔγϣϯͷ֬ೝ mysql> SHOW SLAVE STATUS\G

  160. ɹϨϓϦέʔγϣϯ࣮ߦ ⾣ϨϓϦέʔγϣϯͷ֬ೝ mysql> SHOW SLAVE STATUS\G ***************** 1. row *****************

    Slave_IO_State: Waiting for master to send event Master_Log_File: mysql-bin.000075 Read_Master_Log_Pos: 878873047 Slave_IO_Running: Yes Slave_SQL_Running: Yes Exec_Master_Log_Pos: 605504154 Seconds_Behind_Master: 244615 Last_IO_Errno: 0 Last_IO_Error: Last_SQL_Errno: 0 Last_SQL_Error: Master_Server_Id: 1001
  161. ɹϨϓϦέʔγϣϯͷ֬ೝ ⾣4MBWF@*0@4UBUFɿ 8BJUJOHGPSNBTUFSUPTFOEFWFOU εϨʔϒͷݱࡏͷεςʔλε ϨϓϦέʔγϣϯ͕։࢝͞Ε Ϛελʔ͔ΒͷΠϕϯτ଴ͪ

  162. ɹϨϓϦέʔγϣϯͷ֬ೝ ⾣4MBWF@*0@4UBUFɿ 8BJUJOHGPSNBTUFSUPTFOEFWFOU εϨʔϒͷݱࡏͷεςʔλε ϨϓϦέʔγϣϯ͕։࢝͞Ε Ϛελʔ͔ΒͷΠϕϯτ଴ͪ

  163. ɹϨϓϦέʔγϣϯͷ֬ೝ ⾣.BTUFS@-PH@'JMFɿ NZTRMCJO ϚελʔͷόΠφϦϩάϑΝΠϧ ݱࡏϚελͰߋ৽͞Ε͍ͯΔ ϑΝΠϧ໊ʹͳ͍ͬͯΔ

  164. ɹϨϓϦέʔγϣϯͷ֬ೝ ⾣.BTUFS@-PH@'JMFɿ NZTRMCJO ϚελʔͷόΠφϦϩάϑΝΠϧ ݱࡏϚελͰߋ৽͞Ε͍ͯΔ ϑΝΠϧ໊ʹͳ͍ͬͯΔ

  165. ɹϨϓϦέʔγϣϯͷ֬ೝ ⾣3FBE@.BTUFS@-PH@1PTɿ  ϚελʔͷόΠφϦϩά͔Β εϨʔϒ͕ಡΈऔͬͨҐஔ ˞42-࣮ߦ͞Εͨͱ͸ݶΒͳ͍

  166. ɹϨϓϦέʔγϣϯͷ֬ೝ ⾣3FBE@.BTUFS@-PH@1PTɿ  ϚελʔͷόΠφϦϩά͔Β *0εϨου͕ಡΈऔͬͨҐஔ ˞42-࣮ߦ͞Εͨͱ͸ݶΒͳ͍

  167. ɹϨϓϦέʔγϣϯͷ֬ೝ ⾣&YFD@.BTUFS@-PH@1PTɿ  *0εϨου͕ಡΈࠐΜͩϩά͔Β 42-εϨου͕ ࣮ߦͨ͠ΫΤϦͷҐஔ

  168. ɹϨϓϦέʔγϣϯͷ֬ೝ ⾣&YFD@.BTUFS@-PH@1PTɿ  *0εϨου͕ಡΈࠐΜͩϩά͔Β 42-εϨου͕ ࣮ߦͨ͠ΫΤϦͷҐஔ

  169. ɹϨϓϦέʔγϣϯͷ֬ೝ ⾣&YFD@.BTUFS@-PH@1PTɿ  *0εϨου͕ಡΈࠐΜͩϩά͔Β 42-εϨου͕ ࣮ߦͨ͠ΫΤϦͷҐஔ ಡΈऔͬͨҐஔʔ࣮ߦͨ͠Ґஔ ʹ ஗Ԇ͍ͯ͠ΔτϥϯβΫγϣϯ

  170. ɹϨϓϦέʔγϣϯͷ֬ೝ ⾣4FDPOET@#FIJOE@.BTUFSɿ  εϨʔϒ͕Ϛελʔʹൺ΂ ஗Ԇ͍ͯ͠Δඵ਺

  171. ɹϨϓϦέʔγϣϯͷ֬ೝ ⾣4FDPOET@#FIJOE@.BTUFSɿ  εϨʔϒ͕Ϛελʔʹൺ΂ ஗Ԇ͍ͯ͠Δඵ਺

  172. ɹϨϓϦέʔγϣϯͷ֬ೝ ⾣4FDPOET@#FIJOE@.BTUFSɿ  εϨʔϒ͕Ϛελʔʹൺ΂ ஗Ԇ͍ͯ͠Δඵ਺ ஗ԆτϥϯβΫγϣϯͷ ֤ඵ਺ͷ૯߹ܭ

  173. ɹϨϓϦέʔγϣϯͷ֬ೝ ⾣4MBWF@*0@3VOOJOHɿ:&4 ϚελʔͷόΠφϦϩάΛ औಘͰ͖͍ͯΔ͔

  174. ɹϨϓϦέʔγϣϯͷ֬ೝ ⾣4MBWF@*0@3VOOJOHɿ:&4 ϚελʔͷόΠφϦϩάΛ औಘͰ͖͍ͯΔ͔

  175. ɹϨϓϦέʔγϣϯͷ֬ೝ ⾣4MBWF@42-@3VOOJOHɿ:&4 औಘͨ͠όΠφϦϩάͷ 42-࣮ߦͰ͖͍ͯΔ͔

  176. ɹϨϓϦέʔγϣϯͷ֬ೝ ⾣4MBWF@42-@3VOOJOHɿ:&4 औಘͨ͠όΠφϦϩάͷ 42-࣮ߦͰ͖͍ͯΔ͔

  177. ɹϨϓϦέʔγϣϯͷ֬ೝ ⾣-BTU@*0@&SSOPɿ ࠷ޙʹ࣮ߦͨ͠*0εϨουͷ Τϥʔ൪߸

  178. ɹϨϓϦέʔγϣϯͷ֬ೝ ⾣-BTU@*0@&SSOPɿ ࠷ޙʹ࣮ߦͨ͠ *0εϨουͷ Τϥʔ൪߸

  179. ɹϨϓϦέʔγϣϯͷ֬ೝ ⾣-BTU@*0@&SSPSɿۭจࣈ ࠷ޙʹ࣮ߦͨ͠ *0εϨουͷ Τϥʔϝοηʔδ

  180. ɹϨϓϦέʔγϣϯͷ֬ೝ ⾣-BTU@*0@&SSPSɿۭจࣈ ࠷ޙʹ࣮ߦͨ͠ *0εϨουͷ Τϥʔϝοηʔδ

  181. ɹϨϓϦέʔγϣϯͷ֬ೝ ⾣-BTU@42-@&SSOPɿ ࠷ޙʹ࣮ߦͨ͠ 42-εϨουͷ Τϥʔ൪߸

  182. ɹϨϓϦέʔγϣϯͷ֬ೝ ⾣-BTU@42-@&SSOPɿ ࠷ޙʹ࣮ߦͨ͠ 42-εϨουͷ Τϥʔ൪߸

  183. ɹϨϓϦέʔγϣϯͷ֬ೝ ⾣-BTU@42-@&SSOPɿ ࠷ޙʹ࣮ߦͨ͠ 42-εϨουͷ Τϥʔ൪߸ 1,ॏෳΤϥʔͷ৔߹ 

  184. ɹϨϓϦέʔγϣϯͷ֬ೝ ⾣-BTU@42-@&SSPSɿۭจࣈ ࠷ޙʹ࣮ߦͨ͠ 42-εϨουͷ Τϥʔϝοηʔδ

  185. ɹϨϓϦέʔγϣϯͷ֬ೝ ⾣-BTU@42-@&SSPSɿۭจࣈ ࠷ޙʹ࣮ߦͨ͠ 42-εϨουͷ Τϥʔϝοηʔδ

  186. ɹϨϓϦέʔγϣϯͷ֬ೝ ⾣-BTU@42-@&SSPSɿۭจࣈ ࠷ޙʹ࣮ߦͨ͠ 42-εϨουͷ Τϥʔϝοηʔδ 1,ॏෳΤϥʔͷ৔߹ &SSPS%VQMJDBUFFOUSZGPS LFZ13*."3:PORVFSZɽɽɽ

  187. ɹϨϓϦέʔγϣϯͷ֬ೝ ⾣.BTUFS@4FSWFS@*Eɿ ಉظ͍ͯ͠Δ Ϛελʔͷ*%

  188. ɹϨϓϦέʔγϣϯͷ֬ೝ ⾣.BTUFS@4FSWFS@*Eɿ ಉظ͍ͯ͠Δ Ϛελʔͷ*%

  189. ɹϨϓϦέʔγϣϯखॱ ⾣ϚελʔͷEVNQΛऔಘ ⾣ϚελʔͷόΠφϦϩά໊ɺϙδγϣϯΛه࿥ ⾣εϨʔϒͷNZDOGઃఆ ⾣εϨʔϒʹϦετΞ ⾣εϨʔϒઃఆมߋ ⾣ϨϓϦέʔγϣϯ࣮ߦ ⾣࣮ߦঢ়گΛ؂ࢹ

  190. ɹ࣮ߦঢ়گΛ؂ࢹ mysql> SHOW SLAVE STATUS\G **************** 1. row ************** Read_Master_Log_Pos:

    878873047 Exec_Master_Log_Pos: 605504154 Seconds_Behind_Master: 244615 ⾣࣮ߦ௚ޙ
  191. ɹ࣮ߦঢ়گΛ؂ࢹ mysql> SHOW SLAVE STATUS\G **************** 1. row ************** Read_Master_Log_Pos:

    878873047 Exec_Master_Log_Pos: 605504154 Seconds_Behind_Master: 244615 ⾣࣮ߦ௚ޙ mysql> SHOW SLAVE STATUS\G **************** 1. row ************** Read_Master_Log_Pos: 879066686 Exec_Master_Log_Pos: 879066686 Seconds_Behind_Master: 0 ⾣ಉظ׬ྃ
  192. ॠؒɺ৺ɺॏͶͯ

  193. γϯΫϩ཰ ˋ

  194. ݁Ռ

  195. ݁Ռ ࢲ Ϛελʔ ͕ མͪͯ΋

  196. ݁Ռ ୅ΘΓ ϨϓϦΧ  ͕͋Δ΋ͷʂ

  197. ՝୊

  198. ՝୊ ϑΣΠϧΦʔόʔ ͷ࢓૊ΈΛ༻ҙ͠ ࣗಈతʹ৑௕Խ

  199. ·ͱΊ

  200. ·ͱΊ ⾣ෳ੡࡞੒ɾӡ༻׬ྃʂ ⾣ࢀরܥͷαʔόʔ४උ׬ྃʂ ⾣όοΫΞοϓαʔόʔ࡞੒׬ྃ

  201. ·ͱΊ ⾣ෳ੡࡞੒ɾӡ༻׬ྃʂ ⾣ࢀরܥͷαʔόʔ४උ׬ྃʂ ⾣όοΫΞοϓαʔόʔ࡞੒׬ྃ

  202. ·ͱΊ ⾣ෳ੡࡞੒ɾӡ༻׬ྃʂ ⾣ࢀরܥͷαʔόʔ४උ׬ྃʂ ⾣όοΫΞοϓαʔόʔ࡞੒׬ྃ

  203. ऴΘΓʹ σʔλ͸ ෳ੡໋͕

  204. ऴΘΓʹ Մ༻ੑΛߴΊ γεςϜΛ αʔϏεαʔϏε͎ ͍͖ͯ͠·͠ΐ͏ʂ

  205. ऴΘΓʹ ΠϯϓοτΛ ௐ΂ͯΞ΢τϓοτ ʹ ݟ࣮ͯߦ͢Δʂ

  206. ऴΘΓʹ ϚϯΨ͡Όͳ͍͚Ͳ ՄࢹԽେ੾ʂ

  207. ऴΘΓʹ ͋Γ͕ͱ͏͍͟͝·ͨ͠ʂ

  208. 4QFDJBM5IBOLT ωλఏڙˏ Ԟ ͞ · ೥݄೔ ݄

  209. ͓·͚ ⾣ݩهࣄͷ͝঺հ ɾ.Z42-ϨϓϦέʔγϣϯઃఆ खॱɾ֤छεςʔλεͷৄࡉͱ τϥϒϧγϡʔςΟϯά ɹIUUQRJJUBDPNNBNZJUFNTBFEGBCGE