higobashi.aws 第1回 AWS re:Invent 2017 報告会 re:Invent 2017で発表されたDBのアップデートに迫る！

Slide 1

Slide 1 text

IJHPCBTIJBXT SF*OWFOUͰൃද͞Εͨ %#ͷΞοϓσʔτʹഭΔʂ "84ࣄۀ෦γχΞιϦϡʔγϣϯΞʔΩςΫτେ܀फ

Slide 2

Slide 2 text

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

Slide 3

Slide 3 text

8IPBN* େ܀फʢ!NBSPPOTUʣ ϝʔΧʔܥ4*FSʹ೥΄Ͳࡏ੶ͯ͠  ΫϥεϝιουʹδϣΠϯ ݱࡏ͸"84ͷಋೖίϯαϧςΟϯά΍  ΠϯϑϥߏஙΛߦ͍ͬͯ·͢ ຊڌ஍͸౦ژͰ͕݄͢ ݄͸େࡕʹ͍·͢ 

Slide 4

Slide 4 text

No content

Slide 5

Slide 5 text

re:Inventʹ ࢀՃ͖ͯ͠·ͨ͠ʂ

Slide 6

Slide 6 text

Slide 7

Slide 7 text

૯੎34ਓʂ

Slide 8

Slide 8 text

Slide 9

Slide 9 text

ΈΜͳεΧδϟϯணͯͨΒ

Slide 10

Slide 10 text

ެࣜΞΧ΢ϯτʹิ଍͞Ε·ͨ͠

Slide 11

Slide 11 text

"HFOEB ,FZOPUFͰൃද͞Εͨ৽αʔϏε ,FZOPUFͰൃද͞ΕͨΞοϓσʔτ ,FZOPUFҎ֎ͷΞοϓσʔτ΋ ·ͱΊ

Slide 12

Slide 12 text

KeynoteͰൃද͞Εͨ৽αʔϏε

Slide 13

Slide 13 text

Slide 14

Slide 14 text

