management

[Brendan]

Lets say i have a website where users can upload their songs. Each time you upload a song, it assigns values to a table on a mysql database. Now lets say the mp3's are uploaded to a server, which is now nearly full. So i buy another server, and now i make all the new files that the users upload go on the new server.

The problem is, How do i detect which file is on which server? Should i assign a value to each entry in the mysql database, and depending on the value look on that server, or is there a more practical way.

the table looks like this:
|bandname|songname|filename|server|
|name...|Song name..|1_song.mp3|1_|

[liquorvicar]

upgrade your original server with a bigger hard drive?

[AstroTeg]

It doesn't sound like a bad idea to keep track of which server the file is loaded on. I can't really see how else you'd do it unless you want to try doing something like putting the server info into the file name. But that would make it more difficult to query.

[Brendan]

Well, upgrading to a bigger hardrive isnt practicle since they can only get so big, and i was just wondering if this is the method most of the big mp3 and image hosts do it. And i'm not sure if you could link up servers together, but if thats how its usually done that may not work since i might have multiple hosts.

Thanks,
-Brendan