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
210
入門 NewSQL(γ)
ryuichi1208
January 31, 2023
Tweet
Share
More Decks by ryuichi1208
See All by ryuichi1208
実録_マルチテナント環境でのGmailガイドライン対応
ryuichi1208
7
1.7k
5分でわかるGoの自動計装
ryuichi1208
2
1.2k
入門EOL対応
ryuichi1208
21
7.6k
超入門 SRE
ryuichi1208
1
120
Mackerelを触り始めて2年経ったので 作ってきたプラグインを振り返る
ryuichi1208
0
1.5k
SREという働き方
ryuichi1208
0
360
SREのチーム共通言語をGoにした話
ryuichi1208
2
510
入門障害対応
ryuichi1208
1
3.7k
インフラCI_CD継続的改善の道のり
ryuichi1208
1
1.2k
Featured
See All Featured
Facilitating Awesome Meetings
lara
42
5.6k
Become a Pro
speakerdeck
PRO
11
4.5k
GraphQLの誤解/rethinking-graphql
sonatard
50
9.2k
What’s in a name? Adding method to the madness
productmarketing
PRO
16
2.6k
BBQ
matthewcrist
80
8.8k
Build The Right Thing And Hit Your Dates
maggiecrowley
24
2k
Sharpening the Axe: The Primacy of Toolmaking
bcantrill
17
1.4k
The Straight Up "How To Draw Better" Workshop
denniskardys
227
130k
Designing Experiences People Love
moore
136
23k
A designer walks into a library…
pauljervisheath
200
23k
The Illustrated Children's Guide to Kubernetes
chrisshort
31
46k
KATA
mclloyd
15
12k
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)