data and analytics requirements Accelerated rate of change driven by DevOps Data grows 10x every 5 years driven by network- connected smart devices Microservices architecture decreases need for “one size fits all’ databases and increases need for real-time monitoring and analytics Dev Ops Transition from IT to DevOps increases rate of change
setup and data replication for high availability Capacity planning, and scaling clusters for compute and storage Managing databases on-premises: Time-consuming and complex
and building new applications, not managing infrastructure AWS Self-managed Fully managed Schema design Query construction Query optimization Automatic failover Backup and recovery Isolation and security Industry compliance Push-button scaling Automated patching Advanced monitoring Routine maintenance Built-in best practices
a choice of six popular database engines Easy to administer Available and durable Highly scalable Fast and secure No need for infrastructure provisioning, installing, and maintaining DB software Automatic Multi-AZ data replication; automated backup, snapshots, failover Scale database compute and storage with a few clicks with no app downtime SSD storage and guaranteed provisioned I/O; data encryption at rest and in transit
incomplete data Discover and organize data 7 Rs Applications Performance Infrastructure Level of effort Retire Retain Relocate Rehost Repurchase Re-platform Refactor Tribal knowledge SLA/OLA App configuration data Asset inventories CMDB Architecture Performance Information Automation and guidance AWS Application Discovery Service Amazon Athena
and pilot ASSESSMENT ANALYSIS AND PILOT WORKLOAD MIGRATIONS Directional business case Rapid discovery Landing zone Skills/CoE Discovery & planning Migration expertise Migration business case Migration plan Migrate Integrate Test Transform Monitor Optimize
• Full control over the environment • COTS applications • For database servers • All features available • All versions supported • Full administrative access Amazon EC2
tooling to convert schemas between databases and data warehouses Native tooling Migration options included with the engine Open source Ora2Pg and others Commercial Attunity, Golden Gate, Informatica, Talend, and others Benefit • Automates schema conversion including database structure and code • Minimizes manual effort of performing a schema re-write • Allows conversion from commercial to open source platforms Benefit • Leverage a familiar environment • Full support for native features Benefit • Tailored solution for a specific problem • Multiple tools can offer a more complete solution than any one product • Free Benefit • Commercial solutions are available for a wide range of migration sources and targets including legacy mainframe systems AWS DMS Database migration and replication managed service Benefit • Easily and securely migrate and/or replicate your databases and data warehouses to AWS • Migrate between different database engines • Low cost and global availability
Database Migration Service (AWS DMS) easily and securely migrates and/or replicates your databases and data warehouses to AWS AWS Schema Conversion Tool (AWS SCT) converts your commercial database and data warehouse schemas to open-source engines or native AWS services, such as Amazon Aurora and Amazon Redshift Modernize Migrate Replicate
rights reserved. AWS Schema Conversion Tool (AWS SCT) • Client-side tool • Database schema and code conversion service • OLTP schema or data warehouse schema • Converts embedded SQL statements too • Creates a conversion report • Helps choose the best target engine
rights reserved. AWS SCT Assessment Report • Assessment of migration compatibility of source databases with open-source database engines – RDS MySQL, RDS PostgreSQL and Aurora • Recommends best target engine • Provides details level of efforts to complete migration
Source DB or DW AWS SCT Native tool Destination DB or DW Step 2: Move your data Source DB or DW AWS SCT Destination DB or DW AWS DMS Copy or convert Copy DB DW
Instance • Connect to Source & Destination • Select Tables, Schemas or Databases Keep your apps running during the migration AWS Database Migration Service • Let DMS create tables, load data, and keep them in sync • Switch applications to new target at your convenience
rights reserved. General Workflow—Full Load + CDC • Migrate schema with SCT • Drop all FK constraints/indexes on target • Initiate full load using DMS • Stop task (can do this automatically with task settings) • Create secondary indexes • Resume task to apply cached changes • Enable foreign keys • Start change data capture
your migration • Topic-by-topic overview of how to migrate databases and data warehouses to AWS services • Covers all proprietary features and the different database objects • Migration best practices • Oracle to Aurora PostgreSQL • SQL Server to Aurora MySQL • SQL Server to Aurora PostgreSQL • Oracle to Aurora MySQL • Cassandra to DynamoDB, data warehouses to Amazon Redshift, and Db2 LUW to Aurora PostgreSQL AWS SCT AWS DMS Playbook Schema Data Best practices
training courses cover topics and services related to relational and nonrelational databases Resources created by the experts at AWS to help you build and validate database skills Validate expertise with the AWS Certified Database – Specialty exam The classroom offering, Planning and Designing Databases on AWS, features AWS expert instructors and hands-on activities Visit the databases learning path at aws.amazon.com/training/path-databases