Slide 1

Slide 1 text

© 2019, Amazon Web Services, Inc. or its Affiliates. All rights reserved. © 2019, Amazon Web Services, Inc. or its Affiliates. All rights reserved. Amazon Confidential and Trademark / ) ( / /A / / . / /

Slide 2

Slide 2 text

© 2019, Amazon Web Services, Inc. or its Affiliates. All rights reserved. • .9Q2019-5115,5B#'%6KIO X8 >7E CAWS=U!"(# &(http://aws.amazon.com) PF • 9QJAV2Y@ 9Q6IOAWS=U!"(# &GaIO; Z40AWS=U!"(# &IORD • IOM^

Slide 3

Slide 3 text

© 2019, Amazon Web Services, Inc. or its Affiliates. All rights reserved. ( ) ( ( ) (

Slide 4

Slide 4 text

© 2019, Amazon Web Services, Inc. or its Affiliates. All rights reserved. -B - - - - - - - - - - - - - A - & - A & A - - - -

Slide 5

Slide 5 text

© 2019, Amazon Web Services, Inc. or its Affiliates. All rights reserved. , , A L PS P M M L A , P Q

Slide 6

Slide 6 text

© 2019, Amazon Web Services, Inc. or its Affiliates. All rights reserved. "2(: 8KH 8FUB ;EB/9, ,&&0 8,8 ($1"NC$";EB 08 6:JT.!+"RP

Slide 7

Slide 7 text

© 2019, Amazon Web Services, Inc. or its Affiliates. All rights reserved. ) , I / / / / A a ) 3/ ) / )/ / ) I ) Idc C W L bg 3 3 3 3 ) / / ( / / ( 3/ Idc e S L MI 3

Slide 8

Slide 8 text

© 2019, Amazon Web Services, Inc. or its Affiliates. All rights reserved. , , , 0 1 5, .0 , , , , 1, 0 2, ( ) 302. 1 0 .2 , 0 0 0,.2

Slide 9

Slide 9 text

© 2019, Amazon Web Services, Inc. or its Affiliates. All rights reserved. 1 5 6 4 ) 45 4 4 A 45 ) ) ) ( ) 2 4 6 3 0 A 2 . 4 6 4 45 4 4 - 1 , ) 6 4 - 1 ,

Slide 10

Slide 10 text

© 2019, Amazon Web Services, Inc. or its Affiliates. All rights reserved. • NR O e H nIT R a M p • ( t I Q HT R a MNU • e dIn H LK • ) T R a H • T R a nH F S dC • ) e d HT R a MNU • CA MyoH EKrl K ) ) ) ( 1 1

Slide 11

Slide 11 text

© 2019, Amazon Web Services, Inc. or its Affiliates. All rights reserved. Q L D Q Q M Q I Q S

Slide 12

Slide 12 text

© 2019, Amazon Web Services, Inc. or its Affiliates. All rights reserved. Aurora • SSD:3&* )#* – 10GB64TB &*/4 )!% – 2;@ 0 E. – Peer-to-peer gossip*%('+ • GA 1B3729 – 3AZ6" $=8 – 2":35> H?B> • 6-1AZ:35> 3, H?B>CD IF – 3":35> H<B> SQL Transactions AZ 1 AZ 2 AZ 3 Caching Amazon S3

Slide 13

Slide 13 text

© 2019, Amazon Web Services, Inc. or its Affiliates. All rights reserved. A A5 , 0 A 9 8 2S 61 QEND A E I OL L ELL L ELL L I MNE F N LA 5LE LS IMN I A A E IMN I A ( 5E 3 / 3 . , 0 A 9 8 9 A 3 8 7 A NL IM NE IM , 0 AL E E I NRIM AR O AM ELL LEIC MN I S PAL CA , 0 AL NL IM NE I 5LE LS IMN I A A E IMN I A 3, ) 6 4 2 -EMNLE ONA QLENAM A E IMN I A 5E 3 A A5 ,0 A 9 8 9 A 3 8 7 A NL IM NE IM U 4 /02 , 0 AL NL IM NE I ) EBE NE I U 4 . 33 EI C - N - O A QLENA 1 C /L BE AM

