Home / Companies / Tessell / Blog / Post Details
Content Deep Dive

6 Step MySQL Migration from RDS to Tessell using DMS

Blog post from Tessell

Post Details
Company
Date Published
Author
Priyank Parikh
Word Count
1,362
Language
English
Hacker News Points
-
Summary

Customers move from MySQL RDS to Tessell for enhanced performance with NVMe, native backup capabilities, and instance-based pricing. AWS Database Migration Service (AWS DMS) facilitates this transition through a structured six-step process, which includes configuring both the source MySQL RDS and the target Tessell MySQL databases, testing connectivity, setting up a DMS instance, migrating schemas, and creating migration tasks. The process involves careful configuration of database parameters, provisioning of instances, and the establishment of network connections, such as VPC peering if needed. Once the databases are configured, AWS DMS is used to create and start migration tasks, which can either be a one-time migration or continuous replication using change data capture (CDC). Advanced settings in DMS allow for customization of migration tasks, such as table mapping and load tuning, and validation options ensure data integrity. The migration time varies depending on the data size, and tools like CloudWatch can be used to monitor the migration process, while partial migrations are possible by specifying specific schema tables to be transferred.