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

MHAでデータベースの運用を楽にしよう!

 MHAでデータベースの運用を楽にしよう!

Takuma Kume

April 26, 2017
Tweet

More Decks by Takuma Kume

Other Decks in Technology

Transcript

  1. ٱถ୓അ(.01&1"#0JOD
    ϗε5FDI.5(
    .)"Ͱσʔλϕʔεӡ༻Λ
    ָʹ͠Α͏ʂ

    View Slide

  2. ΠϯϑϥΤϯδχΞ
    ٱถ୓അ!UBLVNBLVNF
    ϗεςΟϯάࣄۀ෦ΠϯϑϥνʔϜ

    View Slide

  3. .)"ͱ͸ʁ

    View Slide

  4. .)"ͱ͸ʁ
    w.Z42-ΤΩεύʔτͱͯ͠ੈքతʹ΋༗໊ͳদ৴ՅൣࢯʹΑΔɺ
    .Z42-Ϛελʔͷ৑௕ԽΛߦ͏ͨΊͷ1FSM੡ͷιϑτ΢ΣΞɻ
    w਺ඵͷμ΢ϯλΠϜͰɺσʔλͷ੔߹ੑΛอͪͭͭɺϚελʔαʔ
    όͷϑΣΠϧΦʔόΛߦ͏ػೳΛ΋͍ͬͯΔɻ
    (JUIVC
    IUUQTHJUIVCDPNZPTIJOPSJNNIBNZTRMNBOBHFS
    IUUQTHJUIVCDPNZPTIJOPSJNNIBNZTRMOPEF

    View Slide

  5. Զ͸σʔλϕʔεͷഒ
    ௼Γ͕޷͖ͩʂʂʂ

    View Slide

  6. ͱ͍͏͜ͱͰ

    View Slide

  7. Ϛελʔσʔλϕʔεͷো֐ʹΑͬͯ
    w͓٬༷ʹఏڙ͍ͯ͠ΔαʔϏεΛࢭΊͨ͘ͳ͍ʂ
    w ͍ͭͰʹɺ௼ΓΛָ͠ΜͰ͍Δͱ͜ΖΛअຐ͞Εͨ͘ͳ͍ʂ

    View Slide

  8. Ϛελʔσʔλϕʔεͷো֐ʹΑͬͯ
    w͓٬༷ʹఏڙ͍ͯ͠ΔαʔϏεΛࢭΊͨ͘ͳ͍ʂ
    w ͍ͭͰʹɺ௼ΓΛָ͠ΜͰ͍Δͱ͜ΖΛअຐ͞Εͨ͘ͳ͍ʂ

    View Slide

  9. ͱ͍͏ײ͡ͷϞνϕʔγϣϯͰ
    .)"ͷಋೖΛߦ͍·ͨ͠ʂ

    View Slide

  10. ຊ೔ͷ಺༰
    લఏ஌ࣝ
    ɾϚελʔσʔλϕʔεͷো֐ରԠ͕ਏ͍͜ͱͷڞ༗
    ϝΠϯͷ͓͸ͳ͠
    ɾͦΕΛղܾ͢Δ.)"ͷಈ࡞ͷ࢓૊Έ
    ͓ΘΓ
    ɾࠓޙʹ͍ͭͯ

    View Slide

  11. Ϛελʔ%#ͷো֐͸ਏ͍ΜͰ͢

    View Slide

  12. Ϛελʔ%#ͷো֐͸ਏ͍ΜͰ͢
    NBTUFS TMBWF TMBWF
    "QQMJDBUJPO
    ॻ͖ࠐΈ
    ಉظ
    ಉظ
    ௨ৗ࣌

    View Slide

  13. Ϛελʔ%#ͷো֐͸ਏ͍ΜͰ͢
    NBTUFS TMBWF TMBWF
    "QQMJDBUJPO
    ॻ͖ࠐΈ
    େ੾ͳߋ৽ॲཧ͕ࢭ·Δ
    ো֐ൃੜʂ
    ো֐ൃੜ

    View Slide

  14. ͔͜͜Β෮چ࡞ۀ͕࢝·Δ

    View Slide

  15. Ϛελʔ%#ͷো֐͸ਏ͍ΜͰ͢
    NBTUFS TMBWF TMBWF
    "QQMJDBUJPO
    σʔλ͕൪৽͍͠αʔόΛબͿ
    ৽Ϛελʔબఆ

    View Slide

  16. Ϛελʔ%#ͷো֐͸ਏ͍ΜͰ͢
    NBTUFS NBTUFS TMBWF
    "QQMJDBUJPO
    σʔλͷ੔߹ੑΛ߹ΘͤΔ
    ৽NBTUFS TMBWFؒͷ
    σʔλͷ੔߹ੑΛ߹ΘͤΔ

    σʔλྔʹԠ͕͔͔ͯ࣌ؒ͡Δ࡞ۀ

    View Slide

  17. Ϛελʔ%#ͷো֐͸ਏ͍ΜͰ͢
    NBTUFS NBTUFS TMBWF
    "QQMJDBUJPO
    εϨʔϒಉظΛ։࢝
    ಉظ

    View Slide

  18. Ϛελʔ%#ͷো֐͸ਏ͍ΜͰ͢
    NBTUFS NBTUFS TMBWF
    "QQMJDBUJPO
    ΞϓϦέʔγϣϯ͸
    ॻ͖ࠐΈΛ࠶։
    ॻ͖ࠐΈ࠶։
    ಉظ

    View Slide

  19. ͜ͷҰ࿈ͷ࡞ۀΛٸ͍Ͱ
    ߦΘͳ͚Ε͹ͳΒͳ͍

    View Slide

  20. େมͰ͢Ͷʜ

    View Slide

  21. खಈ෮چͷ໰୊఺
    wਓ͕ରԠ͢ΔͨΊҎԼΛڐ༰͠ͳ͚Ε͹ͳΒͳ͍
    wো֐ݕ஌ˠΤεΧϨʔγϣϯˠݱঢ়֬ೝˠରԠ։࢝
    wλΠϜϥά͕ൃੜ͢Δɻͦͷؒ͸αʔϏεஅɻ
    wϛεΦϖϨʔγϣϯʹΑΔσʔλϩετͷةݥ
    w໷ؒͳͲʹى͖Δ͜ͱ΋͋ΔͷͰ୲౰ऀ͕ർฐ͢Δ

    View Slide

  22. खಈ෮چͷ໰୊఺
    wਓ͕ରԠ͢ΔͨΊҎԼΛڐ༰͠ͳ͚Ε͹ͳΒͳ͍
    wো֐ݕ஌ˠΤεΧϨʔγϣϯˠݱঢ়֬ೝˠରԠ։࢝
    wλΠϜϥά͕ൃੜ͢Δɻͦͷؒ͸αʔϏεஅɻ
    wϛεΦϖϨʔγϣϯʹΑΔσʔλϩετͷةݥ
    w໷ؒͳͲʹى͖Δ͜ͱ΋͋ΔͷͰ୲౰ऀ͕ർฐ͢Δ
    w୲౰ऀ͕௼ΓΛָ͠ΜͰ͍Δ͔΋͠Εͳ͍ɻ

    View Slide

  23. ͦΕΛղܾ͢Δҝʹ.)"Λಋೖͨ͠ʂ

    View Slide

  24. .)"͸ো֐ݕ஌͔Β෮چ·ͰͷҰ࿈ͷ
    ྲྀΕΛࣗಈͰߦͬͯ͘ΕΔιϑτ΢ΣΞɻ

    View Slide

  25. ຊ೔͸.)"ͷಈ࡞ͷ࢓૊Έʹ͍ͭͯ
    આ໌͍ͨ͠ͱࢥ͍·͢ʂ

    View Slide

  26. ߏ੒
    NBTUFS TMBWF TMBWF
    NIBNBOHFS
    NIBOPEF NIBOPEF NIBOPEF NIBOPEF
    TMBWF
    ϔϧενΣοΫ
    ࠷௿ϊʔυ

    Ϛελʔʹো֐͕ى͖Ε͹ࣗಈͰ
    ผͷαʔόʹ੾Γସ͑Δ

    View Slide

  27. Ҏ߱ͷઆ໌
    .)"ͷओͳҎԼͷػೳʹ͍ͭͯॱʹઆ໌͠·͢ɻ
    ɾϔϧενΣοΫ
    ɾσʔλͷ੔߹ੑͷΩʔϓ
    ɾϑΣΠϧΦʔόʔ

    View Slide

  28. ϔϧενΣοΫ
    ɾNBTUFSσʔλϕʔε͕ࢀর΋͘͠͸ॻ͖ࠐΈͰ͖Δঢ়ଶͰ͋Δ͔
    ɹΛνΣοΫ͢Δɻ NIBNBOBHFSNIBOPEF<.BTUFS>


    View Slide

  29. σʔλͷ੔߹ੑΩʔϓ
    .BTUFS
    4MBWF
    4MBWF
    4MBWF
    ࣮ߦࡁ SFMBZMPH ʢ.BTUFS͔ΒૹΒΕ͖ͯͨσʔλͰσʔλϕʔεʹॻ͖ࠐ·Ε͍ͯͳ͍΋ͷʣ

    View Slide

  30. σʔλͷ੔߹ੑΩʔϓ
    .BTUFS
    4MBWF
    4MBWF
    4MBWF
    ࣮ߦࡁ SFMBZMPH
    Ϛελʔσʔλϕʔεʹো֐ൃੜʂ

    View Slide

  31. σʔλͷ੔߹ੑΩʔϓ
    .BTUFS
    4MBWF
    4MBWF
    4MBWF
    ࣮ߦࡁ SFMBZMPH
    ൪σʔλ͕.BTUFSʹ͍ۙαʔόΛ
    ৽Ϛελʔʹબఆ

    View Slide

  32. σʔλͷ੔߹ੑΩʔϓ
    .BTUFS
    4MBWF
    4MBWF
    4MBWF
    ࣮ߦࡁ SFMBZMPH

    ৽Ϛελʔʹબఆ

    View Slide

  33. σʔλͷ੔߹ੑΩʔϓ
    .BTUFS
    4MBWF
    4MBWF
    4MBWF
    ࣮ߦࡁ SFMBZMPH
    Ͳͷ4MBWFʹ΋సૹ͞Ε͍ͯͳ͍σʔλ͸ϩετ

    View Slide

  34. σʔλͷ੔߹ੑΩʔϓ
    .BTUFS
    4MBWF
    4MBWF
    4MBWF
    ࣮ߦࡁ SFMBZMPH
    .BTUFS ৽ϚελʔͷSFMBZMPH͕શͯద༻͞ΕΔ·Ͱ
    NIBNBOBHFS͸଴ػ

    View Slide

  35. σʔλͷ੔߹ੑΩʔϓ
    .BTUFS
    4MBWF
    4MBWF
    4MBWF
    ࣮ߦࡁ SFMBZMPH
    .BTUFS
    4MBWFʹ଍Γͳ͍σʔλΛ4$1Ͱసૹ͢Δ

    View Slide

  36. σʔλͷ੔߹ੑΩʔϓ
    .BTUFS
    4MBWF
    4MBWF
    4MBWF
    ࣮ߦࡁ SFMBZMPH
    .BTUFS
    SFMBZMPHΛద༻

    View Slide

  37. σʔλͷ੔߹ੑΩʔϓ
    .BTUFS
    4MBWF
    4MBWF
    4MBWF
    ࣮ߦࡁ SFMBZMPH
    .BTUFS
    σʔλͷ੔߹ੑ͕อͨΕΔ

    View Slide

  38. ϑΣΠϧΦʔόʔ
    NBTUFS TMBWF TMBWF
    NIBNBOHFS
    NIBOPEF NIBOPEF NIBOPEF NIBOPEF
    TMBWF
    ো֐ൃੜ
    ݕ஌ʂ

    "QQT

    View Slide

  39. ϑΣΠϧΦʔόʔ
    NBTUFS TMBWF TMBWF
    NIBNBOHFS
    NIBOPEF NIBOPEF NIBOPEF NIBOPEF
    TMBWF
    Ϛελʔબఆ

    "QQT

    View Slide

  40. ϑΣΠϧΦʔόʔ
    NBTUFS .BTUFS TMBWF
    NIBNBOHFS
    NIBOPEF NIBOPEF NIBOPEF NIBOPEF
    TMBWF
    ੔߹ੑͷΩʔϓ

    "QQT

    View Slide

  41. ϑΣΠϧΦʔόʔ
    NBTUFS .BTUFS TMBWF
    NIBNBOHFS
    NIBOPEF NIBOPEF NIBOPEF NIBOPEF
    TMBWF
    ಉظ։࢝
    ಉظ։࢝

    "QQT

    View Slide

  42. ϑΣΠϧΦʔόʔ
    NBTUFS .BTUFS TMBWF
    NIBNBOHFS
    NIBOPEF NIBOPEF NIBOPEF NIBOPEF
    TMBWF
    ಉظ։࢝
    ಉظ։࢝

    "QQT
    ⾨͜Ε͚ͩͰ͸ΞϓϦέʔγϣϯ͕ݹ͍ϚελʔΛࢀর͍ͯ͠Δঢ়ଶ

    View Slide

  43. ϑΣΠϧΦʔόʔ
    NBTUFS .BTUFS TMBWF
    NIBNBOHFS
    NIBOPEF NIBOPEF NIBOPEF NIBOPEF
    TMBWF
    ಉظ
    ಉظ
    ϑΣΠϧΦʔόʔ࣌ʹ.)"ͷػೳͰ೚ҙͷ
    εΫϦϓτΛ࣮ߦͰ͖Δʂ

    "QQT

    View Slide

  44. ϑΣΠϧΦʔόʔ
    NBTUFS .BTUFS TMBWF
    NIBNBOHFS
    NIBOPEF NIBOPEF NIBOPEF NIBOPEF
    TMBWF
    ಉظ
    ಉظ
    όʔνϟϧ*1
    όʔνϟϧ*1ΞυϨεΛ༧Ί෇༩͓͖ͯ͠ɺεΫϦϓτͰ৽ϚελʔʹҠಈͤͯ͞
    ΞϓϦέʔγϣϯ͕ϚελʔͷࢀরઌΛม͑ͳͯ͘ྑ͍Α͏ʹ͢Δɻ

    "QQT

    View Slide

  45. ϑΣΠϧΦʔόʔ
    NBTUFS .BTUFS TMBWF
    NIBNBOHFS
    NIBOPEF NIBOPEF NIBOPEF NIBOPEF
    TMBWF
    ಉظ
    ಉظ
    όʔνϟϧ*1

    "QQT
    ⾨ΞϓϦέʔγϣϯ͸৽͍͠ϚελʔΛࣗಈతʹࢀর͢Δ

    View Slide

  46. ͦͷଞͷػೳ
    ɾࣗಈϑΣΠϧΦʔό࣌ͷ௨஌ػೳ
    ɾखಈͰͷϚελʔ੾ସ͑ػೳ
    ɹˠσʔλϕʔεͷϝϯςφϯεָ͕ʹͳΔʂ
    ɾεϨʔϒຖʹϚελʔঢ֨ީิͷઃఆ͕Ͱ͖Δɻ
    ɹˠόοΫΞοϓ༻్ͷαʔό͸Ϛελʔʹঢ֨ͤ͞ͳ͍
    ɹɹͳͲͷӡ༻͕Մೳɻ

    View Slide

  47. .)"͸طଘͷ.Z42-ͷఀࢭΛ
    ൐Θͣʹಋೖ͢Δ͜ͱ͕Ͱ͖ΔͷͰ
    ඇৗʹಋೖͷෑډ͕௿͍Ͱ͢ʂ

    View Slide

  48. ୆ͷNIBNBOBHFSͰෳ਺ͷ
    γεςϜΛ؅ཧ͢Δ͜ͱ͕Ͱ͖·͢ʂ

    View Slide

  49. ʲࢀߟʳ.)"Λಋೖ͢ΔͨΊͷલఏ৚݅
    w֤ϊʔυؒͰͷ44)ެ։伴ೝূ͕Ͱ͖Δ͜ͱ
    w.Z42-Ҏ߱ͷΈαϙʔτ
    wϚελʔঢ֨ީิͷαʔόͰMPHCJO͕FOBCMFʹͳͬͯΔ͜ͱ
    [email protected]@QVSHFΛແޮʹ͓ͯ͘͠ඞཁ
    wཧ༝͸ɺϑΣΠϧΦʔό࣌ʹ࠷৽ͷ4MBWFͷ[email protected]Λݹ͍4MBWFʹసૹ͠
    ͯ੔߹ੑΛ୲อ͢ΔͨΊɻ
    w Ϛελʔঢ֨ީิαʔόʹϨϓϦέʔγϣϯ༻Ϣʔβ͕ଘࡏ͢Δ͜ͱ
    w εςʔτϝϯτϕʔεͷϨϓϦέʔγϣϯͰ͸-0"%%"5"*/'*-&Λ࢖༻ͯ͠͸
    ͍͚ͳ͍

    View Slide

  50. ϖύϘͰ͸ɺ͓ͬ͘Μ͞Μ !IGN
    ͕
    EBZT"MCVNʹઌߦಋೖ͍ͯͨ͠ͷͰ
    ஌ݟΛڞ༗௖͖ɺඇৗʹָʹಋೖͰ͖·ͨ͠ʂ
    ʢ͋Γ͕ͱ͏͍͟͝·ͨ͠ʂʣ

    View Slide

  51. ࠓޙʹ͍ͭͯ
    ɾ·ͩ.)"͕ಋೖ͞Ε͍ͯͳ͍γεςϜ͕ෳ਺͋ΔͷͰɺ
    ɹ࣮੷ΛੵΈͭͭਵ࣌ಋೖΛ޿͍͖͍͛ͯͨͱࢥ͍·͢ɻ

    View Slide

  52. ͝ਗ਼ௌ͋Γ͕ͱ͏͍͟͝·ͨ͠ʂ

    View Slide