Slide 14

Slide 14 text

© 2019, Amazon Web Services, Inc. or its Affiliates. All rights reserved. • C T A3 L S • C T A • 3 Q 1 2 1 2

Slide 15

Slide 15 text

© 2019, Amazon Web Services, Inc. or its Affiliates. All rights reserved. • + / + + ( ) + ( + ) 2.1 >+ ) + >+ 7 ؝ؾ٦ך侧 7X 剅ֹ鴥׫ؙؓ٦ٓي 7S 铣׫鴥׫ؙؓ٦ٓي

Slide 16

Slide 16 text

© 2019, Amazon Web Services, Inc. or its Affiliates. All rights reserved. 7 ؝ؾ٦ך侧 7X 剅ֹ鴥׫ؙؓ٦ٓي 7S 铣׫鴥׫ؙؓ٦ٓي "NB[PO"VSPSBחֶֽ׷ؙؓ٦ٓيٌرٕ • + / + + ( ) + ( + ) 2.1 >+ ) + >+

Slide 17

Slide 17 text

© 2019, Amazon Web Services, Inc. or its Affiliates. All rights reserved. A A § § ( § ( A1 6 6 § 3 ( 3 34 1 4 / 32 4 4 4 6 34 1 4 4 4 4 6 +) +)

Slide 18

Slide 18 text

© 2019, Amazon Web Services, Inc. or its Affiliates. All rights reserved. 3 1 1 : 22 § Z 1 h a h h F § e § A eh 1 n t H G 1 e a uo H1 e Z + G yt HF 2 r l e a Z AG

Slide 19

Slide 19 text

© 2019, Amazon Web Services, Inc. or its Affiliates. All rights reserved. • 6 Ø Ø • 6 • 3 3 ) 4 (

Slide 20

Slide 20 text

© 2019, Amazon Web Services, Inc. or its Affiliates. All rights reserved. Aurora Master 30% Read 70% Write Aurora Replica 100% New Reads Shared Multi-AZ Storage MySQL Master 30% Read 70% Write MySQL Replica 30% New Reads 70% Write # ! Binlog.$ Data Volume Data Volume MySQL read scaling • !# binlog / relay log*% • !# ,0 • !#/-(' • "+)& PAGE CACHE UPDATE

Slide 21

Slide 21 text

© 2019, Amazon Web Services, Inc. or its Affiliates. All rights reserved. App running Failure detection DNS propagation Recovery Recovery DB failure MYSQL App running Failure detection DNS propagation Recovery DB failure AURORA WITH MARIADB DRIVER 1 5 - 2 0 s e c 3 - 2 0 s e c

Slide 22

Slide 22 text

© 2019, Amazon Web Services, Inc. or its Affiliates. All rights reserved. • 5 Bp T 5 ze i R R k I – 3 3 R R r c • 5 ma IS P A P • 3 3 A ndA o t u

Slide 23

Slide 23 text

© 2019, Amazon Web Services, Inc. or its Affiliates. All rights reserved. (: M() • ( : " I " K " K • L C;E ;AF ; E; " " K E;C A ; D AF FH K K K K K K K " • – L –

Slide 24

Slide 24 text

© 2019, Amazon Web Services, Inc. or its Affiliates. All rights reserved. © 2019, Amazon Web Services, Inc. or its Affiliates. All rights reserved.

Slide 25

Slide 25 text

© 2019, Amazon Web Services, Inc. or its Affiliates. All rights reserved. • A i aW d A d • A R R R R R R d • / i d d • aW / e

Slide 26

Slide 26 text

© 2019, Amazon Web Services, Inc. or its Affiliates. All rights reserved. • D • P B d eDu C • DP c P sD D B h D t kD i • d ae p • Dv • d ae C C nm lDkr D a o // // //

Slide 27

Slide 27 text

© 2019, Amazon Web Services, Inc. or its Affiliates. All rights reserved. • : : : : – : : SX R e aGs – eO Q DAED lD LQK Y XDs – LQD C UX M Y PGv – eMKSX TGro BW T SX IUMG VI N – ro Gu

Slide 28

Slide 28 text

© 2019, Amazon Web Services, Inc. or its Affiliates. All rights reserved. 1 2 4 8 16 32 64 128 0 500 1000 1500 2000 2500 3000 1 20 39 58 77 96 115 134 153 172 191 210 229 248 267 286 305 324 343 362 381 400 419 438 457 476 495 514 533 552 571 590 609 628 647 666 685 704 723

Slide 29

Slide 29 text

© 2019, Amazon Web Services, Inc. or its Affiliates. All rights reserved. ) ) ( ) ) ) • 0 921 2 / SM Q I – 52 A dm • E Ial – on • ei

