How can a world-leading multimedia content producer migrate Oracle to Amazon EC2 with minimal downtime while also reducing licensing costs? In this blog post, we discuss how we saved o...
Why migrate Oracle to AWS RDS or EC2?
Companies around the world have relied on Oracle Database for their data for many years. AWS documentation highlights several different methods to migrate Oracle to AWS. In addition, AWS published a white paper titled Strategies for Migrating Oracle Databases to AWS last updated August 2018.
Amazon Relational Database Service (Amazon RDS) for Oracle Database is the easiest way to set up, operate, and scale a highly available Oracle Database in the cloud. You can deploy multiple editions of Oracle Database, including Enterprise Edition, Standard Edition, Standard Edition 1, and Standard Edition 2, with the Bring Your Own License (BYOL) model. Amazon RDS backs up your database automatically and applies patches within the same patch set release.
Although Amazon RDS supports most Oracle Database use cases, it restricts access to some system procedures and tables that require advanced privileges. In some cases, you might want to install an Oracle Database without restricting any features, privileges, storage sizes, and IOPS.
Two examples of common features that Oracle Databases customers rely on include Data Guard and Automated Storage Management. These two features are not directly supported on RDS. For these higher workloads, we recommend that you install Oracle Database in an Amazon Elastic Compute Cloud (Amazon EC2) virtual computing environment.
Over provisioning of EC2 instances based on older CPU and memory on the original server.
We use our in-house DBMSys platform developed around data collection and analysis to capture the metrics from on-premise database servers such as IOPS, memory usage, and CPU utilization for specific period of time. Basing on this information we recommend our customers the most appropriate EC2 instance type for their system in AWS.
How to minimize downtime during the migration?
Some business situations require zero-downtime during the database migrations. The best way to accomplish this is to conduct a detailed planning and utilize the necessary data replication tools for proper execution.
These migration methodologies typically involve two components: an initial bulk extract/load and tracking the changes that occurred during the execution of the bulk step. Once these changes have been applied, you should validate the migrated data and conduct any necessary testing.
The replication process synchronizes the source and target databases and then replicates all data changes between them.
You can switch over to the database in AWS at any time because the source and target databases will always be in sync.
We consider Oracle Data Guard tool to be the most appropriate for zero-downtime migration tasks.
Please click out our white paper Best Practices for Migrating Oracle Databases to AWS EC2 instances for more information.
Determining which Database and infrastructure technology is a best fit in AWS
There are many approaches to database technology in AWS from infrastructure EC2 to managed RDS and the many flavors of database server that can be supported here.
Key here are understanding these points
- 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 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 you evaluate your current workload and direct you to the best technology in the AWS.
How can I migrate terabytes of data to the Amazon cloud?
Imagine you have a 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 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 to AWS for completing the import process.
DB Best Architects are trained to help you in configuring the Snowball Edge, in extracting and help you in completing the data transfer much faster.
Building an AWS stack with multiple layers can be time consuming and error prone
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, EC2 instances, databases, Auto-scaling groups, creating S3 buckets and uploading data, database restores and health checks.
Experts in AWS Migrations
DB Best has unique expertise and services to migrate Oracle AWS RDS or EC2. We can leverage automation tools like AWS Database Migration Service along with the Schema Conversion Tool (SCT) to help you migrate databases and applications to AWS in a short period of time. With unparalleled experience in Oracle databases, we are ready to help you develop cost-effective strategies for migrating and modernizing your application assets to AWS technologies.
We can examine your exact needs and help determine whether AWS RDS, Amazon EC2, or other AWS-based services are the best path forward.
We are the only AWS partner who can say we've migrated more databases to AWS RDS, Amazon Aurora, and Amazon Redshift than any other partner in the world using AWS Database Migration Service (DMS) and Schema Conversion Tool (SCT).
Considering a move of your Oracle data warehouse to Amazon Redshift? Learn how DB Best can use a combination of people, processes, and products for the fast and secure migration project.
The DB Best database migration team can help you take advantage of Amazon Aurora MySQL or RDS MySQL. We can move your Oracle databases from the on-premises environment into the Amazon cloud quickly and efficiently.
Are you planning to migrate Oracle to Amazon Aurora PostgreSQL or RDS PostgreSQL? We know all about database migrations to AWS and we can move your Oracle database into the Amazon cloud within a short period of time.
Manage and migrate your Oracle Data Warehouse data and applications anywhere
At DB Best, we have a set of entry-level offers to help you understand your modernization landscape and demonstrate the value of moving your Oracle workloads to AWS EC2. We can help you chose the best migration option and provide you with extended support that goes well beyond the database migration effort and covers all operational issues that may emerge when you start working with a cloud-based system.
Trust the experts with the best knowledge of AWS DMS and the Schema Conversion Tool (SCT) to help move your on-premises databases to AWS RDS, Amazon Aurora, and Amazon Redshift.
Customer Story - Oracle Migration for Global Content Provider
We have a great set of blog posts and data sheets to help you better understand our capabilities as the leader in database migration services and prove out possibilities and expertise in moving workloads to AWS EC2.
In this video blog post, we will walk through the various Oracle database connection options using the AWS Schema Conversion Tool as the source database. The AWS Schema Conversion Tool...
Reference data sheet
Reference white paper
AWS documentation highlights several different methods for migrating Oracle database data to AWS. In addition, AWS published a white paper titled Strategies for Migrating Oracle Databa...