Auroraの凄さを振り返る

Transcript

1. 
      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. & .-*  (2  ,0'/4"# 51 
   83;7 +)

   !&%$9( 6:  Attention

3. 3 Who am I ? 0 a5 5z s @

   aW :@ M 5 e r a A u S I @ t nmo : 5 1

4. 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. 5  170 PV  
   Developers.IO 4

6. 6 Agenda • - • • A •

7. 7  
      •
    •
   

       •
     •
     

8. 8 Aurora
   

9. Wrench, spanner PNG image http://pngimg.com/download/3124

10. European Southern Observatory
    ESO / 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

11. 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. 12 Aurora
    

13. 13 Amazon Aurora 0 0 IL S MBR 4 1

    0 D A 2 :4 Q P

14. 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. 15 Aurora  
      
       QM .

    , QM 3 3 L 9 L 3  9L L L Z A% Z PS 5 3

16. 16 Aurora  B 
     D

17. 17 Aurora $ 
     # " 
     " !

    "    

18. 18 Aurora
    

19. 19 Aurora
    

20. 20 Well-ArchitectedAurora
    

21. 21 Well-Architected Framework - 5F
      W -

    A

22. 22 Well-ArchitectedAurora" - 5   
       

     !

23. 23 
    

24. 24 6 • A 23 -232 L D Z Da

    B Z • ( S • D B ) 1 6 6 6 1 A

25. 25 
    

26. 26 
    

27. 27 6 3 / V3 )+ ) ) 3 V3

    / / )+ ) ) / 2 > V )+ ) 3 2 2 2

28. 28 6 2 6 2 2 3   

    

29. 29 6  
         

    

30. 30 6 
          

31. 31 
    
     4 3 A 3 / 3

32. 32 
     ( )

33. 33 
     ( )

34. 34 
     ( )

35. 35 Log-Structured Storage S L L 
      

     S -

36. 36 Log Structured Storage
    Write

37. 37 Log Structured Storage
    Write

38. 38 Log Structured Storage
    Write

39. 39 Log Structured Storage
    Write

40. 40 Log Structured Storage
    Commit

41. 41 Log Structured Storage
    Read

42. 42 Log Structured Storage
    Read

43. 43 Log Structured Storage
    Read

44. 44 Log Structured Storage
    Read

45. 45 Log Structured Storage
    Transaction Recovery

46. 46 Log Structured Storage
    Transaction Recovery

47. 47 Log Structured Storage
    Transaction Recovery

48. 48 Log Structured Storage
    Transaction Recovery

49. 49 Log Structured Storage
    Recovery

50. 50 Log Structured Storage
    Recovery

51. 51 Log Structured Storage
    Recovery

52. 52 Log Structured Storage
    Recovery

53. 53 Log Structured Storage
    Recovery

54. 54 Log Structured Storage
    Recovery

55. 55 Log Structured Storage
    Recovery

56. 56 Log Structured Storage
    Recovery

57. 57 
     

58. 58 PQ S e 5 5 3 • O A

    H J • / A f • / / A f • A i f • I K a Bch •

59. 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. 60 . I/O . / 3 3 3 5 .

    . /

61. 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. 62 Hash Join Batch Scan  
      

    • ) H( ( d MA Na d A K e A • J d MA ) BHc MA LQ S MA

63. 63 Parallel Query  
       • 
     

    "
    
    &# • 
    
      ' 
     $  • 
    
     %! https://www.slideshare.net/AmazonWebServices/deep-dive-on-the-amazon-aurora-mysqlcompatible-edition-dat301-reinvent-2017

64. 64 
    Slave % # 
    "& $!'  

65. 65 
    Slave % # 
    "& $!'  

66. 66 
    

67. 67 M  
      • R S

    • - S • • 6A •

68. 68 Multi-AZ"%!Read Replica$ &# 
         

     "%! 
        

69. 69 Multi-AZ Read Replica
     

70. 70 Multi-AZ Read Replica
     

71. 71 Read Replica
    Auto Scaling

72. 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. 73 
    

74. 74   
         • 

     •    • 
    

75. 75 
    
    

76. 76 L  
         • •

    I • • • • Z • A D • • PMZ •

77. 77 Zero Downtime Patch ( ) https://d1.awsstatic.com/events/jp/2017/summit/slide/D3T1-6.pdf

78. 78
          !  D

    M B

79. 79 backtrack 
          • 1

    • BD ) ( • Log-Structured Storage 

80. 80 Database clone 
      /

81. 81 Performance Insights 
      
     
     

      

82. 82 IAM /
     
     • / )/ • A

    ( • )W • 0 WS 2 2

83. 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. 84 DDL  
        1

85. 85 Lambda S
      • W • W

    L • A S   Amazon ES Lambda S

86. 86 
    

87. 87 • • a u D A D D A

    • r A o A R S

88. 88