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
18k
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
[JAWS DAYS 2025] 最近の DB の競合解決の仕組みが分かった気になってみた
maroon1st
0
330
ハワイアン航空 ステータスへの道 #HAairstudy
maroon1st
0
240
[JAWS-UG横浜 #79] re:Invent 2024 の DB アップデートは Multi-Region!
maroon1st
1
230
[JAWS-UG横浜 #80] うわっ…今年のServerless アップデート、少なすぎ…?
maroon1st
1
260
【re:Growth 2024】 Aurora DSQL をちゃんと話します!
maroon1st
1
1.2k
[JAWS-UG横浜 #76] イケてるアップデートを宇宙いち早く紹介するよ!
maroon1st
0
750
【DevelopersIO 2024】AI 半可通なのにエッジ AI 機能を全力で解説してみる 〜Cloudflare の場合〜
maroon1st
0
490
Google Cloud の RDB を徹底比較! 選び方と最新機能紹介 #devio2024
maroon1st
0
1.6k
Google Cloud の AI を支える裏側のインフラを垣間見る!
maroon1st
0
850
Other Decks in Technology
See All in Technology
Flutter向けPDFビューア、pdfrxのpdfium WASM対応について
espresso3389
0
130
SEQUENCE object comparison - db tech showcase 2025 LT2
nori_shinoda
0
120
IPA&AWSダブル全冠が明かす、人生を変えた勉強法のすべて
iwamot
PRO
2
110
Zephyr RTOSを使った開発コンペに参加した件
iotengineer22
1
220
Should Our Project Join the CNCF? (Japanese Recap)
whywaita
PRO
0
340
マーケットプレイス版Oracle WebCenter Content For OCI
oracle4engineer
PRO
3
960
成長し続けるアプリのためのテストと設計の関係、そして意思決定の記録。
sansantech
PRO
0
120
自律的なスケーリング手法FASTにおけるVPoEとしてのアカウンタビリティ / dev-productivity-con-2025
yoshikiiida
1
16k
KiCadでPad on Viaの基板作ってみた
iotengineer22
0
300
AWS認定を取る中で感じたこと
siromi
1
190
ビズリーチにおけるリアーキテクティング実践事例 / JJUG CCC 2025 Spring
visional_engineering_and_design
1
120
Operating Operator
shhnjk
1
580
Featured
See All Featured
Creating an realtime collaboration tool: Agile Flush - .NET Oxford
marcduiker
30
2.1k
How to Create Impact in a Changing Tech Landscape [PerfNow 2023]
tammyeverts
53
2.9k
Git: the NoSQL Database
bkeepers
PRO
430
65k
The Psychology of Web Performance [Beyond Tellerrand 2023]
tammyeverts
48
2.9k
Faster Mobile Websites
deanohume
307
31k
No one is an island. Learnings from fostering a developers community.
thoeni
21
3.4k
The Illustrated Children's Guide to Kubernetes
chrisshort
48
50k
Imperfection Machines: The Place of Print at Facebook
scottboms
267
13k
Become a Pro
speakerdeck
PRO
29
5.4k
Designing Dashboards & Data Visualisations in Web Apps
destraynor
231
53k
The Cult of Friendly URLs
andyhume
79
6.5k
Rebuilding a faster, lazier Slack
samanthasiow
82
9.1k
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