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
28
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
870
生成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
790
Amazon Q Developer Proで効率化するAPI開発入門
seike460
PRO
0
420
実行委員長が振り返る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
アメ車でサンノゼを走ってきたよ!
s_shimotori
0
140
Advance Your Career with Open Source
ivargrimstad
0
360
なぜあの開発者はDevRelに伴走し続けるのか / Why Does That Developer Keep Running Alongside DevRel?
nrslib
3
370
CSC509 Lecture 04
javiergs
PRO
0
300
GraphQL×Railsアプリのデータベース負荷分散 - 月間3,000万人利用サービスを無停止で
koxya
1
1.2k
CSC509 Lecture 01
javiergs
PRO
1
430
CSC509 Lecture 06
javiergs
PRO
0
240
開発者への寄付をアプリ内課金として実装する時の気の使いどころ
ski
0
350
GitHub Actions × AWS OIDC連携の仕組みと経緯を理解する
ota1022
0
240
育てるアーキテクチャ:戦い抜くPythonマイクロサービスの設計と進化戦略
fujidomoe
1
150
Local Peer-to-Peer APIはどのように使われていくのか?
hal_spidernight
2
450
monorepo の Go テストをはやくした〜い!~最小の依存解決への道のり~ / faster-testing-of-monorepos
convto
2
410
Featured
See All Featured
Designing for humans not robots
tammielis
254
25k
Design and Strategy: How to Deal with People Who Don’t "Get" Design
morganepeng
132
19k
Building an army of robots
kneath
306
46k
Build The Right Thing And Hit Your Dates
maggiecrowley
37
2.9k
Rebuilding a faster, lazier Slack
samanthasiow
84
9.2k
Writing Fast Ruby
sferik
629
62k
Navigating Team Friction
lara
189
15k
[RailsConf 2023] Rails as a piece of cake
palkan
57
5.9k
What’s in a name? Adding method to the madness
productmarketing
PRO
23
3.7k
Connecting the Dots Between Site Speed, User Experience & Your Business [WebExpo 2025]
tammyeverts
9
580
KATA
mclloyd
32
15k
Learning to Love Humans: Emotional Interface Design
aarron
274
40k
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/
͝ਗ਼ௌ͍͖ͨͩ͋Γ͕ͱ͏͍͟͝·ͨ͠