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.2k
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.1k
Other Decks in Technology
See All in Technology
アジャイルな開発チームでテスト戦略の話は誰がする? / Who Talks About Test Strategy?
ak1210
1
830
Amazon Athenaから利用時のGlueのIcebergテーブルのメンテナンスについて
nayuts
0
110
AIエージェント元年@日本生成AIユーザ会
shukob
1
260
4th place solution Eedi - Mining Misconceptions in Mathematics
rist
0
150
LINE NEWSにおけるバックエンド開発
lycorptech_jp
PRO
0
370
JavaにおけるNull非許容性
skrb
2
2.7k
【Forkwell】「正しく」失敗できるチームを作る──現場のリーダーのための恐怖と不安を乗り越える技術 - FL#83 / A team that can fail correctly by forkwell
i35_267
1
100
20250304_赤煉瓦倉庫_DeepSeek_Deep_Dive
hiouchiy
2
130
Qiita Organizationを導入したら、アウトプッターが爆増して会社がちょっと有名になった件
minorun365
PRO
1
320
What's new in Go 1.24?
ciarana
1
120
データベースの負荷を紐解く/untangle-the-database-load
emiki
2
550
【Snowflake九州ユーザー会#2】BigQueryとSnowflakeを比較してそれぞれの良し悪しを掴む / BigQuery vs Snowflake: Pros & Cons
civitaspo
2
660
Featured
See All Featured
Building Adaptive Systems
keathley
40
2.4k
The Cult of Friendly URLs
andyhume
78
6.2k
Done Done
chrislema
182
16k
A Modern Web Designer's Workflow
chriscoyier
693
190k
The Art of Programming - Codeland 2020
erikaheidi
53
13k
Designing for humans not robots
tammielis
250
25k
Distributed Sagas: A Protocol for Coordinating Microservices
caitiem20
330
21k
Fantastic passwords and where to find them - at NoRuKo
philnash
51
3k
Writing Fast Ruby
sferik
628
61k
Typedesign – Prime Four
hannesfritz
41
2.5k
Designing Dashboards & Data Visualisations in Web Apps
destraynor
231
53k
Exploring the Power of Turbo Streams & Action Cable | RailsConf2023
kevinliebholz
30
4.6k
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