Migrating from a Relational Database to DynamoDB

Log in to the provided bastion host:

ssh cloud_user@<BASTION_PUBLIC_IP>

Then, connect to the source database:

mysql -h <SOURCE_DATABASE_PUBLIC_IP> -u cloud_user -pbettertogether employees

Note: There's no space between the -p parameter and the password bettertogether.

With the information gathered from the source database, design your data model with consideration for the provided access patterns. Map this data model to the DynamoDB table partition/sort keys, as well as any local or global secondary indexes. Then, create DMS task mapping rules to map the data from the source database to your DynamoDB table.

References

• The data model shown in our solution video is available at this link
• DMS Task Mapping Rule Reference

Navigate to the DynamoDB web console and create a DynamoDB table called employees. Additionally, you will need to create three local secondary indexes called Fullname, hire_date, and title_from_date, as well as a global secondary index with a partition name of title and a sort key of salary_to_date.

Navigate to the Database Migration Service web console and create a new task using the mapping rules you created, and set the task to start automatically.

Once the DMS task has completed, navigate to the DynamoDB web console and test that you have satisfied the requested access patterns.

You will need to satisfy the following access patterns:

1. Search the table for all employees in the Development department with the title Senior Engineer and only include their most recent salary.
2. Get all information about an employee in the Production department with the Fullname Hercules Benzmuller.
3. Get information on all employees in the Production department hired between January 1, 1999 and January 1, 2001. Filter this data so there are no duplicate records.
4. Get information on all employees in the Development department that had a title change in the 6 months before January 1, 2001. Filter this data so there are no duplicate records.
5. Get information on all employees with the title Engineer and return only records that show their most recent salary date.