2018.07.31 JAWS-UG京都 AWSマネージドDB祭～まだDBにEC2使ってんの？～ / 今のAuroraのスゴさ

2018.07.31 JAWS-UG京都 AWSマネージドDB祭～まだDBにEC2使ってんの？～ / 今のAuroraのスゴさ #jawsug

Transcript

1. #jawsug Aurora
   2018.07.31 JAWS-UG AWS  DBDBEC2 Serverworks, Inc / Takayoshi Kobayashi @koba_taka
2. 2 #jawsug @koba_taka Twitter Amazon CloudSearch Amazon Elasticsearch Service Alexa Like takayoshi.kobayashi.16 Facebook Serverworks Co., Ltd. Sales Job Takayoshi Kobayashi Who is ?
3. 3 #jawsug 
    Serverworks   "  !#!!!
4. 4 #jawsug Thank you!!
   
5. 5 #jawsug # HashTag Twitter #jawsug
6. 6 #jawsug  DB   
   
7. 7 #jawsug Aurora
      only
8. 8 #jawsug I ♡ Aurora
    
9. 9 #jawsug Aurora Release!! 2014.
   aurora-release.com aurora-release.com 2015.10 
   GA
10. 10 #jawsug Aurora Release!! Happy Birthday!!
11. 11 #jawsug Amazon Aurora   Aurora
    Update 
    
12. 12 #jawsug Amazon Aurora "AWS-& #RDB# "RDB '20! "AWS)$. ,1
    # ( *) "!#  (/+ OSS%  Aurora 
    
13. 13 #jawsug  
     https://bit.ly/2An8lct Amazon Aurora
14. 14 #jawsug    Aurora 
    Aurora Replica    !! Amazon Aurora
15. 15 #jawsug ( ' - RDS for MySQL # LOGINGDATA*! Primary Instance
    ) EBS +,. /"(Replica) +,. %$ [Amazon Aurora: Design Considerations for High Throughput Cloud-Native Relational Databases] Figure 2  & Amazon Aurora
16. 16 #jawsug  %1 0$ Amazon Aurora "- !"")")'5,* !REDO 32 "") !(# Master3+ Slave,* !&.
      &. ") !REDO 4/
    Repair &. !Log-Structured Storage Amazon Aurora
17. 17 #jawsug  #32" Quorum !9(14
    &7+* : %/'4 DynamoDBS3)0  Aurora Quorum .8-;4! 58-;3! !3AZ2! $6! Quorum  6,;https://bit.ly/2AqMC3z Amazon Aurora
18. 18 #jawsug +3 * +3 * Quorum64 4 +3 %*. OK   5"- ()ms – )ms) 
    AZ4&10#!+3 Quorum$ Automatic failback to 3 of 4 if an AZ is unavailable ,'1AZ + 1(4+3 / 2 Amazon Aurora
19. 19 #jawsug   Quorum 3 3   OK 3 
     1AZ + 1  Amazon Aurora
20. 20 #jawsug   Aurora GA 
    
21. 21 #jawsug 
     Update 
     
22. 22 #jawsug Update List 2015 Aurora
     Update  2015/07/28 Aurora GA 2015/10/07 Tokyo Region Release★ 2015/12/07 Encryption at Rest for Amazon Aurora 2015/12/18 Enhanced Monitoring for Amazon RDS ★ 
23. 23 #jawsug Update List 2016 2016/03/16 Additional Failover Control for Amazon Aurora 2016/05/18 Cross-account snapshot sharing for Amazon Aurora. 2016/06/01 Cross-Region Read Replicas for Amazon Aurora 2016/06/01 Efficient storage of binary logs. 2016/10/19 Data loading from S3. 2016/07/20 Create Cluster from MySQL Backup 2016/09/02 Parallel Read Ahead, Faster Indexing, NUMA Awareness 2016/09/08 Load Balancing & Higher Availability (Reader endpoint)★ 2016/10/18 Lambda integration★ 2016/12/14 Spatial Indexing and Zero-Downtime Patching★ Aurora
     Update  ★ 
24. 24 #jawsug Load Balancing & Higher Availability (Reader endpoint) Read Replica) 35% 35(41 '"0   !."0 HAProxy!. +$ 
    /&*2 Aurora  -#Update,
25. 25 #jawsug Lambda Integration Lambda) Aurora*!(  & IoT#'"&  Aurora
    % Update $
26. 26 #jawsug Update List 2017 2017/01/18 Create an Amazon Aurora Read Replica from an RDS MySQL DB Instance 2017/03/28 More Cross Region & Cross Account Support, T2.Small DB Instances 2017/04/24 IAM Authenticate ★ 2017/06/01 Export Data into S3 2017/09/11 Fast Database Cloning 2017/10/24 PostgreSQL Compatibility (PostgreSQL 9.6.3 ) 2017/11/29 Aurora Serverless ★ Aurora
     Update ★ 
27. 27 #jawsug IAM Authenticate DB$*ID/PASSWORD-,  
    IAM-, #( EC2 Attach IAM Role -,!+ 1) 20 $*.-,% &.15 Aurora  ("Update'
28. 28 #jawsug Aurora Serverless Later… Aurora
    Update
29. 29 #jawsug Update List 2018 2018/05/10 Backtrack ★ Aurora
    Update 
30. 30 #jawsug Backtrack DB&(,0 &()%
    &(2!1  AuroraLog-Structured Storage ' ."*"  # MySQL 5.7 + Aurora  /$Update-
31. 31 #jawsug   Aurora
     Update 
32. 32 #jawsug Lab Mode Aurora +&&#,(,! Mode.< +aurora_lab_mode0(A1)1(>1) +E ?C Scan Batching - *#$'
    %*:5'79 HF%* ,"*5- Hash Joins – 7G,equi-join 64
     ,"*5-   Fast DDL - ALTER TABLE XX ADD COLUMN2; 8D3C Lock Compression – )",% /B #$'G=766% 0@ https://docs.aws.amazon.com/ja_jp/AmazonRDS/latest/UserGuide/AuroraMySQL.Updates.LabModeFeatures.html
33. 33 #jawsug Aurora Serverless Aurora aurora-release.com 2017.
    
34. 36  Aurora Aurora ' RDB MySQL
    PostgreSQL&%  ! )+Update
    -*
    .)+," Serverless$ (#/
35. 37 #jawsug I ♡ Aurora
     
36. 38 #jawsug MS SQL Server
    Aurora Aurora
37. 41 #jawsug 
    Dive  !   DB  
38. Thank you!