Online storage for database.

[xianaier]

I have an idea for project I wanted to play with. The site I will host on a VPS I have running a few other test/dev sites. I have mysql installed on this machine already. For this new project idea though, I will need much more storage than my VPS has and upgrading the vps to get more storage isn't really an option.

As such, I was curious if it might be possible to use some online storage server (or maybe just my home server's hard drive) and mount a directory using NFS or similar to store the database. Would this work for MySQL? Would the performance be too poor working over an internet connection?

Would this be viable at all? It doesn't have to be super fast for testing, but it needs to be somewhat reasonable reasonable (ie, not taking several minutes to update or select from the db).

Or perhaps there is another option available I could consider?

Thanks

[Henry Rose]

If you combine VPS with a offsite storage and run your database server from there, probably you will have to ensure that VPS's memory is enough to cache your queries and your indexes. If the memory is not enough, as compared to database amount, then you will be running into trouble performance wise...