AWS Aurora Serverless -Zero to Serverless in 60 seconds

Amazon Aurora Serverless是Aurora(MySQL兼容版本)的一种按需自动伸缩配置,在该配置中,数据库将根据应用程序的需要自动启动、关闭和缩放容量。它使您能够在云中运行数据库,而无需管理任何数据库实例。Aurora Serverless是一个简单、经济高效的选项,适用于不频繁、间歇或不可预测的工作负载。我们将探讨这些用例,深入研究无服务器数据库的未来。我们还将听到客户在Aurora Serverless上构建新功能的案例研究。

展开查看详情

1.AWS Aurora Serverless Zero to Serverless in 60 seconds © 2018, Amazon Web Services, Inc. or its affiliates. All rights reserved. 1

2.Agenda 1. Evolution of AWS Aurora 2. Relational database and resource utilization 3. What is AWS Aurora Serverless? 4. Simplified experience and use cases 5. Demonstration © 2018, Amazon Web Services, Inc. or its affiliates. All rights reserved. 2

3.Evolution of AWS Aurora © 2018, Amazon Web Services, Inc. or its affiliates. All rights reserved. 3

4.Evolution of Compute and Storage AWS EC2 becomes publicly available, 2006 2009, AWS Relational Database Service for MySQL becomes publicly available 2013, AWS RDS supports MySQL, Oracle, SQL Server, PostgreSQL AWS Lambda becomes publicly available, 2014 2015, AWS Aurora MySQL-compatible edition becomes publicly available 2017, AWS Aurora PostgreSQL-compatible edition becomes publicly available © 2018, Amazon Web Services, Inc. or its affiliates. All rights reserved. 4

5.What is AWS Aurora? • Managed MySQL/PostgreSQL compatible relational database product built for AWS Cloud • Innovative elastic storage, no provisioned IOPs • Highly durable and available by design • License headache free • Backed by AWS’s engineering talent and culture of customer obsession © 2018, Amazon Web Services, Inc. or its affiliates. All rights reserved. 5

6.AWS Aurora Architecture Client DB AZ 1 apps Engine …. AZ 2 AZ 3 Customer’s VPC RDS Instance VPCs Aurora multi-tenant storage VPC © 2018, Amazon Web Services, Inc. or its affiliates. All rights reserved. 6

7.What is AWS Aurora? Spot a server hiding in plain sight Client DB AZ 1 apps Engine process AZ 2 A virtual server AZ 3 provided by EC2 © 2018, Amazon Web Services, Inc. or its affiliates. All rights reserved. 7

8.Relational databases and resource utilization © 2018, Amazon Web Services, Inc. or its affiliates. All rights reserved. 8

9.Capacity planning isn’t easy 120 120 100 100 80 80 60 60 40 40 20 20 0 0 41 45 49 13 17 21 25 29 33 37 53 57 61 65 69 73 77 81 85 89 93 97 1 5 9 13 89 93 5 9 17 21 25 29 33 37 41 45 49 53 57 61 65 69 73 77 81 85 97 1 CPU Connections Capacity CPU Connections Capacity 120 100 80 60 40 20 0 49 53 13 17 21 25 29 33 37 41 45 57 61 65 69 73 77 81 85 89 93 97 1 5 9 CPU Connections Capacity © 2018, Amazon Web Services, Inc. or its affiliates. All rights reserved. 9

10.What causes inefficient resource utilization? • Inherently irregular/cyclical workloads • Costs associated with real-time capacity management • Potential workload disruptions when adjusting database capacity Customers often over-provision relational databases for worst-case workloads. © 2018, Amazon Web Services, Inc. or its affiliates. All rights reserved. 10

11.AWS Aurora Serverless is the next step Summer 2018, AWS Aurora Serverless for MySQL becomes publicly available Aurora Serverless is a solution to access relational database software running in a Cloud © 2018, Amazon Web Services, Inc. or its affiliates. All rights reserved. 11

12.What is AWS Aurora Serverless? © 2018, Amazon Web Services, Inc. or its affiliates. All rights reserved. 12

13.Aurora Serverless makes database compute elastic Application • Starts up on demand, shuts down when not in use Database endpoint • Scales up/down automatically Warm pool of compute capacity Request Router • No application impact when scaling • Pay per second, 5 minute minimum Scalable DB Capacity Scalable storage © 2018, Amazon Web Services, Inc. or its affiliates. All rights reserved. 13

