From production to archive ..
Posted by:
Mike Moran
Date: September 28, 2012 09:42AM
Currently running mysql 5.1.xx (who know what precisely as it is Rackspace build) using INNODB tables exclusively.
The problem is that the original architect did not anticipate a future customer with an 11 year data retention policy. So at the 3 year mark we have a handful of
tables approaching 1TB in size.
So the question become how can I effectively peel off a years worth of data to a more long term storage without resorting to dump/restore as mgmt won't allow because it runs for more time than the downtime SLAs allow? Complicate this by the fact that once "archived" the data needs to be retrievable in less than a day.
And yes, I'm aware that I can't shrink INNODB tablespaces .. I'm just looking for a way to keep a handfull of table from needing their own SAN devices.
Thoughts?
Thanks
Subject
Views
Written By
Posted
From production to archive ..
1698
September 28, 2012 09:42AM
871
October 01, 2012 07:22PM
689
October 04, 2012 08:24AM
766
October 05, 2012 01:53AM
742
October 07, 2012 04:54PM
771
October 08, 2012 02:36AM
850
October 30, 2012 09:48AM
785
October 30, 2012 10:50AM
820
October 30, 2012 12:51PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.