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
入門 NewSQL(γ)
Search
ryuichi1208
January 31, 2023
2
270
入門 NewSQL(γ)
ryuichi1208
January 31, 2023
Tweet
Share
More Decks by ryuichi1208
See All by ryuichi1208
超入門SRE 2025
ryuichi1208
2
960
Goで作って学ぶWebSocket
ryuichi1208
3
2.4k
コード化されていない稼働中のサーバを移設_再構築する技術
ryuichi1208
20
9k
AI前提のサービス運用ってなんだろう?
ryuichi1208
9
1.7k
入門 バックアップ
ryuichi1208
22
10k
効果的なオンコール対応と障害対応
ryuichi1208
9
3.7k
コロナ禍とその後:地方エンジニアが学んだキャリア戦略の変遷
ryuichi1208
6
420
入門オンコール対応
ryuichi1208
10
3.6k
MySQLのOOMと戦った話
ryuichi1208
7
3.1k
Featured
See All Featured
Why Our Code Smells
bkeepers
PRO
336
57k
Designing Experiences People Love
moore
140
23k
Designing for humans not robots
tammielis
250
25k
Practical Tips for Bootstrapping Information Extraction Pipelines
honnibal
PRO
12
980
Git: the NoSQL Database
bkeepers
PRO
427
65k
Making Projects Easy
brettharned
116
6k
We Have a Design System, Now What?
morganepeng
51
7.4k
Optimising Largest Contentful Paint
csswizardry
34
3.1k
Distributed Sagas: A Protocol for Coordinating Microservices
caitiem20
330
21k
Embracing the Ebb and Flow
colly
84
4.6k
Designing for Performance
lara
604
68k
The Web Performance Landscape in 2024 [PerfNow 2024]
tammyeverts
4
430
Transcript
෦ཾҰ(.01FQBCP *OD ೖ/FX42- Ѝ
ฤूྺ wೖ/FX42- Ծ িಈతʹ࡞ wೖ/FX42- Ќ νʔϜ͚ࢿྉʹमਖ਼ wೖ/FX42- Ѝ 1JOH$"1͞Μͱͷใަձͷ༰ΛՃ
ΞδΣϯμ w42-ͱ/P42-ͱ/FX42-ͷൺֱ w࣮ࡍͷιϦϡʔγϣϯʹ౿ΈࠐΜͰ͓ w·ͱΊ
42- w ϝϦοτ w "$*%ͳτϥϯβΫγϣϯ͕Մೳ w $"1ఆཧͷʮҰ؏ੑʯͱʮՄ༻ੑʯʹڧ͍ w +PJOͱ͔ෳࡶͳσʔλૢ࡞Մೳ w
ࠃࡍඪ४Խ *40 ͞Ε͍ͯͨΓͯ͠Ұճֶ͋Δ͕ࣝఔྲྀ༻Ͱ͖ͨΓ͠·͢ w σϝϦοτ w εέʔϥϏϦςΟʹ͓͚Δݶք w ϦʔυαʔόΛ૿ͤͳΜͱ͔ͳΔ͕XSJUFͲ͏͠Α͏ͳ͍ $16ੑೳΛ্͛Δ
/P42- w /PU0OMZ42- %ZOBNB%#ͱ͔.POHP%# w ߏԽ͞Ε͍ͯͳ͍σʔλͷͨΊʹಈతͳεΩʔϚΛ࣋ͪɺσʔλ༷ʑͳํ๏Ͱอଘ w ϝϦοτ w
ߴ͍εέʔϥϏϦςΟ w ߹ੑΛ٘ਜ਼ʹͯ͠ࢄͯ͠ॻ͖ࠐΈ͕ՄೳɻXSJUFεέʔϧͰ͖Δ w σϝϦοτ w "$*%ಛੑ͕΄΅ͳ͍ w ϦϨʔγϣφϧΛΔʹΞϓϦέʔγϣϯଆͰؤுΔ͔͠ແ͍
3FBE8SJUFͷεέʔϧͤͭͭ͞ τϥϯβΫγϣϯͱ͔42-४ڌͰ42-ͰΕͨ͜ͱΛΓ͍ͨ Λ͑Δͷ͕/FX42-
/FX42- w৽͍͠ܗͷ42- wεέʔϥϒϧ wࢄΞʔΩςΫνϟ wաڈͷ3%#.4ʹແ͍ಛΛ࣋ͭ42-
ͦΕͧΕͷൺֱ
ྨͱ͔ IUUQTXXXJOGPRDPNOFXTOFXTRM
/FX42-Կ͕ྑ͍ͷ͔ w42-ͷྑ͞ͱ/P42-ͷྑ͞ΛΈ߹Θٕͤͨज़ wࠓ·Ͱ௨Γ42-ͱ͍͍͚ͨͲ/P42-Α͏ͳεέʔϧମײ͕ཉ͍͠ wͦ͏͍ͬͨέʔεͰ/FX42-ΘΕ͍ͯΔ w /FX໊ͬͯশΛ͚͍ͭͯΔ͕ࠓޙͲ͏͢ΔͷͩΖ͏ /FX
/FX42-ͷྫ w4QBOOFS w$PDSPBDI%# w5J%# w:VHB#ZUF%#
/FX42-ք۾͕͍ͬͯΔ͓͠Ζٕज़ w 3BGU w ಛఆͷςʔϒϧΛෳͷύʔςΟγϣϯɺγϟʔυͯ͠Δɻͦͷจ຺Ͱొ͢Δ w )5"1 )ZCSJE5SBOTBDUJPO"OBMZUJD1SPDFTT w
0-51ͱ0-"1ͷ྆ํͷϫʔΫϩʔυΛ࣮ݱ͢Δػೳ w ૬ίϛοτʢ5XP1IBTF$PNNJUʣ w ࢄγεςϜͷશϊʔυ͕τϥϯβΫγϣϯͷίϛοτʹ߹ҙ͢ΔͨΊͷࢄΞϧΰϦζϜ w -4.5SFF w )%%͚ʹ࠷దԽ͞Εͨ#5SFFʹରͯ͠44%/7%*..ͳͲʹ࠷దԽ͞Εͨૠೖআ͕ଟ͍༻్ʹ͍ͨΠϯσοΫεߏ
ΞδΣϯμ w42-ͱ/P42-ͱ/FX42-ͷൺֱ w5J%#ʹ͍ͭͯ w·ͱΊ
5J%#ʹ͍ͭͯ wτϥϯβΫγϣϯ͓Αͼੳॲཧ )5"1 ϫʔΫϩʔυΛαϙʔτ ͢ΔΦʔϓϯιʔεͷ/FX42-σʔλϕʔε w5J%#ͷ5Jνλϯ w.Z42-ͱޓੑ͕͋ΓɺਫฏํͷεέʔϥϏϦςΟɺڧྗͳ ߹ੑɺ͓ΑͼߴՄ༻ੑΛఏڙ w1JOH$"1 *ODʹΑͬͯ։ൃ͓Αͼαϙʔτ͞ΕͯΔ
5J%#ʹ͍ͭͯ ࠃͰͷಋೖ࣮ଟ͘ແ͍͕ͦͦ͋͜͜Δ େنࣄྫͩͱ1BZ1BZͳͲ͕ӡ༻͍ͯ͠Δ
5J%#ʹ͍ͭͯ ECUTͰ/PΒ͍͠ ελʔҰ൪ଟ͍ (JU)VC্Ͱެ։͞Ε͍ͯͳ͍ͷ͋Δ
5J%#ͷΞʔΩςΫνϟ
5J%#ͷΞʔΩςΫνϟ 5J%# ΫϥΠΞϯτͱΓऔΓ͢Δ෦ 5J,7 σʔλʹ࣮ࡍʹ৮Δ෦ ,FZ7BMVFͰσʔλΛஔ 1% Ϋϥελͷ಄ σʔλͷஔ
τϥϯβΫγϣϯཧ
5J,7ͷΞʔΩςΫνϟ
5J%#ͷಛ w)PSJ[POUBM4DBMBCJMJUZ ਫฏ֦ு w.Z42-$PNQBUJCMF4ZOUBY .Z42-ޓ w%JTUSJCVUFE5SBOTBDUJPOT ࢄτϥϯβΫγϣϯ
w$MPVE/BUJWF ΫϥυωΠςΟϒࢤ w.JOJNJ[F&5- 0-51ͱ0-"1ͷαϙʔτ w)JHI"WBJMBCJMJUZ ߴՄ༻ੑ
5J%#ͷಛ w)PSJ[POUBM4DBMBCJMJUZ ਫฏ֦ு w.Z42-$PNQBUJCMF4ZOUBY .Z42-ޓ w%JTUSJCVUFE5SBOTBDUJPOT ࢄτϥϯβΫγϣϯ
w$MPVE/BUJWF ΫϥυωΠςΟϒࢤ w.JOJNJ[F&5- 0-51ͱ0-"1ͷαϙʔτ w)JHI"WBJMBCJMJUZ ߴՄ༻ੑ
5J%#ͷΞʔΩςΫνϟ ίϯϙʔωϯτ͝ͱʹεέʔϧՄೳ 42-ͷॲཧ͕ॏ͍5J%#Λ૿͢ *0ετϨʔδ͕ṧഭ5J,7Λ૿͢ ແఀࢭͰਫฏ֦ுՄೳ 5J%#εςʔτϨε 5J,7ͱΜͰٕज़ʹΑΓՄೳ ϐʔΫλΠϜҎ֎Ͱίετݮ͕Մೳ
5J%#ͷಛ w)PSJ[POUBM4DBMBCJMJUZ ਫฏ֦ு w.Z42-$PNQBUJCMF4ZOUBY .Z42-ޓ w%JTUSJCVUFE5SBOTBDUJPOT ࢄτϥϯβΫγϣϯ
w$MPVE/BUJWF ΫϥυωΠςΟϒࢤ w.JOJNJ[F&5- 0-51ͱ0-"1ͷαϙʔτ w)JHI"WBJMBCJMJUZ ߴՄ༻ੑ
5J%#ͷಛ w.Z42-ͱޓ͕͋ΔΑ͏ʹ࡞ΒΕ͍ͯΔ wطଘͷ.Z42-ͷΫϥΠΞϯτϥΠϒϥϦͦͷ··͏͜ͱ͕Մೳ wͨͩ͠શʹରԠ͍ͯ͠ΔΘ͚Ͱͳ͍ͷͰҙ͕ඞཁ
5J%#ͷಛ w)PSJ[POUBM4DBMBCJMJUZ ਫฏ֦ு w.Z42-$PNQBUJCMF4ZOUBY .Z42-ޓ w%JTUSJCVUFE5SBOTBDUJPOT ࢄτϥϯβΫγϣϯ
w$MPVE/BUJWF ΫϥυωΠςΟϒࢤ w.JOJNJ[F&5- 0-51ͱ0-"1ͷαϙʔτ w)JHI"WBJMBCJMJUZ ߴՄ༻ੑ
5J%#ͷಛ w0-51ͱ0-"1ͷαϙʔτ wϋΠϒϦουτϥϯβΫγϣϯੳॲཧʢ)5"1ʣͷ༏Εͨϫϯετο ϓαʔϏεΛఏڙ w0-51 ϦΞϧλΠϜͳ0-"1 wߦࢤ ྻࢤͷςʔϒϧΛϦΞϧλΠϜͰߏங wΫΤϦͷಛੑͰͲͬͪΛ͏͔ΛࣗಈͰผͯ͘͠ΕΔ w
ΦϯϥΠϯτϥϯβΫγϣϯॲཧ 0-51 ༻ͷߦϕʔεετϨʔδΤϯδϯ5J,7ͱɺΦϯϥΠϯੳॲཧ 0-"1 ༻ͷྻܕετϨʔδΤϯδϯ5J'MBTI͕ڞଘ
5J%#ͷಛ
5J%#͜ΜͳέʔεͰ͑ͦ͏ w8SJUFϔϏʔͰࠔ͍ͬͯΔ wϐʔΫλΠϜͱͦΕҎ֎ͰඞཁεϖοΫ͕େ͖͘ҧ͏ wඵͰεέʔϧՄೳ σʔλίϐʔ͋ΔͷͰσʔλΛখ͘͞อͭ w/P42-ͰΞϓϦέʔγϣϯͰؤுͬͯ"$*%ಛੑΛ࣮͍ͯ͠Δ wςʔϒϧαΠζ͕ΊͪΌΊͪΌେ͖ͯ͘औಘࣗମ͕͘ͳͬͯ͠·͍ͬͯΔ w0-510-"1ͲͬͪͬͯΔσʔλϕʔε )5"1ࣗମ/FX42-ͱ͍
͏ΑΓ5J%#ಛ༗ͷͷ
5J%#ͷσϝϦοτ w .Z42-͕ΕΔ͚ͩͰཪଆ·ͬͨ͘ͷผͳͷͰӡ༻πʔϧྨҰ৽͢Δඞཁ͕͋Δ w ࠷Ͱϓϩηε͕ಈ͘ͷͰϩʔΧϧͰಈ͔͢ͷਏ͍ w ࣗͷϤϫϤϫαʔόͩͱͪΐͬͱͭΒ͔ͬͨ w ࠷ίετߴ͍ w
σʔλ࠷ͭʹԽ͞ΕΔͷͰετϨʔδίετߴ͘ͳΔ w ωοτϫʔΫ௨৴͕ೖΔͷͰϨΠςϯγѱ͘ͳΔ w NT୯ҐͰؾʹ͢ΔέʔεͰ͍͍ͯͳ͍
·ͱΊ w /FX42-ཪଆσʔλϕʔεͷجૅٕज़ͷԠ༻ͰΓཱ͍ͬͯͨ w ͳΜͰ͔ΜͰ͏ͷͰͳ͘େنαʔϏε͡Όͳ͍ͱΦʔόʔϔουͷํ͕େ͖ͦ͏ w 5J%#LTͱͷ࿈ܞൃల͍ͯ͠ΔͷͰࠓޙָ͕͠Έ w ֎෦ެ։͞ΕͯΔใϝϦοτ໘͕΄ͱΜͲͰσϝϦοτ͕ݟ͍͑ͯͳ͍ͷͰݕূ͍ͨ͠ w
ফ͑ͯࠔΒͳ͍Α͏ͳσʔλͷอଘઌʹͯ͠ӡ༻ͯ͠ΈͯݟΛஷΊΔͳͲΛͯ͠Έ͍ͨ
ࢀߟॻ੶ͱ͔ϦϯΫͱ͔ * [2020ݱࡏͷNewSQLʹ͍ͭͯ](https://qiita.com/tzkoba/items/5316c6eac66510233115 ) * [NewSQLͷίϯϙʔωϯτৄղ](https://qiita.com/tzkoba/items/3e875e5a6ccd99af332f ) * [ࢄτϥϯβΫγϣϯʹઓ͠Α͏ʂ](https://www.ogis-ri.co.jp/otc/hiroba/technical/DTP/step2/index.html )
* [MySQLΠϯλʔϑΣʔεNewSQL TiDBͷ࣮ྗͱ](https://speakerdeck.com/pingcap0315/mysqlintahuesunewsql-tidbnoshi-li-toha ) * [TiDB Best Practices](https://docs.pingcap.com/tidb/stable/tidb-best-practices)