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 full-size slide

  2. .Z42-
    Λ


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

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

    View full-size slide

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

    View full-size slide

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

    View full-size slide

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

    ͢Δ͓࿩

    View full-size slide

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

    View full-size slide

  7. NZDOG͕
    σϑΥϧτ

    View full-size slide

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

    View full-size slide

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

    View full-size slide

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

    View full-size slide

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

    View full-size slide

  12. ηΧϯυ
    ΠϯύΫτ

    View full-size slide

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

    View full-size slide

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

    View full-size slide

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

    View full-size slide

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

    View full-size slide

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

    View full-size slide

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

    View full-size slide

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

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

    View full-size slide

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

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

    View full-size slide

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

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

    View full-size slide

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

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

    View full-size slide

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

    View full-size slide

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

    View full-size slide

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

    View full-size slide

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

    View full-size slide

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

    View full-size slide

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

    View full-size slide

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

    View full-size slide

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

    View full-size slide

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

    View full-size slide

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

    View full-size slide

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

    View full-size slide

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

    View full-size slide

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

    View full-size slide

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

    View full-size slide

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

    View full-size slide

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

    View full-size slide

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

    View full-size slide

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

    View full-size slide

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

    View full-size slide

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

    View full-size slide

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

    View full-size slide

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

    View full-size slide

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

    View full-size slide

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

    View full-size slide

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

    View full-size slide

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

    View full-size slide

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

    View full-size slide

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

    View full-size slide

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

    View full-size slide

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

    View full-size slide

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

    View full-size slide

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

    View full-size slide

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

    View full-size slide

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

    View full-size slide

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

    View full-size slide

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

    View full-size slide

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

    View full-size slide

  60. ๻͕
    ΍Γ·͢

    View full-size slide

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

    View full-size slide

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

    View full-size slide

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

    View full-size slide

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

    View full-size slide

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

    View full-size slide

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

    View full-size slide

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

    View full-size slide

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

    View full-size slide

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

    NZTRMCJO

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


    ʜ

    View full-size slide

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

    NZTRMCJO

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


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

    View full-size slide

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

    NZTRMCJO

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


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

    View full-size slide

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

    View full-size slide

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

    View full-size slide

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

    View full-size slide

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

    View full-size slide

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

    View full-size slide

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

    View full-size slide

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

    View full-size slide

  79. ϚελʔͷNZDOG

    View full-size slide

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

    View full-size slide

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

    View full-size slide

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

    View full-size slide

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

    View full-size slide

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

    View full-size slide

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

    View full-size slide

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

    View full-size slide

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

    View full-size slide

  88. ɹɹϚελʔόΠφϦϩάͷ֬ೝ
    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 full-size slide

  89. ɹɹϚελʔόΠφϦϩάͷ֬ೝ
    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 full-size slide

  90. ɹɹϚελʔόΠφϦϩάͷ֬ೝ
    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 full-size slide

  91. ɹɹϚελʔόΠφϦϩάͷ֬ೝ
    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 full-size slide

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

    View full-size slide

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

    View full-size slide

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

    View full-size slide

  95. ɹɹεϨʔϒͷઃఆ֬ೝ
    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 full-size slide

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

    View full-size slide

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

    View full-size slide

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

    View full-size slide

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

    View full-size slide

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

    View full-size slide

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

    View full-size slide

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

    View full-size slide

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

    View full-size slide

  104. ɹɹϚελʔόΠφϦϩάͷ֬ೝ
    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 full-size slide

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

    View full-size slide

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

    View full-size slide

  107. ɹɹϚελʔόΠφϦϩάͷ֬ೝ
    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 full-size slide

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

    View full-size slide

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

    View full-size slide

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

    View full-size slide

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

    View full-size slide

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

    View full-size slide

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

    View full-size slide

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

    View full-size slide

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

    View full-size slide

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

    View full-size slide

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

    View full-size slide

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

    View full-size slide

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

    View full-size slide

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

    View full-size slide

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

    View full-size slide

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

    View full-size slide

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

    View full-size slide

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

    View full-size slide

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

    View full-size slide

  126. ɹɹϚελʔόΠφϦϩάͷ֬ೝ
    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 full-size slide

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

    View full-size slide

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

    View full-size slide

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

    View full-size slide

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

    View full-size slide

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

    View full-size slide

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

    View full-size slide

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

    View full-size slide

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

    View full-size slide

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

    View full-size slide

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

    View full-size slide

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

    View full-size slide

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

    View full-size slide

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

    View full-size slide

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

    View full-size slide

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

    View full-size slide

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

    View full-size slide

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

    View full-size slide

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

    View full-size slide

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

    View full-size slide

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

    View full-size slide

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

    View full-size slide

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

    View full-size slide

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

    View full-size slide

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

    View full-size slide

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

    View full-size slide

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

    View full-size slide

  153. ɹϨϓϦέʔγϣϯ࣮ߦ
    ⾣ϨϓϦέʔγϣϯͷ֬ೝ
    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 full-size slide

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

    View full-size slide

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

    View full-size slide

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

    View full-size slide

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

    View full-size slide

  158. ɹϨϓϦέʔγϣϯͷ֬ೝ
    [email protected]@-PH@1PTɿ

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

    View full-size slide

  159. ɹϨϓϦέʔγϣϯͷ֬ೝ
    [email protected]@-PH@1PTɿ

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

    View full-size slide

  160. ɹϨϓϦέʔγϣϯͷ֬ೝ
    ⾣&[email protected]@-PH@1PTɿ

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

    View full-size slide

  161. ɹϨϓϦέʔγϣϯͷ֬ೝ
    ⾣&[email protected]@-PH@1PTɿ

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

    View full-size slide

  162. ɹϨϓϦέʔγϣϯͷ֬ೝ
    ⾣&[email protected]@-PH@1PTɿ

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

    View full-size slide

  163. ɹϨϓϦέʔγϣϯͷ֬ೝ
    ⾣4FDPOET@#[email protected]ɿ

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

    View full-size slide

  164. ɹϨϓϦέʔγϣϯͷ֬ೝ
    ⾣4FDPOET@#[email protected]ɿ

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

    View full-size slide

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

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

    View full-size slide

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

    View full-size slide

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

    View full-size slide

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

    View full-size slide

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

    View full-size slide

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

    View full-size slide

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

    View full-size slide

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

    View full-size slide

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

    View full-size slide

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

    View full-size slide

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

    View full-size slide

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

    View full-size slide

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

    View full-size slide

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

    View full-size slide

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

    View full-size slide

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

    View full-size slide

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

    View full-size slide

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

    View full-size slide

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

    View full-size slide

  184. ɹ࣮ߦঢ়گΛ؂ࢹ
    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 full-size slide

  185. ॠؒɺ৺ɺॏͶͯ

    View full-size slide

  186. γϯΫϩ཰
    ˋ

    View full-size slide

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

    View full-size slide

  188. ݁Ռ
    ୅ΘΓ ϨϓϦΧ

    ͕͋Δ΋ͷʂ

    View full-size slide

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

    View full-size slide

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

    View full-size slide

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

    View full-size slide

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

    View full-size slide

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

    View full-size slide

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

    View full-size slide

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

    View full-size slide

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

    View full-size slide

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

    View full-size slide

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

    View full-size slide

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

    View full-size slide