PDA

View Full Version : larger file archiving



sDesign
21 Dec 2010, 04:15 PM
So I will be making an audio archive that will be ever growing. It would be convenient to store the audio in a mysql table so I could ignore a messy folder of audio clips named with arbitrary numbers (to link to tags in db), and have added security against people ripping the clips off my server. My question comes in here, would storing audio clips, potentially thousands of them at up to 16 megs a piece (medium blob), create a problem later down the road resulting in lost info from too much load? How much more difficult would it be to export backups as it grows? Any tips on large data archiving would be appreciated.

I am starting this site on a shared server (no funds to be starting dedicated), and I foresee a migration to dedicated being necessary if it booms because there will be a lot of server side processing. I want to avoid any problems during migration because downtime could cost this project its success especially at the pivotal time that migration would be necessary.

running MySQL 5.0.91 with phpMyAdmin 3.2.4

Thanks in advance