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

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

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

F0940359a23a1d02661e8715487a729b?s=128

Takayoshi Kobayashi

July 31, 2018
Tweet

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 MySQLPostgreSQL&%  ! )+Update-*.)+,"

    Serverless$ (#/
  35. 37 #jawsug I ♡ Aurora  

  36. 38 #jawsug MS SQL Server Aurora Aurora

  37. 41 #jawsug Dive  !   DB  

  38. Thank you!