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
290
入門 NewSQL(γ)
ryuichi1208
January 31, 2023
Tweet
Share
More Decks by ryuichi1208
See All by ryuichi1208
AI前提のサービス運用について再考する
ryuichi1208
6
1.2k
A Shallow Dive into the World of TCP
ryuichi1208
1
560
入門リトライ
ryuichi1208
19
7.2k
超入門SRE 2025
ryuichi1208
4
1.4k
Goで作って学ぶWebSocket
ryuichi1208
5
3.7k
コード化されていない稼働中のサーバを移設_再構築する技術
ryuichi1208
20
13k
AI前提のサービス運用ってなんだろう?
ryuichi1208
9
1.9k
入門 バックアップ
ryuichi1208
22
10k
効果的なオンコール対応と障害対応
ryuichi1208
9
3.9k
Featured
See All Featured
The Pragmatic Product Professional
lauravandoore
35
6.7k
Optimizing for Happiness
mojombo
379
70k
10 Git Anti Patterns You Should be Aware of
lemiorhan
PRO
657
60k
Unsuck your backbone
ammeep
671
58k
Large-scale JavaScript Application Architecture
addyosmani
512
110k
Practical Orchestrator
shlominoach
188
11k
Sharpening the Axe: The Primacy of Toolmaking
bcantrill
44
2.4k
jQuery: Nuts, Bolts and Bling
dougneiner
63
7.8k
VelocityConf: Rendering Performance Case Studies
addyosmani
332
24k
"I'm Feeling Lucky" - Building Great Search Experiences for Today's Users (#IAC19)
danielanewman
229
22k
Writing Fast Ruby
sferik
628
62k
Designing for humans not robots
tammielis
253
25k
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)