Deep Dive on MySQL Databases on Amazon RDS

在本期课程中,我们将概述AWS上提供的MySQL选项,包括深入了解针对MySQL的Amazon Relational Database Service(Amazon RDS)和Amazon Aurora,性能高达5倍的MySQL兼容数据库,以及许多其他创新。
关于作者
Chayan Biswas
Chayan Biswas is a Sr. Product Manager with the Amazon RDS team, currently focusing on Amazon Aurora MySQL, RDS MySQL, and RDS MariaDB engines. Prior to RDS, he was a Sr. PM in the management tools space and worked on key services such as AWS Config, Config Rules, and CloudTrail. In his prior career, Chayan spent nearly 8 years in enterprise IT, designing and implementing large scale distributed ecommerce solutions as a solution architect. Chayan received his Master’s in Business Administration (MBA) from the Carnegie Mellon University’s Tepper School of Business and an undergraduate degree in Engineering from National Institute of Technology Karnataka, India.

展开查看详情

1.Deep Dive on MySQL Databases on Amazon RDS Chayan Biswas Sr. Product Manager, AWS cbbiswas@amazon.com © 2018, Amazon Web Services, Inc. or its Affiliates. All rights reserved. Amazon Confidential and Trademark

2.Amazon Relational Database Service (Amazon RDS) Managed relational database service with a choice of popular database engines Easy to administer Performant & scalable Available & durable Secure & compliant Easily deploy and Scale compute Automatic Multi-AZ Data encryption at maintain hardware, and storage with a data replication; rest and in transit; OS, and DB software; few clicks; minimal automated backup, industry compliance built-in monitoring downtime for your snapshots, and failover and assurance application programs

3.Amazon RDS database engines Commercial Open source Cloud native MySQL compatible PostgreSQL compatible Amazon Elastic Block Store (Amazon EBS)-based storage Amazon Aurora storage system

4.Amazon RDS database engines Commercial Open source Cloud native MySQL compatible PostgreSQL compatible Amazon Elastic Block Store (Amazon EBS)-based storage Amazon Aurora storage system

5.Agenda • Why run MySQL • Why run managed MySQL on Amazon RDS • Why Aurora MySQL?

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

7. 1. Popular 2. Innovative 3. Flexible Image credit: By Mackphillips - Own work, CC BY-SA 4.0, https://commons.wikimedia.org/w/index.php?curid=55946550

8. 1. Popular 2. Innovative 3. Flexible Image credit: By Mackphillips - Own work, CC BY-SA 4.0, https://commons.wikimedia.org/w/index.php?curid=55946550

9.MySQL is the world’s most popular database All respondents Source: Stack Overflow Developer Survey Results 2018 ( https://insights.stackoverflow.com/survey/2018/#technology )

10.“Most popular” buys you . . . Highly exercised, stable code Large ecosystem of ISVs, Tools, Implementation and Support Partners Large community of users and community- driven resources and a larger DBA talent pool

11. 1. Popular 2. Innovative 3. Flexible Image credit: By Mackphillips - Own work, CC BY-SA 4.0, https://commons.wikimedia.org/w/index.php?curid=55946550

12.MySQL 8.0 highlights - FUNCTIONALITY • Common Table Expressions • Window functions • JSON improvements • 5108 Spatial Reference Systems • utf8mb4

13.MySQL 8.0 highlights - AVAILABILITY • Instant ADD COLUMN • Unified, transactional data dictionary • Crash-safe, atomic DDL

14.MySQL 8.0 highlights - PERFORMANCE • Hot-spot management • Descending indexes • Invisible indexes • Improved optimizer cost model • Resource Groups • Improved replication

15.MySQL 8.0 highlights – SECURITY, MANAGEABILITY • Roles • Password strength • Open SSL as default TLS/SSL library • Enhanced observability

16.MariaDB 10.3 highlights • Oracle compatibility • PL/SQL compatibility parser • Sequences • INTERSECT and EXCEPT to complement UNION • New ROW type and TYPE OF stored functions • Invisible Columns • Cursor with parameters • Temporal data processing • User-defined aggregates • Instant ADD COLUMN for InnoDB Image credit: By Mackphillips - Own work, CC BY-SA 4.0, https://commons.wikimedia.org/w/index.php?curid=55946550

17.MariaDB 10.4 highlights (Release Candidate) • SQL Server compatibility • sql_mode=‘mssql’ • Subset of Microsoft SQL Server's language • Password expiry and account locking • Instant DROP COLUMN for InnoDB Image credit: By Mackphillips - Own work, CC BY-SA 4.0, https://commons.wikimedia.org/w/index.php?curid=55946550

18. 1. Popular 2. Innovative 3. Flexible Image credit: By Mackphillips - Own work, CC BY-SA 4.0, https://commons.wikimedia.org/w/index.php?curid=55946550

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

20.1. Popular 2. Innovative 3. Flexible

21.Hundreds of thousands of customers

22.Popular buys you . . . Highly exercised, stable code Unrivalled operational excellence

23.Who can you trust? Automated remediation World’s most experienced operators Automation

24. 1. Popular 2. Innovative 3. Flexible Image credit: By Mackphillips - Own work, CC BY-SA 4.0, https://commons.wikimedia.org/w/index.php?curid=55946550

25.Amazon RDS highlights - AVAILABILITY • Automated, 0-RPO failover across AZs • Managed x-region replicas for DR • Automated backups, manual snapshots • Point-in-time recovery

26.Automated, 0-RPO failover across AZs Availability zone 1 Availability zone 2 Each host manages set of EBS volumes Primary Standby with a full copy of the data EBS EBS Instances are monitored by an external #1 DNS #2 observer to maintain consensus over quorum EC2 EC2 #1 #2 App

27.Automated, 0-RPO failover across AZs Availability zone 1 Availability zone 2 Each host manages set of EBS volumes Primary Standby with a full copy of the data EBS EBS Instances are monitored by an external #1 DNS #2 observer to maintain consensus over quorum EC2 EC2 #1 #2 Failover initiated by automation or through RDS API App

28.Automated, 0-RPO failover across AZs Availability zone 1 Availability zone 2 Each host manages set of EBS volumes Primary with a full copy of the data EBS EBS Instances are monitored by an external #1 DNS #2 observer to maintain consensus over quorum EC2 EC2 #1 #2 Failover initiated by automation or through RDS API Redirection to the new primary instance is provided through DNS App

29.Automated, 0-RPO failover across AZs Availability zone 1 Availability zone 2 Each host manages set of EBS volumes Standby Primary with a full copy of the data EBS EBS Instances are monitored by an external #1 DNS #2 observer to maintain consensus over quorum EC2 EC2 #1 #2 Failover initiated by automation or through RDS API Redirection to the new primary instance is provided through DNS App