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
270
【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.7k
Google Cloud の AI を支える裏側のインフラを垣間見る!
maroon1st
0
850
Other Decks in Technology
See All in Technology
Glacierだからってコストあきらめてない? / JAWS Meet Glacier Cost
taishin
1
160
生まれ変わった AWS Security Hub (Preview) を紹介 #reInforce_osaka / reInforce New Security Hub
masahirokawahara
0
470
AWS Organizations 新機能!マルチパーティ承認の紹介
yhana
1
280
NewSQLや分散データベースを支えるRaftの仕組み - 仕組みを理解して知る得意不得意
hacomono
PRO
2
170
LLM時代の検索
shibuiwilliam
2
170
CRE Camp #1 エンジニアリングを民主化するCREチームでありたい話
mntsq
1
130
マネジメントって難しい、けどおもしろい / Management is tough, but fun! #em_findy
ar_tama
7
1.1k
How Do I Contact HP Printer Support? [Full 2025 Guide for U.S. Businesses]
harrry1211
0
120
OSSのSNSツール「Misskey」をさわってみよう(右下ワイプで私のOSCの20年を振り返ります) / 20250705-osc2025-do
akkiesoft
0
170
第4回Snowflake 金融ユーザー会 Snowflake summit recap
tamaoki
1
290
データグループにおけるフロントエンド開発
lycorptech_jp
PRO
1
110
FOSS4G 2025 KANSAI QGISで点群データをいろいろしてみた
kou_kita
0
400
Featured
See All Featured
Visualizing Your Data: Incorporating Mongo into Loggly Infrastructure
mongodb
46
9.6k
Building Flexible Design Systems
yeseniaperezcruz
328
39k
Designing for humans not robots
tammielis
253
25k
Git: the NoSQL Database
bkeepers
PRO
430
65k
BBQ
matthewcrist
89
9.7k
CSS Pre-Processors: Stylus, Less & Sass
bermonpainter
357
30k
ピンチをチャンスに:未来をつくるプロダクトロードマップ #pmconf2020
aki_iinuma
126
53k
StorybookのUI Testing Handbookを読んだ
zakiyama
30
5.9k
Unsuck your backbone
ammeep
671
58k
Embracing the Ebb and Flow
colly
86
4.7k
Code Review Best Practice
trishagee
69
18k
The Cost Of JavaScript in 2023
addyosmani
51
8.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