Upgrade to Pro
— share decks privately, control downloads, hide ads and more …
Speaker Deck
Sign up for free
Menu
Search
Features
All features
Private URLs
Password Protection
Custom URLS
Scheduled publishing
Remove Branding
Restrict embedding
Deck Collections
Notes
Features
All features
Private URLs
Password Protection
Custom URLS
Scheduled publishing
Remove Branding
Restrict embedding
Deck Collections
Notes
Explore
Featured decks
Featured speakers
Programming
Technology
Storyboards
Explore
Featured decks
Featured speakers
Programming
Technology
Storyboards
Pricing
Search
Sign in
Sign up for free
pixivにおけるMySQL運用の実際
Search
konoiz
February 23, 2018
Technology
5.7k
8
Share
Embed
Copy iframe code
Copy JS code
Copy link
Start on current slide
pixivにおけるMySQL運用の実際
MySQL Trend Seminar 2018 @ 福岡
konoiz
February 23, 2018
Transcript
52 slides
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
More Decks by konoiz
See All by konoiz
pixivとPawooの インフラ構成的な話2017
konoiz
2
2.4k
Other Decks in Technology
See All in Technology
業務の傍らで進める改善ループエンジニアリング
bengo4com
1
190
Datadog の権限統制 〜Org 統合に向けて調べた注意点 / JDDUG-Meetup_24
visional_engineering_and_design
1
190
Frontier Teams — Amazon は AI で「開発のやり方」をどう変えたのか
kmotohas
0
300
こんなに変わった! AWSネットワークの常識
shotashiratori
16
11k
常時稼働エージェントの作り方(Claude公式ブログを資料化)
minorun365
PRO
16
28k
3文字略語に騙されない! 世界一わかりやすい『EDR』超入門
kamadamakoto
1
270
_マネジメントする人される人ナイト_2026__良いチームを作っていきたい_お気持ち_.pdf
xkxaxkx
0
800
PHPで家庭用ゲーム機の専用コントローラーをMIDIデバイスとして扱ってみる
wind111
0
150
gem install とrequire のむこうがわ
ydah
0
230
「任されビリティ」で引き受けて「よしなりてぃ」に頼らず任せる / Accept tasks with "makasarebility" and hand them over without relying on "yoshinarily"
pauli
1
800
パスワードのない鍵で、 データを手元に置く
ginjihayashi
0
360
共通基盤の実装に Kotlin - Quarkus を選定した理由と採用したアーキテクチャ
nealle
1
130
Featured
See All Featured
How to Grow Your eCommerce with AI & Automation
katarinadahlin
PRO
2
350
First, design no harm
axbom
PRO
2
1.4k
Why You Should Never Use an ORM
jnunemaker
PRO
61
10k
Practical Orchestrator
shlominoach
192
12k
Designing Powerful Visuals for Engaging Learning
tmiket
1
660
Fight the Zombie Pattern Library - RWD Summit 2016
marcelosomers
234
18k
GraphQLとの向き合い方2022年版
quramy
50
15k
BBQ
matthewcrist
90
10k
The Spectacular Lies of Maps
axbom
PRO
1
1.1k
WCS-LA-2024
lcolladotor
0
1k
Site-Speed That Sticks
csswizardry
13
1.6k
Building a A Zero-Code AI SEO Workflow
portentint
PRO
0
840