archiving my db

[cleary1981]

Hi,

I have created a database that logs realtime data and stores 1440 records per day in my database. This system must log data 24hrs a day and always running. My fear now is that my db will eventually get to large. What are my options as regards archiving my data? Not sure if it relevant but I need to keep data for up to two years.

[Atli]

Hi.

How big are these logs?
If they aren't that big, 1440 records per day isn't all that much.
Two years of that would be just over a million records, right?
Do you have the space to store that?

If not, you could simply set up a second server and have that take over once the first is out of space. Depending on the software you use to populate the database, this could be as simple as swapping out the IP addresses.

You could also set up something more flexible. Like say, alternating between databases or tables, backing up and clearing the once not in use.

You could even try setting up something using replication, but that might be a bit to much.
(See MySQL :: MySQL 5.0 Reference Manual :: 16 Replication)

Depends on what you need.