Showing entries 1 to 1
Displaying posts with tag: archive Terabytes of data in few seconds (reset)
How to Archive Terabytes of data in few seconds

If a table is partitioned then that makes it easy to maintain. Table has grown so huge and the backups are just keep running long then probably you need to think of archival or purge.

Purge the data if you don't want data from old partitions just by doing truncate or drop of those partitions which completes momentarily without locking the table for a long time

Archival can be done couple of ways.
We can take mysqldump (preferably from a slave) with a where condition to filter out the data you don't want to copy. And then import the dump file to archive database. check this link out for mysqldump with where clause .. and once data is copied, the old partition can be truncated.

[Read more]
Showing entries 1 to 1