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

Transcript

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

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

3. 8IP
   BN
   *
    େ܀
   फʢ!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γεςϜͰ͸ॻ͖ࠐΈ͸ׂͱݴΘΕΔɻ
 ࠓ·Ͱͷ3FBE
    3FQMJDBͰରԠͰ͖ͳ͍͔ʁ
    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. "VSPSB
    4FSWFSMFTT  ΦϯσϚϯυɺΦʔτεέʔϧͳαʔόϨεσʔλϕʔε
    wΠϯελϯεͷϓϩϏδϣχϯάෆཁͰΩϟύγςΟ͕ࣗಈ૿ݮ
    wΦϯσϚϯυͷىಈͱɺෆཁ࣌ʹ͸ఀࢭ͕Մೳ
    w"84
    .BOBHFNFOU
    $POTPMF
    Ͱ਺ճΫϦοΫ͢Δ͚ͩͰɺ
 ඪ४ͱαʔόʔϨεͷઃఆؒΛҠߦ

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

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

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

36. 

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

38. 

39. %ZOBNP%#
    #BDLVQ
    BOE
    3FTUPSF  Ϋϥ΢υσʔλϕʔεʹΦϯσϚϯυͱܧଓత৔όοΫΞο ϓΛఏڙ
    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. #BUDIFE
    TDBOT
    "NB[PO
    "VSPSB  εΩϟϯͷόονॲཧΛαϙʔτ
    wϝϞϦ಺ͷεΩϟϯࢦ޲ͷΫΤϦΛେ෯ʹߴ଎Խ
    wςʔϒϧϑϧεΩϟϯɺΠϯσοΫεϑϧεΩϟϯɺ
 ΠϯσοΫεϨϯδεΩϟϯͷύϑΥʔϚϯε͕޲্

43. #BUDIFE
    TDBOT
    "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. 1BSBMMFM
    2VFSZ
    "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