2016 utah cloud summit: rds
TRANSCRIPT
![Page 1: 2016 Utah Cloud Summit: RDS](https://reader035.vdocuments.us/reader035/viewer/2022062523/587064a21a28ab48378b4aaf/html5/thumbnails/1.jpg)
Amazon Relational Database Service: What’s New
Lynn Ferrante, Business Development Manager, RDS Open Source DatabasesJanuary 2016
![Page 2: 2016 Utah Cloud Summit: RDS](https://reader035.vdocuments.us/reader035/viewer/2022062523/587064a21a28ab48378b4aaf/html5/thumbnails/2.jpg)
Agenda
RDS Introduction and What’s New Across RDSAmazon AuroraDatabase Migration Service
![Page 3: 2016 Utah Cloud Summit: RDS](https://reader035.vdocuments.us/reader035/viewer/2022062523/587064a21a28ab48378b4aaf/html5/thumbnails/3.jpg)
Amazon RDS
Relational Database Service (Amazon RDS) makes it easy to set up, operate, and scale a relational database in the cloud.
It frees you up to focus on your applications and business.
![Page 4: 2016 Utah Cloud Summit: RDS](https://reader035.vdocuments.us/reader035/viewer/2022062523/587064a21a28ab48378b4aaf/html5/thumbnails/4.jpg)
If You Host Your Databases On-premises
Power, HVAC, net
Rack & stack
Server maintenance
OS patches
DB s/w patchesDatabase backups
ScalingHigh availability
DB s/w installs
OS installation
you
App optimization
![Page 5: 2016 Utah Cloud Summit: RDS](https://reader035.vdocuments.us/reader035/viewer/2022062523/587064a21a28ab48378b4aaf/html5/thumbnails/5.jpg)
If You Choose a Managed Database Service
Power, HVAC, net
Rack & stack
Server maintenance
OS patches
DB s/w patchesDatabase backups
App optimization
High availability
DB s/w installs
OS installation
you
Scaling
![Page 6: 2016 Utah Cloud Summit: RDS](https://reader035.vdocuments.us/reader035/viewer/2022062523/587064a21a28ab48378b4aaf/html5/thumbnails/6.jpg)
Amazon RDS Databases
Amazon Aurora
![Page 7: 2016 Utah Cloud Summit: RDS](https://reader035.vdocuments.us/reader035/viewer/2022062523/587064a21a28ab48378b4aaf/html5/thumbnails/7.jpg)
RDS What’s New?
• Larger storage and IOPS• Increased maximum storage to 6 TB for MySQL,
PostgreSQL, and Oracle and to 4 TB for SQL Server• Increased provisioned IOPS to 20K for SQL Server• Higher performance and storage of more data
• HIPAA Eligibility/BAA Inclusion for RDS MySQL and Oracle
![Page 8: 2016 Utah Cloud Summit: RDS](https://reader035.vdocuments.us/reader035/viewer/2022062523/587064a21a28ab48378b4aaf/html5/thumbnails/8.jpg)
RDS What’s New?
• Support for MariaDB in RDS• Fully managed service in all public AWS regions, allows more
choices for our customers• Share unencrypted snapshots between accounts
• Useful for test/QA/production accounts
• Cross regions concurrent snapshot copies• Local timezone support for MySQL and MariaDB
![Page 9: 2016 Utah Cloud Summit: RDS](https://reader035.vdocuments.us/reader035/viewer/2022062523/587064a21a28ab48378b4aaf/html5/thumbnails/9.jpg)
RDS What’s New?
• Enhanced OS monitoring for Aurora, MySQL 5.6, and MariaDB
• Expanded OS level metrics
![Page 10: 2016 Utah Cloud Summit: RDS](https://reader035.vdocuments.us/reader035/viewer/2022062523/587064a21a28ab48378b4aaf/html5/thumbnails/10.jpg)
Important systems and OS metrics
User System Wait IRQ Idle
CPU Utilization
Rx per declared ethn Tx per declared ethn
Network
Num processes Num interruptible Num non-interruptible Num zombie
Processes
Process ID Process name VSS Res Mem % consumed CPU % used CPU time Parent ID
Process List
MemTotal MemFree Buffers Cached SwapCached Active Inactive SwapTotal SwapFree Dirty Writeback Mapped Slab
MemoryTPS Blk_read Blk_wrtn read_kb read_IOs read_size write_kb write_IOs write_size avg_rw_size avg_queue_len
Device IO
Free capacity Used % Used
File System
![Page 11: 2016 Utah Cloud Summit: RDS](https://reader035.vdocuments.us/reader035/viewer/2022062523/587064a21a28ab48378b4aaf/html5/thumbnails/11.jpg)
Integrations with 3rd party tools
![Page 12: 2016 Utah Cloud Summit: RDS](https://reader035.vdocuments.us/reader035/viewer/2022062523/587064a21a28ab48378b4aaf/html5/thumbnails/12.jpg)
MySQL-compatible relational database
Performance and availability of commercial databases
Simplicity and cost-effectiveness of open source databases
Delivered as a managed service
What is Amazon Aurora?
![Page 13: 2016 Utah Cloud Summit: RDS](https://reader035.vdocuments.us/reader035/viewer/2022062523/587064a21a28ab48378b4aaf/html5/thumbnails/13.jpg)
Aurora at a glance
AZ 1 AZ 2 AZ 3
Amazon S3
MasterRead
ReplicaRead
ReplicaRead
ReplicaRead
Replica
Massively scale-out storage distributed across 3 AZs
![Page 14: 2016 Utah Cloud Summit: RDS](https://reader035.vdocuments.us/reader035/viewer/2022062523/587064a21a28ab48378b4aaf/html5/thumbnails/14.jpg)
Perfect fit for enterprise workload
6-way replication across 3 data centers Failover in less than 30 secs Near instant crash recovery
Up to 500 K/sec read and 100 K/sec write 15 low latency (10 ms) Read Replicas Up to 64 TB DB optimized storage volume
Instant provisioning and deployment Automated patching and software upgrade Backup and point-in-time recovery Compute and storage scaling
Performance and scale
Enterprise class availability
Fully managed service
![Page 15: 2016 Utah Cloud Summit: RDS](https://reader035.vdocuments.us/reader035/viewer/2022062523/587064a21a28ab48378b4aaf/html5/thumbnails/15.jpg)
Perfect fit for more
1) All MySQL applications. Aurora is MySQL 5.6 compatible 2) Customers wanting high performance and availability at a cost efficient price point 3) High traffic websites using a relational database as the backend 4) Read or read/write intensive databases 5) Customers needing more storage - up to 64TB with Aurora
![Page 16: 2016 Utah Cloud Summit: RDS](https://reader035.vdocuments.us/reader035/viewer/2022062523/587064a21a28ab48378b4aaf/html5/thumbnails/16.jpg)
Amazon Aurora
Aurora is architected for the cloudMany technical advantages over MySQL
• No over-provisioning of storage needed• Storage provisioned automatically• Pay only for storage you use• Six copies of data spread across 3 AZs
• Up to 5x the throughput of standard MySQL• Fraction of the cost of commercial databases• Aurora Replicas (up to 15) used for read AND failover
![Page 17: 2016 Utah Cloud Summit: RDS](https://reader035.vdocuments.us/reader035/viewer/2022062523/587064a21a28ab48378b4aaf/html5/thumbnails/17.jpg)
What new in Aurora land
Encryption at rest
Enhanced monitoring
New region launches• Tokyo (others coming soon)
![Page 18: 2016 Utah Cloud Summit: RDS](https://reader035.vdocuments.us/reader035/viewer/2022062523/587064a21a28ab48378b4aaf/html5/thumbnails/18.jpg)
Migrating from MySQL to Aurora
• Console migration for RDS MySQL 5.6 migration• Can also use dump and load; replication• Database Migration Service
• If you want to consolidate many MySQL databases into one Aurora instance
• If you want to split MySQL into multiple Aurora instances• If you want to use a managed service to capture ongoing
changes
![Page 19: 2016 Utah Cloud Summit: RDS](https://reader035.vdocuments.us/reader035/viewer/2022062523/587064a21a28ab48378b4aaf/html5/thumbnails/19.jpg)
Migrations from Other Engines to Aurora
• Use Schema Conversion Tool to do an assessment• Migration is easiest if not deeply entrenched in engine
specific stored procedures, triggers and data types, • Use Database Migration Service to move data• May be easier to move from outside cloud to AWS RDS
on same engine, and then migrate to Aurora
![Page 20: 2016 Utah Cloud Summit: RDS](https://reader035.vdocuments.us/reader035/viewer/2022062523/587064a21a28ab48378b4aaf/html5/thumbnails/20.jpg)
• 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 AWS EC2 or RDS
AWSDatabase Migration
Service
![Page 21: 2016 Utah Cloud Summit: RDS](https://reader035.vdocuments.us/reader035/viewer/2022062523/587064a21a28ab48378b4aaf/html5/thumbnails/21.jpg)
CustomerPremises
Application Users
AWS
Internet
VPN
Start a replication instance
Connect to source and target databases
Select tables, schemas or databases
Let the AWS Database Migration Service create tables, load data and keep them in sync
Switch applications over to the target at your convenience
Keep your apps running during the migration
![Page 22: 2016 Utah Cloud Summit: RDS](https://reader035.vdocuments.us/reader035/viewer/2022062523/587064a21a28ab48378b4aaf/html5/thumbnails/22.jpg)
• Migrate off Oracle and SQL Server
• Move your tables, views, stored procedures and DML to MySQL, MariaDB & Amazon Aurora
• Highlight where manual edits are neededAWS
Schema Conversion Tool
![Page 23: 2016 Utah Cloud Summit: RDS](https://reader035.vdocuments.us/reader035/viewer/2022062523/587064a21a28ab48378b4aaf/html5/thumbnails/23.jpg)
Summary
• RDS continues to add value and features • Amazon Aurora is the relational database that is
architected for the AWS cloud• The Database Migration Service can assist you in
migrating from on prem, EC2 or RDS databases
![Page 24: 2016 Utah Cloud Summit: RDS](https://reader035.vdocuments.us/reader035/viewer/2022062523/587064a21a28ab48378b4aaf/html5/thumbnails/24.jpg)
Thank You!