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
入門 NewSQL(γ)
Search
ryuichi1208
January 31, 2023
360
2
Share
Embed
Copy iframe code
Copy JS code
Copy link
Start on current slide
入門 NewSQL(γ)
ryuichi1208
January 31, 2023
Transcript
31 slides
෦ཾҰ(.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)
More Decks by ryuichi1208
See All by ryuichi1208
なぜそう壊れるのか「障害を切り分ける技術」を書きました
ryuichi1208
2
360
そのasync、止まってない? ”鉄板”イベントループ ブロッキング処理検出術
ryuichi1208
1
2.3k
AIでサービス運用はどう変わるのか
ryuichi1208
0
230
入門 再発防止策
ryuichi1208
17
8k
SREの組織構造と実践.
ryuichi1208
0
340
信頼性・システムの観測・障害対応
ryuichi1208
1
530
障害対応からの学びと体制づくり
ryuichi1208
0
1.2k
金曜日デプロイ、するかしないか.pdf
ryuichi1208
1
510
会話で作る信頼性
ryuichi1208
0
220
Featured
See All Featured
Tips & Tricks on How to Get Your First Job In Tech
honzajavorek
1
850
Music & Morning Musume
bryan
48
7.5k
Information Architects: The Missing Link in Design Systems
soysaucechin
1
1.3k
Build your cross-platform service in a week with App Engine
jlugia
234
19k
Bash Introduction
62gerente
615
220k
Navigating Weather and Climate Data
rabernat
0
590
Rebuilding a faster, lazier Slack
samanthasiow
85
9.8k
How to Create Impact in a Changing Tech Landscape [PerfNow 2023]
tammyeverts
56
3.5k
Groundhog Day: Seeking Process in Gaming for Health
codingconduct
0
490
Effective software design: The role of men in debugging patriarchy in IT @ Voxxed Days AMS
baasie
1
610
Mozcon NYC 2025: Stop Losing SEO Traffic
samtorres
1
600
30 Presentation Tips
portentint
PRO
1
470