Just lately, an organization is planning emigrate the essential software a part of its enterprise to AWS(aws dumps). This a part of the applying is a standard three-tier Internet software utilizing the Oracle database.
Everybody ought to know that knowledge have to be encrypted throughout transmission and at relaxation. The database carries 12TB of knowledge. On the identical time, the corporate hopes to cut back the corporate’s personal working prices through the use of AWS managed companies. And it solely permits to construct all main keys with the supply Oracle database by way of the interior community; nevertheless, it accommodates many binary giant community connections. Because of licensing restrictions, the native replication software of the database can’t be used.
So which database migration answer could have the least influence on software availability?
A. Arrange Amazon RDS for Amazon cases. The sub internet internet hosting the RDS database (VPC) within the digital non-public cloud has Web entry, and the RDS database is about as an encrypted read-only copy of the supply database. Use SSL to encrypt the connection between the 2 databases. Monitor the replication efficiency by observing the RDS Reproduction Lag indicator. In the course of the software upkeep window, when there isn’t any extra replication lag, flip off the native Reproduction Lag indicator to watch replication efficiency. In the course of the software upkeep window, when there isn’t any extra replication lag, shut down the native database and change the applying connection to the RDS occasion. Promote the learn duplicate to a standalone database occasion. In keeping with the database, the applying connection is switched to the RDS occasion, and the learn duplicate is promoted to an unbiased database occasion.
B. Arrange an Amazon EC2 occasion and set up the identical Oracle database software program. Use supported instruments to create a backup of the supply database. In the course of the software upkeep window, restore the backup to the Oracle database operating within the EC2 occasion. In the course of the setup of the Amazon RDS for Oracle software upkeep window, restore the backup to the Oracle database operating within the EC2 occasion. Arrange an Amazon RDS for Oracle occasion and create an import job between AWS-managed databases. After the job is accomplished, shut the supply database and join the database to the Oracle occasion, and change to the RDS occasion. Change to the RDS occasion.
C. Use AWS DMS to load and replicate datasets between the native Oracle database and the replication occasion hosted on AWS. Present an Amazon RDS Oracle occasion with Clear Information Encryption (TDE) enabled, which is configured because the goal replication occasion. Create a customer-managed AWS KMS RDS Oracle occasion with Clear Information Encryption (TDE) enabled, which is configured because the goal replication occasion. Create a customer-managed AWS KMS grasp key and set it because the encryption key for the replication occasion. Use AWS DMS duties to load knowledge into the goal RDS occasion. Within the grasp key of the applying, set it because the encryption key of the replication occasion. Use AWS DMS duties to load knowledge into the goal RDS occasion. In the course of the software upkeep window and after the load activity reaches the continuing replication section, change the database connection to the brand new database.
D. In the course of the software upkeep window, create a compressed full database backup on the native Oracle database. When performing backups, a ten Gbps AWS Direct Join connection is supplied to extend the switch pace of database backup information to Amazon S3 and shorten the upkeep window.