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

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

Ae763d151aeee101b40ae10cc13ebe63?s=47 maroon1st
December 14, 2017

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

2017年12月13日に開催したhigobashi.aws ( https://classmethod.connpass.com/event/72893/ ) の発表資料です

Ae763d151aeee101b40ae10cc13ebe63?s=128

maroon1st

December 14, 2017
Tweet

Transcript

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

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

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


  4. None
  5.  re:Inventʹ ࢀՃ͖ͯ͠·ͨ͠ʂ

  6. 

  7.  ૯੎34ਓʂ

  8. 

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

  10.  ެࣜΞΧ΢ϯτʹิ଍͞Ε·ͨ͠

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

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

  13. 

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

  15. "NB[PO/FQUVOF  Φʔϓϯͳάϥϑ"1*ʢ(SFNMJOɺ41"32-ʣ w(SFNMJO
 w41"32-
 prefix : <#> 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
  16. "NB[PO/FQUVOF  ";ʹ·͕ͨͬͯͭͷϨϓϦέʔγϣϯΛ࡞੒Ͱ͖ɺ ϑϧόοΫΞοϓɾϑϧϦετΞ͕Մೳ wҰݴͰݴ͏ͱɺ"NB[PO"VSPSBͱಉ͡Α͏ͳετϨʔδͷ ্ʹ/FQUVOFͷάϥϑ%#༻ϊʔυ͕ࡌ͍ͬͯΔΠϝʔδͰ ߟ͑Δͱྑ͍ͱࢥ͏

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

  18. "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

  19. "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

  20. "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

  21. "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

  22. "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

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

  24. 

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

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

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

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

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

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

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

  32. 

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

  34. "VSPSB4FSWFSMFTT  ΠϯελϯεͷϓϩϏδϣχϯάͱεέʔϦϯά wॳճϦΫΤετ͔Β௨ৗ
 dඵͰϓϩϏδϣχϯά wεέʔϦϯάͰ΋Ϣʔβʔ
 ηογϣϯ͕ऴྃ͠ͳ͍ wετϨʔδ͸Ϣʔβ͕
 ໌ࣔతʹ࡟আ͢Δ·Ͱ
 ӬଓԽ͍ͯ͠Δ

    https://www.slideshare.net/AmazonWebServices/deep-dive-on-the-amazon-aurora-mysqlcompatible-edition-dat301-reinvent-2017
  35. "VSPSB4FSWFSMFTT  Serverlessͱݴ͏໊લ͕ͩ
 Lambdaઐ༻ͷRDBͰ͸ͳ͍ ௨ৗͷΞΫηε͕ͳ͍։ൃ؀ڥͳͲ΍
 όονॲཧͰ࢖༻͢Δͱྑͦ͞͏

  36. 

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

  38. 

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

  40.  KeynoteҎ֎ͷΞοϓσʔτ΋

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

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

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

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

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

    Aurora 1.16ͷΞοϓσʔτͰຊ೔͔Βར༻Մೳ
  46. 1BSBMMFM2VFSZ "NB[PO"VSPSB  ετϨʔδϊʔυͷ५୔ͳ$16Λ࢖༻ͨ͠ฒྻΫΤϦ ॲཧ wϔουϊʔυ͕ύϥϨϧΫΤϦϓϥϯ
 Λੜ੒ͯ͠ετϨʔδϊʔυ΁ૹ৴ wετϨʔδϊʔυͰεΩϟϯର৅ͷ
 ϖʔδϦετΛجʹεΩϟϯ wϔουϊʔυ͕σʔλΛू໿

    https://www.slideshare.net/AmazonWebServices/deep-dive-on-the-amazon-aurora-mysqlcompatible-edition-dat301-reinvent-2017
  47.  ·ͱΊ

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

  49. None
  50. None