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

AuroraかRDSどちらを選ぶべきか | Developers.IO 2019 in OSAKA

kazue
October 11, 2019

AuroraかRDSどちらを選ぶべきか | Developers.IO 2019 in OSAKA

https://dev.classmethod.jp/cloud/aws/developers-io-2019-in-osaka-aurora-or-rds/
こちらに詳細を記載していますのでこちらをご覧ください。

kazue

October 11, 2019
Tweet

More Decks by kazue

Other Decks in Programming

Transcript

  1. ࣗݾ঺հ  ͔ͣ͑ • AWSࣄۀຊ෦ ίϯαϧςΟϯά෦ • େࡕΦϑΟεۈ຿ • 2019೥1݄JOIN

    • ৬ྺ • WEBίϯαϧʢडୗ։ൃʣ8೥ • ࣗࣾαʔϏε։ൃӡ༻อक 2೥ • ޷͖ͳAWSαʔϏε • Terraform
  2. ฒྻΫΤϦ  w IUUQTQBHFTBXTDMPVEDPNST5;.JNBHFT%QEG • ΫΤϦ࣮ߦɺτϥϯβΫγϣϯͳͲ͸
 Πϯελϯεͷ໾ׂ • ετϨʔδଆʹ΋CPU͕ଘࡏ(਺ઍݸʣ •

    Ұ෦ΛɺετϨʔδଆϦιʔεͰߦͳ͏
 ˠ ॲཧߴ଎Խ • ΫΤϦ͕࠷େͰ120ഒߴ଎ʹͳͬͨ • 22ΫΤϦͷ͏ͪ8ΫΤϦͰ10ഒҎ্ߴ଎Խ ➡ ΠϯελϯελΠϓΛr3.8xlarge→r3.2xlarge
 ʹམͱͤͨ
  3. "VSPSBʹ͔͠ͳ͍ػೳ  • όοΫΞοϓ/ϦετΞ/ϦΧόϦʔ͕ૣ͍(Protection Groups) • BackTrack • ΫϥελΩϟογϡ؅ཧʹΑΔߴ଎ϦΧόϦ •

    ฒྻΫΤϦ • Global Database • Aurora Serverless • ΄͔ʹ΋৭ʑ৭ʑ ✴ DBΤϯδϯɺόʔδϣϯʹΑͬͯରԠঢ়گ͕·ͪ·ͪͳͷͰ஫ҙ
  4. 

  5. 

  6. 

  7. ΠϯελϯελΠϓ͕ҟͳΔ  U NJDSP TNBMM NFEJVN MBSHF YMBSHF YMBSHF U

    NJDSP TNBMM NFEJVN MBSHF YMBSHF YMBSHF N NFEJVN MBSHF YMBSHF YMBSHF N MBSHF YMBSHF YMBSHF YMBSHF YMBSHF YMBSHF N MBSHF YMBSHF YMBSHF YMBSHF YMBSHF YMBSHF S MBSHF YMBSHF YMBSHF YMBSHF YMBSHF S MBSHF YMBSHF YMBSHF YMBSHF YMBSHF YMBSHF S MBSHF YMBSHF YMBSHF YMBSHF YMBSHF YMBSHF RDS for MySQL(5.6)
  8. ΠϯελϯελΠϓ͕ҟͳΔ  U NJDSP TNBMM NFEJVN MBSHF YMBSHF YMBSHF U

    NJDSP TNBMM NFEJVN MBSHF YMBSHF YMBSHF N NFEJVN MBSHF YMBSHF YMBSHF N MBSHF YMBSHF YMBSHF YMBSHF YMBSHF YMBSHF N MBSHF YMBSHF YMBSHF YMBSHF YMBSHF YMBSHF S MBSHF YMBSHF YMBSHF YMBSHF YMBSHF S MBSHF YMBSHF YMBSHF YMBSHF YMBSHF YMBSHF S MBSHF YMBSHF YMBSHF YMBSHF YMBSHF YMBSHF Aurora MySQL (5.6)
  9. 

  10. %#Τϯδϯͷ৽ػೳΛ͍ͪૣ͘࢖͍͍ͨ  • RDSͷํ͕࠷৽ͷDBΤϯδϯόʔδϣϯରԠ͕ૣ͍ • ྫ1: PostgreSQL 10ରԠ • RDS:

    2018/02/27 (10.1)
 2018/07/25 (10.4) • Aurora: 2018/09/25 (10.4 ޓ׵) • ྫ2: MySQL 5.7ରԠ • RDS: 2016/02/22 • Aurora: 2018/02/06
 w IUUQTEPDTBNB[POBXTDOFO@VT"NB[PO3%4MBUFTU"VSPSB6TFS(VJEF8IBUT/FXIUNM w IUUQTEPDTBXTBNB[PODPNKB@KQ"NB[PO3%4MBUFTU6TFS(VJEF8IBUT/FXIUNM
  11. ͍҆ͨ͘͠՝ۚܗଶͷҧ͍  w IUUQTBXTBNB[PODPNKQSETNZTRMQSJDJOH w IUUQTBXTBNB[PODPNKQSETBVSPSBQSJDJOH RDS Aurora DBΠϯελϯε ࣌ؒैྔ՝ۚ

    ετϨʔδ ࣌ؒैྔ՝ۚ DBΠϯελϯε ࣌ؒैྔ՝ۚ ετϨʔδ ࣌ؒैྔ՝ۚ I/O ϦΫΤετ਺ैྔ՝ۚ ʴ ʴ ʴ > 100 ສ݅ͷϦΫΤετ͋ͨΓ
 0.24USD (@౦ژϦʔδϣϯ)
  12. ͍҆ͨ͘͠%#Πϯελϯεैྔ՝ۚ  w IUUQTBXTBNB[PODPNKQSETNZTRMQSJDJOH w IUUQTBXTBNB[PODPNKQSETBVSPSBQSJDJOH RDS(USD/h) Aurora(USD/h) Ձ֨ࠩ r5.large

    0.285 0.35 122.81% r5.xlarge 0.57 0.7 122.81% r5.2xlarge 1.14 1.4 122.81% r5.4xlarge 2.28 2.8 122.81% r5.12xlarge 6.84 8.4 122.81% ౦ژϦʔδϣϯɾMySQLɾγϯάϧAZɾr5ΠϯελϯελΠϓͰൺֱ
  13. ʢ"VSPSBΑΓ΋ʣ3%4Λ࢖͏΂͖έʔε ࠶ܝ  • DBΤϯδϯͷ৽ػೳΛ͍ͪૣ͘࢖͍͍ͨ • ద༻͞Εͳ͍ύϥϝʔλʔ͕ॏཁ • ͍҆ͨ͘͠ •

    I/O Ͱ΋՝ۚ • Πϯελϯεྉ͕ۚߴ͍ • Auroraͷํ͕҆͘ͳΔ෦෼ • Multi-AZෆཁͳέʔε • StandByϨϓϦΧෆཁ • ϨϓϦΧ෼ͷετϨʔδྉ͔͔ۚΒͳ͍ • ϨϓϦΧͷ୆਺ݮΒ͢orεϖοΫԼ͛ΒΕΔ͔΋ • τʔλϧίετͰߟ͑Δ
  14. ·ͱΊ  • AuroraͱRDSͷҧ͍Λཧղͯ͠ɺ
 ద੾ʹ࢖͍෼͚Δ͜ͱ͕Ͱ͖ΔΑ͏ʹ • ΞʔΩςΫνϟͷҧ͍ • Auroraʹ͔͠ͳ͍ػೳ •

    Aurora࢖͑ͳ͍৔߹ • RDS࢖͏΂͖৔߹ • Aurora͍͢͝ɻΈΜͳ΋·ͣAuroraࢼͦ͏ͥ • ͕͢͝͞఻Θͬͯͳ͔ͬͨΒࢲͷ੹೚Ͱ͢