We are in the process of archiving our DB since the size of the table is increasing which in turn is slowing down the application. Each table is having around 60-70 lakhs of records and the database is having records for last 4 yrs. After analyzing we have found that the past year records are not accessed frequently so we have decided to keep only 6 months of data on live DB & archive the rest.
Have gone through the pt-archiver documentation & in that it has mentioned option of
before_delete function by extending the tool to archive all dependent tables. I am completely new to perl & percona toolkit. Would like to explore this option since most of our tables are dependent on single table
Can anyone point me in direction on how to move ahead with this