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
1
230
入門 NewSQL(γ)
ryuichi1208
January 31, 2023
Tweet
Share
More Decks by ryuichi1208
See All by ryuichi1208
コロナ禍とその後:地方エンジニアが学んだキャリア戦略の変遷
ryuichi1208
2
250
入門オンコール対応
ryuichi1208
6
2.7k
MySQLのOOMと戦った話
ryuichi1208
3
2.6k
障害対応を楽しむ7つのコツ
ryuichi1208
7
4.5k
超入門 SRE
ryuichi1208
8
3.6k
SLO Docsのすゝめ
ryuichi1208
7
2.9k
SMTPでのOpenTelemetryの可能性を考えてみる
ryuichi1208
7
2.6k
実録_マルチテナント環境でのGmailガイドライン対応
ryuichi1208
9
2.1k
5分でわかるGoの自動計装
ryuichi1208
4
1.5k
Featured
See All Featured
Automating Front-end Workflow
addyosmani
1365
200k
What’s in a name? Adding method to the madness
productmarketing
PRO
21
3k
Reflections from 52 weeks, 52 projects
jeffersonlam
346
20k
"I'm Feeling Lucky" - Building Great Search Experiences for Today's Users (#IAC19)
danielanewman
225
22k
Fashionably flexible responsive web design (full day workshop)
malarkey
400
65k
How to train your dragon (web standard)
notwaldorf
85
5.6k
Speed Design
sergeychernyshev
18
400
Creatively Recalculating Your Daily Design Routine
revolveconf
215
12k
Intergalactic Javascript Robots from Outer Space
tanoku
268
26k
Building Applications with DynamoDB
mza
89
5.9k
WebSockets: Embracing the real-time Web
robhawkes
59
7.3k
Cheating the UX When There Is Nothing More to Optimize - PixelPioneers
stephaniewalter
278
13k
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)