Hi all, I am tossing up with converting from database attachment storage to file based.
My setup is a VPS running NGINX via Centminmod I am just moving to this server as my forum is growing but part of the process I am considering changing to file based storage of attachments.
Some reasons I can see for the move -
1) Database size will only be 200mb's if the attachments are moved to the file system so database backups /restorals are much faster.
2) For disaster recovery I can afford to make more regular backups of the database and then less regular of the file storage so say database backups every two days and file structure every week as I can afford to loose a few attachments vs a weeks worth of posts.
So for other people with alot of attachments and big ones what do you think is best File or DataBase storage and can you think of any pros / cons for and against?
Some other questions -
1) I know you can move from database to file quite easily but what happens to all the posts that have images embedded in them?
2) If I go to file storage and then want to go back to database is this possible and again what happens with the existing posts?
My setup is a VPS running NGINX via Centminmod I am just moving to this server as my forum is growing but part of the process I am considering changing to file based storage of attachments.
Some reasons I can see for the move -
1) Database size will only be 200mb's if the attachments are moved to the file system so database backups /restorals are much faster.
2) For disaster recovery I can afford to make more regular backups of the database and then less regular of the file storage so say database backups every two days and file structure every week as I can afford to loose a few attachments vs a weeks worth of posts.
So for other people with alot of attachments and big ones what do you think is best File or DataBase storage and can you think of any pros / cons for and against?
Some other questions -
1) I know you can move from database to file quite easily but what happens to all the posts that have images embedded in them?
2) If I go to file storage and then want to go back to database is this possible and again what happens with the existing posts?
Comment