Upgrade to Pro
— share decks privately, control downloads, hide ads and more …
Speaker Deck
Features
Speaker Deck
PRO
Sign in
Sign up for free
Search
Search
Amazon Aurora DSQLパフォーマンスチェック / Amazon Aurora ...
Search
shiro seike
PRO
February 01, 2025
Programming
0
26
Amazon Aurora DSQLパフォーマンスチェック / Amazon Aurora DSQL Performance Check
#jawsugsaga24 2025年もクラウドでGO!新春LT大会
https://jawsug-saga.connpass.com/event/338826/
shiro seike
PRO
February 01, 2025
Tweet
Share
More Decks by shiro seike
See All by shiro seike
なぜ適用するか、移行して理解するClean Architecture 〜構造を超えて設計を継承する〜 / Why Apply, Migrate and Understand Clean Architecture - Inherit Design Beyond Structure
seike460
PRO
3
860
生成AIコーディングとの向き合い方、AIと共創するという考え方 / How to deal with generative AI coding and the concept of co-creating with AI
seike460
PRO
1
440
地方のPHPerもクラウドを使う理由 ~コストの最適化とチームに向き合う~ / Why even local PHPers use the cloud ~optimize costs and face the team
seike460
PRO
0
73
OpenTelemetryで始めるベンダーフリーなobservability / Vendor-free observability starting with OpenTelemetry
seike460
PRO
0
200
AIコーディングの本質は“コード“ではなく“構造“だった / The essence of AI coding is not “code” but "structure
seike460
PRO
2
1.2k
OpenTelemetryを活用したObservability入門 / Introduction to Observability with OpenTelemetry
seike460
PRO
1
780
Amazon Q Developer Proで効率化するAPI開発入門
seike460
PRO
0
410
実行委員長が振り返るBacklogWorldの裏側と運営Backlog術 / The chairperson of the executive committee looks back on the backstage of BacklogWorld and the art of managing Backlog.
seike460
PRO
0
14
(再)ひとり技術広報からの脱却 / Re:Breaking away from one-man technical public relations
seike460
PRO
1
260
Other Decks in Programming
See All in Programming
Build your own WebP codec in Swift
kishikawakatsumi
2
860
AIで開発生産性を上げる個人とチームの取り組み
taniigo
0
130
Repenser les filtres API Platform: une nouvelle syntaxe
vinceamstoutz
2
160
そのpreloadは必要?見過ごされたpreloadが技術的負債として爆発した日
mugitti9
2
2.8k
Local Peer-to-Peer APIはどのように使われていくのか?
hal_spidernight
2
430
なぜあの開発者はDevRelに伴走し続けるのか / Why Does That Developer Keep Running Alongside DevRel?
nrslib
1
320
開発生産性を上げるための生成AI活用術
starfish719
1
110
CSS Linter の現在地 2025年のベストプラクティスを探る
ryo_manba
10
3.2k
気づいて!アプリからのSOS 〜App Store Connect APIで始めるパフォーマンス健康診断〜
waka12
0
250
私達はmodernize packageに夢を見るか feat. go/analysis, go/ast / Go Conference 2025
kaorumuta
2
420
iOSアプリの信頼性を向上させる取り組み/ios-app-improve-reliability
shino8rayu9
0
130
Web技術を最大限活用してRAW画像を現像する / Developing RAW Images on the Web
ssssota
2
1.1k
Featured
See All Featured
How to Think Like a Performance Engineer
csswizardry
27
2k
Fireside Chat
paigeccino
40
3.7k
Git: the NoSQL Database
bkeepers
PRO
431
66k
The Psychology of Web Performance [Beyond Tellerrand 2023]
tammyeverts
49
3.1k
How to Ace a Technical Interview
jacobian
280
23k
Bootstrapping a Software Product
garrettdimon
PRO
307
110k
Measuring & Analyzing Core Web Vitals
bluesmoon
9
610
"I'm Feeling Lucky" - Building Great Search Experiences for Today's Users (#IAC19)
danielanewman
229
22k
Making the Leap to Tech Lead
cromwellryan
135
9.5k
Principles of Awesome APIs and How to Build Them.
keavy
127
17k
Practical Tips for Bootstrapping Information Extraction Pipelines
honnibal
PRO
23
1.5k
Sharpening the Axe: The Primacy of Toolmaking
bcantrill
45
2.5k
Transcript
©Fusic Co., Ltd. 1 Amazon Aurora DSQLΛࢼͯ͠ΈΔ 2025.02.01 @seike460 #jawsugsaga24
2025ΫϥυͰGOʂ৽य़LTେձ
©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 ϓϦϯγύϧΤϯδχΞ/ΤόϯδΣϦετ
©Fusic Co., Ltd. 3 CONTENTS ࣍ 1. Amazon DSQLͱ 2.
Python͔Βܨ͍ͰΈΔ 3. ఏڙϦʔδϣϯͷ՝ 4. ·ͱΊ
©Fusic Co., Ltd. 4 Amazon DSQLͱ 1
©Fusic Co., Ltd. 5 Amazon DSQLͱ Amazon Aurora DSQLʢDistributed SQLʣAuroraͷ৽ػೳͰ͋Γɺ
ҎԼͷಛΛ࣋ͪ·͢ - ࢄSQLΞʔΩςΫνϟ - ΫϥελશମͰΫΤϦΛฒྻॲཧ͠ɺߴ͍εέʔϥϏϦςΟΛ࣮ݱ - άϩʔόϧͳσʔλҰ؏ੑ - ෳͷϦʔδϣϯʹ·͕ͨΔσʔλϕʔεͰ Ұ؏ͨ͠τϥϯβΫγϣϯΛఏڙ - PostgreSQLޓ - PostgreSQLͱͷޓੑΛ࣋ͪͭͭɺ ߴͳੳΫΤϦͱεϧʔϓοτΛఏڙ
©Fusic Co., Ltd. 6 2 Python͔Βܨ͍ͰΈΔ
©Fusic Co., Ltd. 7 Amazon DSQLͷ࡞͔ΜͨΜ Create clusterΛԡԼ
©Fusic Co., Ltd. 8 Amazon DSQLͷ࡞͔ΜͨΜ NameλάΛઃఆͰ͖ΔͷͰ໊લΛઃఆ͢Δ ϚϧνϦʔδϣϯʹ͍ͨ͠߹ Add linked
RegionsʹνΣοΫΛ͢Δ
©Fusic Co., Ltd. 9 Amazon DSQLͷ࡞͔ΜͨΜ ଓใৄࡉ͔ΒConnectΛԡ͢ͱͰ͖ͯ·͢
©Fusic Co., Ltd. 10 Python͔Βͷଓ ιʔείʔυΫϥεϝιου༷ͷͷΛྲྀ༻͖ͤͯ͞·ͨ͠ɻ ࢀߟURLɿhttps://dev.classmethod.jp/articles/connect-aurora-dsql-from-aws-cli-and-python-psycopg-on-aws-cloudshell/
©Fusic Co., Ltd. 11 InsertͱSelectΛ10ճ܁Γฦ͢ʢσϞʣ ͓ੈࣙʹૣ͍ͱݴ͑ͳ͍
©Fusic Co., Ltd. 12 ఏڙϦʔδϣϯͷ՝ 3
©Fusic Co., Ltd. 13 Amazon DSQLͷ՝ όʔδχΞ෦ʢus-east-1ʣͱΦϋΠΦʢus-east-2ʣͰ͔͠ར༻Ͱ͖ͳ͍ ͦͦ·ͩϓϨϏϡʔͳͷͰ͠ΐ͏͕ͳ͍ͷͰ͕͢ɺ ଠฏ༸ΛڬΜͰSQL͕ྲྀΕΔͷඇৗʹݫͦ͠͏
©Fusic Co., Ltd. 14 LambdaΛόʔδχΞ෦ʹཱͯΔʁ౦ژʹཱͯΔʁ ͦΕͰར༻͍ͨ͠߹ɺ AWS LambdaͱDSQLͷڑΛߟྀ͠όʔδχΞ෦ʹཱͯΔ͖ͳͷ͔ ͦΕͱAWS LambdaͷىಈΛ༏ઌͯ͠౦ژʹཱͯΔ͖ͳͷ͔
©Fusic Co., Ltd. 15 ࢼͯ͠ΈΑ͏ ͬ͞ͱAWS LambdaͰࢼͯ͠ΈΑ͏ͱಉ͡ιʔείʔυͰ ࢼͨ͠ͱ͜ΖΤϥʔ͕ൃੜɺIPv6ͷIPʹଓͰ͖ͯͳ͍Έ͍ͨ VPC Lambdaʹઃఆͯ͠IPv6ʹઃఆ͠ͳ͚ΕͳΒͳ͍
©Fusic Co., Ltd. 16 VPC LambdaΛ࡞ͯ͠IPv6ରԠͯ͠ࢼͯ͠ΈΔ VPC Lambda ʹରԠͯ͠IPv̒༗ޮԽͯ͠Έͯ͏·͍͔͘ͳ͍ connection
is bad: no error details available ʢଓෆྑɿΤϥʔͷৄࡉෆ໌ʣ ͦͷޙɺॾʑࢼ͍ͯͨ͠ͱ͜ΖɺIPv4ͷϩάग़ݱ࢝͠ΊΔ…
©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/
©Fusic Co., Ltd. 18 InsertͱSelectΛ10ճ܁Γฦ͢ʢσϞʣ 1/40 ʙ 1/100·ͰߴԽͨ͠ͷͰɺྲྀੴʹڑͷࠩେ͖͍
©Fusic Co., Ltd. 19 ·ͱΊ 4
©Fusic Co., Ltd. 20 ·ͱΊ Amazon Aurora DSQLࢄSQLΞʔΩςΫνϟɺαʔόϨεͱͯ͠৺ͪʹͯͨ͠αʔϏε Point 01
ͪΖΜػೳ੍ݶͳͲ͋Δ͚Ͳɺ͑ͳ͍Θ͚Ͱͳ͍ Point 02 IPv6ରԠ͠ͳ͍ͱ͍͚ͳ͍ʁ -> ͭ·ΓVPC LambdaͰͳ͍ͱ͍͚ͳ͍ʁʢະ֬ఆʣ Point 03 ΓόʔδχΞ෦ͷํ͕രͰૣ͍ɺϓϨϏϡʔ֎Εͯૣ͘ຊϦʔδϣϯʹདྷͯཉ͍͠ʂ Point 04
©Fusic Co., Ltd. 21 Thank You We are Hiring! https://recruit.fusic.co.jp/
͝ਗ਼ௌ͍͖ͨͩ͋Γ͕ͱ͏͍͟͝·ͨ͠