Slide 30

Slide 30 text

© 2019, Amazon Web Services, Inc. or its Affiliates. All rights reserved. ( ( ( ()( ( ( ( • DB B B B CC d l V T / r ne u o y K 552 p oL M d l c • 9 AA M 2 d l S aPVWO DB B c • H , 10 Qba – L / N • 2 I WJ Qba • sH d vHm V T

Slide 31

Slide 31 text

© 2019, Amazon Web Services, Inc. or its Affiliates. All rights reserved. • u I M SG R S F u g I G N P Z A – a H O L G • LnlDC T E a iI R S L – R S oH rB EBG 3 3 3 1 12 3 3 3 1 12 2 2 2 2

Slide 32

Slide 32 text

© 2019, Amazon Web Services, Inc. or its Affiliates. All rights reserved. 1LO1 B E V BV 4 I D T 0 R SWB 4 1N B 2 3

Slide 33

Slide 33 text

© 2019, Amazon Web Services, Inc. or its Affiliates. All rights reserved. . ) ( • nos e ULtOp OoR m Ow u c e U Lnos R U HG : , a P Q ouhyiOu Opl O U fkn e U ,e b – 2 g op o tyi u – H C A Op • C AG e ckh • GHA sOz rn eq O lUL enos • A g op o R c UPkh e • DH g op o R b Rc_ SP kh e M Td P • C AG GHA C AG GHA fkn e • GHA A DH GHA L A L DH fkn e GGC ## " " A" # A # G G# H H # . 2 H G A " G . 2 H G A " H , / ,

Slide 34

Slide 34 text

© 2019, Amazon Web Services, Inc. or its Affiliates. All rights reserved. © 2019, Amazon Web Services, Inc. or its Affiliates. All rights reserved.

Slide 35

Slide 35 text

© 2019, Amazon Web Services, Inc. or its Affiliates. All rights reserved. Amazon Aurora • )"26Amazon>8; RDBMS • 1*4/EF3!.CB 7?0G – Amazon Aurora#(-: &+:<CB @=7 0G • 1A571D%+$PITR49 < ',-

Slide 36

Slide 36 text

© 2019, Amazon Web Services, Inc. or its Affiliates. All rights reserved. • 7O D 7 2 41fd – I+ 7MI I( 7 7O D7MI 7 7 7O D 7 : • 7O D 7 0/23.a cb – + MMM 7BB D I: I : B I ) L IA : • 7O D 7 – + 7MI 7: I7 D : D 7 7 I 7 D D B • 7O D 7 G W e SQ – I+ 7MI 7 7O D B I D MI 7 7O D 7 7 D: : G 7D: B7 : 7 B – I+ 7MI 7 7O D B I D MI 7 7O D 7 7 D: : G 7:I 7D: 7 D I 7 – I+ 7MI 7 7O D B I D MI 7 7O D 7 7 D: : : D I I I D G I I – I+ 7MI 7 7O D B I D MI 7 7O D 7 7 D: : G I • .7 7 7I -B 7O D 7 – I+ 7MI 7 7O D B I :7 7 7I 7 7 7