Database Services on AWS

Ivan SalazarEnterprise Solutions Architect, AWSivansal@amazon.com

Experience Day, Guadalajara

Agenda

• Amazon Relational Database Service (RDS)• AWS Database Migration Service• Amazon ElastiCache• Amazon Redshift• Amazon DynamoDB

Amazon Relational Database Service

• Managed service for MySQL, Oracle, Microsoft SQL Server, PostgreSQL, and Amazon Aurora

• Handles time-consuming database management tasks, such as backups, patch management, and replication

• MySQL, PostgreSQL, and Amazon Aurora support one or more read replicas

• Works with existing code, applications, and tools

No infrastructure management

Scale up/downCost-effective

Instant provisioning

Application compatibility

Amazon RDS Benefits

Amazon RDS engines

Commercial Open source Amazon Aurora

backup & recovery,data load & unload

performance tuning25%40%

5% 5%

scripting & codingsecurityplanning

install, upgrade, patch and migrate

documentation, licensing & training

Why Managed Databases?

If You Host Your Databases On-premises

Power, HVAC, netRack & stack

Server maintenance

OS patches

DB s/w patchesDatabase backups

ScalingHigh availability

DB s/w installs

OS installation

you

App optimization

Power, HVAC, netRack & stack

Server maintenance

OS patches

DB s/w patchesDatabase backups

ScalingHigh availability

DB s/w installs

OS installation

you

App optimization

If You Host Your Databases On-premises

If You Host Your Databases in EC2

Power, HVAC, netRack & stack

Server maintenance

OS patches

DB s/w patchesDatabase backups

ScalingHigh availability

DB s/w installs

OS installation

you

App optimization

OS patches

DB s/w patchesDatabase backups

ScalingHigh availability

DB s/w installs

you

App optimization

Power, HVAC, netRack & stack

Server maintenanceOS installation

If You Host Your Databases in EC2

If You Choose a Managed Database Service

Power, HVAC, netRack & stack

Server maintenance

OS patches

DB s/w patchesDatabase backups

App optimization

High availability

DB s/w installs

OS installation

you

Scaling

Amazon RDS Multi-AZ

Amazon RDS for Aurora

• Amazon Aurora is a MySQL-compatible relational database engine– The speed and availability of high-end commercial databases– The simplicity and cost-effectiveness of open source databases

• Up to five times better performance than MySQL • At a price point 1/10 of a commercial database • Amazon RDS for Aurora provides administration

for Aurora by handling routine database tasks

Demo

Details: Amazon RDS for Aurora• Key Features

– Designed for compatibility with MySQL 5.6.10– Auto-scaling storage, so no need to pre-allocate– Data is transparently replicated 6 ways among 3 Availability Zones– Add up to 15 Replicas

• Single-digit millisecond replica lag times• Replicas are also Multi-AZ failover candidates

– Encryption at rest and in transit

ü Move data to the same or different database engine

ü Keep your apps running during the migration

ü Start your first migration in 10 minutes or less

ü Replicate within, to, or from Amazon EC2 or RDS

AWS Database Migration Service

Migrate from Oracle and SQL Server

Move your tables, views, stored procedures, and data manipulation language (DML) to MySQL, MariaDB, and Amazon Aurora

Highlight where manual edits are neededAWS Schema

Conversion Tool

Amazon ElastiCache

• In-memory managed cache cluster• Supports two open-source caching engines:

Memcached and Redis• Automatically detects and replaces failed nodes• Redis engine supports replication and Multi-AZs• Great fit for read-heavy applications and often deployed

in front of Amazon RDS

Amazon Redshift

• Fast, fully managed, petabyte-scale relational data warehouse solution

• Columnar storage technology to improve I/O and parallelizing queries across multiple nodes (SSD & HDD)

• Uses familiar SQL-based clients and business intelligence (BI) tools using standard JDBC and ODBC drivers

• Costs less than a tenth of most other cloud data warehouse solutions: $1,000/TB/Year; starts at $0.25/hour

Amazon Redshift architecture

Leader NodeSimple SQL end pointStores metadataOptimizes query planCoordinates query execution

Compute NodesLocal columnar storageParallel/distributed execution of all queries, loads, backups, restores, resizes

Start at just $0.25/hour, grow to 2 PB (compressed)DC1: SSD; scale from 160 GB to 326 TBDS2: HDD; scale from 2 TB to 2 PB

Ingestion/BackupBackupRestore

JDBC/ODBC

10 GigE(HPC)

Large ecosystem

Data Integration Systems IntegratorsBusiness Intelligence

Service oriented architecture

DynamoDB

EMR

S3

EC2/SSH

RDS/Aurora

Amazon Redshift

Amazon Kinesis

MachineLearning

Data Pipeline

CloudSearch

Mobile Analytics

Amazon DynamoDB

• Fast and flexible NoSQL database service• Provides a schema-less, no joins, no complex

transactions managed database• Single-digit millisecond latency at any scale for items

ranging from 1byte to 400KB• Great fit for mobile, web, games, ad-tech, IoT, and many

other applications

Demo

Why NoSQL?

Optimized for storage Optimized for compute

Normalized/relational Denormalized/hierarchical

Ad hoc queries Instantiated views

Scale vertically Scale horizontally

Good for OLAP Built for OLTP at scale

SQL NoSQL

Amazon DynamoDB

Document or Key-Value Scales to Any WorkloadFully Managed NoSQL

Access Control Event Driven ProgrammingFast and Consistent

AWS offers a complete set of database services

Your apps Amazon RDSManaged SQL

AWS offers a complete set of database services

Your apps

Amazon DynamoDB

Managed NoSQL

Amazon RDSManaged SQL

AWS offers a complete set of database services

Your apps

Amazon DynamoDB

Managed NoSQL

Amazon RDSManaged SQL

Amazon ElastiCacheManaged in-memory caching

AWS offers a complete set of database services

Your apps

Amazon DynamoDB

Managed NoSQL

Amazon RDSManaged SQL

Amazon ElastiCacheManaged in-memory caching

Amazon RedshiftManaged data warehouse

Your BI tools

GRACIAS!