Auroraの凄さを振り返る

JAWS-UG 初心者支部#13　「AWS Night school」での発表資料です。
https://jawsug-bgnr.connpass.com/event/94301/

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