Tweet
Tweet

Slide 1

Slide 1 text

%ZOBNP%# 4UFQ;FSPUP0OF ٢ాوจ ![FQIJSBOTBT Ϋϥεϝιουגࣜձࣾ

Slide 2

Slide 2 text

εϥΠυ͸ޙͰೖख͢Δ͜ͱ͕ग़དྷ·͢ͷͰ ൃදதͷ಺༰ΛϝϞ͢Δඞཁ͸͋Γ·ͤΜɻ ࣸਅࡱӨΛ͢Δ৔߹͸ ϑϥογϡɾγϟολʔԻ͕ग़ͳ͍Α͏ʹ͝഑ྀ͍ͩ͘͞ Attention

Slide 3

Slide 3 text

#ChugokuDB

Slide 4

Slide 4 text

ࣗݾ঺հ ٢ాوจ ![FQIJSBOTBT wΫϥεϝιουגࣜձࣾ wϞόΠϧΞϓϦαʔϏε෦ wԬࢁ+BWBϢʔβձ୅දΦʔϓϯη ϛφʔԬࢁ࣮ߦҕһ w޷͖ͳ"84ͷαʔϏε w&$4 %ZOBNP%#

Slide 5

Slide 5 text

ΞδΣϯμ w3%#ͱ%ZOBNP%# wΩϟύγςΟϢχοτ wύʔςΟγϣϯΩʔͱϨϯδΩʔ wσʔλ֨ೲʹ͍ͭͯ wݕࡧํ๏ w̎ͭͷಡΈࠐΈ੔߹ੑ w࣮ࡍͷར༻ྫ

Slide 6

Slide 6 text

RDBͱDynamoDB

Slide 7

Slide 7 text

3%#ͷಛ௃ wߦͱΧϥϜͰߏ੒͞Εͨςʔϒϧ w42-Λ࢖ͬͯɺࣗ༝ʹσʔλΛߜΓࠐΜͩΓ͠ ͯݕࡧ͕Ͱ͖Δ wσʔλͷҰ؏ੑ $POTJTUFODZ ɺॻ͖ࠐΈૢ࡞ ͷݪࢠੑ "UPNJDJUZ wՄ༻ੑͱ֦ுੑΛߋʹٻΊΒΕΔΑ͏ʹͳͬͯ ͖ͨ

Slide 8

Slide 8 text

Մ༻ੑͱ֦ுੑΛͲ͏ߴΊΔͷ͔ʁ Մ༻ੑΛ্͛Δʹ͸৑௕Խ wෳ਺ͷϊʔυʹσʔλͷίϐʔΛ࣋ͭ wͲ͔͕͜ো֐Λ͓ͯ͜͠΋ɺଞͷϊʔυͰॲཧ ΛܧଓͰ͖Δ ֦ுੑΛ্͛Δʹʹ͸෼ࢄԽ wϊʔυ͝ͱʹड͚࣋ͭσʔλΛ෼͚Δ w෼ࢄ͢Δ͜ͱͰੑೳΛ୲อ͢Δ

Slide 9

Slide 9 text

͔͠͠৑௕Խɺ෼ࢄԽ͢Δͱ Ұ؏ੑΛอ࣋͢Δ͜ͱ͕೉͍͠

Slide 10

Slide 10 text

Մ༻ੑˍ֦ுੑ ͱ Ұ؏ੑ͸τϨʔυΦϑ

Slide 11

Slide 11 text

Ұ؏ੑΛଟগ٘ਜ਼ʹͭͭ͠ ߴՄ༻ੑɺߴ֦ுੑΛऔΔ Ұ؏ੑ͸ͦΕ΄ͲॏཁͰͳ͍έʔε΋ଟ਺

Slide 12

Slide 12 text

%ZOBNP%#ͷಛ௃ wϑϧϚωʔδυ wΩʔͱ஋ͷอଘͷΈʹಛԽ wͭͷ";ʹσʔλΛίϐʔ͢Δ͜ͱͰɺߴ͍Մ ༻ੑΛ֬อ wෳ਺ͷϊʔυͰσʔλΛड͚࣋ͭ͜ͱͰɺߴ͍ ֦ுੑΛ֬อ

Slide 13

Slide 13 text

%ZOBNP%#ͷಛ௃ʢࠓ೔͸࿩͞ͳ͍ʣ w55- 5JNFUP-JWF w%ZOBNP%#4USFBNT w%"9

Slide 14

Slide 14 text

3%#ͱൺ΂ͯͰ͖ͳ͍͜ͱ wॊೈͳݕࡧ wूܭ wςʔϒϧಉ࢜ͷ+0*/ w௕͍ϨίʔυʢLC੍ݶʣ wҰ؏ੑͷ͋ΔಡΈऔΓ wτϥϯβΫγϣϯʢݶఆతʣ

Slide 15

Slide 15 text

ΩϟύγςΟϢχοτ

Slide 16

Slide 16 text

ΩϟύγςΟϢχοτ wඵؒ౰ͨΓͷεϧʔϓοτΛࣄલʹઃఆͰ͖Δ wಡΈࠐΈɺॻ͖ࠐΈผʹࢦఆ w͍ͭͰ΋ແఀࢭͰ্͛ͨΓɺԼ͛ͨΓͰ͖Δ w$6ͷ஋Ͱར༻ྉ͕ۚ΄΅ܾ·Δ

Slide 17

Slide 17 text

ΩϟύγςΟϢχοτ 3FBEDBQBDJUZ wϢχοτͰɺຖඵLCͷσʔλΛಡΈ͜ΊΔ 8SJUFDBQBDJUZ wϢχοτͰɺຖඵLCͷσʔλΛॻ͖͜ΊΔ wσʔλͷฏۉαΠζͱɺཁٻ͞ΕΔඵؒͷε ϧʔϓοτ͕෼͔Ε͹ɺࣄલʹઃఆͰ͖Δ

Slide 18

Slide 18 text

ΩϟύγςΟϢχοτ ௒͑ΔͱͲ͏ͳΔͷʁ wεϩοτϦϯά͕ൃੜ͢ΔʢΤϥʔʹͳΔʣ w4%,ଆͰϦτϥΠͯ͘͠ΕΔ w$MPVE8BUDIͳͲͰεϩοτϦϯά͕ൃੜͯ͠ ͍ͳ͍͔ɺద੾ʹ؂ࢹ wద੾ͳ$6Λઃఆ͢Δඞཁ͕͋Δ

Slide 19

Slide 19 text

ΩϟύγςΟϢχοτ "VUP4DBMJOH wҰఆ࣌ؒɺࢦఆͨ͠$6Λ௒͍͑ͯͨ৔߹ʹɺ ࣗಈͰ$6Λ૿΍͢ʢݮΒ͢ʣ w༗ޮԽ͢Δͱ$MPVE8BUDI"MBSNʹ֤छ "MBSN͕࡞੒͞ΕΔͷͰɺͦͷ಺༰ΛνΣοΫ

Slide 20

Slide 20 text

ΩϟύγςΟϢχοτ 0O%FNBOE w׬શ͓·͔ͤίʔε wͨͩ͠ɺগʑ͓ߴ͍ʢఔ౓ʣ wIUUQTEFWDMBTTNFUIPEKQDMPVEBXT SFJOWFOUDPNQBSFEZOBNPECPO EFNBOEQSJDFXJUIQSPWJTJPOFEQSJDF

Slide 21

Slide 21 text

ύʔςΟγϣϯΩʔͱ ϨϯδΩʔ

Slide 22

Slide 22 text

ύʔςΟγϣϯΩʔͱ͸ ύʔςΟγϣϯΩʔʢϋογϡΩʔʣ w3%#Ͱ͍͏ͱ͜ΖͷओΩʔ wͭͷΈࢦఆ wྫ͑͹Ϣʔβ*%ͳͲ wͲͷϊʔυʹσʔλΛ֨ೲ͢Δ͔ͷ൑அʹ࢖Θ ΕΔ

Slide 23

Slide 23 text

ςʔϒϧͷΠϝʔδ *E /BNF (SBEF 7BMVF ߴւઍՎ ౉ล༵ ࡩ಺སࢠ ࠃ໦ాՖؙ

Slide 24

Slide 24 text

ϨϯδΩʔͱ͸ ϨϯδΩʔʢιʔτΩʔʣ wύʔςΟγϣϯΩʔͱ͸ผʹɺෳ߹Ωʔͱͯ͠ ࢖༻͢Δଐੑ wྫ͑͹λΠϜελϯϓͳͲ wݕࡧ࣌ʹ৚݅ࢦఆͰ͖Δ wΠίʔϧɺେখɺCFUXFFOɺCFHJOXJUI

Slide 25

Slide 25 text

ςʔϒϧͷΠϝʔδ *E %BUF 7BMVF

Slide 26

Slide 26 text

σʔλ֨ೲํ๏ʹ͍ͭͯ

Slide 27

Slide 27 text

JUFN͸෼ࢄͨ͠ύʔςΟγϣϯʹอଘ͞ΕΔ *E ϋογϡ஋ BCDE BDCE *E ϋογϡ஋ CBDE *E ϋογϡ஋ DBCE node-A node-B node-C

Slide 28

Slide 28 text

JUFN͸ͭͷ";ʹϨϓϦέʔτ͞ΕΔ *E ϋογϡ஋ BCDE BDCE AZ1 *E ϋογϡ஋ BCDE BDCE AZ2 *E ϋογϡ஋ BCDE BDCE AZ3

Slide 29

Slide 29 text

σʔλ֨ೲͷΠϝʔδ /PEF ύʔςΟγϣϯΩʔ ϋογϡ஋ ϨϯδΩʔ " BCDE " BCDE " "DCE # CBDE $ DBCE

Slide 30

Slide 30 text

ݕࡧํ๏

Slide 31

Slide 31 text

%ZOBNP%#ͷݕࡧํ๏ w4DBO w(FU*UFN w2VFSZ

Slide 32

Slide 32 text

4DBO wશ݅ಡΈࠐΈ wίετ͕ߴ͍ wϑΟϧλΛࢦఆͰ͖Δ wશ݅औಘޙʹϑΟϧλ͕ద༻͞ΕΔ

Slide 33

Slide 33 text

(FU*UFN wύʔςΟγϣϯΩʔɺ·ͨ͸ύʔςΟγϣϯ ΩʔͱϨϯδΩʔΛࢦఆͯ͠ɺd݅ͷJUFNΛ औಘ͢Δ wϨϯδΩʔΛൣғࢦఆͰ͖ͳ͍

Slide 34

Slide 34 text

2VFSZ wύʔςΟγϣϯΩʔͱϨϯδΩʔΛࢦఆͯ͠ɺ ෳ਺݅ͷJUFNΛऔಘ͢Δ wϨϯδΩʔʹ͸ΠίʔϧɺେখɺCFUXFFOɺ CFHJOXJUIͳͲΛࢦఆͰ͖Δ

Slide 35

Slide 35 text

w%ZOBNP%#Ͱ͸σʔλΛߴ଎ʹݕࡧ͢Δͨ ΊɺύʔςΟγϣϯΛಛఆͰ͖ͳ͍ݕࡧ͸ఏڙ ͞Ε͍ͯͳ͍

Slide 36

Slide 36 text

σʔλ֨ೲͷΠϝʔδ /PEF ύʔςΟγϣϯΩʔ ϋογϡ஋ ϨϯδΩʔ " BCDE " BCDE " BDCE # CBDE $ DBCE

Slide 37

Slide 37 text

2ͭͷ ಡΈࠐΈ੔߹ੑ

Slide 38

Slide 38 text

̎ͭͷಡΈࠐΈ੔߹ੑ ݁Ռ੔߹ੑ wJUFNΛߋ৽ޙɺ͙͢͜ΕΛಡΈࠐΉͱݹ͍ σʔλ͕ฦͬͯ͘Δ৔߹͕͋Δ w࠷େͰ΋ඵఔ౓ ڧ͍੔߹ੑ wඞͣ࠷৽ͷσʔλ͕ฦͬͯ͘Δ wͨͩ͠$6ΛഒҎ্ফඅ͢Δ

Slide 39

Slide 39 text

JUFN͸ͭͷ";ʹϨϓϦέʔτ͞ΕΔ *E /BNF )PHF AZ1 AZ2 AZ3 *E /BNF )PHF *E /BNF )PHF

Slide 40

Slide 40 text

ߋ৽ॲཧΛͨ͠৔߹ɾɾɾ *E /BNF )PHF AZ1 AZ2 AZ3 *E /BNF 'VHB *E /BNF 'VHB

Slide 41

Slide 41 text

ڧ͍੔߹ੑͰಡΈࠐΜͩ৔߹ *E /BNF )PHF AZ1 AZ2 AZ3 *E /BNF 'VHB *E /BNF 'VHB

Slide 42

Slide 42 text

࣮ࡍͷར༻ྫ

Slide 43

Slide 43 text

ΞϓϦͷૢ࡞ϩά wϢʔβ*%ΛύʔςΟγϣϯΩʔ wλΠϜελϯϓΛϨϯδΩʔ wΠϕϯτϩάΛߴ଎ʹॻ͖͜Ή w%ZOBNP%#4USFBNT-BNCEB4 "UIFOBͰूܭ

Slide 44

Slide 44 text

ΧϨϯμʔσʔλ w3%#͚ͩͩͱΩπΠ w܁Γฦ͠ɺऴ೔༧ఆɺଞϢʔβͱͷڞ༗ΧϨϯ μʔɺެ։ൣғɾɾɾ w3%#ͷσʔλΛݩʹ424ʹλεΫΛ࡞੒ w%ZOBNP%#্ʹϢʔβɺ೔෇ผʹݸผʹ౎౓ σʔλ࡞੒

Slide 45

Slide 45 text

·ͱΊ w3%#ɺ%ZOBNP%#ͦΕͧΕͷಛੑΛ׆͔͢ wΩϟύγςΟϢχοτ͸ద੾ʹ w%ZOBNP%#͕σʔλΛͲͷΑ͏ʹอ͍࣋ͯ͠Δ ͔Πϝʔδ͢Δ͜ͱ͸େࣄ wΫϥ΢υͩͱ3%#΍%ZOBNP%#ͷଞʹ΋σʔλ ετϨʔδ͸͋Δ w֤ʑͷσʔλͷϥΠϑαΠΫϧɺΞΫηεස౓ɺ ͳͲΛߟ͑ɺద੾ͳσʔλετϨʔδʹσʔλΛ ஔ͜͏

Slide 46

Slide 46 text

͋Γ͕ͱ͏͍͟͝·ͨ͠