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

Transcript

1. ٱถ୓അ
   
   (.0
   1&1"#0
   JOD
   ϗε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. ͝ਗ਼ௌ͋Γ͕ͱ͏͍͟͝·ͨ͠ʂ