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.4k
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
2.2k
Other Decks in Technology
See All in Technology
Gemini in Android Studio - Google I/O Bangkok '25
akexorcist
0
180
バクラクによるコーポレート業務の自動運転 #BetAIDay
layerx
PRO
1
750
SAE J1939シミュレーション環境構築
daikiokazaki
1
220
ファインディにおける Dataform ブランチ戦略
hiracky16
0
250
Findy Freelance 利用シーン別AI活用例
ness
0
220
Power Automate のパフォーマンス改善レシピ / Power Automate Performance Improvement Recipes
karamem0
0
280
興味の胞子を育て 業務と技術に広がる”きのこ力”
fumiyasac0921
0
550
LLMをツールからプラットフォームへ〜Ai Workforceの戦略〜 #BetAIDay
layerx
PRO
1
750
Claude Codeから我々が学ぶべきこと
s4yuba
6
960
2時間で300+テーブルをデータ基盤に連携するためのAI活用 / FukuokaDataEngineer
sansan_randd
0
120
帳票構造化タスクにおけるLLMファインチューニングの性能評価
yosukeyoshida
1
230
Microsoft Learn MCP/Fabric データエージェント/Fabric MCP/Copilot Studio-簡単・便利なAIエージェント作ってみた -"Building Simple and Powerful AI Agents with Microsoft Learn MCP, Fabric Data Agent, Fabric MCP, and Copilot Studio"-
reireireijinjin6
1
220
Featured
See All Featured
The MySQL Ecosystem @ GitHub 2015
samlambert
251
13k
個人開発の失敗を避けるイケてる考え方 / tips for indie hackers
panda_program
110
19k
Performance Is Good for Brains [We Love Speed 2024]
tammyeverts
10
1k
KATA
mclloyd
31
14k
Fight the Zombie Pattern Library - RWD Summit 2016
marcelosomers
234
17k
Unsuck your backbone
ammeep
671
58k
The Illustrated Children's Guide to Kubernetes
chrisshort
48
50k
Cheating the UX When There Is Nothing More to Optimize - PixelPioneers
stephaniewalter
283
13k
Docker and Python
trallard
45
3.5k
Documentation Writing (for coders)
carmenintech
73
5k
Designing Experiences People Love
moore
142
24k
Templates, Plugins, & Blocks: Oh My! Creating the theme that thinks of everything
marktimemedia
31
2.5k
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