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
Google Cloud の AI を支える裏側のインフラを垣間見る!
maroon1st
0
210
JAWS-UG横浜 #63 AWS re:Invent 2023 宇宙一早い Recap イケてるアップデートを宇宙いち早く紹介するよ!
maroon1st
0
3
Google Cloud Next '23 Recap AI 時代のデータベース関連のイケてるアップデートをお届け
maroon1st
0
730
Zaraz 試してみた #CloudflareUG #CloudflareUG_www
maroon1st
0
750
Cloudflare Application Service のサイト登録の種類を確認してみた #CloudflareUG #CloudflareUG_hnd
maroon1st
0
870
Cloudflare 概論 Cloudflare Meetup Kick Off! #CloudflareUG
maroon1st
1
1.4k
Cloudflare の画像最適化機能を紹介してみる
maroon1st
0
1.8k
データベースの発表には RDBMS 以外もありますよ
maroon1st
0
500
Aurora Serverless v2 のスケールの傾向を実際に確認してみた
maroon1st
0
160
Other Decks in Technology
See All in Technology
Microsoft Cloudで開発ライフサイクルを保護する
kkamegawa
0
150
株式会社EventHub・エンジニア採用資料
eventhub
0
1.9k
自動生成を活用した、運用保守コストを抑える Error/Alert/Runbook の一元集約管理 / Centralized management of Error/Alert/Runbook to minimize operational costs using automated code generation
biwashi
10
2.1k
転移学習とドメイン適応の基礎
kmatsui
2
570
オブザーバビリティの Primary Signals
onk
PRO
0
550
Tableau事例紹介 / Tableau Case Study of Eureka
kazuya_araki_tokyo
1
170
開発生産性向上サービスを作るFindyが自分たちで開発生産性を爆上げした組織づくりの歩み / Findy's path to boosting its own development productivity 2024-04-17
ma3tk
3
340
LLM とプロンプトエンジニアリング/チューターをビルドする / LLM and Prompt Engineering and Building Tutors
ks91
PRO
0
220
AWS を使う上で知っておきたいオンプレミス知識/aws-on-premise-essentials
emiki
1
4.2k
[PlatformCon 24] Platform Orchestrators: The Missing Middle of Internal Developer Platforms?
danielbryantuk
1
180
プロデザ! BY リクルート vol.18_リクルートのリサーチ実践組織「リサーチブーストコミュニティ」
recruitengineers
PRO
3
240
Tebiki株式会社 エンジニア採用資料
tebiki
0
4.1k
Featured
See All Featured
The World Runs on Bad Software
bkeepers
PRO
61
6.7k
Designing for humans not robots
tammielis
247
25k
4 Signs Your Business is Dying
shpigford
175
21k
ReactJS: Keep Simple. Everything can be a component!
pedronauck
658
120k
Happy Clients
brianwarren
91
6.4k
I Don’t Have Time: Getting Over the Fear to Launch Your Podcast
jcasabona
20
1.6k
Building Better People: How to give real-time feedback that sticks.
wjessup
354
18k
Atom: Resistance is Futile
akmur
258
25k
Large-scale JavaScript Application Architecture
addyosmani
503
110k
Building Effective Engineering Teams - LeadDev
addyosmani
27
1.8k
Building Adaptive Systems
keathley
30
1.8k
Visualization
eitanlees
135
14k
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