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

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

22522e2bc35255ab75308c399ff782f6?s=128

Takuma Kume

April 26, 2017
Tweet

Transcript

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

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

  3. .)"ͱ͸ʁ 

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

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

  6. ͱ͍͏͜ͱͰ 

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

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

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

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

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

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

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

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

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

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

    σʔλྔʹԠ͕͔͔ͯ࣌ؒ͡Δ࡞ۀ
  17. Ϛελʔ%#ͷো֐͸ਏ͍ΜͰ͢ NBTUFS NBTUFS TMBWF "QQMJDBUJPO εϨʔϒಉظΛ։࢝ ಉظ 

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

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

  20. େมͰ͢Ͷʜ 

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

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

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

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

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

  26. ߏ੒ NBTUFS TMBWF TMBWF NIBNBOHFS NIBOPEF NIBOPEF NIBOPEF NIBOPEF TMBWF

    ϔϧενΣοΫ ࠷௿ϊʔυ  Ϛελʔʹো֐͕ى͖Ε͹ࣗಈͰ ผͷαʔόʹ੾Γସ͑Δ
  27. Ҏ߱ͷઆ໌ .)"ͷओͳҎԼͷػೳʹ͍ͭͯॱʹઆ໌͠·͢ɻ ɾϔϧενΣοΫ ɾσʔλͷ੔߹ੑͷΩʔϓ ɾϑΣΠϧΦʔόʔ 

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

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

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

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

  32. σʔλͷ੔߹ੑΩʔϓ .BTUFS 4MBWF 4MBWF 4MBWF ࣮ߦࡁ SFMBZMPH  ৽Ϛελʔʹબఆ

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

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

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

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

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

  38. ϑΣΠϧΦʔόʔ NBTUFS TMBWF TMBWF NIBNBOHFS NIBOPEF NIBOPEF NIBOPEF NIBOPEF TMBWF

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

    Ϛελʔબఆ  "QQT
  40. ϑΣΠϧΦʔόʔ NBTUFS .BTUFS TMBWF NIBNBOHFS NIBOPEF NIBOPEF NIBOPEF NIBOPEF TMBWF

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

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

    ಉظ։࢝ ಉظ։࢝  "QQT ⾨͜Ε͚ͩͰ͸ΞϓϦέʔγϣϯ͕ݹ͍ϚελʔΛࢀর͍ͯ͠Δঢ়ଶ
  43. ϑΣΠϧΦʔόʔ NBTUFS .BTUFS TMBWF NIBNBOHFS NIBOPEF NIBOPEF NIBOPEF NIBOPEF TMBWF

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

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

    ಉظ ಉظ όʔνϟϧ*1  "QQT ⾨ΞϓϦέʔγϣϯ͸৽͍͠ϚελʔΛࣗಈతʹࢀর͢Δ
  46. ͦͷଞͷػೳ ɾࣗಈϑΣΠϧΦʔό࣌ͷ௨஌ػೳ ɾखಈͰͷϚελʔ੾ସ͑ػೳ ɹˠσʔλϕʔεͷϝϯςφϯεָ͕ʹͳΔʂ ɾεϨʔϒຖʹϚελʔঢ֨ީิͷઃఆ͕Ͱ͖Δɻ ɹˠόοΫΞοϓ༻్ͷαʔό͸Ϛελʔʹঢ֨ͤ͞ͳ͍ ɹɹͳͲͷӡ༻͕Մೳɻ 

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

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

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

    εςʔτϝϯτϕʔεͷϨϓϦέʔγϣϯͰ͸-0"%%"5"*/'*-&Λ࢖༻ͯ͠͸ ͍͚ͳ͍ 
  50. ϖύϘͰ͸ɺ͓ͬ͘Μ͞Μ !IGN ͕ EBZT"MCVNʹઌߦಋೖ͍ͯͨ͠ͷͰ ஌ݟΛڞ༗௖͖ɺඇৗʹָʹಋೖͰ͖·ͨ͠ʂ ʢ͋Γ͕ͱ͏͍͟͝·ͨ͠ʂʣ 

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

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