14.Aurora Serverless: Pause/Resume, Scaling • Database is automatically paused when it has no open connections for 5m - 24h (customer configurable) • Database is resumed automatically when first connection arrives • Database is scaled up if during 10 minutes period metrics indicate that • It runs at 70%+ CPU utilization • It runs at 90%+ connections • Database is scaled down if during 10 minutes period metrics indicate that • It runs below 30% CPU utilization • It runs below 40% connections © 2018, Amazon Web Services, Inc. or its affiliates. All rights reserved. 14

15.Here are the results • Get the capacity that you need! • Pay for what you get! © 2018, Amazon Web Services, Inc. or its affiliates. All rights reserved. 15

16.How did we do it? Scaling request contains encrypted and signed routing information. Only Router can decrypt it Aurora Old Serverless node Control Plane Application NLB Request Aurora Router Storage New node Encrypted session state Database is being sent to Router VPC Endpoint and restored on a new backend. Router has no key to decrypt session Customer’s VPC state Service VPC © 2018, Amazon Web Services, Inc. or its affiliates. All rights reserved. 16

17.Simplified experience and use cases © 2018, Amazon Web Services, Inc. or its affiliates. All rights reserved. 17

18.Simpler experience: less to worry about Goal - have customers get started in minutes! • No CPU credits to monitor • No commitment to particular availability zone • No migrations between instance type generations • No DB instance reservations to manage • No instances to manage • Encryption at REST is always enabled • No need to manually suspend, resume or scale database • No DNS propagation delays • No maintenance window • No old database versions to upgrade © 2018, Amazon Web Services, Inc. or its affiliates. All rights reserved. 18

19. Sample Use-Cases: Pause/Resume • Data store for periodic jobs/reports (daily, weekly, monthly...) • Non-customer interactive applications • Retriable workloads - back-office applications • Back testing - restore snapshots to Aurora Serverless • Dev / test environments • Educational / training • Demos © 2018, Amazon Web Services, Inc. or its affiliates. All rights reserved. 19

20. Sample Use-Cases: Auto-Scaling • OLTP data stores with variable workload Automatic adjusting to load cyclicality • Consolidated Databases Simpler capacity management for multi-tenant services • Scheduled autoscaling Scale up or down at specific times of the day when you have known loads coming in or dropping off (requires some custom event processing) © 2018, Amazon Web Services, Inc. or its affiliates. All rights reserved. 20

21.How can I migrate? To Aurora MySQL To Aurora Serverless for MySQL ✓ ✓ Restore from Snapshot Dump & Load ✓ ✓ ✓ ✓ AWS Data Migration Service ✓ ✗ Transaction Log Replication Restore from S3 ✓ ✗ © 2018, Amazon Web Services, Inc. or its affiliates. All rights reserved.

22.What is the availability story? Aurora MySQL Aurora MySQL Aurora (Multi-AZ) (Single-AZ) Serverless for MySQL Fast Failover ✓ ✗ ✗ ✓ ✗ ✓ Cross-AZ failover ✓ ✓ ✓ Storage HA/Durability © 2018, Amazon Web Services, Inc. or its affiliates. All rights reserved.

23.Demonstration © 2018, Amazon Web Services, Inc. or its affiliates. All rights reserved. 23

24.Q&A and Related Talks 14:20 Polyglot and Containers Kathy Gibbs 14:20 Deep Dive on MySQL Databases on Amazon Chayan Biswas 15:20 Top 10 Mistakes when Migrating from Oracle to PG Jim Mlodgenski 16:30 Tips and Tricks with Amazon RDS for PostgreSQL Denis Lussier 17:00 Understanding this Important Update Optimization Jim Mlodgenski © 2018, Amazon Web Services, Inc. or its affiliates. All rights reserved. 24

25.© 2018, Amazon Web Services, Inc. or its affiliates. All rights reserved.

26.© 2018, Amazon Web Services, Inc. or its affiliates. All rights reserved.

27.© 2018, Amazon Web Services, Inc. or its affiliates. All rights reserved.

28.© 2018, Amazon Web Services, Inc. or its affiliates. All rights reserved.

29. https://us-w © 2018, Amazon Web Services, Inc. or its affiliates. All rights reserved.