"NB[PO/FQUVOF Ϋϥ΢υ޲͚ͷߴ଎Ͱߴ৴པੑͷάϥϑσʔλϕʔε wΦʔϓϯͳάϥϑ"1*ʢ(SFNMJOɺ41"32-ʣ wԿेԯ΋ͷσʔλɾϦϨʔγϣϯʹରͯ͠ɺϛϦඵͷΫΤϦ w";ʹ·͕ͨͬͯͭͷϨϓϦέʔγϣϯΛ࡞੒Ͱ͖ɺϑϧ όοΫΞοϓɾϑϧϦετΞ͕Մೳ

Slide 15

Slide 15 text

"NB[PO/FQUVOF Φʔϓϯͳάϥϑ"1*ʢ(SFNMJOɺ41"32-ʣ w(SFNMJO  w41"32-  preﬁx : <#> select ?names where { ?howard :name "Howard" . ?howard :knows/:knows/:name ?names . } g.V().has('name', 'Howard').out('knows').out('knows').values('name') https://docs.aws.amazon.com/neptune/latest/userguide/graph-database.html

Slide 16

Slide 16 text

"NB[PO/FQUVOF ";ʹ·͕ͨͬͯͭͷϨϓϦέʔγϣϯΛ࡞੒Ͱ͖ɺ ϑϧόοΫΞοϓɾϑϧϦετΞ͕Մೳ wҰݴͰݴ͏ͱɺ"NB[PO"VSPSBͱಉ͡Α͏ͳετϨʔδͷ ্ʹ/FQUVOFͷάϥϑ%#༻ϊʔυ͕ࡌ͍ͬͯΔΠϝʔδͰ ߟ͑Δͱྑ͍ͱࢥ͏

Slide 17

Slide 17 text

"NB[PO/FQUVOF /FQUVOF "VSPSB https://www.slideshare.net/AmazonWebServices/dat405-amazon-aurora-deep-dive https://www.youtube.com/watch?v=6o1Ezf6NZ_E

Slide 18

Slide 18 text

"NB[PO/FQUVOF /FQUVOF "VSPSB https://www.slideshare.net/AmazonWebServices/aws-reinvent-2016-deep-dive-on-amazon-aurora-dat303 https://www.youtube.com/watch?v=6o1Ezf6NZ_E

Slide 19

Slide 19 text

"NB[PO/FQUVOF /FQUVOF "VSPSB https://www.slideshare.net/AmazonWebServices/aws-reinvent-2016-deep-dive-on-amazon-aurora-dat303 https://www.youtube.com/watch?v=6o1Ezf6NZ_E

Slide 20

Slide 20 text

"NB[PO/FQUVOF /FQUVOF "VSPSB https://www.slideshare.net/AmazonWebServices/aws-reinvent-2016-deep-dive-on-amazon-aurora-dat303 https://www.youtube.com/watch?v=6o1Ezf6NZ_E

Slide 21

Slide 21 text

"NB[PO/FQUVOF /FQUVOF "VSPSB https://www.slideshare.net/AmazonWebServices/deep-dive-on-the-amazon-aurora-mysqlcompatible-edition-dat301-reinvent-2017 https://www.youtube.com/watch?v=6o1Ezf6NZ_E

Slide 22

Slide 22 text

"NB[PO/FQUVOF /FQUVOF "VSPSB https://www.slideshare.net/AmazonWebServices/deep-dive-on-the-amazon-aurora-mysqlcompatible-edition-dat301-reinvent-2017 https://www.youtube.com/watch?v=6o1Ezf6NZ_E

Slide 23

Slide 23 text

KeynoteͰൃද͞ΕͨΞοϓσʔτ

Slide 24

Slide 24 text

Slide 25

Slide 25 text

"VSPSB.VMUJ.BTUFS ʰෳ਺ͷσʔληϯλʔʹΘͨΔεέʔϧΞ΢τ͢Δॳ ͷ3%#αʔϏεʱ wϊʔυো֐Ͱ΋ΞϓϦέʔγϣϯͷθϩμ΢ϯλΠϜ w";ো֐Ͱ΋ΞϓϦέʔγϣϯͷθϩμ΢ϯλΠϜ wॻ͖ࠐΈੑೳͷ޲্

Slide 26

Slide 26 text

"VSPSB.VMUJ.BTUFS ෼ࢄ୆ாΛ࢖༻ͨ͠ίϯϑϦΫτͷղܾ https://www.slideshare.net/AmazonWebServices/deep-dive-on-the-amazon-aurora-mysqlcompatible-edition-dat301-reinvent-2017

Slide 27

Slide 27 text

"VSPSB.VMUJ.BTUFS ֊૚తͳίϯϑϦΫτͷղܾ https://www.slideshare.net/AmazonWebServices/deep-dive-on-the-amazon-aurora-mysqlcompatible-edition-dat301-reinvent-2017

Slide 28

Slide 28 text

"VSPSB.VMUJ.BTUFS Ұൠతͳ8FCγεςϜͰ͸ॻ͖ࠐΈ͸ׂͱݴΘΕΔɻ  ࠓ·Ͱͷ3FBE3FQMJDBͰରԠͰ͖ͳ͍͔ʁ wࠓ·Ͱ͸8SJUFͱ3FBEΛΞϓϦͰ޲͖Λม͑Δඞཁ͕͋Δ w.VMUJ.BTUFS͸ΞϓϦͷϩδοΫมߋແ͠ʹεέʔϧͰ͖Δ w"DUJWF"DUJWFͳͷͰطଘͷ'BJMPWFSΑΓߴՄ༻ੑΛظ଴

Slide 29

Slide 29 text

"VSPSB.VMUJ.BTUFS ϦʔδϣϯΛ·͕ͨΔ.VMUJ.BTUFS͸೥༧ఆ wָ؍తಉ࣮࣌ߦ੍ޚ wڝ߹Խগͳ͚Ε͹  εέʔϦϯά͢Δ https://www.slideshare.net/AmazonWebServices/deep-dive-on-the-amazon-aurora-mysqlcompatible-edition-dat301-reinvent-2017

Slide 30

Slide 30 text

"VSPSB.VMUJ.BTUFS Ͱ΋ϦʔδϣϯΛ·͕ͨΔMulti-Master͸ 1ϦʔδϣϯͰʮͲ͏ͯ͠΋ʯղܾͰ͖ͳ͍  ৔߹ͷΈ࢖༻͢΂͖ͩͱࢥ͏

Slide 31

Slide 31 text

"VSPSB.VMUJ.BTUFS Ұൠతͳ༻్ͱͯ͠͸ େن໛ো֐ʹର͢ΔBCPͷखஈͱͯ͠ ࢖༻͢Δ͜ͱ͕ྑͦ͞͏ DRઌͰߋ৽ͨ͠σʔλͷϦετΞ͕ ෆཁʹͳΔ͸ͣ

Slide 32

Slide 32 text

Slide 33

Slide 33 text

"VSPSB4FSWFSMFTT ΦϯσϚϯυɺΦʔτεέʔϧͳαʔόϨεσʔλϕʔε wΠϯελϯεͷϓϩϏδϣχϯάෆཁͰΩϟύγςΟ͕ࣗಈ૿ݮ wΦϯσϚϯυͷىಈͱɺෆཁ࣌ʹ͸ఀࢭ͕Մೳ w"84.BOBHFNFOU$POTPMFͰ਺ճΫϦοΫ͢Δ͚ͩͰɺ  ඪ४ͱαʔόʔϨεͷઃఆؒΛҠߦ

Slide 34

Slide 34 text

"VSPSB4FSWFSMFTT ΠϯελϯεͷϓϩϏδϣχϯάͱεέʔϦϯά wॳճϦΫΤετ͔Β௨ৗ  dඵͰϓϩϏδϣχϯά wεέʔϦϯάͰ΋Ϣʔβʔ  ηογϣϯ͕ऴྃ͠ͳ͍ wετϨʔδ͸Ϣʔβ͕  ໌ࣔతʹ࡟আ͢Δ·Ͱ  ӬଓԽ͍ͯ͠Δ https://www.slideshare.net/AmazonWebServices/deep-dive-on-the-amazon-aurora-mysqlcompatible-edition-dat301-reinvent-2017

Slide 35

Slide 35 text

"VSPSB4FSWFSMFTT Serverlessͱݴ͏໊લ͕ͩ  Lambdaઐ༻ͷRDBͰ͸ͳ͍ ௨ৗͷΞΫηε͕ͳ͍։ൃ؀ڥͳͲ΍  όονॲཧͰ࢖༻͢Δͱྑͦ͞͏

Slide 36

Slide 36 text

Slide 37

Slide 37 text

%ZOBNP%#(MPCBM5BCMFT ϑϧϚωʔδυɺϚϧνϚελɺϚϧνϦʔδϣϯͷ%# wߴੑೳͰάϩʔόϧʹ෼ࢄͨ͠ΞϓϦέʔγϣϯͷߏங w௿ϨΠςϯγͳಡΈࠐΈͱϩʔΧϧͰ࢖༻Մೳͳද΁ॻ͖ࠐΈ wϚϧνϦʔδϣϯͷ৑௕ੑʹΑΔࡂ֐ wηοτΞοϓ͕؆୯ͰΞϓϦέʔγϣϯͷॻ͖׵͑ෆཁ

Slide 38

Slide 38 text

Slide 39

Slide 39 text

%ZOBNP%##BDLVQBOE3FTUPSF Ϋϥ΢υσʔλϕʔεʹΦϯσϚϯυͱܧଓత৔όοΫΞο ϓΛఏڙ wࠓ·Ͱ΋ΠϯϙʔτΤΫεϙʔτ͕͕͋ͬͨҰ؏ੑͷແ͍σʔλͩͬͨ wߴ଎ʹҰ؏ੑͷ͋ΔόοΫΞοϓΛऔಘՄೳ wύϑΥʔϚϯεӨڹͳ͠ʹ਺ඦ5#ͷσʔλͷόοΫΞοϓΛऔಘՄೳ

Slide 40

Slide 40 text

KeynoteҎ֎ͷΞοϓσʔτ΋

Slide 41

Slide 41 text

#BDLUSBDL "NB[PO"VSPSB طଘͷΫϥελΛ΄΅ॠ࣌ʹϦετΞͰ͖Δ wر๬ͷ࣌ࠁ΁σʔλϕʔεͷঢ়ଶΛૉૣ͘໭͢ wผΫϥελΛ࡞੒͠ͳ͍ wޡͬͨ%.-%%-ͷૢ࡞͔Β  ૉૣ͘෮ݩͰ͖Δ https://www.slideshare.net/AmazonWebServices/deep-dive-on-the-amazon-aurora-mysqlcompatible-edition-dat301-reinvent-2017

Slide 42

Slide 42 text

#BUDIFETDBOT "NB[PO"VSPSB εΩϟϯͷόονॲཧΛαϙʔτ wϝϞϦ಺ͷεΩϟϯࢦ޲ͷΫΤϦΛେ෯ʹߴ଎Խ wςʔϒϧϑϧεΩϟϯɺΠϯσοΫεϑϧεΩϟϯɺ  ΠϯσοΫεϨϯδεΩϟϯͷύϑΥʔϚϯε͕޲্

Slide 43

Slide 43 text

#BUDIFETDBOT "NB[PO"VSPSB εΩϟϯͷόονॲཧΛαϙʔτ wϝϞϦ಺ͷεΩϟϯࢦ޲ͷΫΤϦΛେ෯ʹߴ଎Խ wςʔϒϧϑϧεΩϟϯɺΠϯσοΫεϑϧεΩϟϯɺ  ΠϯσοΫεϨϯδεΩϟϯͷύϑΥʔϚϯε͕޲্ Aurora 1.16ͷΞοϓσʔτͰຊ೔͔Βར༻Մೳ

Slide 44

Slide 44 text

)BTI+PJOT "NB[PO"VSPSB ݁߹ΞϧΰϦζϜͱͯ͠ϋογϡδϣΠϯΛαϙʔτ wࠓ·Ͱ.Z42-ͷδϣΠϯΞϧΰϦζϜ /-+ɺ#," ʹରԠ wҰൠతʹ͸/-+#,"ʹൺ΂ͯɺ݁߹ର৅͕ଟ͘ϝϞϦ͕  ५୔Ͱ͋Δɺ݁߹৚݅ʹΠϯσοΫε͕ͳ͍౳ͷ৔߹ʹ  ߴ଎ʹಈ࡞͢Δ

Slide 45

Slide 45 text

)BTI+PJOT "NB[PO"VSPSB ݁߹ΞϧΰϦζϜͱͯ͠ϋογϡδϣΠϯΛαϙʔτ wࠓ·Ͱ.Z42-ͷδϣΠϯΞϧΰϦζϜ /-+ɺ#," ʹରԠ wҰൠతʹ͸/-+#,"ʹൺ΂ͯɺ݁߹ର৅͕ଟ͘ϝϞϦ͕  ५୔Ͱ͋Δɺ݁߹৚݅ʹΠϯσοΫε͕ͳ͍౳ͷ৔߹ʹ  ߴ଎ʹಈ࡞͢Δ Aurora 1.16ͷΞοϓσʔτͰຊ೔͔Βར༻Մೳ

