Upgrade to Pro — share decks privately, control downloads, hide ads and more …

入門 NewSQL(γ)

ryuichi1208
January 31, 2023
190

入門 NewSQL(γ)

ryuichi1208

January 31, 2023
Tweet

Transcript

  1. ౉෦ཾҰ(.01FQBCP *OD
    ೖ໳/FX42- Ѝ

    View Slide

  2. ฤूྺ
    wೖ໳/FX42- Ծ
    িಈతʹ࡞੒
    wೖ໳/FX42- Ќ
    νʔϜ޲͚ࢿྉʹमਖ਼
    wೖ໳/FX42- Ѝ
    1JOH$"1͞Μͱͷ৘ใަ׵ձͷ಺༰Λ௥Ճ

    View Slide

  3. ΞδΣϯμ
    w42-ͱ/P42-ͱ/FX42-ͷൺֱ
    w࣮ࡍͷιϦϡʔγϣϯʹ౿ΈࠐΜͰ͓࿩
    w·ͱΊ

    View Slide

  4. 42-
    w ϝϦοτ
    w "$*%ͳτϥϯβΫγϣϯ͕Մೳ
    w $"1ఆཧͷ಺ʮҰ؏ੑʯͱʮՄ༻ੑʯʹڧ͍
    w +PJOͱ͔ෳࡶͳσʔλૢ࡞΋Մೳ
    w ࠃࡍඪ४Խ *40
    ͞Ε͍ͯͨΓͯ͠Ұճֶ΂͹͋Δ஌͕ࣝఔ౓ྲྀ༻Ͱ͖ͨΓ͠·͢
    w σϝϦοτ
    w εέʔϥϏϦςΟʹ͓͚Δݶք
    w Ϧʔυ͸αʔόΛ૿΍ͤ͹ͳΜͱ͔ͳΔ͕XSJUF͸Ͳ͏͠Α͏΋ͳ͍ $16ੑೳΛ্͛Δ

    View Slide

  5. /P42-
    w /PU0OMZ42- %ZOBNB%#ͱ͔.POHP%#

    w ߏ଄Խ͞Ε͍ͯͳ͍σʔλͷͨΊʹಈతͳεΩʔϚΛ࣋ͪɺσʔλ͸༷ʑͳํ๏Ͱอଘ
    w ϝϦοτ
    w ߴ͍εέʔϥϏϦςΟ
    w ੔߹ੑΛ٘ਜ਼ʹͯ͠෼ࢄͯ͠ॻ͖ࠐΈ͕ՄೳɻXSJUF΋εέʔϧͰ͖Δ
    w σϝϦοτ
    w "$*%ಛੑ͕΄΅ͳ͍
    w ϦϨʔγϣφϧΛ΍Δʹ͸ΞϓϦέʔγϣϯଆͰؤுΔ͔͠ແ͍

    View Slide

  6. 3FBE΍8SJUFͷεέʔϧͤͭͭ͞
    τϥϯβΫγϣϯͱ͔42-४ڌͰ42-Ͱ΍Εͨ͜ͱΛ΍Γ͍ͨ
    Λ׎͑Δͷ͕/FX42-

    View Slide

  7. /FX42-
    w৽͍͠ܗͷ42-
    wεέʔϥϒϧ
    w෼ࢄΞʔΩςΫνϟ
    wաڈͷ3%#.4ʹ͸ແ͍ಛ௃Λ࣋ͭ42-

    View Slide

  8. ͦΕͧΕͷൺֱ

    View Slide

  9. ෼ྨͱ͔
    IUUQTXXXJOGPRDPNOFXTOFXTRM

    View Slide

  10. /FX42-͸Կ͕ྑ͍ͷ͔
    w42-ͷྑ͞ͱ/P42-ͷྑ͞Λ૊Έ߹Θٕͤͨज़
    wࠓ·Ͱ௨Γ42-ͱ࢖͍͍͚ͨͲ/P42-Α͏ͳεέʔϧମײ͕ཉ͍͠
    wͦ͏͍ͬͨέʔε౳Ͱ/FX42-͸࢖ΘΕ͍ͯΔ
    w /FX໊ͬͯশΛ͚͍ͭͯΔ͕ࠓޙͲ͏͢ΔͷͩΖ͏ /FX

    View Slide

  11. /FX42-ͷྫ
    w4QBOOFS
    w$PDSPBDI%#
    w5J%#
    w:VHB#ZUF%#

    View Slide

  12. /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%*..ͳͲʹ࠷దԽ͞Εͨૠೖ΍࡟আ͕ଟ͍༻్ʹ޲͍ͨΠϯσοΫεߏ଄

    View Slide

  13. ΞδΣϯμ
    w42-ͱ/P42-ͱ/FX42-ͷൺֱ
    w5J%#ʹ͍ͭͯ
    w·ͱΊ

    View Slide

  14. 5J%#ʹ͍ͭͯ
    wτϥϯβΫγϣϯ͓Αͼ෼ੳॲཧ )5"1
    ϫʔΫϩʔυΛαϙʔτ
    ͢ΔΦʔϓϯιʔεͷ/FX42-σʔλϕʔε
    w5J%#ͷ5J͸νλϯ
    w.Z42-ͱޓ׵ੑ͕͋Γɺਫฏํ޲ͷεέʔϥϏϦςΟɺڧྗͳ੔
    ߹ੑɺ͓ΑͼߴՄ༻ੑΛఏڙ
    w1JOH$"1 *ODʹΑͬͯ։ൃ͓Αͼαϙʔτ͞ΕͯΔ

    View Slide

  15. 5J%#ʹ͍ͭͯ
    ࠃ಺Ͱͷಋೖ࣮੷΋ଟ͘͸ແ͍͕ͦͦ͋͜͜Δ
    େن໛ࣄྫͩͱ1BZ1BZͳͲ͕ӡ༻͍ͯ͠Δ

    View Slide

  16. 5J%#ʹ͍ͭͯ
    ECUTͰ΋஫໨/PΒ͍͠
    ελʔ਺΋Ұ൪ଟ͍ (JU)VC্Ͱެ։͞Ε͍ͯͳ͍΋ͷ΋͋Δ

    View Slide

  17. 5J%#ͷΞʔΩςΫνϟ

    View Slide

  18. 5J%#ͷΞʔΩςΫνϟ
    5J%#
    ΫϥΠΞϯτͱ΍ΓऔΓ͢Δ෦෼
    5J,7
    σʔλʹ࣮ࡍʹ৮Δ෦෼

    ,FZ7BMVFͰσʔλΛ഑ஔ
    1%
    Ϋϥελͷ಄೴
    σʔλͷ഑ஔ
    τϥϯβΫγϣϯ؅ཧ

    View Slide

  19. 5J,7ͷΞʔΩςΫνϟ

    View Slide

  20. 5J%#ͷಛ௃
    w)PSJ[POUBM4DBMBCJMJUZ ਫฏ֦ு

    w.Z42-$PNQBUJCMF4ZOUBY .Z42-ޓ׵

    w%JTUSJCVUFE5SBOTBDUJPOT ෼ࢄτϥϯβΫγϣϯ

    w$MPVE/BUJWF Ϋϥ΢υωΠςΟϒࢤ޲

    w.JOJNJ[F&5- 0-51ͱ0-"1ͷαϙʔτ

    w)JHI"WBJMBCJMJUZ ߴՄ༻ੑ

    View Slide

  21. 5J%#ͷಛ௃
    w)PSJ[POUBM4DBMBCJMJUZ ਫฏ֦ு

    w.Z42-$PNQBUJCMF4ZOUBY .Z42-ޓ׵

    w%JTUSJCVUFE5SBOTBDUJPOT ෼ࢄτϥϯβΫγϣϯ

    w$MPVE/BUJWF Ϋϥ΢υωΠςΟϒࢤ޲

    w.JOJNJ[F&5- 0-51ͱ0-"1ͷαϙʔτ

    w)JHI"WBJMBCJMJUZ ߴՄ༻ੑ

    View Slide

  22. 5J%#ͷΞʔΩςΫνϟ
    ίϯϙʔωϯτ͝ͱʹεέʔϧՄೳ
    42-ͷॲཧ͕ॏ͍5J%#Λ૿΍͢
    *0΍ετϨʔδ͕ṧഭ5J,7Λ૿΍͢
    ແఀࢭͰਫฏ֦ுՄೳ
    5J%#͸εςʔτϨε
    5J,7͸ͱΜͰ΋ٕज़ʹΑΓՄೳ
    ϐʔΫλΠϜҎ֎Ͱίετ࡟ݮ͕Մೳ

    View Slide

  23. 5J%#ͷಛ௃
    w)PSJ[POUBM4DBMBCJMJUZ ਫฏ֦ு

    w.Z42-$PNQBUJCMF4ZOUBY .Z42-ޓ׵

    w%JTUSJCVUFE5SBOTBDUJPOT ෼ࢄτϥϯβΫγϣϯ

    w$MPVE/BUJWF Ϋϥ΢υωΠςΟϒࢤ޲

    w.JOJNJ[F&5- 0-51ͱ0-"1ͷαϙʔτ

    w)JHI"WBJMBCJMJUZ ߴՄ༻ੑ

    View Slide

  24. 5J%#ͷಛ௃
    w.Z42-ͱޓ׵͕͋ΔΑ͏ʹ࡞ΒΕ͍ͯΔ
    wطଘͷ.Z42-ͷΫϥΠΞϯτ΍ϥΠϒϥϦ͸ͦͷ··࢖͏͜ͱ͕Մೳ
    wͨͩ͠׬શʹରԠ͍ͯ͠ΔΘ͚Ͱ͸ͳ͍ͷͰ஫ҙ͕ඞཁ

    View Slide

  25. 5J%#ͷಛ௃
    w)PSJ[POUBM4DBMBCJMJUZ ਫฏ֦ு

    w.Z42-$PNQBUJCMF4ZOUBY .Z42-ޓ׵

    w%JTUSJCVUFE5SBOTBDUJPOT ෼ࢄτϥϯβΫγϣϯ

    w$MPVE/BUJWF Ϋϥ΢υωΠςΟϒࢤ޲

    w.JOJNJ[F&5- 0-51ͱ0-"1ͷαϙʔτ

    w)JHI"WBJMBCJMJUZ ߴՄ༻ੑ

    View Slide

  26. 5J%#ͷಛ௃
    w0-51ͱ0-"1ͷαϙʔτ
    wϋΠϒϦουτϥϯβΫγϣϯ෼ੳॲཧʢ)5"1ʣͷ༏Εͨϫϯετο
    ϓαʔϏεΛఏڙ
    w0-51ϦΞϧλΠϜͳ0-"1
    wߦࢤ޲ྻࢤ޲ͷςʔϒϧΛϦΞϧλΠϜͰߏங
    wΫΤϦͷಛੑͰͲͬͪΛ࢖͏͔ΛࣗಈͰ൑ผͯ͘͠ΕΔ
    w ΦϯϥΠϯτϥϯβΫγϣϯॲཧ 0-51
    ༻ͷߦϕʔεετϨʔδΤϯδϯ5J,7ͱɺΦϯϥΠϯ෼ੳॲཧ 0-"1
    ༻ͷྻܕετϨʔδΤϯδϯ5J'MBTI͕ڞଘ

    View Slide

  27. 5J%#ͷಛ௃

    View Slide

  28. 5J%#͸͜ΜͳέʔεͰ࢖͑ͦ͏
    w8SJUFϔϏʔͰࠔ͍ͬͯΔ
    wϐʔΫλΠϜͱͦΕҎ֎ͰඞཁεϖοΫ͕େ͖͘ҧ͏
    w਺ඵͰεέʔϧՄೳ σʔλίϐʔ͸͋ΔͷͰσʔλΛখ͘͞อͭ

    w/P42-ͰΞϓϦέʔγϣϯͰؤுͬͯ"$*%ಛੑΛ࣮૷͍ͯ͠Δ
    wςʔϒϧαΠζ͕ΊͪΌΊͪΌେ͖ͯ͘औಘࣗମ͕஗͘ͳͬͯ͠·͍ͬͯΔ
    w0-51΋0-"1΋Ͳͬͪ΋΍ͬͯΔσʔλϕʔε )5"1ࣗମ͸/FX42-ͱ͍
    ͏ΑΓ΋5J%#ಛ༗ͷ΋ͷ

    View Slide

  29. 5J%#ͷσϝϦοτ
    w .Z42-͕஻ΕΔ͚ͩͰཪଆ͸·ͬͨ͘ͷผ෺ͳͷͰӡ༻πʔϧྨ͸Ұ৽͢Δඞཁ͕͋Δ
    w ࠷௿Ͱ΋ϓϩηε͕ಈ͘ͷͰϩʔΧϧͰಈ͔͢ͷ͸ਏ͍
    w ࣗ୐ͷϤϫϤϫαʔόͩͱͪΐͬͱͭΒ͔ͬͨ
    w ࠷௿ίετ͸ߴ͍
    w σʔλ΋࠷௿ͭʹ৑௕Խ͞ΕΔͷͰετϨʔδίετ͸ߴ͘ͳΔ
    w ωοτϫʔΫ௨৴͕ೖΔͷͰϨΠςϯγ͸ѱ͘ͳΔ
    w ਺NT୯ҐͰؾʹ͢ΔέʔεͰ͸޲͍͍ͯͳ͍

    View Slide

  30. ·ͱΊ
    w /FX42-͸ཪଆ͸σʔλϕʔεͷجૅٕज़ͷԠ༻Ͱ੒Γཱ͍ͬͯͨ
    w ͳΜͰ΋͔ΜͰ΋࢖͏΋ͷͰ͸ͳ͘େن໛αʔϏε͡Όͳ͍ͱΦʔόʔϔουͷํ͕େ͖ͦ͏
    w 5J%#͸LTͱͷ࿈ܞ΋ൃల͍ͯ͠ΔͷͰࠓޙָ͕͠Έ
    w ֎෦ެ։͞ΕͯΔ৘ใ͸ϝϦοτ໘͕΄ͱΜͲͰσϝϦοτ͕ݟ͍͑ͯͳ͍ͷͰݕূ͍ͨ͠
    w ফ͑ͯ΋ࠔΒͳ͍Α͏ͳσʔλͷอଘઌʹͯ͠ӡ༻ͯ͠Έͯ஌ݟΛஷΊΔͳͲΛͯ͠Έ͍ͨ

    View Slide

  31. ࢀߟॻ੶ͱ͔ϦϯΫͱ͔
    * [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)

    View Slide