$30 off During Our Annual Pro Sale. View Details »

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

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/ ) の発表資料です

maroon1st

December 14, 2017
Tweet

More Decks by maroon1st

Other Decks in Technology

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