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

Amazon Aurora DSQLパフォーマンスチェック / Amazon Aurora ...

Amazon Aurora DSQLパフォーマンスチェック / Amazon Aurora DSQL Performance Check

#jawsugsaga24 2025年もクラウドでGO!新春LT大会
https://jawsug-saga.connpass.com/event/338826/

Avatar for shiro seike

shiro seike

February 01, 2025
Tweet

More Decks by shiro seike

Other Decks in Programming

Transcript

  1. ©Fusic Co., Ltd. 2 ਗ਼Ո ࢙࿠ AWS Community Builder Serverless

    ίϛϡχςΟ Fukuoka.php Fukuoka.go JAWS-UG Fukuoka Serverless Meetup Fukuoka Cloudflare Meetup Fukuoka JP_Stripes Fukuoka ࣗݾ঺հ ͸͡Ίʹ גࣜձࣾFusic ϓϦϯγύϧΤϯδχΞ/ΤόϯδΣϦετ
  2. ©Fusic Co., Ltd. 3 CONTENTS ໨࣍ 1. Amazon DSQLͱ͸ 2.

    Python͔Βܨ͍ͰΈΔ 3. ఏڙϦʔδϣϯͷ՝୊ 4. ·ͱΊ
  3. ©Fusic Co., Ltd. 5 Amazon DSQLͱ͸ Amazon Aurora DSQLʢDistributed SQLʣ͸Auroraͷ৽ػೳͰ͋Γɺ

    ҎԼͷಛ௃Λ࣋ͪ·͢ - ෼ࢄSQLΞʔΩςΫνϟ - ΫϥελશମͰΫΤϦΛฒྻॲཧ͠ɺߴ͍εέʔϥϏϦςΟΛ࣮ݱ - άϩʔόϧͳσʔλҰ؏ੑ - ෳ਺ͷϦʔδϣϯʹ·͕ͨΔσʔλϕʔεͰ΋ Ұ؏ͨ͠τϥϯβΫγϣϯΛఏڙ - PostgreSQLޓ׵ - PostgreSQLͱͷޓ׵ੑΛ࣋ͪͭͭɺ ߴ଎ͳ෼ੳΫΤϦͱεϧʔϓοτΛఏڙ
  4. ©Fusic Co., Ltd. 16 VPC LambdaΛ࡞੒ͯ͠IPv6ରԠͯ͠ࢼͯ͠ΈΔ VPC Lambda ʹରԠͯ͠IPv̒༗ޮԽͯ͠Έͯ΋͏·͍͔͘ͳ͍ connection

    is bad: no error details available ʢ઀ଓෆྑɿΤϥʔͷৄࡉ͸ෆ໌ʣ ͦͷޙɺॾʑࢼ͍ͯͨ͠ͱ͜ΖɺIPv4ͷϩά΋ग़ݱ࢝͠ΊΔ…
  5. ©Fusic Co., Ltd. 20 ·ͱΊ Amazon Aurora DSQL͸෼ࢄSQLΞʔΩςΫνϟɺαʔόϨε੎ͱͯ͠͸৺଴ͪʹͯͨ͠αʔϏε Point 01

    ΋ͪΖΜػೳ੍ݶͳͲ͸͋Δ͚Ͳɺ࢖͑ͳ͍Θ͚Ͱ͸ͳ͍ Point 02 IPv6ରԠ͠ͳ͍ͱ͍͚ͳ͍ʁ -> ͭ·ΓVPC LambdaͰ͸ͳ͍ͱ͍͚ͳ͍ʁʢະ֬ఆʣ Point 03 ΍͸ΓόʔδχΞ๺෦ͷํ͕ര଎Ͱૣ͍ɺϓϨϏϡʔ֎Εͯૣ͘೔ຊϦʔδϣϯʹདྷͯཉ͍͠ʂ Point 04