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
17
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
810
生成AIコーディングとの向き合い方、AIと共創するという考え方 / How to deal with generative AI coding and the concept of co-creating with AI
seike460
PRO
1
400
地方のPHPerもクラウドを使う理由 ~コストの最適化とチームに向き合う~ / Why even local PHPers use the cloud ~optimize costs and face the team
seike460
PRO
0
67
OpenTelemetryで始めるベンダーフリーなobservability / Vendor-free observability starting with OpenTelemetry
seike460
PRO
0
180
AIコーディングの本質は“コード“ではなく“構造“だった / The essence of AI coding is not “code” but "structure
seike460
PRO
2
1.1k
OpenTelemetryを活用したObservability入門 / Introduction to Observability with OpenTelemetry
seike460
PRO
1
680
Amazon Q Developer Proで効率化するAPI開発入門
seike460
PRO
0
350
実行委員長が振り返るBacklogWorldの裏側と運営Backlog術 / The chairperson of the executive committee looks back on the backstage of BacklogWorld and the art of managing Backlog.
seike460
PRO
0
4
(再)ひとり技術広報からの脱却 / Re:Breaking away from one-man technical public relations
seike460
PRO
1
230
Other Decks in Programming
See All in Programming
ソフトウェア設計とAI技術の活用
masuda220
PRO
25
7.1k
AI Ramen Fight
yusukebe
0
120
「次に何を学べばいいか分からない」あなたへ──若手エンジニアのための学習地図
panda_program
3
690
プロダクトという一杯を作る - プロダクトチームが味の責任を持つまでの煮込み奮闘記
hiliteeternal
0
320
Google I/O Extended Incheon 2025 ~ What's new in Android development tools
pluu
1
220
Git Sync を超える!OSS で実現する CDK Pull 型デプロイ / Deploying CDK with PipeCD in Pull-style
tkikuc
4
490
コーディングエージェント概観(2025/07)
itsuki_t88
1
470
QA x AIエコシステム段階構築作戦
osu
0
220
What's new in Adaptive Android development
fornewid
0
130
Prompt Engineeringの再定義「Context Engineering」とは
htsuruo
0
110
MCP連携で加速するAI駆動開発/mcp integration accelerates ai-driven-development
bpstudy
0
220
AIに安心して任せるためにTypeScriptで一意な型を作ろう
arfes0e2b3c
0
310
Featured
See All Featured
Improving Core Web Vitals using Speculation Rules API
sergeychernyshev
18
1k
Into the Great Unknown - MozCon
thekraken
40
1.9k
CoffeeScript is Beautiful & I Never Want to Write Plain JavaScript Again
sstephenson
161
15k
Visualization
eitanlees
146
16k
[Rails World 2023 - Day 1 Closing Keynote] - The Magic of Rails
eileencodes
35
2.5k
Building a Modern Day E-commerce SEO Strategy
aleyda
42
7.4k
4 Signs Your Business is Dying
shpigford
184
22k
VelocityConf: Rendering Performance Case Studies
addyosmani
332
24k
The MySQL Ecosystem @ GitHub 2015
samlambert
251
13k
Easily Structure & Communicate Ideas using Wireframe
afnizarnur
194
16k
個人開発の失敗を避けるイケてる考え方 / tips for indie hackers
panda_program
110
19k
Keith and Marios Guide to Fast Websites
keithpitt
411
22k
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/
͝ਗ਼ௌ͍͖ͨͩ͋Γ͕ͱ͏͍͟͝·ͨ͠