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
Auroraの凄さを振り返る
Search
maroon1st
August 22, 2018
Technology
14
19k
Auroraの凄さを振り返る
JAWS-UG 初心者支部#13 「AWS Night school」での発表資料です。
https://jawsug-bgnr.connpass.com/event/94301/
maroon1st
August 22, 2018
Tweet
Share
More Decks by maroon1st
See All by maroon1st
業務自動化プラットフォーム Google Agentspace に入門してみる #devio2025
maroon1st
0
190
[JAWS DAYS 2025] 最近の DB の競合解決の仕組みが分かった気になってみた
maroon1st
0
390
ハワイアン航空 ステータスへの道 #HAairstudy
maroon1st
0
360
[JAWS-UG横浜 #79] re:Invent 2024 の DB アップデートは Multi-Region!
maroon1st
1
330
[JAWS-UG横浜 #80] うわっ…今年のServerless アップデート、少なすぎ…?
maroon1st
1
350
【re:Growth 2024】 Aurora DSQL をちゃんと話します!
maroon1st
1
1.3k
[JAWS-UG横浜 #76] イケてるアップデートを宇宙いち早く紹介するよ!
maroon1st
0
810
【DevelopersIO 2024】AI 半可通なのにエッジ AI 機能を全力で解説してみる 〜Cloudflare の場合〜
maroon1st
0
540
Google Cloud の RDB を徹底比較! 選び方と最新機能紹介 #devio2024
maroon1st
0
1.8k
Other Decks in Technology
See All in Technology
FastAPIの魔法をgRPC/Connect RPCへ
monotaro
PRO
1
730
SoccerNet GSRの紹介と技術応用:選手視点映像を提供するサッカー作戦盤ツール
mixi_engineers
PRO
1
170
バイブコーディングと継続的デプロイメント
nwiizo
2
410
ACA でMAGI システムを社内で展開しようとした話
mappie_kochi
1
250
Azure SynapseからAzure Databricksへ 移行してわかった新時代のコスト問題!?
databricksjapan
0
140
SOC2取得の全体像
shonansurvivors
1
370
自作LLM Native GORM Pluginで実現する AI Agentバックテスト基盤構築
po3rin
2
250
pprof vs runtime/trace (FlightRecorder)
task4233
0
160
定期的な価値提供だけじゃない、スクラムが導くチームの共創化 / 20251004 Naoki Takahashi
shift_evolve
PRO
3
300
研究開発部メンバーの働き⽅ / Sansan R&D Profile
sansan33
PRO
3
20k
From Prompt to Product @ How to Web 2025, Bucharest, Romania
janwerner
0
120
DataOpsNight#8_Terragruntを用いたスケーラブルなSnowflakeインフラ管理
roki18d
1
340
Featured
See All Featured
RailsConf 2023
tenderlove
30
1.2k
GraphQLの誤解/rethinking-graphql
sonatard
73
11k
Build The Right Thing And Hit Your Dates
maggiecrowley
37
2.9k
Agile that works and the tools we love
rasmusluckow
331
21k
Done Done
chrislema
185
16k
Visualization
eitanlees
148
16k
Statistics for Hackers
jakevdp
799
220k
Helping Users Find Their Own Way: Creating Modern Search Experiences
danielanewman
30
2.9k
Save Time (by Creating Custom Rails Generators)
garrettdimon
PRO
32
1.6k
For a Future-Friendly Web
brad_frost
180
9.9k
Mobile First: as difficult as doing things right
swwweet
224
10k
[Rails World 2023 - Day 1 Closing Keynote] - The Magic of Rails
eileencodes
36
2.5k
Transcript
0 3 - I J G 3
1 D C AA H # # CC D A8 / 3 C CC D A C D , . 2 B 1
& .-* (2 ,0'/4"# 51 83;7 +)
!&%$9( 6: Attention
3 Who am I ? 0 a5 5z s @
aW :@ M 5 e r a A u S I @ t nmo : 5 1
4 170 PV d o Developers.IO https://dev.classmethod.jp/ ( 3A 22
dA Pd 1 O w v i , 0A ov tA A 1 A d X e P f ) ( c X A V cTW 1 0 1 0 i n W ed , 0 8 8 A ( OA, 0 rc I UIWIS O O 76 : 2 0 : 0 r OWA: 0 c 0 :9 A 56 78 ) Pd rO O
5 170 PV Developers.IO 4
6 Agenda • - • • A •
7 • •
• •
8 Aurora
Wrench, spanner PNG image http://pngimg.com/download/3124
European Southern ObservatoryESO / Creative Commons Attribution 4.0 International https://upload.wikimedia.org/wikipedia/commons/thumb/3/38/Artist%27s_rendering_ULAS_J1120%2B0641.jpg/1280px-Artist%27s_rendering_ULAS_J1120%2B0641.jpg
Creative Commons Attribution-Share Alike 3.0 Unported https://upload.wikimedia.org/wikipedia/commons/thumb/b/b0/Aurora_Borealis_NO.JPG/1280px-Aurora_Borealis_NO.JPG
12 Aurora
13 Amazon Aurora 0 0 IL S MBR 4 1
0 D A 2 :4 Q P
14 Aurora • L • M • • SQ •
P • Creative Commons Attribution-Share Alike 3.0 Unported https://commons.wikimedia.org/wiki/File:Aurora_Borealis_22Jan2004.jpg
15 Aurora QM .
, QM 3 3 L 9 L 3 9L L L Z A% Z PS 5 3
16 Aurora B D
17 Aurora $ # " " !
"
18 Aurora
19 Aurora
20 Well-ArchitectedAurora
21 Well-Architected Framework - 5F W -
A
22 Well-ArchitectedAurora" - 5
!
23
24 6 • A 23 -232 L D Z Da
B Z • ( S • D B ) 1 6 6 6 1 A
25
26
27 6 3 / V3 )+ ) ) 3 V3
/ / )+ ) ) / 2 > V )+ ) 3 2 2 2
28 6 2 6 2 2 3
29 6
30 6
31 4 3 A 3 / 3
32 ( )
33 ( )
34 ( )
35 Log-Structured Storage S L L
S -
36 Log Structured StorageWrite
37 Log Structured StorageWrite
38 Log Structured StorageWrite
39 Log Structured StorageWrite
40 Log Structured StorageCommit
41 Log Structured StorageRead
42 Log Structured StorageRead
43 Log Structured StorageRead
44 Log Structured StorageRead
45 Log Structured StorageTransaction Recovery
46 Log Structured StorageTransaction Recovery
47 Log Structured StorageTransaction Recovery
48 Log Structured StorageTransaction Recovery
49 Log Structured StorageRecovery
50 Log Structured StorageRecovery
51 Log Structured StorageRecovery
52 Log Structured StorageRecovery
53 Log Structured StorageRecovery
54 Log Structured StorageRecovery
55 Log Structured StorageRecovery
56 Log Structured StorageRecovery
57
58 PQ S e 5 5 3 • O A
H J • / A f • / / A f • A i f • I K a Bch •
59 "# ! https://image.slidesharecdn.com/20171222awsblackbelt2017aurorapostgresql-171220102238/95/aws-
black-belt-online-seminar-2017-amazon-aurora-with-postgresql-compatibility-36-638.jpg http://media.amazonwebservices.com/jp/summit2016/2D-02.pdf
60 . I/O . / 3 3 3 5 .
. /
61 AKP PJoinJ .
) K 6 - - -- e 5 ( ( AB 6 S 6 J c Q AL 5 ( 5 ( K Rd g M P f P a
62 Hash Join Batch Scan
• ) H( ( d MA Na d A K e A • J d MA ) BHc MA LQ S MA
63 Parallel Query •
" &# • ' $ • %! https://www.slideshare.net/AmazonWebServices/deep-dive-on-the-amazon-aurora-mysqlcompatible-edition-dat301-reinvent-2017
64 Slave % # "& $!'
65 Slave % # "& $!'
66
67 M • R S
• - S • • 6A •
68 Multi-AZ"%!Read Replica$ &#
"%!
69 Multi-AZ Read Replica
70 Multi-AZ Read Replica
71 Read ReplicaAuto Scaling
72 Aurora Serverless 2 10 • 5 • 2 5
• https://www.slideshare.net/AmazonWebServices/deep-dive-on-the-amazon-aurora-mysqlcompatible-edition-dat301-reinvent-2017
73
74 •
• •
75
76 L • •
I • • • • Z • A D • • PMZ •
77 Zero Downtime Patch ( ) https://d1.awsstatic.com/events/jp/2017/summit/slide/D3T1-6.pdf
78 ! D
M B
79 backtrack • 1
• BD ) ( • Log-Structured Storage
80 Database clone /
81 Performance Insights
82 IAM / • / )/ • A
( • )W • 0 WS 2 2
83 A 1 5 %
% 5 6 https://image.slidesharecdn.com/dat303-161214152920/95/aws-reinvent-2016-deep-dive-on-amazon-aurora-dat303-51-638.jpg
84 DDL 1
85 Lambda S • W • W
L • A S Amazon ES Lambda S
86
87 • • a u D A D D A
• r A o A R S
88