Auroraの凄さを振り返る

Ae763d151aeee101b40ae10cc13ebe63?s=47 maroon1st
August 22, 2018

 Auroraの凄さを振り返る

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

Ae763d151aeee101b40ae10cc13ebe63?s=128

maroon1st

August 22, 2018
Tweet

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 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

  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 StorageWrite

  37. 37 Log Structured StorageWrite

  38. 38 Log Structured StorageWrite

  39. 39 Log Structured StorageWrite

  40. 40 Log Structured StorageCommit

  41. 41 Log Structured StorageRead

  42. 42 Log Structured StorageRead

  43. 43 Log Structured StorageRead

  44. 44 Log Structured StorageRead

  45. 45 Log Structured StorageTransaction Recovery

  46. 46 Log Structured StorageTransaction Recovery

  47. 47 Log Structured StorageTransaction Recovery

  48. 48 Log Structured StorageTransaction Recovery

  49. 49 Log Structured StorageRecovery

  50. 50 Log Structured StorageRecovery

  51. 51 Log Structured StorageRecovery

  52. 52 Log Structured StorageRecovery

  53. 53 Log Structured StorageRecovery

  54. 54 Log Structured StorageRecovery

  55. 55 Log Structured StorageRecovery

  56. 56 Log Structured StorageRecovery

  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 ReplicaAuto 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