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
17k
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-UG横浜 #63 AWS re:Invent 2023 宇宙一早い Recap イケてるアップデートを宇宙いち早く紹介するよ!
maroon1st
0
1
Google Cloud Next '23 Recap AI 時代のデータベース関連のイケてるアップデートをお届け
maroon1st
0
700
Zaraz 試してみた #CloudflareUG #CloudflareUG_www
maroon1st
0
700
Cloudflare Application Service のサイト登録の種類を確認してみた #CloudflareUG #CloudflareUG_hnd
maroon1st
0
820
Cloudflare 概論 Cloudflare Meetup Kick Off! #CloudflareUG
maroon1st
1
1.4k
Cloudflare の画像最適化機能を紹介してみる
maroon1st
0
1.8k
データベースの発表には RDBMS 以外もありますよ
maroon1st
0
490
Aurora Serverless v2 のスケールの傾向を実際に確認してみた
maroon1st
0
140
ひさしぶりの英語セッションでも『読める、読めるぞ!』 〜 別の角度の re:Invent 事前準備 〜
maroon1st
0
840
Other Decks in Technology
See All in Technology
「XX試験の環境作ってよ」と言われた時によく使うAWSのソリューションについて
bun913
0
120
オブジェクトのおしゃべり大失敗 メッセージングアンチパターン集 / messaging anti-pattern collection
ytake
0
330
コードレビューを支援するAI技術の応用
akkie76
2
140
BDD(Cucumber)コミュニティが無料提供しているコンテンツの紹介と現在起きている危機
nihonbuson
4
740
サービス成長と共に肥大化するモノレポ、長くなるCI時間 / As services grow, monorepos get bigger and CI time gets longer
kohbis
5
2.1k
Introduction to Jetpack Compose
pohjus
1
110
生成AI・LLM時代における 機械学習エンジニアとしてのキャリア戦略・開発戦略 / my-career-and-development-strategies-for-ml-engineer-2024
yuya4
4
800
AMLD 2024 - Build Your Own GPT
donlelef
1
260
エンジニア候補者向け資料2024.03.28.pdf
macloud
0
2.9k
VSCode上からSlackにメッセージを送る拡張機能を作っている話
ebarakazuhiro
0
120
これまでのキャリアとこれからMLエンジニアとしてどう動くか
masatakashiwagi
0
520
統計的学習理論読み Chapter 1
kmatsui
3
910
Featured
See All Featured
What's in a price? How to price your products and services
michaelherold
236
11k
Navigating Team Friction
lara
177
13k
The Illustrated Children's Guide to Kubernetes
chrisshort
28
46k
Making the Leap to Tech Lead
cromwellryan
123
8.4k
Clear Off the Table
cherdarchuk
82
310k
Responsive Adventures: Dirty Tricks From The Dark Corners of Front-End
smashingmag
242
20k
Creating an realtime collaboration tool: Agile Flush - .NET Oxford
marcduiker
11
1.4k
Documentation Writing (for coders)
carmenintech
59
3.8k
Statistics for Hackers
jakevdp
789
220k
Fireside Chat
paigeccino
19
2.6k
How to Create Impact in a Changing Tech Landscape [PerfNow 2023]
tammyeverts
12
1.4k
Rebuilding a faster, lazier Slack
samanthasiow
72
8.2k
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