Register Members List Search Today's Posts Mark Forums Read

Reply
 
Mod Options
  #1  
Old 14 Mar 2006, 00:25
Kevlar's Avatar
Kevlar Kevlar is offline
 
Join Date: Nov 2001
Question Attachments

How do large boards handle attachments? Right now I have about 7GB of attachments in my file system. I was just curious how others deal with this issue. Especially if you have more than one web server...
__________________
KEVLAR
www.bimmerforums.com
Reply With Quote
Comments
  #2  
Old 14 Mar 2006, 00:26
Xenon's Avatar
Xenon Xenon is offline
 
Join Date: Oct 2001
Real name: Stefan Kaeser
We have about 1.5 GB in the DB, but i do get the feeling, that we should change that.....

during the normal process that's not a problem but during upgrades that table is most of the time responsible for the timeouts
__________________
Unfortunatelly i am completely out of vbulletin buisness, so i won't upgrade any of my hacks anymore. Everyone who wants to upgrade my hacks or use part of my codes is allowed to do so, without needing any special permission by me anymore. You just have to mention my full name if you want to reuse some of my work, thats all i ask for.
Reply With Quote
  #3  
Old 14 Mar 2006, 00:28
Erwin's Avatar
Erwin Erwin is offline
 
Join Date: Jan 2002
I have attachments on a separate server with some minor hacks to the attachment php files and templates.
Reply With Quote
  #4  
Old 14 Mar 2006, 00:47
Paul M's Avatar
Paul M Paul M is offline
 
Join Date: Sep 2004
Real name: Paul M
Anyone with more than a few hundred MB of attachements should move them out of the DB and into the file system. Personally I would always use the file system anyway, I don't think attachments belong in the database (the only time it's useful to have them in the DB is when moving server)
__________________

Cable Forum
Please do not PM me about custom work - I no longer undertake any.
Note: I will not answer support questions via e-mail or PM - please use the relevant thread or forum.
Reply With Quote
  #5  
Old 14 Mar 2006, 00:48
Kevlar's Avatar
Kevlar Kevlar is offline
 
Join Date: Nov 2001
Originally Posted by Erwin
I have attachments on a separate server with some minor hacks to the attachment php files and templates.
I guess... the next question would be, how did you come across those minor hacks to allow you to run the attachments from a different server? :surprised:
__________________
KEVLAR
www.bimmerforums.com
Reply With Quote
  #6  
Old 14 Mar 2006, 01:39
AdminNation's Avatar
AdminNation AdminNation is offline
 
Join Date: Mar 2006
Originally Posted by Kevlar
I guess... the next question would be, how did you come across those minor hacks to allow you to run the attachments from a different server? :surprised:
Given some of the hacks he's released, its pretty safe to assume that he meant that he figured out how to mod the files accordingly. There is no publically released hack that tells you how to do it.
Reply With Quote
  #7  
Old 14 Mar 2006, 12:42
Trigunflame's Avatar
Trigunflame Trigunflame is offline
 
Join Date: Aug 2002
Real name: Dusty Burns
http://mysqldump.azundris.com/archiv...-Database.html

This is a very good read for anyone that would like more "exact" information on why Files stored in Database for a busy site is not a good idea; as well as a compromise.

Keep the master storage in the Database, while providing a local cache in the file system.
Reply With Quote
  #8  
Old 15 Mar 2006, 21:35
Erwin's Avatar
Erwin Erwin is offline
 
Join Date: Jan 2002
Originally Posted by Kevlar
I guess... the next question would be, how did you come across those minor hacks to allow you to run the attachments from a different server? :surprised:
It's actually easier than it looks - make sure subdomains are included in the cookie, then have an attachment server that runs a strip down vbulletin with just attachment.php, global.php and some include files, modify attachment.php, modify the attachment templates to point to the subdomain for the attachment server, and you're done.
Reply With Quote
  #9  
Old 16 Mar 2006, 01:31
Paul M's Avatar
Paul M Paul M is offline
 
Join Date: Sep 2004
Real name: Paul M
Originally Posted by Erwin
It's actually easier than it looks - make sure subdomains are included in the cookie, then have an attachment server that runs a strip down vbulletin with just attachment.php, global.php and some include files, modify attachment.php, modify the attachment templates to point to the subdomain for the attachment server, and you're done.
I would be interested to know how that is covered by the licence since you are running two copies of vb ?
__________________

Cable Forum
Please do not PM me about custom work - I no longer undertake any.
Note: I will not answer support questions via e-mail or PM - please use the relevant thread or forum.
Reply With Quote
  #10  
Old 16 Mar 2006, 02:29
who is chris c who is chris c is offline
 
Join Date: Sep 2005
well if the forum powered it all (on the backend) it wouldnt be a violation it still would be 1 copy (just not in the directory structure they supplied)
Reply With Quote
  #11  
Old 16 Mar 2006, 13:58
Kevlar's Avatar
Kevlar Kevlar is offline
 
Join Date: Nov 2001
Originally Posted by Erwin
It's actually easier than it looks - make sure subdomains are included in the cookie, then have an attachment server that runs a strip down vbulletin with just attachment.php, global.php and some include files, modify attachment.php, modify the attachment templates to point to the subdomain for the attachment server, and you're done.
Thanks for the insight... I'm going to have to try this today and see if it helps lessen the load on my primary server (as it's currently buckling).
__________________
KEVLAR
www.bimmerforums.com
Reply With Quote
  #12  
Old 16 Mar 2006, 21:23
Erwin's Avatar
Erwin Erwin is offline
 
Join Date: Jan 2002
Originally Posted by Paul M
I would be interested to know how that is covered by the licence since you are running two copies of vb ?
I run a few webservers with multiple copies of vB. But they are within the same network and for the same site - Jelsoft allows that.
Reply With Quote
  #13  
Old 19 Mar 2006, 13:39
GrCh_Jeff's Avatar
GrCh_Jeff GrCh_Jeff is offline
 
Join Date: Dec 2005
Please explain how I would do this legally? Thanx.
Reply With Quote
  #14  
Old 21 Mar 2006, 23:42
kerplunknet kerplunknet is offline
 
Join Date: Jul 2002
Originally Posted by GrCh_Jeff
Please explain how I would do this legally? Thanx.
Only one copy can be available to the public, for public use.
Reply With Quote
  #15  
Old 23 Mar 2006, 18:50
GrCh_Jeff's Avatar
GrCh_Jeff GrCh_Jeff is offline
 
Join Date: Dec 2005
would you explain this please?
But they are within the same network and for the same site - Jelsoft allows that
I want to somehow run a second server same members same site name linked to the present server for storage and upload/download uses.storage for the site.

Last edited by GrCh_Jeff; 23 Mar 2006 at 18:58.
Reply With Quote
Reply

Similar Mod
Mod Developer Type Replies Last Post
vb3 Attachments - Including Multiple Attachments Option rake vBulletin 2.x Full Releases 273 24 Sep 2006 05:10
Private Attachments! (Attachments in Private Messages) Chen vBulletin 2.x Full Releases 117 22 Jan 2004 19:35



Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Mod Options

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump


New To Site? Need Help?

All times are GMT. The time now is 16:40.

Layout Options | Width: Wide Color: