The tag has no wiki summary.

learn more… | top users | synonyms

0
votes
0answers
1 views

Archiving data from logging db (high writes, no reads)

I have a logging database into with a few lookup tables and one massive event table that has 79 million rows. On busy days my code inserts over 3 million rows, so the event table would be enormous in ...
0
votes
0answers
7 views

MySQL: Archival How to?

I would like to know the correct Archival Strategy for my DB Schema. We are using Mysql 5.5. Here is the full scenario: We have around 35 tables in DB out of which 10 would be transactional in ...
0
votes
0answers
34 views

how to archive old entries from mysql on rds

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 ...
1
vote
1answer
173 views

How does Postgres know which logs have been archived?

I'm asking this because Postgres was hard-stopped yesterday, and I fear that there could be partial / corrupt data in one of my archived log segments. I'd like to simply delete the logs from my slave ...
0
votes
0answers
91 views

Tape rotation strategies

I am trying to find a tape rotation strategy that would be optimal under the following conditions: Backup Media Rotation strategy should support the following: Media Archives required ...
0
votes
3answers
148 views

Using MySQL InnoDB as an Archive

My site has a main MySQL InnoDB table that it does most of its work on. New rows get inserted at a rate of 1 million per week, and rows older than a week gets moved over to an archive table on a daily ...
0
votes
2answers
688 views

Delete and archive old data from several related tables

Our schema looks like this: table tblTrip: stores start and end trip date and time table tblTripData: keeps all the trip data table tblTripEvent: stores events related to the particular trip. Then ...
1
vote
3answers
180 views

Design for archiving a sorted list (with ability for a few INSERT)

I have a somewhat static sorted list of words which I want to save in a database table: -- simplified! -- Note: the rank/order of each item is NOT calculable from other values! CREATE table words ( ...
2
votes
2answers
160 views

Support ticket system - when/how to move old tickets?

I don't have access to the partitioning feature, but consider a support ticket system with tens of thousands of tickets being opened everyday and taking about a week to a couple of months in getting ...
2
votes
1answer
474 views

Archive database on Postgres

I have a table with more than 60mio records, where every month I have to add about 2-4 milions. It's not insert only table, I need to read from it and update recently added rows (status changes, ...
7
votes
1answer
953 views

Database archive solutions

In continuation to a question posted by me on Is it a good idea to move high-volume and highly-accessed tables to a separate database?, am looking out for different techniques/solutions available for ...
1
vote
1answer
492 views

Data archival strategy that handles schema changes?

I am working with a legacy application that has about ten years of customer data. A majority of this data is not used in day-to-day operations but there is a business requirement to have the data ...