入門 NewSQL(γ)

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