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

mysql_replication

 mysql_replication

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

mamy1326

April 20, 2017
Tweet

More Decks by mamy1326

Other Decks in Programming

Transcript

  1. .Z42-αʔόʔΛ
    ϨϓϦέʔγϣϯ
    Λ࣮ߦ͢Δ͓࿩
    ·Έ΍ͳ͓͖ !NBNZ

    "QS !ୈճ1)1ษڧձˏ౦ژ

    View Slide

  2. .Z42-
    Λ


    ͠
    αʔόʔ
    1)1ษڧձ!౦ژୈ࿩
    ࢲ͕
    ˓ΜͰ΋
    ୅ΘΓ͸ ུ

    ͢Δ
    ͓࿩
    ·Έ΍ͳϮ͖
    !NBNZ

    View Slide

  3. ࠓ೔ͷςʔϚ
    ࢲͷ୅ΘΓ͸
    ͍͘ΒͰ΋͍ΔΘ
    ͱݴͬͯ

    View Slide

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

    View Slide

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

    ͢Δ͓࿩

    View Slide

  6. ੢ྐྵ೥݄

    View Slide

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

    View Slide

  8. NZDOG͕
    σϑΥϧτ

    View Slide

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

    View Slide

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

    View Slide

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

    View Slide

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

    View Slide

  13. ੢ྐྵ೥݄

    View Slide

  14. ηΧϯυ
    ΠϯύΫτ

    View Slide

  15. ՝୊

    View Slide

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

    View Slide

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

    View Slide

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

    View Slide

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

    View Slide

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

    View Slide

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

    View Slide

  22. ɹϨϓϦέʔγϣϯͱ͸
    ⾣σʔλϕʔεશମͷෳ੡ ϨϓϦΧ

    ⾣ผͷαʔόʔʹෳ੡ʢεϨʔϒʣ
    ⾣.Z42-ͷඪ४ػೳͰ͓खܰ
    ⾣΄΅࣌ؒࠩͳ͠ʹಉظ

    View Slide

  23. ɹϨϓϦέʔγϣϯͱ͸
    ⾣σʔλϕʔεશମͷෳ੡ ϨϓϦΧ

    ⾣ผͷαʔόʔʹෳ੡ʢεϨʔϒʣ
    ⾣.Z42-ͷඪ४ػೳͰ͓खܰ
    ⾣΄΅࣌ؒࠩͳ͠ʹಉظ

    View Slide

  24. ɹϨϓϦέʔγϣϯͱ͸
    ⾣σʔλϕʔεશମͷෳ੡ ϨϓϦΧ

    ⾣ผͷαʔόʔʹෳ੡ʢεϨʔϒʣ
    ⾣.Z42-ͷඪ४ػೳͰ͓खܰ
    ⾣΄΅࣌ؒࠩͳ͠ʹಉظ

    View Slide

  25. ɹϨϓϦέʔγϣϯͱ͸
    ⾣σʔλϕʔεશମͷෳ੡ ϨϓϦΧ

    ⾣ผͷαʔόʔʹෳ੡ʢεϨʔϒʣ
    ⾣.Z42-ͷඪ४ػೳͰ͓खܰ
    ⾣΄΅࣌ؒࠩͳ͠ʹಉظ

    View Slide

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

    View Slide

  27. Ϛελʔ

    View Slide

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

    View Slide

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

    View Slide

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

    View Slide

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

    View Slide

  32. εϨʔϒ

    View Slide

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

    View Slide

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

    View Slide

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

    View Slide

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

    View Slide

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

    View Slide

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

    View Slide

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

    View Slide

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

    View Slide

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

    View Slide

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

    View Slide

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

    View Slide

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

    View Slide

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

    View Slide

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

    View Slide

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

    View Slide

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

    View Slide

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

    View Slide

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

    View Slide

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

    View Slide

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

    View Slide

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

    View Slide

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

    View Slide

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

    View Slide

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

    View Slide

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

    View Slide

  58. ͭ·Γ

    View Slide

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

    View Slide

  60. Ͱ΋

    View Slide

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

    View Slide

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

    View Slide

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

    View Slide

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

    View Slide

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

    View Slide

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

    View Slide

  67. ๻͕
    ΍Γ·͢

    View Slide

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

    View Slide

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

    View Slide

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

    View Slide

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

    View Slide

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

    View Slide

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

    View Slide

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

    View Slide

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

    View Slide

  76. ɹɹϨϓϦέʔγϣϯϢʔβʔ࡞੒
    TVEPDBUWBSMJCNZTRMNBTUFSJOGP

    NZTRMCJO

    <Ϛελʔͷ*1ΞυϨε·ͨ͸ϗετ໊>
    <Ϛελʔʹ઀ଓ͢ΔNZTRMϢʔβʔ໊>
    <Ϛελʔʹ઀ଓ͢ΔNZTRMύεϫʔυ>


    ʜ

    View Slide

  77. ɹɹϨϓϦέʔγϣϯϢʔβʔ࡞੒
    TVEPDBUWBSMJCNZTRMNBTUFSJOGP

    NZTRMCJO

    <Ϛελʔͷ*1ΞυϨε·ͨ͸ϗετ໊>
    <Ϛελʔʹ઀ଓ͢ΔNZTRMϢʔβʔ໊>
    <Ϛελʔʹ઀ଓ͢ΔNZTRMύεϫʔυ>


    ʜ
    ઀ଓ৘ใ͕
    ϓϨʔϯςΩετ

    View Slide

  78. ɹɹϨϓϦέʔγϣϯϢʔβʔ࡞੒
    TVEPDBUWBSMJCNZTRMNBTUFSJOGP

    NZTRMCJO

    <Ϛελʔͷ*1ΞυϨε·ͨ͸ϗετ໊>
    <Ϛελʔʹ઀ଓ͢ΔNZTRMϢʔβʔ໊>
    <Ϛελʔʹ઀ଓ͢ΔNZTRMύεϫʔυ>


    ʜ
    ηΩϡϦςΟͷͨΊ
    ઐ༻Ϣʔβ࡞੒

    View Slide

  79. ͜͏͍͏࣌
    ͋Γ·ͤΜ͔ʁ

    View Slide

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

    View Slide

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

    View Slide

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

    View Slide

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

    View Slide

  84. ɹɹϨϓϦέʔγϣϯϢʔβʔ࡞੒
    ⾣ݖݶίϚϯυ
    NZTRM NBTUFS
    (3"/53&1-*$"5*0/4-"7&
    NZTRM NBTUFS
    0/50
    NZTRM NBTUFS
    `SFQM`!`<εϨʔϒͷϗετ໊>`

    View Slide

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

    View Slide

  86. ϚελʔͷNZDOG

    View Slide

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

    View Slide

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

    View Slide

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

    View Slide

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

    View Slide

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

    View Slide

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

    View Slide

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

    View Slide

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

    View Slide

  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)

    View Slide

  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

    View Slide

  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͕࣮ߦ͞Εͨ
    ϙδγϣϯ

    View Slide

  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)
    εϨʔϒઃఆͰ࢖༻͢ΔͨΊ
    ϝϞ͓͖ͯ͠·͠ΐ͏

    View Slide

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

    View Slide

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

    View Slide

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

    View Slide

  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)

    View Slide

  103. ɹɹεϨʔϒͷઃఆ֬ೝ
    [email protected]*[email protected]ɿۭจࣈ
    ɹεϨʔϒͷݱࡏͷεςʔλε
    ɹϨϓϦέʔγϣϯ్͕੾Ε͍ͯΔͨΊ
    ɹۭจࣈͱͳ͍ͬͯΔ
    ࣮ߦ͞Ε͍ͯΕ͹
    8BJUJOHGPSNBTUFSUPTFOEFWFOU

    View Slide

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

    View Slide

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

    View Slide

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

    View Slide

  107. ɹɹεϨʔϒͷઃఆ֬ೝ
    [email protected]ɿSFQM
    εϨʔϒ͔ΒϚελʔʹ
    ઀ଓ͢ΔϢʔβʔ໊
    ɹ
    ઌ΄Ͳઃఆͨ͠ઐ༻Ϣʔβʔ

    View Slide

  108. ɹɹεϨʔϒͷઃఆ֬ೝ
    [email protected]ɿSFQM
    εϨʔϒ͔ΒϚελʔʹ
    ઀ଓ͢ΔϢʔβʔ໊
    ɹ
    ϚελʔͰ࡞੒ͨ͠ઐ༻Ϣʔβʔ

    View Slide

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

    View Slide

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

    View Slide

  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)
    ϩʔςʔτ͞Εͯ
    ϑΝΠϧ͕ͳ͍ͷͰ
    औಘͰ͖ͳ͍

    View Slide

  112. ɹɹεϨʔϒͷઃఆ֬ೝ
    [email protected]@[email protected]ɿ
    εϨʔϒͷ*0εϨου͕
    ࠷ޙʹಡΈऔͬͨҐஔ
    ɹ
    ͔͜͜ΒϨϓϦέʔγϣϯ࠶։͕ͩ
    େ͖͘ζϨ͍ͯΔ

    View Slide

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

    View Slide

  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)
    ͕ࠩ͋Γ͗͢Δͱ
    ಉظͷࡍʹ
    ෛՙ͕͔͔Δ

    View Slide

  115. ɹɹεϨʔϒͷઃఆ֬ೝ
    [email protected]*[email protected]ɿ/0
    εϨʔϒͷ*0εϨου͕
    ࣮ߦ͞Ε͍ͯͳ͍
    ɹ
    ϚελʔͷόΠφϦϩά͕ҧ͏ͷͰ
    ઀ଓͰ͖͍ͯͳ͍

    View Slide

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

    View Slide

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

    View Slide

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

    View Slide

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

    View Slide

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

    View Slide

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

    View Slide

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

    View Slide

  123. ɹɹεϨʔϒͷઃఆ֬ೝ
    [email protected]@*Eɿ
    ઀ଓ͍ͯ͠Δ
    Ϛελʔͷ*%
    ɹ
    ઀ଓͰ͖͍ͯͳ͍

    View Slide

  124. ɹɹεϨʔϒͷઃఆ֬ೝ
    [email protected]@*Eɿ
    ઀ଓ͍ͯ͠Δ
    Ϛελʔͷ*%
    ɹ
    ઀ଓͰ͖͍ͯͳ͍

    View Slide

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

    View Slide

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

    View Slide

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

    View Slide

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

    View Slide

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

    View Slide

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

    View Slide

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

    View Slide

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

    View Slide

  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)
    εϨʔϒઃఆͰ࢖༻͢ΔͨΊ
    ϝϞ͓͖ͯ͠·͠ΐ͏

    View Slide

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

    View Slide

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

    View Slide

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

    View Slide

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

    View Slide

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

    View Slide

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

    View Slide

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

    View Slide

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

    View Slide

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

    View Slide

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

    View Slide

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

    View Slide

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

    View Slide

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

    View Slide

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

    View Slide

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

    View Slide

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

    View Slide

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

    View Slide

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

    View Slide

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

    View Slide

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

    View Slide

  154. mysql> STOP SLAVE;
    mysql> RESET SLAVE;
    mysql> CHANGE MASTER TO
    -> master_log_file = ’mysql-bin.000075’,
    -> master_log_pos = 588201136;
    ɹεϨʔϒઃఆมߋ
    ⾣ϚελʔͰϝϞͨ͠಺༰Λઃఆ
    ϚελʔͷόΠφϦϩάɺ
    ϙδγϣϯΛઃఆ

    View Slide

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

    View Slide

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

    View Slide

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

    View Slide

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

    View Slide

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

    View Slide

  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

    View Slide

  161. ɹϨϓϦέʔγϣϯͷ֬ೝ
    [email protected]*[email protected]ɿ
    8BJUJOHGPSNBTUFSUPTFOEFWFOU
    εϨʔϒͷݱࡏͷεςʔλε
    ϨϓϦέʔγϣϯ͕։࢝͞Ε
    Ϛελʔ͔ΒͷΠϕϯτ଴ͪ

    View Slide

  162. ɹϨϓϦέʔγϣϯͷ֬ೝ
    [email protected]*[email protected]ɿ
    8BJUJOHGPSNBTUFSUPTFOEFWFOU
    εϨʔϒͷݱࡏͷεςʔλε
    ϨϓϦέʔγϣϯ͕։࢝͞Ε
    Ϛελʔ͔ΒͷΠϕϯτ଴ͪ

    View Slide

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

    View Slide

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

    View Slide

  165. ɹϨϓϦέʔγϣϯͷ֬ೝ
    [email protected]@[email protected]ɿ

    ϚελʔͷόΠφϦϩά͔Β
    εϨʔϒ͕ಡΈऔͬͨҐஔ
    ˞42-࣮ߦ͞Εͨͱ͸ݶΒͳ͍

    View Slide

  166. ɹϨϓϦέʔγϣϯͷ֬ೝ
    [email protected]@[email protected]ɿ

    ϚελʔͷόΠφϦϩά͔Β
    *0εϨου͕ಡΈऔͬͨҐஔ
    ˞42-࣮ߦ͞Εͨͱ͸ݶΒͳ͍

    View Slide

  167. ɹϨϓϦέʔγϣϯͷ֬ೝ
    ⾣&[email protected]@[email protected]ɿ

    *0εϨου͕ಡΈࠐΜͩϩά͔Β
    42-εϨου͕
    ࣮ߦͨ͠ΫΤϦͷҐஔ

    View Slide

  168. ɹϨϓϦέʔγϣϯͷ֬ೝ
    ⾣&[email protected]@[email protected]ɿ

    *0εϨου͕ಡΈࠐΜͩϩά͔Β
    42-εϨου͕
    ࣮ߦͨ͠ΫΤϦͷҐஔ

    View Slide

  169. ɹϨϓϦέʔγϣϯͷ֬ೝ
    ⾣&[email protected]@[email protected]ɿ

    *0εϨου͕ಡΈࠐΜͩϩά͔Β
    42-εϨου͕
    ࣮ߦͨ͠ΫΤϦͷҐஔ
    ಡΈऔͬͨҐஔʔ࣮ߦͨ͠Ґஔ
    ʹ
    ஗Ԇ͍ͯ͠ΔτϥϯβΫγϣϯ

    View Slide

  170. ɹϨϓϦέʔγϣϯͷ֬ೝ
    [email protected]#[email protected]ɿ

    εϨʔϒ͕Ϛελʔʹൺ΂
    ஗Ԇ͍ͯ͠Δඵ਺

    View Slide

  171. ɹϨϓϦέʔγϣϯͷ֬ೝ
    [email protected]#[email protected]ɿ

    εϨʔϒ͕Ϛελʔʹൺ΂
    ஗Ԇ͍ͯ͠Δඵ਺

    View Slide

  172. ɹϨϓϦέʔγϣϯͷ֬ೝ
    [email protected]#[email protected]ɿ

    εϨʔϒ͕Ϛελʔʹൺ΂
    ஗Ԇ͍ͯ͠Δඵ਺
    ஗ԆτϥϯβΫγϣϯͷ
    ֤ඵ਺ͷ૯߹ܭ

    View Slide

  173. ɹϨϓϦέʔγϣϯͷ֬ೝ
    [email protected]*[email protected]ɿ:&4
    ϚελʔͷόΠφϦϩάΛ
    औಘͰ͖͍ͯΔ͔

    View Slide

  174. ɹϨϓϦέʔγϣϯͷ֬ೝ
    [email protected]*[email protected]ɿ:&4
    ϚελʔͷόΠφϦϩάΛ
    औಘͰ͖͍ͯΔ͔

    View Slide

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

    View Slide

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

    View Slide

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

    View Slide

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

    View Slide

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

    View Slide

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

    View Slide

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

    View Slide

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

    View Slide

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

    View Slide

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

    View Slide

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

    View Slide

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

    View Slide

  187. ɹϨϓϦέʔγϣϯͷ֬ೝ
    [email protected]@*Eɿ
    ಉظ͍ͯ͠Δ
    Ϛελʔͷ*%

    View Slide

  188. ɹϨϓϦέʔγϣϯͷ֬ೝ
    [email protected]@*Eɿ
    ಉظ͍ͯ͠Δ
    Ϛελʔͷ*%

    View Slide

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

    View Slide

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

    View Slide

  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
    ⾣ಉظ׬ྃ

    View Slide

  192. ॠؒɺ৺ɺॏͶͯ

    View Slide

  193. γϯΫϩ཰
    ˋ

    View Slide

  194. ݁Ռ

    View Slide

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

    View Slide

  196. ݁Ռ
    ୅ΘΓ ϨϓϦΧ

    ͕͋Δ΋ͷʂ

    View Slide

  197. ՝୊

    View Slide

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

    View Slide

  199. ·ͱΊ

    View Slide

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

    View Slide

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

    View Slide

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

    View Slide

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

    View Slide

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

    View Slide

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

    View Slide

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

    View Slide

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

    View Slide

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

    View Slide

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

    View Slide