౉෦ཾҰ(.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 ϦϨʔγϣφϧΛ΍Δʹ͸ΞϓϦέʔγϣϯଆͰؤுΔ͔͠ແ͍

3FBE΍8SJUFͷεέʔϧͤͭͭ͞ τϥϯβΫγϣϯͱ͔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-51΋0-"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)