Amazon Aurora latest update

Mix Leap Study #42 - DB Night Osaka Vol.1 (https://yahoo-osaka.connpass.com/event/128246/) での発表資料です

Transcript

1. © 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 / / . / /
2. © 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; Z40
   AWS=U!"(# &IORD   • IOM^<G ,.`L/][3?*$)+N: 40
   S_W TM \H   • AWS does not offer binding price quotes. AWS pricing is publicly available and is subject to change in accordance with the AWS Customer Agreement available at http://aws.amazon.com/agreement/. Any pricing information included in this document is provided only as an estimate of usage charges for AWS services based on certain information that you have provided. Monthly charges will be based on your actual use of AWS services, and may vary from the estimates provided.
3. © 2019, Amazon Web Services, Inc. or its Affiliates. All rights reserved. ( ) ( ( ) (
         
4. © 2019, Amazon Web Services, Inc. or its Affiliates. All rights reserved. -B - - - - - - - - - - - - - A - & - A & A - - - -
5. © 2019, Amazon Web Services, Inc. or its Affiliates. All rights reserved. , , A L PS P M M L A , P Q
6. © 2019, Amazon Web Services, Inc. or its Affiliates. All rights reserved.   "2(: 8 KH 8 FUB ;EB/9, ,&&0 8,8 <Q #58' :07:" MV I8& "9 ;EB-&%UD SO4*$8: ?G@ AL3:'):" => ($1"NC$";EB
   08 6: JT.!+" RP  
   
7. © 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
8. © 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
9. © 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 ,
10. © 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
11. © 2019, Amazon Web Services, Inc. or its Affiliates. All rights reserved. Q L D Q Q M Q I Q S
12. © 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-1 AZ:35> 3, H?B>CD IF – 3 ":35> H<B> SQL Transactions AZ 1 AZ 2 AZ 3 Caching Amazon S3
13. © 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
14. © 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 
      
15. © 2019, Amazon Web Services, Inc. or its Affiliates. All rights reserved. 
     • + / + + ( ) + ( + ) 2.1 >+ ) + >+ 7
    ؝ؾ٦ך侧 7X 剅ֹ鴥׫ؙؓ٦ٓي 7S 铣׫鴥׫ؙؓ٦ٓي                     
16. © 2019, Amazon Web Services, Inc. or its Affiliates. All rights reserved. 7
    ؝ؾ٦ך侧 7X 剅ֹ鴥׫ؙؓ٦ٓي 7S 铣׫鴥׫ؙؓ٦ٓي                      "NB[PO
    "VSPSB
    חֶֽ׷ؙؓ٦ٓيٌرٕ 
     • + / + + ( ) + ( + ) 2.1 >+ ) + >+
17. © 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 +) +)
18. © 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
19. © 2019, Amazon Web Services, Inc. or its Affiliates. All rights reserved.  
     • 6 Ø Ø • 6 • 3 3 ) 4 (
20. © 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
21. © 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
22. © 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
23. © 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 –
24. © 2019, Amazon Web Services, Inc. or its Affiliates. All rights reserved. © 2019, Amazon Web Services, Inc. or its Affiliates. All rights reserved.
    
25. © 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
26. © 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 // // //
27. © 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
28. © 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 
     
29. © 2019, Amazon Web Services, Inc. or its Affiliates. All rights reserved. ) ) ( ) ) ) • 0 921 2 / SM Q I – 52 A dm • E Ial – on • ei
30. © 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
31. © 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
32. © 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
33. © 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 , / ,
34. © 2019, Amazon Web Services, Inc. or its Affiliates. All rights reserved. © 2019, Amazon Web Services, Inc. or its Affiliates. All rights reserved. 
    
35. © 2019, Amazon Web Services, Inc. or its Affiliates. All rights reserved. Amazon Aurora • )"26 Amazon>8; RDBMS • 1*4/EF3
    !.CB 7?0G – Amazon Aurora#(-: &+:<CB @=7 0G • 1A57
    1D %+$
    PITR49   < ',-
36. © 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