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

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

Transcript

1. ©Fusic Co., Ltd. 1 Amazon Aurora DSQLΛࢼͯ͠ΈΔ 2025.02.01 @seike460 #jawsugsaga24 2025೥΋Ϋϥ΢υͰGOʂ৽य़LTେձ
2. ©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 ϓϦϯγύϧΤϯδχΞ/ΤόϯδΣϦετ
3. ©Fusic Co., Ltd. 3 CONTENTS ໨࣍ 1. Amazon DSQLͱ͸ 2. Python͔Βܨ͍ͰΈΔ 3. ఏڙϦʔδϣϯͷ՝୊ 4. ·ͱΊ
4. ©Fusic Co., Ltd. 4 Amazon DSQLͱ͸ 1
5. ©Fusic Co., Ltd. 5 Amazon DSQLͱ͸ Amazon Aurora DSQLʢDistributed SQLʣ͸Auroraͷ৽ػೳͰ͋Γɺ ҎԼͷಛ௃Λ࣋ͪ·͢ - ෼ࢄSQLΞʔΩςΫνϟ - ΫϥελશମͰΫΤϦΛฒྻॲཧ͠ɺߴ͍εέʔϥϏϦςΟΛ࣮ݱ - άϩʔόϧͳσʔλҰ؏ੑ - ෳ਺ͷϦʔδϣϯʹ·͕ͨΔσʔλϕʔεͰ΋ Ұ؏ͨ͠τϥϯβΫγϣϯΛఏڙ - PostgreSQLޓ׵ - PostgreSQLͱͷޓ׵ੑΛ࣋ͪͭͭɺ ߴ଎ͳ෼ੳΫΤϦͱεϧʔϓοτΛఏڙ
6. ©Fusic Co., Ltd. 6 2 Python͔Βܨ͍ͰΈΔ
7. ©Fusic Co., Ltd. 7 Amazon DSQLͷ࡞੒΋͔ΜͨΜ Create clusterΛԡԼ
8. ©Fusic Co., Ltd. 8 Amazon DSQLͷ࡞੒΋͔ΜͨΜ NameλάΛઃఆͰ͖ΔͷͰ໊લΛઃఆ͢Δ ϚϧνϦʔδϣϯʹ͍ͨ͠৔߹͸ Add linked RegionsʹνΣοΫΛ͢Δ
9. ©Fusic Co., Ltd. 9 Amazon DSQLͷ࡞੒΋͔ΜͨΜ ઀ଓ৘ใ͸ৄࡉ͔ΒConnectΛԡ͢ͱͰ͖ͯ·͢
10. ©Fusic Co., Ltd. 10 Python͔Βͷ઀ଓ ιʔείʔυ͸Ϋϥεϝιου༷ͷ΋ͷΛྲྀ༻ͤͯ͞௖͖·ͨ͠ɻ ࢀߟURLɿhttps://dev.classmethod.jp/articles/connect-aurora-dsql-from-aws-cli-and-python-psycopg-on-aws-cloudshell/
11. ©Fusic Co., Ltd. 11 InsertͱSelectΛ10ճ܁Γฦ͢ʢσϞʣ ͓ੈࣙʹ΋ૣ͍ͱ͸ݴ͑ͳ͍
12. ©Fusic Co., Ltd. 12 ఏڙϦʔδϣϯͷ՝୊ 3
13. ©Fusic Co., Ltd. 13 Amazon DSQLͷ՝୊ όʔδχΞ๺෦ʢus-east-1ʣͱΦϋΠΦʢus-east-2ʣͰ͔͠ར༻Ͱ͖ͳ͍ ͦ΋ͦ΋·ͩϓϨϏϡʔͳͷͰ͠ΐ͏͕ͳ͍ͷͰ͕͢ɺ ଠฏ༸ΛڬΜͰSQL͕ྲྀΕΔͷ͸ඇৗʹݫͦ͠͏
14. ©Fusic Co., Ltd. 14 LambdaΛόʔδχΞ๺෦ʹཱͯΔʁ౦ژʹཱͯΔʁ ͦΕͰ΋ར༻͍ͨ͠৔߹ɺ AWS LambdaͱDSQLͷڑ཭Λߟྀ͠όʔδχΞ๺෦ʹཱͯΔ΂͖ͳͷ͔ ͦΕͱ΋AWS LambdaͷىಈΛ༏ઌͯ͠౦ژʹཱͯΔ΂͖ͳͷ͔
15. ©Fusic Co., Ltd. 15 ࢼͯ͠ΈΑ͏ ͬ͞ͱAWS LambdaͰࢼͯ͠ΈΑ͏ͱಉ͡ιʔείʔυͰ ࢼͨ͠ͱ͜ΖΤϥʔ͕ൃੜɺIPv6ͷIPʹ઀ଓͰ͖ͯͳ͍Έ͍ͨ VPC Lambdaʹઃఆͯ͠IPv6ʹઃఆ͠ͳ͚Ε͹ͳΒͳ͍
16. ©Fusic Co., Ltd. 16 VPC LambdaΛ࡞੒ͯ͠IPv6ରԠͯ͠ࢼͯ͠ΈΔ VPC Lambda ʹରԠͯ͠IPv̒༗ޮԽͯ͠Έͯ΋͏·͍͔͘ͳ͍ connection is bad: no error details available ʢ઀ଓෆྑɿΤϥʔͷৄࡉ͸ෆ໌ʣ ͦͷޙɺॾʑࢼ͍ͯͨ͠ͱ͜ΖɺIPv4ͷϩά΋ग़ݱ࢝͠ΊΔ…
17. ©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/
18. ©Fusic Co., Ltd. 18 InsertͱSelectΛ10ճ܁Γฦ͢ʢσϞʣ 1/40 ʙ 1/100·Ͱߴ଎Խͨ͠ͷͰɺྲྀੴʹڑ཭ͷࠩ͸େ͖͍
19. ©Fusic Co., Ltd. 19 ·ͱΊ 4
20. ©Fusic Co., Ltd. 20 ·ͱΊ Amazon Aurora DSQL͸෼ࢄSQLΞʔΩςΫνϟɺαʔόϨε੎ͱͯ͠͸৺଴ͪʹͯͨ͠αʔϏε Point 01 ΋ͪΖΜػೳ੍ݶͳͲ͸͋Δ͚Ͳɺ࢖͑ͳ͍Θ͚Ͱ͸ͳ͍ Point 02 IPv6ରԠ͠ͳ͍ͱ͍͚ͳ͍ʁ -> ͭ·ΓVPC LambdaͰ͸ͳ͍ͱ͍͚ͳ͍ʁʢະ֬ఆʣ Point 03 ΍͸ΓόʔδχΞ๺෦ͷํ͕ര଎Ͱૣ͍ɺϓϨϏϡʔ֎Εͯૣ͘೔ຊϦʔδϣϯʹདྷͯཉ͍͠ʂ Point 04
21. ©Fusic Co., Ltd. 21 Thank You We are Hiring! https://recruit.fusic.co.jp/ ͝ਗ਼ௌ͍͖ͨͩ͋Γ͕ͱ͏͍͟͝·ͨ͠