Upgrade to Pro
— share decks privately, control downloads, hide ads and more …
Speaker Deck
Features
Speaker Deck
PRO
Sign in
Sign up for free
Search
Search
pixivにおけるMySQL運用の実際
Search
konoiz
February 23, 2018
Technology
8
5.1k
pixivにおけるMySQL運用の実際
MySQL Trend Seminar 2018 @ 福岡
konoiz
February 23, 2018
Tweet
Share
More Decks by konoiz
See All by konoiz
pixivとPawooの インフラ構成的な話2017
konoiz
2
2k
Other Decks in Technology
See All in Technology
Can We Measure Developer Productivity?
ewolff
1
150
TanStack Routerに移行するのかい しないのかい、どっちなんだい! / Are you going to migrate to TanStack Router or not? Which one is it?
kaminashi
0
590
【若手エンジニア応援LT会】ソフトウェアを学んできた私がインフラエンジニアを目指した理由
kazushi_ohata
0
150
マルチモーダル / AI Agent / LLMOps 3つの技術トレンドで理解するLLMの今後の展望
hirosatogamo
37
12k
B2B SaaSから見た最近のC#/.NETの進化
sansantech
PRO
0
830
AIチャットボット開発への生成AI活用
ryomrt
0
170
ドメインの本質を掴む / Get the essence of the domain
sinsoku
2
150
Platform Engineering for Software Developers and Architects
syntasso
1
520
エンジニア人生の拡張性を高める 「探索型キャリア設計」の提案
tenshoku_draft
1
130
これまでの計測・開発・デプロイ方法全部見せます! / Findy ISUCON 2024-11-14
tohutohu
3
370
スクラムチームを立ち上げる〜チーム開発で得られたもの・得られなかったもの〜
ohnoeight
2
350
リンクアンドモチベーション ソフトウェアエンジニア向け紹介資料 / Introduction to Link and Motivation for Software Engineers
lmi
4
300k
Featured
See All Featured
Intergalactic Javascript Robots from Outer Space
tanoku
269
27k
Helping Users Find Their Own Way: Creating Modern Search Experiences
danielanewman
29
2.3k
[Rails World 2023 - Day 1 Closing Keynote] - The Magic of Rails
eileencodes
33
1.9k
What’s in a name? Adding method to the madness
productmarketing
PRO
22
3.1k
Six Lessons from altMBA
skipperchong
27
3.5k
Docker and Python
trallard
40
3.1k
Adopting Sorbet at Scale
ufuk
73
9.1k
Fireside Chat
paigeccino
34
3k
Fantastic passwords and where to find them - at NoRuKo
philnash
50
2.9k
"I'm Feeling Lucky" - Building Great Search Experiences for Today's Users (#IAC19)
danielanewman
226
22k
Responsive Adventures: Dirty Tricks From The Dark Corners of Front-End
smashingmag
250
21k
Typedesign – Prime Four
hannesfritz
40
2.4k
Transcript
QJYJWʹ͓͚Δ.Z42-ӡ༻ͷ࣮ࡍ .Z42-5SFOE4FNJOBS!Ԭ ϐΫγϒגࣜձࣾΠϯϑϥ෦ࢁࠜ೭
ࣗݾհ
ࣗݾհ w :"."/&:PTIJZVLJLPOPJ[ w ʹ৽ଔೖࣾɺΠϯϑϥνʔϜʹଐ w ීஈ౦ژΦϑΟεۈ
BHFOEB w QJYJWʹ͍ͭͯ w QJYJWͷΠϯϑϥɺ.Z42-ߏ w QJYJWͰͷ.Z42-ͷӡ༻ʹ͍ͭͯ w .BTUFSঢ֨ɺ"-5&3
QJYJWʹ͍ͭͯ
QJYJWʹ͍ͭͯ w ΫϦΤΠλʔͷͨΊͷ4/4 w ݄αʔϏε։࢝ w ొϢʔβ ສਓҎ্ w ݄ؒͷར༻ऀ
ສਓ w ૯ߘ ສ࡞
QJYJWʹ͍ͭͯ
QJYJWͷΠϯϑϥʹ͍ͭͯ
QJYJWͷΠϯϑϥʹ͍ͭͯ
QJYJWͷΠϯϑϥʹ͍ͭͯ
QJYJWͷΠϯϑϥʹ͍ͭͯ w ݱࡏσʔληϯλͰӡ༻ w ڌϥοΫ w पลαʔϏεͱ߹Θͤͯαʔό w (CQT
QJYJWͷΠϯϑϥʹ͍ͭͯ w νʔϜϝϯόʔਓ w αʔϏεͷΠϯϑϥνʔϜ w .Z42-αʔόͷӡ༻ਓ
QJYJWͷΠϯϑϥʹ͍ͭͯ 'SPOU4FSWFS OHJOY -PBE#BMBODFS -74 .Z42- NBTUFS .Z42- TMBWF *NBHF
4UPSBHF ,74 3FEJT /"5(BUFXBZ -PH4UPSBHF XSJUF JNHVQMPBE SFQMJDBUJPO SFBE SFR SFBE SFT MPH DBDIF ˞/"5HBUFXBZ*OUFSOFUʹ͍݁ͯ͠ͳ͍ αʔόʹରͯ͠ΠϯλʔωοτΞΫηεΛఏڙ *OUFSOFU $POWFSU $BDIF4FSWFS *NBHF'MVY "QQMJDBUJPO4FSWFS BQBDIF QIQ 4FBSDI4FSWFS 4PMS TFBSDI JNQPSU *NBHF %JTQBUDIFS OHJOY
QJYJWͷΠϯϑϥʹ͍ͭͯ 'SPOU4FSWFS OHJOY -PBE#BMBODFS -74 .Z42- NBTUFS .Z42- TMBWF *NBHF
4UPSBHF ,74 3FEJT /"5(BUFXBZ -PH4UPSBHF XSJUF JNHVQMPBE SFQMJDBUJPO SFBE SFR SFBE SFT MPH DBDIF ˞/"5HBUFXBZ*OUFSOFUʹ͍݁ͯ͠ͳ͍ αʔόʹରͯ͠ΠϯλʔωοτΞΫηεΛఏڙ *OUFSOFU $POWFSU $BDIF4FSWFS *NBHF'MVY "QQMJDBUJPO4FSWFS BQBDIF QIQ 4FBSDI4FSWFS 4PMS TFBSDI JNQPSU *NBHF %JTQBUDIFS OHJOY
QJYJWͷ.Z42-
QJYJWͷ.Z42- w ༻్ผʹܥ౷ͷ.Z42-σʔλϕʔε w .Z42-ࣗମ͘͝ී௨ͷ.BTUFS4MBWFߏ w SFBE-JOVY7JSUVBM4FSWFS -74 Ͱࢄ w
։ൃόοΫΞοϓ༻ʹ.Z42-4BOECPYΛ༻
ܥ౷ͷ.Z42- w Ϣʔβؔ࿈σʔλɺΠϥετؔ࿈σʔλɺܾࡁؔ࿈σʔλʜͱ͍ͬ ͨܗͰਨׂ w ݪଇͱ֤ͯ͠ܥ౷4MBWF͕͍Δ w ߹ܭ.BTUFSɺ4MBWF w ࠷େ͖ͳߏͷܥ౷.BTUFSʹରͯ͠4MBWF
-74 w -JOVY7JSUVBM4FSWFS w ܥ౷ຖʹTMBWF༻ͷԾ*1Λ༻ҙ w BQQ͕Ծ*1ʹରͯ͠ࢀরϦΫΤετ w -74͕όϥϯγϯάͯ͠TMBWFʹ࠶ૹ w
TMBWFBQQʹରͯ͠Ԡ %43 -PBE#BMBODFS -74 .Z42- NBTUFS .Z42- TMBWF XSJUF SFQMJDBUJPO SFBE SFR SFBE SFT "QQMJDBUJPO4FSWFS BQBDIF QIQ
.Z42-4BOECPY w αʔόͰෳͷ.Z42-Λ؆୯ʹىಈͰ͖Δ w ։ൃڥόοΫΞοϓ༻ͷ.Z42-ʹ༻ w 4BOECPYͰ࡞ͬͨTMBWFͷEBUBσΟϨΫτϦΛίϐʔͯ͠όοΫ ΞοϓΛ࡞ w ։ൃڥಉ༷ͷख๏Ͱຖຊ൪σʔλͱಉظ͠ͳ͓͢
.Z42-ͷӡ༻ʹ͍ͭͯ
લఏ w QJYJWͰݪଇϝϯςφϯεϞʔυʹ͠ͳ͍ w ݅ͷΤϥʔڐ༰͠ɺαʔϏεແఀࢭͰϝϯςφϯε͢Δ w .Z42-4MBWFΛ.BTUFSʹঢ֨ͤ͞Δࡍಉ༷
.BTUFSঢ֨
.BTUFSঢ֨ w QJYJWͷ.Z42-.BTUFSܥ౷͝ͱʹԾ*1Λ͍࣋ͬͯΔ w Ծ*1Λ4MBWFʹ͚ସ͑ΔࣄͰ.BTUFSঢ֨Λॠؒతʹ࣮ࢪ͢Δ w ྗٕӡ༻
.BTUFSঢ֨ -PBE#BMBODFS -74 .Z42- NBTUFS .Z42- TMBWF XSJUF SFQMJDBUJPO SFBE
"QQMJDBUJPO4FSWFS BQBDIF QIQ .Z42- TMBWF Ծ*1 ࣮*1
.BTUFSঢ֨ -PBE#BMBODFS -74 .Z42- NBTUFS .Z42- TMBWF XSJUF SFQMJDBUJPO "QQMJDBUJPO4FSWFS
BQBDIF QIQ .Z42- TMBWF Ծ*1 ࣮*1 SFBE LJMMNZTRME
.BTUFSঢ֨ -PBE#BMBODFS -74 .Z42- NBTUFS .Z42- TMBWF XSJUF "QQMJDBUJPO4FSWFS BQBDIF
QIQ .Z42- TMBWF Ծ*1 ࣮*1 SFBE
.BTUFSঢ֨ -PBE#BMBODFS -74 .Z42- NBTUFS .Z42- TMBWF XSJUF "QQMJDBUJPO4FSWFS BQBDIF
QIQ .Z42- TMBWF Ծ*1 ࣮*1 SFBE
.BTUFSঢ֨ -PBE#BMBODFS -74 .Z42- NBTUFS .Z42- /FX.BTUFS XSJUF "QQMJDBUJPO4FSWFS BQBDIF
QIQ .Z42- TMBWF Ծ*1 ࣮*1 SFBE
.BTUFSঢ֨ -PBE#BMBODFS -74 .Z42- NBTUFS .Z42- /FX.BTUFS XSJUF "QQMJDBUJPO4FSWFS BQBDIF
QIQ .Z42- TMBWF Ծ*1 ࣮*1 SFBE
.BTUFSঢ֨ -PBE#BMBODFS -74 .Z42- NBTUFS .Z42- /FX.BTUFS XSJUF "QQMJDBUJPO4FSWFS BQBDIF
QIQ .Z42- TMBWF $)"/(&."45&350 ."45&3@)045 Ծ*1 ࣮*1 SFBE
.BTUFSঢ֨ -PBE#BMBODFS -74 .Z42- NBTUFS .Z42- /FX.BTUFS XSJUF "QQMJDBUJPO4FSWFS BQBDIF
QIQ .Z42- TMBWF SFQMJDBUJPO Ծ*1 ࣮*1 SFBE
.BTUFSঢ֨ w ܭըతʹ࣮ߦ͢Δ߹֓ͶඵఔͰ.BTUFSঢ֨Λྃͤ͞Δ w TMBWFಉ࢜ͰQPTJUJPO͕ҟͳΔ߹࠷৽͍͠ͷ·ͨଟܾͰ ଟ͍ͷΛਖ਼ͱͯ͠.BTUFSʹ͢Δ w ݩ.BTUFSࢮΜͰ͍ΔͷͰ࠶ηοτΞοϓͯ͠4MBWFͱͯ͢͠ w োͰ.BTUFS͕ࢮͨ͠߹खॱ΄΅ಉ͡
.BTUFSঢ֨ͷλΠϛϯά w %#ͷ࠶ىಈ͕ඞཁͳ࣌ w .Z42-ͷόʔδϣϯΞοϓ w ΦϯϥΠϯมߋෆՄͳઃఆͷมߋ࣌ w αʔόҠసɾཧαʔόͷϝϯςφϯε࣌ w
8SJUFʹӨڹ͕͋Δέʔε w େنͳςʔϒϧͷ"-5&3 w .BTUFSোൃੜ࣌
"-5&3
CPPLNBSLUBCMF w QJYJWͷػೳͷҰͭͰ͋ΔΠϥετͷʮϒοΫϚʔΫʯΛอଘ͢Δ UBCMF w QJYJWͷ%#ͷதͰಛʹϨίʔυͷଟ͍ςʔϒϧ w (#ͷσʔλΛΦϯϝϞϦͰॲཧ w ࡌϝϞϦ(#ͷαʔό
CPPLNBSLͷ"-5&3 w Πϯϑϥଐޙ࠷ॳͷࣄ w ࣌ͷ#PPLNBSLUBCMF.Z*4".Ͱ.Z42-ɺԯϨίʔυ w ͜ΕΛ*OOP%#ɺ.Z42-ʹมߋ w ී௨ʹ"-5&35"#&-ͨ͠߹ɺҰिؒఔ͔͔Δ
CPPLNBSLͷ"-5&3 w "-5&3ΛΘͳ͍ w ฒྻ*/4&354&-&$5
ฒྻ*/4&354&-&$5 w ִ͞ΕͨTMBWFڥΛ༻ҙ w "-5&3ޙͷঢ়ଶͷςʔϒϧΛ࡞ w "-5&3લͷςʔϒϧΛ4&-&$5ͯ͠CVML*/4&35 w ͨͩ͠*%ͰൣғΛͬͯɺฒྻ࣮ߦ͢Δ
*%CJHJOU ฒྻ*/4&354&-&$5 *%JOU ʜ ʜ
ʜ ʜ ʜ HSPVQ" HSPVQ# PVQ$
*%CJHJOU ฒྻ*/4&354&-&$5 *%JOU ʜ ʜ
ʜ ʜ ʜ HSPVQ" HSPVQ# PVQ$ 4&-&$5 4&-&$5 4&-&$5
*%CJHJOU ʜ ʜ ʜ ฒྻ*/4&354&-&$5
*%JOU ʜ ʜ ʜ ʜ ʜ HSPVQ" HSPVQ# PVQ$ 4&-&$5 4&-&$5 4&-&$5 */4&35 */4&35 */4&35
*%CJHJOU ʜ ʜ ʜ ฒྻ*/4&354&-&$5
*%JOU ʜ ʜ ʜ ʜ ʜ HSPVQ" HSPVQ# PVQ$ 4&-&$5 4&-&$5
*%CJHJOU ʜ ʜ ʜ
ʜ ʜ ฒྻ*/4&354&-&$5 *%JOU ʜ ʜ ʜ ʜ ʜ HSPVQ" HSPVQ# PVQ$ 4&-&$5 4&-&$5 */4&35 */4&35
ฒྻ*/4&354&-&$5 w ฒྻ࣮ߦ͢Δͱ΄΅શʹ*0ϘτϧωοΫʹͳΔ w σΟεΫੑೳ࣍ୈ w ͜ͷ࣌Ͱྃ
CPPLNBSLUBCMF
w ͏͙*/5ܕͷݶքͷԯʹୡ͢Δ w ͜͜Ͱ૿ՃϖʔεՃ w ૣٸʹ*/5Λ#*(*/5ʹ͢Δඞཁ͕͋Δ CPPLNBSLUBCMF
w લͱಉ༷ʹฒྻ*/4&54&-&$5Λ࣮ߦ */5UP#*(*/5
*/5UP#*(*/5 TUBSU FOE
w લͱಉ༷ʹฒྻ*/4&54&-&$5Λ࣮ߦ w ͔Β։࢝ͯ͠ࠓேྃ w ؒ */5UP#*(*/5
ฒྻ*/4&354&-&$5 w "-5&3ͱൺֱͨ͠ϝϦοτ w ௨ৗͷ"-5&3ΑΓߴʹॲཧͰ͖ΔՄೳੑ͕͋Δ w ཧআͷϨίʔυΛཧআ͢Δͱ͍ͬͨࣄ͕ಉ࣌ʹͰ͖Δ
·ͱΊ w QJYJWͰͷ.Z42-ʹ͍ͭͯհ͠·ͨ͠ w QJYJWͷ߹ɺجຊతʹγϯϓϧͳ.BTUFS4MBWFߏͰɺ ͋Δఔͷن·Ͱͳ͘ӡ༻Ͱ͖͍ͯ·͢
QJYJWͰ.Z42-αʔόͷӡ༻ɾվળ ͍ͨ͠ΠϯϑϥΤϯδχΞΛืू͍ͯ͠·͢ʂ XXXQJYJWDPKQ