Download to read offline
Uploaded byDhaval Nagar
Introduction to AWS Cloud Databases [Apr 2020]
The document provides an overview of databases in AWS, including purpose-built, managed, and cloud-native options such as RDS, Aurora, and DynamoDB. It discusses key database concepts like performance optimization, security, and migration strategies, and highlights use cases and features of the databases. Notably, it mentions case studies of organizations successfully migrating to AWS databases to enhance performance and scalability.
Introduction to AWS Cloud Databases [Apr 2020]
- 2. Level 100-200 (IntroductoryLevel) You can ask questions in the chat box, I will try to answer them during the slides.
- 3. Purpose Built Databasesin AWS
- 4. Core AWS Services ●VPC, Subnet ● Security Groups ● IAM ● S3 ● KMS ● CloudWatch ● SNS
- 5. Terminologies ● Region andAvailability Zones ● Multi-AZ Database ● IOPS - Input Output Operations per Second ● Throughput ● Latency ● Queue Length ● Burstable CPU ● Read Replicas ● TLS Connection (Transport Level Security) ● TDE - Transparent Data Encryption ● FLE - Field Level Encryption
- 6. Database Structure ● Compute ○Writer Node(s) ○ Reader Node(s) ● Storage ○ Magnetic ○ General Purpose (SSD) ○ Provisioned IOPS
- 7. General DB TaskManagement ● Patching ● Backup / Restore ● Right Sizing ● Security / Encryption ● Performance Tuning ● Logs ● Security
- 8. Self Managed vsManaged Databases ● Stand by or Active/Active Setup ● TLS ● Encryption at Rest ● Auto Scaling Storage ● Critical Event Notifications ● Right Sizing ● Cost Optimization
- 9. Migration Pattern Rehosting Move databaseto the cloud, but host it on a VM MySQL on EC2 Managed Database Use one of the managed database option MySQL RDS Cloud-native Database Use the modern database built for the cloud Aurora / DynamoDB
- 10. Cloud-native Databases ● Bornin the Cloud ● Optimised for performance ● In-built High Availability ● In-built Fault Tolerance ● Optimised Costing ● Better Visibility ● Less Ops
- 11. Amazon Relational DatabaseService ● Supported Engines ○ RDS, MySQL, PostgreSQL, MariaDB, MS SQL, Oracle ● Multi-AZ Support (Auto-Failover with DNS) ● VPC Private and VPC Public Access Support ○ Although public access is not recommended ● Disk-size is proprotional to your IO Throughput ● Auto-Storage Scaling (upto 64 TB) ● Password and IAM based Authentication ● Encryption At Rest with KMS ● Auto Backup upto 35 Days, Point in time Recovery (till last 5 minutes) ● Performance Insights for Debugging ● Logging and Monitoring
- 12.
- 13.
- 14. RDS vs DigitalOcean **The instances in RDS are optimised for Database Performance
- 15. Amazon Aurora ● Compatiblewith MySQL and PostgreSQL ● Cloud-native Database ● Only available in the cloud, you can not download and install ● High-performance Storage subsystem ● Regional and Global Database Support ● Upto 15 Read Replicas ● Single Writer or Multi Writer Support ● Fault Tolerant and Auto Healing Storage System ● Storage can grow automatically upto 64TB
- 16.
- 17. Aurora Connection Endpoints ●Cluster Endpoint ● Reader Endpoint ● Custom Endpoint ● Instance Endpoint
- 19.
- 20. Manages 60 millioncustomer tickets per single Aurora cluster for one of their tools, Zendesk Explore. https://aws.amazon.com/blogs/database/how-zendesk-tripled-performance-by-moving-a-legacy-system-onto-amazon-aurora-and-amazon-redshift/
- 21. In 2019, thecompany migrated its mission-critical single sign-on (SSO) application from self-managed SQL Server on EC2 to fully managed Aurora MySQL. This service funnels authentication requests from over 142 million users and responds to over 145,000 API requests per minute. https://aws.amazon.com/blogs/database/migrating-autodesks-mission-critical-database-from-microsoft-sql-server-to-amazon-aurora-mysql/
- 22. Amazon DynamoDB ● NoSQLDatabase ● Cloud-native database ● Serverless Database ● Key-Value Store ● No Storage Provisioning ● On-demand vs Fixed Pricing for Read/Write Capacity ● Extremely popular database in AWS ● You can download DynamoDB Local for Development and Testing purposes
- 25. NoSQL Workbench forDynamoDB ● Data Modeling ● Data Visualization ● Operations Building https://docs.aws.amazon.com/amazondynamodb/latest/developerguide/workbench.settingup.html
- 26. Use Cases ● ServerlessBackend ● Mobile App Backend ● High Performance Key Value Store
- 27.
- 28. Stores 31 BillionItems in DynamoDB to Deliver Lessons Globally https://aws.amazon.com/solutions/case-studies/duolingo-case-study-dynamodb/
- 29. Experimental New Features ●RDS Proxy ○ Manage Connections as a Service ○ Useful for Severless Applications ● Aurora Serverless ● Aurora Machine Learning ○ SageMaker ○ Comprehend for Sentiment Analysis
- 30.