TiDBの始め方〜今からでも遅くない分散SQL〜

0QFO4PVSDF$POGFSFODF)PLLBJEP 5J%#ͷ࢝Ίํɹ ʙࠓ͔ΒͰ΋஗͘ͳ͍෼ࢄ42-ʙ .BLPUP)BTFHBXB !NBLPDDIJ

2 Makoto Hasegawa 8PSLJOHBU$ZCFS"HFOU +PC5JUMF5FDIOJDBM-FBE WHO am I X //
@makocchi Facebook // makocchi0923 )PCCZ1MBZJOHCBTT +PC5JUMF1JOH$"1 +1 &YFDVUJWF5FDIOJDBM"EWJTFS "OE

5J%#ͷ࢝Ίํɹɹɹ

ຊ೔ͷΞδΣϯμ w 5J%#ʹ͍ͭͯ w 5J%#ͷར༻ܗଶʹ͍ͭͯཧղ͢Δ w Ϣʔεέʔεຖͷ࢝Ίํ w ͞ΒͳΔֶशͷͨΊʹ

5J%#ͱ͸ɹɹɹɹ

Open Source Conference 2025 Hokkaido 6 TiDB ͱ͸ Φʔϓϯιʔεͷ෼ࢄσʔλϕʔεͰ͢ )5"1ϫʔΫϩʔυΛαϙʔτ͍ͯ͠·͢
.Z42-ͱߴ͍ޓ׵ੑ͕͋Γɺਫฏํ޲ͷεέʔϥϏϦςΟɺڧ ྗͳҰ؏ੑɺ͓ΑͼߴՄ༻ੑΛඋ͍͑ͯ·͢ ओʹ1JOH$"1ࣾʹΑͬͯ։ൃ͞Ε͍ͯ·͢ IUUQTHJUIVCDPNQJOHDBQUJEC ˞5J%#ͷ5J͸5JUBOJVNͷ5J ˞)5"1͸)ZCSJE5SBOTBDUJPOBMBOE"OBMZUJDBM1SPDFTTJOH

