Upgrade to Pro
— share decks privately, control downloads, hide ads and more …
Speaker Deck
Speaker Deck
PRO
Sign in
Sign up
for free
MHAでデータベースの運用を楽にしよう!
Takuma Kume
April 26, 2017
Technology
0
660
MHAでデータベースの運用を楽にしよう!
Takuma Kume
April 26, 2017
Tweet
Share
More Decks by Takuma Kume
See All by Takuma Kume
takumakume
1
200
takumakume
10
2.1k
takumakume
5
7.6k
takumakume
0
100
takumakume
6
5k
takumakume
7
1.5k
takumakume
3
1.5k
takumakume
0
290
takumakume
1
890
Other Decks in Technology
See All in Technology
ch1aki
2
250
go5paopao
9
1.9k
makocchi
2
120
aditya45
2
2.5k
dena_tech
1
860
koukyo1994
3
560
ks91
PRO
0
170
watanabeyu
0
170
ryomasumura
0
130
dena_tech
1
120
kaniza
0
120
joytomo
0
110
Featured
See All Featured
philhawksworth
190
17k
vanstee
117
4.9k
bkeepers
321
53k
addyosmani
311
21k
iamctodd
19
2k
holman
461
280k
lemiorhan
627
44k
keavy
107
14k
lauravandoore
10
1.6k
jnunemaker
PRO
40
4.6k
rmw
11
820
kastner
54
1.9k
Transcript
ٱถഅ(.01&1"#0JOD ϗε5FDI.5( .)"Ͱσʔλϕʔεӡ༻Λ ָʹ͠Α͏ʂ
ΠϯϑϥΤϯδχΞ ٱถഅ!UBLVNBLVNF ϗεςΟϯάࣄۀ෦ΠϯϑϥνʔϜ
.)"ͱʁ
.)"ͱʁ w.Z42-ΤΩεύʔτͱͯ͠ੈքతʹ༗໊ͳদ৴ՅൣࢯʹΑΔɺ .Z42-ϚελʔͷԽΛߦ͏ͨΊͷ1FSMͷιϑτΣΞɻ wඵͷμϯλΠϜͰɺσʔλͷ߹ੑΛอͪͭͭɺϚελʔαʔ όͷϑΣΠϧΦʔόΛߦ͏ػೳΛ͍ͬͯΔɻ (JUIVC IUUQTHJUIVCDPNZPTIJOPSJNNIBNZTRMNBOBHFS IUUQTHJUIVCDPNZPTIJOPSJNNIBNZTRMOPEF
Զσʔλϕʔεͷഒ Γ͕͖ͩʂʂʂ
ͱ͍͏͜ͱͰ
ϚελʔσʔλϕʔεͷোʹΑͬͯ w͓٬༷ʹఏڙ͍ͯ͠ΔαʔϏεΛࢭΊͨ͘ͳ͍ʂ w ͍ͭͰʹɺΓΛָ͠ΜͰ͍Δͱ͜ΖΛअຐ͞Εͨ͘ͳ͍ʂ
ϚελʔσʔλϕʔεͷোʹΑͬͯ w͓٬༷ʹఏڙ͍ͯ͠ΔαʔϏεΛࢭΊͨ͘ͳ͍ʂ w ͍ͭͰʹɺΓΛָ͠ΜͰ͍Δͱ͜ΖΛअຐ͞Εͨ͘ͳ͍ʂ
ͱ͍͏ײ͡ͷϞνϕʔγϣϯͰ .)"ͷಋೖΛߦ͍·ͨ͠ʂ
ຊͷ༰ લఏࣝ ɾϚελʔσʔλϕʔεͷোରԠ͕ਏ͍͜ͱͷڞ༗ ϝΠϯͷ͓ͳ͠ ɾͦΕΛղܾ͢Δ.)"ͷಈ࡞ͷΈ ͓ΘΓ ɾࠓޙʹ͍ͭͯ
Ϛελʔ%#ͷোਏ͍ΜͰ͢
Ϛελʔ%#ͷোਏ͍ΜͰ͢ NBTUFS TMBWF TMBWF "QQMJDBUJPO ॻ͖ࠐΈ ಉظ ಉظ ௨ৗ࣌
Ϛελʔ%#ͷোਏ͍ΜͰ͢ NBTUFS TMBWF TMBWF "QQMJDBUJPO ॻ͖ࠐΈ େͳߋ৽ॲཧ͕ࢭ·Δ োൃੜʂ োൃੜ
͔͜͜Β෮چ࡞ۀ͕࢝·Δ
Ϛελʔ%#ͷোਏ͍ΜͰ͢ NBTUFS TMBWF TMBWF "QQMJDBUJPO σʔλ͕൪৽͍͠αʔόΛબͿ ৽Ϛελʔબఆ
Ϛελʔ%#ͷোਏ͍ΜͰ͢ NBTUFS NBTUFS TMBWF "QQMJDBUJPO σʔλͷ߹ੑΛ߹ΘͤΔ ৽NBTUFS TMBWFؒͷ σʔλͷ߹ੑΛ߹ΘͤΔ
σʔλྔʹԠ͕͔͔ͯ࣌ؒ͡Δ࡞ۀ
Ϛελʔ%#ͷোਏ͍ΜͰ͢ NBTUFS NBTUFS TMBWF "QQMJDBUJPO εϨʔϒಉظΛ։࢝ ಉظ
Ϛελʔ%#ͷোਏ͍ΜͰ͢ NBTUFS NBTUFS TMBWF "QQMJDBUJPO ΞϓϦέʔγϣϯ ॻ͖ࠐΈΛ࠶։ ॻ͖ࠐΈ࠶։ ಉظ
͜ͷҰ࿈ͷ࡞ۀΛٸ͍Ͱ ߦΘͳ͚ΕͳΒͳ͍
େมͰ͢Ͷʜ
खಈ෮چͷ wਓ͕ରԠ͢ΔͨΊҎԼΛڐ༰͠ͳ͚ΕͳΒͳ͍ wোݕˠΤεΧϨʔγϣϯˠݱঢ়֬ೝˠରԠ։࢝ wλΠϜϥά͕ൃੜ͢ΔɻͦͷؒαʔϏεஅɻ wϛεΦϖϨʔγϣϯʹΑΔσʔλϩετͷةݥ wؒͳͲʹى͖Δ͜ͱ͋ΔͷͰ୲ऀ͕ർฐ͢Δ
खಈ෮چͷ wਓ͕ରԠ͢ΔͨΊҎԼΛڐ༰͠ͳ͚ΕͳΒͳ͍ wোݕˠΤεΧϨʔγϣϯˠݱঢ়֬ೝˠରԠ։࢝ wλΠϜϥά͕ൃੜ͢ΔɻͦͷؒαʔϏεஅɻ wϛεΦϖϨʔγϣϯʹΑΔσʔλϩετͷةݥ wؒͳͲʹى͖Δ͜ͱ͋ΔͷͰ୲ऀ͕ർฐ͢Δ w୲ऀ͕ΓΛָ͠ΜͰ͍Δ͔͠Εͳ͍ɻ
ͦΕΛղܾ͢Δҝʹ.)"Λಋೖͨ͠ʂ
.)"োݕ͔Β෮چ·ͰͷҰ࿈ͷ ྲྀΕΛࣗಈͰߦͬͯ͘ΕΔιϑτΣΞɻ
ຊ.)"ͷಈ࡞ͷΈʹ͍ͭͯ આ໌͍ͨ͠ͱࢥ͍·͢ʂ
ߏ NBTUFS TMBWF TMBWF NIBNBOHFS NIBOPEF NIBOPEF NIBOPEF NIBOPEF TMBWF
ϔϧενΣοΫ ࠷ϊʔυ Ϛελʔʹো͕ى͖ΕࣗಈͰ ผͷαʔόʹΓସ͑Δ
Ҏ߱ͷઆ໌ .)"ͷओͳҎԼͷػೳʹ͍ͭͯॱʹઆ໌͠·͢ɻ ɾϔϧενΣοΫ ɾσʔλͷ߹ੑͷΩʔϓ ɾϑΣΠϧΦʔόʔ
ϔϧενΣοΫ ɾNBTUFSσʔλϕʔε͕ࢀর͘͠ॻ͖ࠐΈͰ͖Δঢ়ଶͰ͋Δ͔ ɹΛνΣοΫ͢Δɻ NIBNBOBHFSNIBOPEF<.BTUFS>
σʔλͷ߹ੑΩʔϓ .BTUFS 4MBWF 4MBWF 4MBWF ࣮ߦࡁ SFMBZMPH ʢ.BTUFS͔ΒૹΒΕ͖ͯͨσʔλͰσʔλϕʔεʹॻ͖ࠐ·Ε͍ͯͳ͍ͷʣ
σʔλͷ߹ੑΩʔϓ .BTUFS 4MBWF 4MBWF 4MBWF ࣮ߦࡁ SFMBZMPH Ϛελʔσʔλϕʔεʹোൃੜʂ
σʔλͷ߹ੑΩʔϓ .BTUFS 4MBWF 4MBWF 4MBWF ࣮ߦࡁ SFMBZMPH ൪σʔλ͕.BTUFSʹ͍ۙαʔόΛ ৽Ϛελʔʹબఆ
σʔλͷ߹ੑΩʔϓ .BTUFS 4MBWF 4MBWF 4MBWF ࣮ߦࡁ SFMBZMPH ৽Ϛελʔʹબఆ
σʔλͷ߹ੑΩʔϓ .BTUFS 4MBWF 4MBWF 4MBWF ࣮ߦࡁ SFMBZMPH Ͳͷ4MBWFʹసૹ͞Ε͍ͯͳ͍σʔλϩετ
σʔλͷ߹ੑΩʔϓ .BTUFS 4MBWF 4MBWF 4MBWF ࣮ߦࡁ SFMBZMPH .BTUFS ৽ϚελʔͷSFMBZMPH͕શͯద༻͞ΕΔ·Ͱ NIBNBOBHFSػ
σʔλͷ߹ੑΩʔϓ .BTUFS 4MBWF 4MBWF 4MBWF ࣮ߦࡁ SFMBZMPH .BTUFS 4MBWFʹΓͳ͍σʔλΛ4$1Ͱసૹ͢Δ
σʔλͷ߹ੑΩʔϓ .BTUFS 4MBWF 4MBWF 4MBWF ࣮ߦࡁ SFMBZMPH .BTUFS SFMBZMPHΛద༻
σʔλͷ߹ੑΩʔϓ .BTUFS 4MBWF 4MBWF 4MBWF ࣮ߦࡁ SFMBZMPH .BTUFS σʔλͷ߹ੑ͕อͨΕΔ
ϑΣΠϧΦʔόʔ NBTUFS TMBWF TMBWF NIBNBOHFS NIBOPEF NIBOPEF NIBOPEF NIBOPEF TMBWF
োൃੜ ݕʂ "QQT
ϑΣΠϧΦʔόʔ NBTUFS TMBWF TMBWF NIBNBOHFS NIBOPEF NIBOPEF NIBOPEF NIBOPEF TMBWF
Ϛελʔબఆ "QQT
ϑΣΠϧΦʔόʔ NBTUFS .BTUFS TMBWF NIBNBOHFS NIBOPEF NIBOPEF NIBOPEF NIBOPEF TMBWF
߹ੑͷΩʔϓ "QQT
ϑΣΠϧΦʔόʔ NBTUFS .BTUFS TMBWF NIBNBOHFS NIBOPEF NIBOPEF NIBOPEF NIBOPEF TMBWF
ಉظ։࢝ ಉظ։࢝ "QQT
ϑΣΠϧΦʔόʔ NBTUFS .BTUFS TMBWF NIBNBOHFS NIBOPEF NIBOPEF NIBOPEF NIBOPEF TMBWF
ಉظ։࢝ ಉظ։࢝ "QQT ⾨͜Ε͚ͩͰΞϓϦέʔγϣϯ͕ݹ͍ϚελʔΛࢀর͍ͯ͠Δঢ়ଶ
ϑΣΠϧΦʔόʔ NBTUFS .BTUFS TMBWF NIBNBOHFS NIBOPEF NIBOPEF NIBOPEF NIBOPEF TMBWF
ಉظ ಉظ ϑΣΠϧΦʔόʔ࣌ʹ.)"ͷػೳͰҙͷ εΫϦϓτΛ࣮ߦͰ͖Δʂ "QQT
ϑΣΠϧΦʔόʔ NBTUFS .BTUFS TMBWF NIBNBOHFS NIBOPEF NIBOPEF NIBOPEF NIBOPEF TMBWF
ಉظ ಉظ όʔνϟϧ*1 όʔνϟϧ*1ΞυϨεΛ༧Ί༩͓͖ͯ͠ɺεΫϦϓτͰ৽ϚελʔʹҠಈͤͯ͞ ΞϓϦέʔγϣϯ͕ϚελʔͷࢀরઌΛม͑ͳͯ͘ྑ͍Α͏ʹ͢Δɻ "QQT
ϑΣΠϧΦʔόʔ NBTUFS .BTUFS TMBWF NIBNBOHFS NIBOPEF NIBOPEF NIBOPEF NIBOPEF TMBWF
ಉظ ಉظ όʔνϟϧ*1 "QQT ⾨ΞϓϦέʔγϣϯ৽͍͠ϚελʔΛࣗಈతʹࢀর͢Δ
ͦͷଞͷػೳ ɾࣗಈϑΣΠϧΦʔό࣌ͷ௨ػೳ ɾखಈͰͷϚελʔସ͑ػೳ ɹˠσʔλϕʔεͷϝϯςφϯεָ͕ʹͳΔʂ ɾεϨʔϒຖʹϚελʔঢ֨ީิͷઃఆ͕Ͱ͖Δɻ ɹˠόοΫΞοϓ༻్ͷαʔόϚελʔʹঢ֨ͤ͞ͳ͍ ɹɹͳͲͷӡ༻͕Մೳɻ
.)"طଘͷ.Z42-ͷఀࢭΛ Θͣʹಋೖ͢Δ͜ͱ͕Ͱ͖ΔͷͰ ඇৗʹಋೖͷෑډ͕͍Ͱ͢ʂ
ͷNIBNBOBHFSͰෳͷ γεςϜΛཧ͢Δ͜ͱ͕Ͱ͖·͢ʂ
ʲࢀߟʳ.)"Λಋೖ͢ΔͨΊͷલఏ݅ w֤ϊʔυؒͰͷ44)ެ։伴ೝূ͕Ͱ͖Δ͜ͱ w.Z42-Ҏ߱ͷΈαϙʔτ wϚελʔঢ֨ީิͷαʔόͰMPHCJO͕FOBCMFʹͳͬͯΔ͜ͱ wSFMBZ@MPH@QVSHFΛແޮʹ͓ͯ͘͠ඞཁ wཧ༝ɺϑΣΠϧΦʔό࣌ʹ࠷৽ͷ4MBWFͷSFMBZ@MPHΛݹ͍4MBWFʹసૹ͠ ͯ߹ੑΛ୲อ͢ΔͨΊɻ w Ϛελʔঢ֨ީิαʔόʹϨϓϦέʔγϣϯ༻Ϣʔβ͕ଘࡏ͢Δ͜ͱ w
εςʔτϝϯτϕʔεͷϨϓϦέʔγϣϯͰ-0"%%"5"*/'*-&Λ༻ͯ͠ ͍͚ͳ͍
ϖύϘͰɺ͓ͬ͘Μ͞Μ !IGN ͕ EBZT"MCVNʹઌߦಋೖ͍ͯͨ͠ͷͰ ݟΛڞ༗͖ɺඇৗʹָʹಋೖͰ͖·ͨ͠ʂ ʢ͋Γ͕ͱ͏͍͟͝·ͨ͠ʂʣ
ࠓޙʹ͍ͭͯ ɾ·ͩ.)"͕ಋೖ͞Ε͍ͯͳ͍γεςϜ͕ෳ͋ΔͷͰɺ ɹ࣮ΛੵΈͭͭਵ࣌ಋೖΛ͍͖͍͛ͯͨͱࢥ͍·͢ɻ
͝ਗ਼ௌ͋Γ͕ͱ͏͍͟͝·ͨ͠ʂ