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ࣄۀ෦γχΞιϦϡʔγϣϯΞʔΩςΫτେ܀फ
   

   View Slide

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

   View Slide

3. 8IPBN*
   େ܀फʢ!NBSPPOTUʣ
   ϝʔΧʔܥ4*FSʹ೥΄Ͳࡏ੶ͯ͠

   ΫϥεϝιουʹδϣΠϯ
   ݱࡏ͸"84ͷಋೖίϯαϧςΟϯά΍

   ΠϯϑϥߏஙΛߦ͍ͬͯ·͢
   ຊڌ஍͸౦ژͰ͕݄͢ ݄͸େࡕʹ͍·͢

   

   View Slide

4. View Slide

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

   View Slide

6. 
   

   View Slide

7. 
   ૯੎34ਓʂ
   

   View Slide

8. 
   

   View Slide

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

   View Slide

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

    View Slide

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

    View Slide

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

    View Slide

13. 
    

    View Slide

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

    View Slide

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
    

    View Slide

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

    View Slide

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

    View Slide

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
    

    View Slide

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
    

    View Slide

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
    

    View Slide

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
    

    View Slide

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
    

    View Slide

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

    View Slide

24. 
    

    View Slide

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

    View Slide

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

    View Slide

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

    View Slide

28. "VSPSB.VMUJ.BTUFS
    Ұൠతͳ8FCγεςϜͰ͸ॻ͖ࠐΈ͸ׂͱݴΘΕΔɻ

    ࠓ·Ͱͷ3FBE3FQMJDBͰରԠͰ͖ͳ͍͔ʁ
    wࠓ·Ͱ͸8SJUFͱ3FBEΛΞϓϦͰ޲͖Λม͑Δඞཁ͕͋Δ
    w.VMUJ.BTUFS͸ΞϓϦͷϩδοΫมߋແ͠ʹεέʔϧͰ͖Δ
    w"DUJWF"DUJWFͳͷͰطଘͷ'BJMPWFSΑΓߴՄ༻ੑΛظ଴
    

    View Slide

29. "VSPSB.VMUJ.BTUFS
    ϦʔδϣϯΛ·͕ͨΔ.VMUJ.BTUFS͸೥༧ఆ
    wָ؍తಉ࣮࣌ߦ੍ޚ
    wڝ߹Խগͳ͚Ε͹

    εέʔϦϯά͢Δ
    https://www.slideshare.net/AmazonWebServices/deep-dive-on-the-amazon-aurora-mysqlcompatible-edition-dat301-reinvent-2017
    

    View Slide

30. "VSPSB.VMUJ.BTUFS
    Ͱ΋ϦʔδϣϯΛ·͕ͨΔMulti-Master͸
    1ϦʔδϣϯͰʮͲ͏ͯ͠΋ʯղܾͰ͖ͳ͍

    ৔߹ͷΈ࢖༻͢΂͖ͩͱࢥ͏
    

    View Slide

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

    View Slide

32. 
    

    View Slide

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

    ඪ४ͱαʔόʔϨεͷઃఆؒΛҠߦ
    

    View Slide

34. "VSPSB4FSWFSMFTT
    ΠϯελϯεͷϓϩϏδϣχϯάͱεέʔϦϯά
    wॳճϦΫΤετ͔Β௨ৗ

    dඵͰϓϩϏδϣχϯά
    wεέʔϦϯάͰ΋Ϣʔβʔ

    ηογϣϯ͕ऴྃ͠ͳ͍
    wετϨʔδ͸Ϣʔβ͕

    ໌ࣔతʹ࡟আ͢Δ·Ͱ

    ӬଓԽ͍ͯ͠Δ https://www.slideshare.net/AmazonWebServices/deep-dive-on-the-amazon-aurora-mysqlcompatible-edition-dat301-reinvent-2017
    

    View Slide

35. "VSPSB4FSWFSMFTT
    Serverlessͱݴ͏໊લ͕ͩ

    Lambdaઐ༻ͷRDBͰ͸ͳ͍
    ௨ৗͷΞΫηε͕ͳ͍։ൃ؀ڥͳͲ΍

    όονॲཧͰ࢖༻͢Δͱྑͦ͞͏
    

    View Slide

36. 
    

    View Slide

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

    View Slide

38. 
    

    View Slide

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

    View Slide

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

    View Slide

41. #BDLUSBDL "NB[PO"VSPSB
    
    طଘͷΫϥελΛ΄΅ॠ࣌ʹϦετΞͰ͖Δ
    wر๬ͷ࣌ࠁ΁σʔλϕʔεͷঢ়ଶΛૉૣ͘໭͢
    wผΫϥελΛ࡞੒͠ͳ͍
    wޡͬͨ%.-%%-ͷૢ࡞͔Β

    ૉૣ͘෮ݩͰ͖Δ
    https://www.slideshare.net/AmazonWebServices/deep-dive-on-the-amazon-aurora-mysqlcompatible-edition-dat301-reinvent-2017
    

    View Slide

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

    ΠϯσοΫεϨϯδεΩϟϯͷύϑΥʔϚϯε͕޲্
    

    View Slide

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

    ΠϯσοΫεϨϯδεΩϟϯͷύϑΥʔϚϯε͕޲্
    Aurora 1.16ͷΞοϓσʔτͰຊ೔͔Βར༻Մೳ
    

    View Slide

44. )BTI+PJOT "NB[PO"VSPSB
    
    ݁߹ΞϧΰϦζϜͱͯ͠ϋογϡδϣΠϯΛαϙʔτ
    wࠓ·Ͱ.Z42-ͷδϣΠϯΞϧΰϦζϜ /-+ɺ#,"
    ʹରԠ
    wҰൠతʹ͸/-+#,"ʹൺ΂ͯɺ݁߹ର৅͕ଟ͘ϝϞϦ͕

    ५୔Ͱ͋Δɺ݁߹৚݅ʹΠϯσοΫε͕ͳ͍౳ͷ৔߹ʹ

    ߴ଎ʹಈ࡞͢Δ
    

    View Slide

45. )BTI+PJOT "NB[PO"VSPSB
    
    ݁߹ΞϧΰϦζϜͱͯ͠ϋογϡδϣΠϯΛαϙʔτ
    wࠓ·Ͱ.Z42-ͷδϣΠϯΞϧΰϦζϜ /-+ɺ#,"
    ʹରԠ
    wҰൠతʹ͸/-+#,"ʹൺ΂ͯɺ݁߹ର৅͕ଟ͘ϝϞϦ͕

    ५୔Ͱ͋Δɺ݁߹৚݅ʹΠϯσοΫε͕ͳ͍౳ͷ৔߹ʹ

    ߴ଎ʹಈ࡞͢Δ
    Aurora 1.16ͷΞοϓσʔτͰຊ೔͔Βར༻Մೳ
    

    View Slide

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
    

    View Slide

47. 
    ·ͱΊ
    

    View Slide

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

    View Slide

49. View Slide

50. View Slide