Slide 46

Slide 46 text

1BSBMMFM2VFSZ "NB[PO"VSPSB ετϨʔδϊʔυͷ५୔ͳ$16Λ࢖༻ͨ͠ฒྻΫΤϦ ॲཧ wϔουϊʔυ͕ύϥϨϧΫΤϦϓϥϯ  Λੜ੒ͯ͠ετϨʔδϊʔυ΁ૹ৴ wετϨʔδϊʔυͰεΩϟϯର৅ͷ  ϖʔδϦετΛجʹεΩϟϯ wϔουϊʔυ͕σʔλΛू໿ https://www.slideshare.net/AmazonWebServices/deep-dive-on-the-amazon-aurora-mysqlcompatible-edition-dat301-reinvent-2017

Slide 47

Slide 47 text

·ͱΊ

Slide 48

Slide 48 text

·ͱΊ wάϩʔόϧͳΞϓϦέʔγϣϯΛҙࣝͨ͠ൃදଟ਺ wͰ΋࢖ΘͣʹࡁΉͷͰ͋Ε͹ɺ·ͣ͸γϯάϧϦʔδϣϯͷΞ ϓϦέʔγϣϯΛઃܭ͢΂͠ wάϥϑ%#Λ׆༻ͦ͠͏ͳਓ͸σʔλϞσϧ΍ΫΤϦΛษڧͯ͠ ͓͜͏ w೿खͳൃදҎ֎ʹ΋ӡ༻΍ύϑΥʔϚϯε͕޲্͢Δ৽ػೳ͕ ग़͍ͯΔ w1SFWJFXର৅͕ଟ͍ͷͰɺ͍ͪૣ͘৮ΔͨΊʹਃ͠ࠐΈΛ