Introduction to Amazon Relational Database Service (RDS)

AmazonRDS是一个完全管理的数据库服务,它允许您只需点击几下就可以启动一个经过优化配置、安全且高度可用的数据库。它管理耗时的数据库管理任务,让您可以专注于应用程序和业务。本主题演讲介绍了来自RDS的最新新闻和公告,包括Aurora Serverless、Parallel Query、Backtrack、RDS MySQL8.0、PostgreSQL 10.0、Performance Insights以及其他一些最新创新。

展开查看详情

1.Introduction to Amazon Relational Database Service (RDS) Chayan Biswas Sr. Product Manager, Amazon Web Services

2. Amazon RDS Cloud native engine Open source engines Commercial engines RDS platform • Automatic fail-over • Isolation & security • Advanced monitoring • Backup & recovery • Industry compliance • Routine maintenance • X-region replication • Automated patching • Push-button scaling © 2018, Amazon Web Services, Inc. or its Affiliates. All rights reserved.

3. Fully managed No need to provision infrastructure, or install and maintain DB software Available & durable Automatic Multi-AZ data replication; automated backup, snapshots, and failover Highly scalable Scale DB compute and storage with a few clicks; minimal downtime for your application Fast & secure SSD storage and guaranteed provisioned I/O; data encryption at rest and in transit, and network isolation © 2018, Amazon Web Services, Inc. or its Affiliates. All rights reserved.

4. Hundreds of Thousands of Customers Use Amazon RDS © 2018, Amazon Web Services, Inc. or its Affiliates. All rights reserved.

5. D ata b a s e e n g i n e b u i l t fo r t h e c l o u d © 2018, Amazon Web Services, Inc. or its Affiliates. All rights reserved. © 2017, Amazon Web Services, Inc. or its Affiliates. All rights reserved.

6. A m a zo n A u ro ra 5x throughput of standard MySQL; 3x throughput of standard PostgreSQL 1/10th the cost of commercial databases Availability Availability Availability Purpose-built, self-healing, distributed storage Zone 1 Zone 2 Zone 3 © 2018, Amazon Web Services, Inc. or its Affiliates. All rights reserved. © 2017, Amazon Web Services, Inc. or its Affiliates. All rights reserved.

7. Fully managed Same reliable managed experienced offered by RDS Available & durable 6 copies across 3 AZs; continuous backups, snapshots, and automatic fast failover; Clone and Backtrack in seconds. Highly scalable Automatically scale storage up to 64TB; Up to 15 auto-scaling Aurora Replicas. Fast & secure 5X the performance of MySQL, 3X the performance of PostgreSQL. © 2018, Amazon Web Services, Inc. or its Affiliates. All rights reserved.

8. Fastest growing service in AWS history Aurora is used by ¾ of the top 100 AWS customers © 2018, Amazon Web Services, Inc. or its Affiliates. All rights reserved.

9.Aurora Serverless On-demand, auto-scaling database for applications with variable workloads Application Starts up on demand, shuts down when not in use Database Endpoint Automatically scales with no instances Scalable Database Capacity Warm to manage (Compute + Memory) Capacity Pool Pay per second for the database capacity you use Shared Distributed Storage © 2018, Amazon Web Services, Inc. or its Affiliates. All rights reserved.

10.A u ro ra Pa ra l l e l Q u e r y DATABASE NODE Massively parallel query processing in AGGREGATE PUSH DOWN Aurora’s distributed storage layer RESULTS PREDICATES 2 orders of magnitude faster queries Run analytic queries on production data STORAGE NODES © 2018, Amazon Web Services, Inc. or its Affiliates. All rights reserved.

11.Performance Insights: Simplifying Performance Monitoring Simple yet powerful dashboard for database load Easily identify bottlenecks: Top SQL, Top Hosts, Top Users Available on all RDS engines Free retention for 7 days API Access 2 years at small cost © 2018, Amazon Web Services, Inc. or its Affiliates. All rights reserved.

12. Performance Insights Changes the Game CPU Bottleneck? Wait Bottleneck? Deadlock? Rogue Host? SQL | Plans | Upgrades | App Changes | Indexes © 2018, Amazon Web Services, Inc. or its Affiliates. All rights reserved.

13.AWS Database Migration Service Migrate between on-premises and AWS Migrate between databases 90,000+ Databases migrated Automated schema conversion Data replication for minimal-downtime migration © 2018, Amazon Web Services, Inc. or its Affiliates. All rights reserved.

14.90,000+ Databases Migrated with DMS © 2018, Amazon Web Services, Inc. or its Affiliates. All rights reserved.

15. Partnership with Percona DBA service for Amazon RDS and Aurora Database design and performance tuning Security assessments and best practice adherence © 2018, Amazon Web Services, Inc. or its Affiliates. All rights reserved.

16.Takeaway We do the undifferentiated heavy-lifting So that you can focus on what matters © 2018, Amazon Web Services, Inc. or its Affiliates. All rights reserved.

17.Breakout Sessions 11:20-12:10 Deep Dive on Amazon Aurora 12:20-13:10 Zero to Serverless in 60 seconds 14:20-15:10 Deep Dive on MySQL Databases on Amazon RDS 14:20-15:10 Polyglots and Containers 15:20-19:10 Top 10 Mistakes When Migrating From Oracle to PostgreSQL 16:30-16:55 Tips and Tricks with Amazon RDS for PostgreSQL 17:00-17:25 HOT - Understanding This Important Update Optimization © 2018, Amazon Web Services, Inc. or its Affiliates. All rights reserved.

18. Visit our booth Take away cool swag and AWS credits! © 2018, Amazon Web Services, Inc. or its Affiliates. All rights reserved.

19. Thank you! rds-pm@amazon.com © 2018, Amazon Web Services, Inc. or its Affiliates. All rights reserved.

20.Rate My Session © 2018, Amazon Web Services, Inc. or its Affiliates. All rights reserved.