Upgrade to PRO for Only $50/Year—Limited-Time Offer! 🔥

2018.07.31 JAWS-UG京都 AWSマネージドDB祭~まだDBにEC2使ってんの...

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

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

Takayoshi Kobayashi

July 31, 2018
Tweet

More Decks by Takayoshi Kobayashi

Other Decks in Technology

Transcript

  1. 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 ?
  2. 12 #jawsug Amazon Aurora "AWS-& #RDB# "RDB '20! "AWS)$. ,1

    # ( *) "!#  (/+ OSS%  Aurora 
  3. 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
  4. 16 #jawsug  %1 0$ Amazon Aurora "- !"")")'5,* !REDO

    32 "") !(# Master3+ Slave,* !&.  &. ") !REDO 4/Repair &. !Log-Structured Storage Amazon Aurora
  5. 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
  6. 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
  7. 19 #jawsug   Quorum 3 3   OK

    3  1AZ + 1  Amazon Aurora
  8. 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 ★ 
  9. 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  ★ 
  10. 24 #jawsug Load Balancing & Higher Availability (Reader endpoint) Read

    Replica) 35% 35(41 '"0   !."0 HAProxy!. +$  /&*2 Aurora  -#Update,
  11. 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 ★ 
  12. 27 #jawsug IAM Authenticate DB$*ID/PASSWORD-,  IAM-, #( EC2 Attach

    IAM Role -,!+ 1) 20 $*.-,% &.15 Aurora  ("Update'
  13. 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