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

22522e2bc35255ab75308c399ff782f6?s=47 Takuma Kume
April 26, 2017
Technology
0
580

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

22522e2bc35255ab75308c399ff782f6?s=128

Takuma Kume

April 26, 2017
Tweet

Want more?

22522e2bc35255ab75308c399ff782f6?s=48 takumakume
1
160
22522e2bc35255ab75308c399ff782f6?s=48 takumakume
10
2k
22522e2bc35255ab75308c399ff782f6?s=48 takumakume
5
6.7k
3ab1249be442027903e1180025340b3f?s=48 reverentgeek
2
140
A9a491b0fcbe0fbce3d64063a37add99?s=48 rmw
1
72
766b9746b59e6f09e280cd33cf4ed419?s=48 skipperchong
0
68
61857dafbd287b3027c4dcea9008ad3c?s=48 carmenhchung
5
140
06f8b41980eb4c577fa40c41d5030c19?s=48 keathley
4
160
C0390e8b11079f8761c0cd3274ed61cb?s=48 productmarketing
2
220
C35e01544a0dd94a2cf1619ee8a42ebb?s=48 clairelew
2
430
6bb82b13cda86d3b821fa44100335ddf?s=48 thoeni
1
110
B3ace07412a5178ea778e7eec161fc0a?s=48 jcasabona
4
200

Transcript

  1. 1.

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

  2. 2.

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

  3. 3.

    .)"ͱ͸ʁ 

  4. 4.

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

  5. 5.

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

  6. 6.

    ͱ͍͏͜ͱͰ 

  7. 7.

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

  8. 8.

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

  9. 9.

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

  10. 10.

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

  11. 11.

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

  12. 12.

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

  13. 13.

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

  14. 14.

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

  15. 15.

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

  16. 16.

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

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

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

  18. 18.

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

  19. 19.

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

  20. 20.

    େมͰ͢Ͷʜ 

  21. 21.

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

  22. 22.

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

  23. 23.

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

  24. 24.

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

  25. 25.

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

  26. 26.

    ߏ੒ NBTUFS TMBWF TMBWF NIBNBOHFS NIBOPEF NIBOPEF NIBOPEF NIBOPEF TMBWF

    ϔϧενΣοΫ ࠷௿ϊʔυ  Ϛελʔʹো֐͕ى͖Ε͹ࣗಈͰ ผͷαʔόʹ੾Γସ͑Δ
  27. 27.

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

  28. 28.

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

  29. 29.

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

  30. 30.

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

  31. 31.

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

  32. 32.

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

  33. 33.

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

  34. 34.

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

    
  35. 35.

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

  36. 36.

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

  37. 37.

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

  38. 38.

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

    ো֐ൃੜ ݕ஌ʂ  "QQT
  39. 39.

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

    Ϛελʔબఆ  "QQT
  40. 40.

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

    ੔߹ੑͷΩʔϓ  "QQT
  41. 41.

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

    ಉظ։࢝ ಉظ։࢝  "QQT
  42. 42.

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

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

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

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

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

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

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

    ಉظ ಉظ όʔνϟϧ*1  "QQT ⾨ΞϓϦέʔγϣϯ͸৽͍͠ϚελʔΛࣗಈతʹࢀর͢Δ
  46. 46.

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

  47. 47.

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

  48. 48.

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

  49. 49.

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

    εςʔτϝϯτϕʔεͷϨϓϦέʔγϣϯͰ͸-0"%%"5"*/'*-&Λ࢖༻ͯ͠͸ ͍͚ͳ͍ 
  50. 50.

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

  51. 51.

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

  52. 52.

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