Senior Product Engineer

Hey all, I need some suggestions in creating a replica of our RDS DB for reporting and analytical purposes. Cost is a major factor. I was thinking of using AWS Glue to move data from Amazon RDS to Amazon S3 and use Amazon Athena to run queries on it. Any other suggestions would be appreciable.

READ LESS
2 upvotes17.4K views
Replies (1)
Machine Learning Engineer at Onefootball

If cost is a major factor, I suggest to either A) look at open source tools that you can run on compute you already pay for or B) use AWS services within the free tier.

For option A), check out singer taps and targets. For option B) check out the AWS DBMS (Database Migration Service). It's make for replicating data and your use case is described here https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Target.S3.html

READ MORE
Using Amazon S3 as a target for AWS Database Migration Service - AWS Database Migration Service (docs.aws.amazon.com)
3 upvotes145 views
Avatar of Punith Ganadinni

Punith Ganadinni

Senior Product Engineer