Migrate SQL Server to Amazon Aurora MySQL

There are many approaches to database technology in AWS from infrastructure EC2 to managed RDS and Aurora and the many flavors of database servers that can be supported here.

Key questions to ask:

• What is your current database and infrastructure technology and what is the appropriate match in AWS?
• What resources do you have to support your database technology in AWS? Is Aurora, RDS or EC2 the correct approach?
• What is your HA/DR approach and can it be mapped to AWS?
• What is your data Egress and Ingress and how will that affect your charges?

DB Best can help answer these questions, evaluate your current workload, and direct you to the best technology in the AWS.

We take a data-centric approach to determine which workloads are most appropriate for the cloud.  We start with data collection which gives us a profile of each workload environment such as CPU, RAM, etc. We also gather performance metrics over a period of time using our agentless DBMSys software. In Addition, we work with our customers to understand the business needs/restrictions of each workload to determine a list of potential candidates that can be moved to the cloud.

Traditionally, this means a switch from one data platform to another. However, just switching the nameplate on the back-end DB server may not be the best solution. Some data patterns and use cases may have a better fit for a NoSQL or Data Lake solution.

DB Best Architects are trained to spot these patterns and discuss with the customer another approach that may be a better fit or be able to leverage new technology such as IoT devices.

Imagine you have an 80 TB database that needs to be extracted and imported into AWS Redshift or Aurora database. Normally, it would take up to several weeks for extracting and migrating such databases over the internet. DB Best has worked with Amazon in exposing a Snowball Edge configuration option in the Schema Conversion Tool. With this feature, you can hookup a Snowball Edge device to your on-premises database, extract data and upload data to the Snowball Edge and send it back to Amazon for completing the data import process during your data warehouse migration to AWS.

DB Best Architects are trained to help you configure the Snowball Edge. We’ll also help extract and complete the data transfer much faster.

DB Best’s architects can help you in automating the entire stack creation process leveraging AWS’s CloudFormation templates using command line scripts. These scripts take few command line parameters and setup your VPC, subnets, ELB, Aurora clusters, RDS, and EC2 instances, databases, Auto-scaling groups, creating S3 buckets and uploading data, database restores and health checks.