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

Slide 1

Slide 1 text

©Fusic Co., Ltd. 1 Amazon Aurora DSQLΛࢼͯ͠ΈΔ 2025.02.01 @seike460 #jawsugsaga24 2025೥΋Ϋϥ΢υͰGOʂ৽य़LTେձ

Slide 2

Slide 2 text

©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 ϓϦϯγύϧΤϯδχΞ/ΤόϯδΣϦετ

Slide 3

Slide 3 text

©Fusic Co., Ltd. 3 CONTENTS ໨࣍ 1. Amazon DSQLͱ͸ 2. Python͔Βܨ͍ͰΈΔ 3. ఏڙϦʔδϣϯͷ՝୊ 4. ·ͱΊ

Slide 4

Slide 4 text

©Fusic Co., Ltd. 4 Amazon DSQLͱ͸ 1

Slide 5

Slide 5 text

©Fusic Co., Ltd. 5 Amazon DSQLͱ͸ Amazon Aurora DSQLʢDistributed SQLʣ͸Auroraͷ৽ػೳͰ͋Γɺ ҎԼͷಛ௃Λ࣋ͪ·͢ - ෼ࢄSQLΞʔΩςΫνϟ - ΫϥελશମͰΫΤϦΛฒྻॲཧ͠ɺߴ͍εέʔϥϏϦςΟΛ࣮ݱ - άϩʔόϧͳσʔλҰ؏ੑ - ෳ਺ͷϦʔδϣϯʹ·͕ͨΔσʔλϕʔεͰ΋ Ұ؏ͨ͠τϥϯβΫγϣϯΛఏڙ - PostgreSQLޓ׵ - PostgreSQLͱͷޓ׵ੑΛ࣋ͪͭͭɺ ߴ଎ͳ෼ੳΫΤϦͱεϧʔϓοτΛఏڙ

Slide 6

Slide 6 text

©Fusic Co., Ltd. 6 2 Python͔Βܨ͍ͰΈΔ

Slide 7

Slide 7 text

©Fusic Co., Ltd. 7 Amazon DSQLͷ࡞੒΋͔ΜͨΜ Create clusterΛԡԼ

Slide 8

Slide 8 text

©Fusic Co., Ltd. 8 Amazon DSQLͷ࡞੒΋͔ΜͨΜ NameλάΛઃఆͰ͖ΔͷͰ໊લΛઃఆ͢Δ ϚϧνϦʔδϣϯʹ͍ͨ͠৔߹͸ Add linked RegionsʹνΣοΫΛ͢Δ

Slide 9

Slide 9 text

©Fusic Co., Ltd. 9 Amazon DSQLͷ࡞੒΋͔ΜͨΜ ઀ଓ৘ใ͸ৄࡉ͔ΒConnectΛԡ͢ͱͰ͖ͯ·͢

Slide 10

Slide 10 text

©Fusic Co., Ltd. 10 Python͔Βͷ઀ଓ ιʔείʔυ͸Ϋϥεϝιου༷ͷ΋ͷΛྲྀ༻ͤͯ͞௖͖·ͨ͠ɻ ࢀߟURLɿhttps://dev.classmethod.jp/articles/connect-aurora-dsql-from-aws-cli-and-python-psycopg-on-aws-cloudshell/

Slide 11

Slide 11 text

©Fusic Co., Ltd. 11 InsertͱSelectΛ10ճ܁Γฦ͢ʢσϞʣ ͓ੈࣙʹ΋ૣ͍ͱ͸ݴ͑ͳ͍

Slide 12

Slide 12 text

©Fusic Co., Ltd. 12 ఏڙϦʔδϣϯͷ՝୊ 3

Slide 13

Slide 13 text

©Fusic Co., Ltd. 13 Amazon DSQLͷ՝୊ όʔδχΞ๺෦ʢus-east-1ʣͱΦϋΠΦʢus-east-2ʣͰ͔͠ར༻Ͱ͖ͳ͍ ͦ΋ͦ΋·ͩϓϨϏϡʔͳͷͰ͠ΐ͏͕ͳ͍ͷͰ͕͢ɺ ଠฏ༸ΛڬΜͰSQL͕ྲྀΕΔͷ͸ඇৗʹݫͦ͠͏

Slide 14

Slide 14 text

©Fusic Co., Ltd. 14 LambdaΛόʔδχΞ๺෦ʹཱͯΔʁ౦ژʹཱͯΔʁ ͦΕͰ΋ར༻͍ͨ͠৔߹ɺ AWS LambdaͱDSQLͷڑ཭Λߟྀ͠όʔδχΞ๺෦ʹཱͯΔ΂͖ͳͷ͔ ͦΕͱ΋AWS LambdaͷىಈΛ༏ઌͯ͠౦ژʹཱͯΔ΂͖ͳͷ͔

Slide 15

Slide 15 text

©Fusic Co., Ltd. 15 ࢼͯ͠ΈΑ͏ ͬ͞ͱAWS LambdaͰࢼͯ͠ΈΑ͏ͱಉ͡ιʔείʔυͰ ࢼͨ͠ͱ͜ΖΤϥʔ͕ൃੜɺIPv6ͷIPʹ઀ଓͰ͖ͯͳ͍Έ͍ͨ VPC Lambdaʹઃఆͯ͠IPv6ʹઃఆ͠ͳ͚Ε͹ͳΒͳ͍

Slide 16

Slide 16 text

©Fusic Co., Ltd. 16 VPC LambdaΛ࡞੒ͯ͠IPv6ରԠͯ͠ࢼͯ͠ΈΔ VPC Lambda ʹରԠͯ͠IPv̒༗ޮԽͯ͠Έͯ΋͏·͍͔͘ͳ͍ connection is bad: no error details available ʢ઀ଓෆྑɿΤϥʔͷৄࡉ͸ෆ໌ʣ ͦͷޙɺॾʑࢼ͍ͯͨ͠ͱ͜ΖɺIPv4ͷϩά΋ग़ݱ࢝͠ΊΔ…

Slide 17

Slide 17 text

©Fusic Co., Ltd. 17 ΍Γ͍ͨ͜ͱ͸Amazon Aurora DSQLͷύϑΥʔϚϯε ʢ࠶ʣख๏͸Ϋϥεϝιου༷ͷ΋ͷΛྲྀ༻ͤͯ͞௖͖·ͨ͠ɻ ࢀߟURLɿhttps://dev.classmethod.jp/articles/connect-aurora-dsql-from-aws-cli-and-python-psycopg-on-aws-cloudshell/

Slide 18

Slide 18 text

Slide 19

Slide 19 text

Slide 20

Slide 20 text

©Fusic Co., Ltd. 20 ·ͱΊ Amazon Aurora DSQL͸෼ࢄSQLΞʔΩςΫνϟɺαʔόϨε੎ͱͯ͠͸৺଴ͪʹͯͨ͠αʔϏε Point 01 ΋ͪΖΜػೳ੍ݶͳͲ͸͋Δ͚Ͳɺ࢖͑ͳ͍Θ͚Ͱ͸ͳ͍ Point 02 IPv6ରԠ͠ͳ͍ͱ͍͚ͳ͍ʁ -> ͭ·ΓVPC LambdaͰ͸ͳ͍ͱ͍͚ͳ͍ʁʢະ֬ఆʣ Point 03 ΍͸ΓόʔδχΞ๺෦ͷํ͕ര଎Ͱૣ͍ɺϓϨϏϡʔ֎Εͯૣ͘೔ຊϦʔδϣϯʹདྷͯཉ͍͠ʂ Point 04