Open Source Conference 2025 Hokkaido 7 5J%#ͷಛ௃ )PSJ[POUBM4DBMBCJMJUZ ਫฏ֦ு
.Z42-$PNQBUJCMF4ZOUBY .Z42-ޓ׵ %JTUSJCVUFE5SBOTBDUJPOT ෼ࢄτϥϯβΫγϣϯ $MPVE/BUJWF Ϋϥ΢υωΠςΟϒࢤ޲ .JOJNJ[F&5- 0-51ͱ0-"1ͷαϙʔτ )JHI"WBJMBCJMJUZ ߴՄ༻ੑ

Open Source Conference 2025 Hokkaido 9 5J%#ͷಛ௃ )PSJ[POUBM4DBMBCJMJUZ 5J%#͸ΞʔΩςΫνϟ্42-Λॲཧ͢Δίϯϙʔωϯτͱ ετϨʔδ෦෼͕෼཭͞Ε͍ͯ·͢
ͦΕͧΕͷ୯Ґ 42-ɺετϨʔδ Ͱਫฏʹ֦ு͕ՄೳͰ͢ ୯७ʹ૿΍͚ͩ͢ʂ ແఀࢭͰਫฏ֦ுՄೳ ैདྷͷσʔλϕʔεͰ͸ਨ௚ʹ͔֦͠ுͰ͖ͳ͍ ϦιʔεΛ ௥ՃͰׂΓ౰ͯΔ ৔߹͕ଟ͍ͱࢥ͍·͕͢ɺਨ௚ͷ֦ு͸ݶ ք͕͋Γ·͢

Open Source Conference 2025 Hokkaido 10 TiDB ͷಛ௃ (Horizontal Scalability)
https://github.com/pingcap/tidb ͜ͷ୯ҐͰεέʔϧՄೳ ͜ͷ୯ҐͰεέʔϧՄೳ

Open Source Conference 2025 Hokkaido 12 5J%#ͷಛ௃ .Z42-$PNQBUJCMF4ZOUBY .Z42-ͱޓ׵͕͋ΔΑ͏ʹ࡞ΒΕ͍ͯ·͢ طଘͷ.Z42-ͷΫϥΠΞϯτ΍ϥΠϒϥϦ͸ͦͷ··࢖͏
͜ͱ͕Մೳ ΄ͱΜͲͷ৔߹͸ΞϓϦέʔγϣϯʹखΛՃ͑Δ͜ͱͳ͘ σʔλϕʔεΛೖΕସ͑Δ͜ͱ͕Ͱ͖·͢ ͨͩ͠׬શʹޓ׵ੑ͕͋ΔΘ͚Ͱ͸ͳ͍ͷͰ஫ҙ͕ඞཁ IUUQTEPDTQJOHDBQDPNUJECTUBCMFNZTRMDPNQBUJCJMJUZ ˞ྫ͑͹ετΞυϓϩγʔδϟ΍6%'ͳͲ͸ݱ࣌఺Ͱ͸αϙʔτ͞Ε͍ͯ·ͤΜ

Open Source Conference 2025 Hokkaido 14 5J%#ͷಛ௃ %JTUSJCVUFE5SBOTBDUJPOT 5J%#Ͱ͸಺෦ͰσʔλΛνϟϯΫ 3FHJPO
ʹ෼ׂͯ͠৑௕ੑΛ ୲อ͠ͳ͕Β෼ࢄ഑ஔ͠·͢ τϥϯβΫγϣϯॲཧͷҰ؏ੑΛอͭҝͷ࢓૊Έͱͯ͠ɺ 1$ QIBTFDPNNJU ౳༷ʑͳٕज़͕࠾༻͞Ε͍ͯ·͢ 1$౳ͷٕज़ʹ͍ͭͯ͸Լهͷࢿྉʹৄ͘͠ॻ͍ͯ͋Γ·͢ IUUQTXXXTMJEFTIBSFOFUBLJPNJUPCFUJEC ʮTiDBͷτϥϯβΫγϣϯʯ

Open Source Conference 2025 Hokkaido 16 5J%#ͷಛ௃ $MPVE/BUJWF Ϋϥ΢υ؀ڥ ύϒϦοΫ΍ϓϥΠϕʔτɺͦͯ͠ϋΠϒϦο
υ؀ڥ ʹ਌࿨ੑ͕ྑ͍࡞Γʹͳ͍ͬͯ·͢ ෳ਺ͷίϯϙʔ ωϯτͰߏ੒͞Ε͍ͯΔ఺౳ ͦΕͧΕͷίϯϙʔωϯτຖʹࣗ༝ʹεέʔϧͤ͞Δ͜ͱ͕ Ͱ͖·͢ ,VCFSOFUFT؀ڥͰͷӡ༻΋໰୊ͳ͘Ͱ͖·͢ όʔδϣϯΞοϓ΋༰қ

Open Source Conference 2025 Hokkaido 18 5J%#ͷಛ௃ .JOJNJ[F&5- 5J%#͸0-51ͱ0-"1Λαϙʔτ͍ͯ͠·͢ )5"1
#*πʔϧʹσʔλΛಡ·ͤΔͨΊʹɺΘ͟Θ͟σʔλΛผͷ؀ ڥʹ༻ҙ͢Δඞཁ͕͋Γ·ͤΜ 0-"1ͷػೳΛ࢖༻͢Δ৔߹ɺผ్5J'MBTIͱ͍͏ίϯϙʔω ϯτΛಈ͔͢ඞཁ͕͋Γ·͢ ˞0-510O-JOF5SBOTBDUJPO1SPDFTTJOH ˞0-"10O-JOF"OBMZUJDBM1SPDFTTJOH ˞)5"1)ZCSJE5SBOTBDUJPOBM"OBMZUJDBM1SPDFTTJOH

Open Source Conference 2025 Hokkaido 20 5J%#ͷಛ௃ )JHI"WBJMBCJMJUZ 5J%#Λߏ੒͢Δίϯϙʔωϯτୡ͸ͦΕͧΕ৑௕Խ͕Մೳ Ͱ͢
410' ୯Ұো֐఺ ͕͋Γ·ͤΜ 5J%#͸σʔλΛอଘ͢ΔࡍʹϦʔδϣϯͱݺ͹ΕΔ୯ҐͰ σʔλΛ෼ׂ͠ɺ৑௕Խͯ͠ετϨʔδʹอଘ͠·͢ ΞΫηεස౓͕ߴ͍ϊʔυ ϗοτεϙοτ ͕ൃੜͨ͠৔߹ ͸ࣗಈతʹσʔλ͕Ҡ͞Εͯෛՙ෼ࢄ͞Ε·͢

Open Source Conference 2025 Hokkaido 21 5J%#ͷಛ௃ ࠶ܝ )PSJ[POUBM4DBMBCJMJUZ ਫฏ֦ு

5J%#ͷར༻ܗଶʹ͍ͭͯ ཧղ͢Δɹɹɹɹ

Open Source Conference 2025 Hokkaido 23 5J%#ͷར༻ܗଶ 💡͓֮͑ͯ͘΂͖ϙΠϯτ💡 5J%#ͷར༻ܗଶ͸ͭ͋Δ 5J%#Λར༻͢Δ࣌ʹ͸
ͲΕ͕ద͍ͯ͠Δͷ͔Λ ͔ͬ͠Γཧղ͢Δ͜ͱ͕େ੾

Open Source Conference 2025 Hokkaido 24 5J%#ͷར༻ܗଶ 5J%#$MPVE ࣗ਎Ͱߏஙͨ͠؀ڥͰͷ 5J%#ͷར༻
1JOH$"1ʹΑΔαϙʔτ༗Γ αϙʔτແ͚ͩ͠Ͳ ׬શϑϦʔͰར༻Մೳ 5J%# 4FMG.BOBHFE 5J%# $PNNVOJUZ ϑϧϚωʔδυ؀ڥͰ 5J%#͕ར༻Մೳ 5J%#$MPVE4FSWFSMFTT 5J%#$MPVE%FEJDBUFE

Ϣʔεέʔεຖͷ࢝Ίํ

Open Source Conference 2025 Hokkaido 26 5J%#ͷ͜ͱΛ͋·Γ஌Βͳ͍͔Β ͱΓ͋͑ͣؾܰʹ৮ͬͯΈ5J🤔

Open Source Conference 2025 Hokkaido 27 5J%#ͷ͜ͱΛ͋·Γ஌Βͳ͍͔Β ͱΓ͋͑ͣؾܰʹ৮ͬͯΈ5J🤔 ͦΜͳΞφλʹ͸ɾɾɾɾ 5J%#$MPVE4FSWFSMFTT
5J%#$MPVEͷΞΧ΢ϯτΛ࡞੒͢Δ͚ͩͰ͙͢ʹ࢖͑Δ 5J%#$PNNVOJUZ UJVQίϚϯυ͔ΒQMBZHSPVOEΛىಈͯ͠࢖ͬͯΈΔ

Open Source Conference 2025 Hokkaido 28 ͱʹ͔͘ແྉͰ࢖͍౗͠5Jʂ💪

Open Source Conference 2025 Hokkaido 29 ͱʹ͔͘ແྉͰ࢖͍౗͠5Jʂ💪 ͦΜͳΞφλʹ͸ɾɾɾɾ 5J%#$MPVE4FSWFSMFTT 5J%#$MPVEͷΞΧ΢ϯτΛ࡞੒͢Δ͚ͩͰ͙͢ʹ࢖͑Δ
࠶ܝ ͔͠΋ແྉͰ࡞੒Մೳʂੑೳ΍Ϋϥελʔͷ୆਺ʹ੍ݶ͕͋Δ͚Ͳ΋ ݸਓ։ൃΞϓϦͳͲʹ͸࠷దʂ 5J%#$PNNVOJUZ UJVQίϚϯυ͔ΒQMBZHSPVOEΛىಈͯ͠࢖ͬͯΈΔ

Open Source Conference 2025 Hokkaido 30 5J%#Λࣗ෼ͨͪͰӡ༻͢Δͷ͸ͪΐͬͱ ݫ͍͠ɾɾɾ😓 ͖ͪΜͱͨ͠αϙʔτΛड͚5J☺

Open Source Conference 2025 Hokkaido 31 5J%#Λࣗ෼ͨͪͰӡ༻͢Δͷ͸ͪΐͬͱ ݫ͍͠ɾɾɾ😓 ͖ͪΜͱͨ͠αϙʔτΛड͚5J☺ ͦΜͳΞφλʹ͸ɾɾɾɾ
5J%#$MPVE4FSWFSMFTT5J%#$MPVE%FEJDBUFE 4FSWFSMFTTࡉ͔͍νϡʔχϯάΛؾʹͤͣ࢖͍͍ͨ৔߹ %FEJDBUFE۱ʑ·Ͱνϡʔχϯά͠ͳ͕Β࢖͍͍ͨ 5J%#4FMG.BOBHFE ࣗ෼ͨͪͷΠϯϑϥ؀ڥʹΠϯετʔϧͨ͠5J%#Ͱ΋αϙʔτΛड ͚ΒΕ·͢

Open Source Conference 2025 Hokkaido 32 ࣄ৘͕͋ͬͯύϒϦοΫΫϥ΢υΛ࢖͏͜ ͱ͕Ͱ͖·ͤΜɻ ϓϥΠϕʔτΫϥ΢υͰ5J%#Λ࢖͍5J😐

Open Source Conference 2025 Hokkaido 33 ࣄ৘͕͋ͬͯύϒϦοΫΫϥ΢υΛ࢖͏͜ ͱ͕Ͱ͖·ͤΜɻ ϓϥΠϕʔτΫϥ΢υͰ5J%#Λ࢖͍5J😐 ͦΜͳΞφλʹ͸ɾɾɾɾ
5J%#4FMG.BOBHFE ࣗࣾͷج൫ʹ5J%#ΛΠϯετʔϧͯ͠ӡ༻͢Δ৔߹ 1JOH$"1ͷαϙʔτΛड͚Δ͜ͱ͕Մೳ 5J%#$PNNVOJUZ 1JOH$"1ͷαϙʔτΛड͚ͳͯ͘΋ྑ͍৔߹͸ͪ͜Β

Open Source Conference 2025 Hokkaido 34 ,VCFSOFUFT؀ڥͰ5J%#Λ࢖͍5J

Open Source Conference 2025 Hokkaido 35 ,VCFSOFUFT؀ڥͰ5J%#Λ࢖͍5J ͦΜͳΞφλʹ͸ɾɾɾɾ 5J%#4FMG.BOBHFE ࣗࣾͷ,VCFSOFUFTج൫ʹ5J%#0QFSBUPSΛ࢖༻ͯ͠5J%#Λσϓ
ϩΠՄೳ 1JOH$"1ͷαϙʔτΛड͚Δ͜ͱ͕Ͱ͖Δ 5J%#$PNNVOJUZ 1JOH$"1ͷαϙʔτΛड͚ͳͯ͘΋ྑ͍৔߹͸ͪ͜Β

Open Source Conference 2025 Hokkaido 36 σʔλϕʔεͳͷͰ؂ࠪϩάΛදࣔ͠5J😎

Open Source Conference 2025 Hokkaido 37 σʔλϕʔεͳͷͰ؂ࠪϩάΛදࣔ͠5J😎 ͦΜͳΞφλʹ͸ɾɾɾɾ 5J%#$MPVE%FEJDBUFE 5J%#$MPVE4FSWFSMFTT
5J%#$MPVE4FSWFSMFTT͸ݱ࣌఺Ͱ͸·ͩϕʔλػೳ 8FCίϯιʔϧͷ؂ࠪϩά΋औಘՄೳ 5J%#4FMG.BOBHFE 5J%#$PNNVOJUZͰ͸ؚ·Ε͍ͯͳ͍؂ࠪϩάػೳΛར༻Մೳ

Open Source Conference 2025 Hokkaido 38 ΞϓϦ։ൃऀͰ͢ɻ$*ͷதͰ5J%#Λى ಈͯ͠ΞϓϦͷಈ࡞֬ೝ͠5J😠

Open Source Conference 2025 Hokkaido 39 ΞϓϦ։ൃऀͰ͢ɻ$*ͷதͰ5J%#Λى ಈͯ͠ΞϓϦͷಈ࡞֬ೝ͠5J😠 ͦΜͳΞφλʹ͸ɾɾɾɾ 5J%#$MPVE4FSWFSMFTT
σʔλΛϒϥϯνΛ੾ΔΑ͏ʹ؀ڥ͝ͱʹෳ੡͢Δ͜ͱ͕Մೳ 13ຖʹϒϥϯν೿ੜͤͨ͞σʔλ͔Β৽نΫϥελʔΛ্ཱͪ͛ͯ ςετ΍ϚΠάϨʔγϣϯͷ֬ೝ͕Ͱ͖Δ ݩͷσʔλʹӨڹ͸ແ͍ 5J%#$PNNVOJUZ UJVQίϚϯυͰ1MBZHSPVOEΛىಈͤ͞Δ ௨ৗ͸ຖճ·ͬ͞Βͳঢ়ଶͰ্ཱ͕ͪΔ͕ɺλάΛ࢖༻͢Δ͜ͱͰ σʔλΛอ࣋ͨ͠ঢ়ଶͰ1MBZHSPVOEΛىಈఀࢭ͢Δ͜ͱ΋Ͱ͖Δ

Open Source Conference 2025 Hokkaido 40 ຊ೔ͷϢʔεέʔε·ͱΊ ͱΓ͋͑ͣؾܰʹ৮ͬͯΈ5J ͱʹ͔͘ແྉͰ࢖͍౗͠5J ͖ͪΜͱͨ͠αϙʔτΛड͚5J
ϓϥΠϕʔτΫϥ΢υͰ5J%#Λ࢖͍5J ,VCFSOFUFT؀ڥͰ5J%#Λ࢖͍5J ؂ࠪϩάΛදࣔ͠5J $*ͷதͰ5J%#Λ࢖͍5J

Open Source Conference 2025 Hokkaido 41 ຊ೔ͷϢʔεέʔε·ͱΊ ͱΓ͋͑ͣؾܰʹ৮ͬͯΈ5J ͱʹ͔͘ແྉͰ࢖͍౗͠5J ͖ͪΜͱͨ͠αϙʔτΛड͚5J
ϓϥΠϕʔτΫϥ΢υͰ5J%#Λ࢖͍5J ,VCFSOFUFT؀ڥͰ5J%#Λ࢖͍5J ؂ࠪϩάΛදࣔ͠5J $*ͷதͰ5J%#Λ࢖͍5J Ti Ti Ti 5J%#$MPVE 5J%#4FMG.BOBHFE 5J%#$PNNVOJUZ Ti Ti Ti Ti Ti Ti Ti Ti Ti Ti Ti Ti Ti Ti

͞ΒͳΔֶशͷͨΊʹ

Open Source Conference 2025 Hokkaido 43 Now Printing 👍5J%#6TFS(SPVQͷ͓஌Βͤ👍 ʮDPOOQBTTUJVHʯͰݕࡧʂ
͢Ͱʹ5J%#Λ׆༻தͷϢʔβʔ͸΋ͪΖΜɺ͜Ε͔Β׆༻͍ͨ͠ɺֶͼ͍ͨͱ͍͏஥͕ؒ ू·ͬͯɺΈΜͳͰ஌ࣝ΍ମݧɺߟ͑ͳͲΛγΣΞ͠߹͍ͳ͕ΒֶͼΛਂΊ͍ͯ͘ίϛϡχ ςΟάϧʔϓͰ͢ɻ ฉ͘ελΠϧͷϛʔτΞοϓ΍खΛಈ͔͠ͳ͕ΒֶͿϫʔΫγϣοϓɺ஥ؒಉ͕࢜৘ใަ׵ ΍ަྲྀΛਂΊΔձͳͲ͞·͟·ͳΞΫςΟϏςΟΛఆظతʹ։࠵͍ͯ͠·͢ɻ

Open Source Conference 2025 Hokkaido 44 Now Printing 👍5J%#6TFS(SPVQͷ͓஌Βͤ👍 ͜Μͳײ͡Ͱ׆ಈ͍ͯ͠·͢ʂ
ӡӦ΋ઈࢍืूதͰ͢ʂ

Open Source Conference 2025 Hokkaido 45 Now Printing 🎉͍ͭʹొ৔ʂʂ🎉 ʮTiDB
࣮ફೖ໳ʯ 5J%#ͷجຊతͳಈ͔͠ํ΍ ΞʔΩςΫνϟʹ͍ͭͯղઆͨ͠ ΨΠυϒοΫ͕ઈࢍൃചதʂ

Open Source Conference 2025 Hokkaido 46 Now Printing ࡳຈӺۙ͘ͷلҏࠃ԰Ͱ ࡏݿ֬ೝʂʂ

Open Source Conference 2025 Hokkaido 47 Now Printing 🎉͞Βʹొ৔ʂʂ🎉 ʮΘ͔͹ͪΌΜͱͭͬͯ͘ɺ
յͯ͠ɺ௚ֶͯ͠Ϳ NewSQLೖ໳ʯ ອըͰઆ໌͞Ε͍ͯͯཧղ͠΍͍͢ʂ ͪ͜Β΋ൃചʂ

0QFO4PVSDF$POGFSFODF)PLLBJEP 5J%#ͷ࢝Ίํɹ ʙࠓ͔ΒͰ΋஗͘ͳ͍෼ࢄ42-ʙ .BLPUP)BTFHBXB !NBLPDDIJ ຊ೔͸͋Γ͕ͱ͏͍͟͝·ͨ͠ʂ

TiDBの始め方 〜今からでも遅くない分散SQL〜

TiDBの始め方 〜今からでも遅くない分散SQL〜

More Decks by makocchi

Other Decks in Technology

Featured

Transcript

TiDBの始め方〜今からでも遅くない分散SQL〜

TiDBの始め方〜今からでも遅くない分散SQL〜