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

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

Transcript

1. IJHPCBTIJBXT
   SF*OWFOU
   Ͱൃද͞Εͨ
   %#ͷΞοϓσʔτʹഭΔʂ 
   "84ࣄۀ෦
   γχΞιϦϡʔγϣϯΞʔΩςΫτ
   େ܀
   फ
2. εϥΠυ͸ޙͰೖख͢Δ͜ͱ͕ग़དྷ·͢ͷͰ ൃදதͷ಺༰ΛϝϞ͢Δඞཁ͸͋Γ·ͤΜɻ ࣸਅࡱӨΛ͢Δ৔߹͸ ϑϥογϡɾγϟολʔԻ͕ग़ͳ͍Α͏ʹ͝഑ྀ͍ͩ͘͞ Attention
3. 8IP
   BN
   *
    େ܀
   फʢ!NBSPPOTUʣ
   ϝʔΧʔܥ4*FSʹ೥΄Ͳࡏ੶ͯ͠
 ΫϥεϝιουʹδϣΠϯ
   ݱࡏ͸"84ͷಋೖίϯαϧςΟϯά΍
 ΠϯϑϥߏஙΛߦ͍ͬͯ·͢
   ຊڌ஍͸౦ژͰ͕݄͢ ݄͸େࡕʹ͍·͢

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ର৅͕ଟ͍ͷͰɺ͍ͪૣ͘৮ΔͨΊʹਃ͠ࠐΈΛ