Company
Date Published
Author
Aditya Shajil
Word count
1566
Language
English
Hacker News points
None

Summary

The migration from RDS MySQL to SingleStore Helios was successful, completing in under nine hours, despite the application downtime requirements of less than 24 hours. The company MarTech had strict migration requirements due to its highly OLTP-based workload, and they chose a weekend with lower-than-normal app traffic to minimize downtime. A combination of in-house features and third-party tools, such as Arcion, was used to streamline the migration process. The migration involved transferring data from four RDS instances into SingleStoreDB Cloud, utilizing a combination of columnstore tables and rowstore tables for optimal performance. The cluster was scaled up to S-256 to accommodate the parallel replication process, reducing overall migration time. After validation, the SingleStoreDB cluster was scaled down to its original size, and scripts were run to sync auto-increment values and drop replicate-created tables. The results showed a 95,000% performance improvement in single query execution and a 15x total performance improvement at peak application concurrency. Additionally, there were significant cost of ownership savings.