0
votes
0answers
322 views

Best practices to handle very large databases

The problem: Our new project aims to use a very...very large database. Basicly ~one million of new records have to be stored per month. This requirement gives to the enterprise application a very big ...
1
vote
2answers
5k views

How can I put mysql databases in different disk partitions (linux - Ubuntu)? [duplicate]

Possible Duplicate: multiple file systems for mysql hi, How can I put mysql databases in different partition (linux - Ubuntu)? Thanks, yosef
0
votes
4answers
62 views

back-up database in Linux partition from windows partition!

Hello I am in a very embarrassing situation, I was trying to upgrade to ubuntu 10.04 from ubuntu 9.10 yesterday and while updating I forgot to put my laptop on charger and the battery ran out. Since ...
0
votes
3answers
201 views

Splitting a MySQL DB in two may ease server from “Too many connetions”? I don't think so

I was requested to split a MySQL in two, it's kind of a horizontal partition, in which some rows correspond to one site, and some other correspond to another site. But they want to split it in two DBs ...
0
votes
2answers
268 views

SQL Server Partial Backups

We currently distribute snapshots of our database to our stores by using rdiff on compressed backups of the entire database. In order to optimize how long it takes to both create these backups, and ...