Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I have an AWS RDS MySQL DB.

I have ec2 instances and an s3. What I would like to do is only retain 60days old data and archive the rest.

I'm still new at this so I'm not really sure what to do. What is the simplest way of achieving this?

I'm planning to start from a simple strategy first and then improve my way from there. I know there are a lot of ways in doing this but with my limited knowledge I would prefer the simplest way.

share|improve this question
    
You want to archive data from all tables or from some specific table ? –  Abdul Manaf Mar 6 at 5:21
    
For specific tables only. Any ideas? –  Ragu Diaz Mar 6 at 5:29
    
Do you have timestamp field on those table ? Does your tables have Foreign Key Relationships ? –  Abdul Manaf Mar 6 at 5:31
    
Yes sir. They have timestamps and foreign key relationships. –  Ragu Diaz Mar 6 at 6:14
    
check out pt-archiver –  akuzminsky Mar 6 at 14:47
show 1 more comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.