How AWS Database Migration Service enables ... - Percona

1 2016, Amazon Web services , Inc. or its Affiliates. All rights 26, 2017 How AWS Database Migration Service enables Database freedomAWS Database Migration Service (DMS) and AWS Schema Conversion Tool (SCT)Eran Schitzer, Product Management, Amazon Web ServicesSamples and can I get to the cloud?How will my on-premises data migrate to the cloud?How can I make it transparent to my users?Afterwards, how will on-premises and cloud data interact?How can I integrate my data assets within AWS?Can I get help moving off of commercial databases?Can I move data out? Migration used to be cost + complexity + timeCommercial data Migration and replication softwareComplex to set up and manageApplication downtimeDatabase-engine-specific application codeWhatare DMS and SCT?

2 AWS Database Migration Service (DMS) easily and securely migrates and/or replicate your databases anddata warehouses to AWSAWS Schema Conversion Tool (SCT) converts your commercial Database and data warehouse schemas to open-source engines or AWS-native services , such as Amazon Aurora and Redshift Whento use DMS and SCT? ModernizeMigrateReplicateWhento use DMS and SCT? ModernizeModernizeyour Database tierModernizeyour Data WarehouseAmazon AuroraAmazon RedshiftSCT helps with converting tables, views, and codeSequencesUser-defined typesSynonymsPackagesStored proceduresFunctionsTriggersSchemasTables IndexesViewsSort and distribution keysSCT guidanceWhento use DMS and SCT?

3 Migrate Migratebusiness-critical applications Migratefrom Classic to VPC Migratedata warehouse to Redshift Upgradeto a minor version Consolidateshards into AuroraSources:Ta r g e t s :Amazon Dynamo DBAmazon RedshiftAmazon S3 Amazon AuroraWhento use DMS and SCT? Replicate Createcross-regions Read Replicas Runyour analytics in the cloud Keepyour dev/test and production environment syncNewSCT Data ExtractorsExtract Data from your data warehouse* and migrate to Amazon Redshift Extracts through local Migration agents Data is optimized for Redshift and Saved in local files Files are loaded to an Amazon S3 bucket (through network or Amazon Snowball) and then to Amazon RedshiftAmazon RedshiftAWS SCTS3 Bucket* 1strelease supports Oracle v11 and up and Teradata v14 and upWhyuse DMS and SCT?

4 SecureCost EffectiveRemove Barriersto EntryAllow DBFreedomKeep a Leg inthe CloudEasy to Use, 2016, Amazon Web services , Inc. or its Affiliates. All rights customers are saying about us?Our saying Whatabout DMS and SCT?"We migrated hundreds of our clients from our in-house data-center to Amazon RDS Oracle 12c using the AWS Data Migration Service (DMS). Due to this Service , we could live-replicate the databases between our data-center and RDS before the Migration . That kept the Migration down-time to the very minimum. We are very happy with DMS and are planning to use it for Oracle to MySQL Migration next.

5 The SCT Assessment Report was the key enabler to allow us to understand the scope of effort required to complete an Oracle to PostgreSQL Migration . What was originally thought to be a largely manual task that no one was particularly excited about having to do became a very straight-forward quick and easy process." We are in the process of migrating some databases to Amazon Aurora. The ease by which we can do this using the AWS Database Migration Service has simplified this process for us and enabled us to accelerate our Migration efforts. The ability to closely monitor the process, the detailed logging feature, and the support we received from AWS have given us a great deal of confidence in a successful Migration .

6 Heterogeneous MigrationOracle private DC to RDS PostgreSQL migrationUsed the AWS Schema Conversion Tool to convert their Database schemaUsed on-going replication (CDC) to keep databases in sync until they reached the cutover windowBenefits: Improved reliability of the cloud environment Savings on Oracle licensing costs SCT Assessment Report let them understand the scope of the migrationScale Up MigrationRDS MySQL to Amazon Aurora MigrationUsed DMS with on-going replication (CDC) to migrate the dataBenefits: Aurora handles their larger data storage requirements. Per regulations they are storing 120 TB of data for 2 years Reduced cost and improved performance when compared to large MySQL instancesHomogeneous MigrationRDS MySQL on EC Classic to VPCD atabase ran an end-user application so could not take downtime70 RDS instances have been migratedBenefits.

7 Leveraging CDC, they could decrease outage per Database to less than 5 mins 70 RDS instances have been seamlessly migratedSplit Migration35 million members on it s siteMany interdependent applications built over the last 15 years with unique High IOPS requirementsMigration from legacy cloud Service to AWSC ombination of Migration to MySQL on EC2 and Amazon AuroraBenefits: DMS reduced the time required to migrate our databases by 40 percent Realized 55 percent cost savings by moving some db sto Amazon Aurora 2016, Amazon Web services , Inc. or its Affiliates. All rights Database Migration partners 2016, Amazon Web services , Inc.

8 Or its Affiliates. All rights does it work? Database Migration processStep 1: Convert or Copy your SchemaSource DB or DWAWS SCTN ative ToolDestination DB or DWStep 2: Move your dataSource DB or DWAWS SCTD estination DB or DWAWS DMSC ustomerpremisesApplication usersAWSI nternetVPNS tart a replication instanceConnect to source and target databasesSelect tables, schemas, or databases Let AWS DMS create tables, load data, and keep them in sync Switch applications over to the target at your convenienceKeep your apps running during the migrationAWSDMSM ulti-AZ option for high availability Customerpremises or AWSAWSI nternetVPNAWS DMSAWS DMSLoad is table by tableReplication instanceSourceTargetChange data capture (CDC)

9 And applyReplication instanceSourceTargetUpdatet1t2t1t2 TransactionsChange apply after bulk loadSourceTargetWhat else can I do?SourceSourceReplication instanceWhat else can I do?TargetSourceTargetTargetReplication instanceSourceTake it all or notTargetReplication instanceHomogenous or heterogeneousSQL ServerMySQLO racleOracleOracleAuroraWarehouses as wellAmazon RedshiftSchema Conversion ToolS3 Bucket 2016, Amazon Web services , Inc. or its Affiliates. All rights and 2016, Amazon Web services , Inc. or its Affiliates. All rights fine printOther Database Migration use casesMigration of business-critical applicationsMigration from Classic to VPCC heap Read Replicas for OracleRead Replicas for other enginesCross-region Read Replicas for Oracle and SQL ServerAnalytics in the cloudDev/test and production environment syncOngoing replication for BIMinor version upgradeSources for AWS Database Migration Service Customers use the following databases as a source for data Migration using AWS DMS: On-premises and Amazon EC2 instance databases.

10 Oracle Database 10g 12c Microsoft SQL Server 2005 2014 MySQL MariaDB (MySQL-compatible data source) PostgreSQL SAP ASE +RDS instance databases: Oracle Database 11g 12c Microsoft SQL Server 2008R2 2014. CDC operations are not supported yet. MySQL versions MariaDB (MySQL-compatible data source) PostgreSQL Amazon Aurora (MySQL-compatible data source)Targets for AWS Database Migration Service Customers can use the following databases as a target for data replication using AWS DMS:On-premises and EC2 instance databases: Oracle Database 10g 12c Microsoft SQL Server 2005 2014 MySQL MariaDB (MySQL-compatible data source) PostgreSQL SAP ASE +RDS instance databases.