Register Members List Search Today's Posts Mark Forums Read

Reply
 
Thread Tools
  #1  
Old 29 Oct 2009, 21:15
profanitytalker's Avatar
profanitytalker profanitytalker is offline
 
Join Date: Nov 2006
Will spliting the mysql database and files to different servers make my forum faster?

Will splitting the mysql database and files to different servers make my forum faster or should I just upgrade to a dedicated server?

For example, I am running on vps. If I had lets say 2x 1440 ram which makes it 2880 ram and split my mysql and files into two different servers will it be better or will upgrading to 2880 ram without splitting my mysql and files a better option?
Reply With Quote
  #2  
Old 31 Oct 2009, 01:19
RenatoMN's Avatar
RenatoMN RenatoMN is offline
 
Join Date: Nov 2008
I see the upgrade to 2880 mb ram a better option.

Webserver/Database RAM comsuption is something hard to guess, and not ever equilibrated.

So if you have 2x1440, your apache/lighttpd/webserver can break 1440mb while mysql is using just 400mb or vice-versa.

With a single server, you have more flexibility: 1440+400 is 1840, still far from crashing or even slowing down the website access.
Reply With Quote
  #3  
Old 31 Oct 2009, 08:28
profanitytalker's Avatar
profanitytalker profanitytalker is offline
 
Join Date: Nov 2006
Thanks RenatoMN
Reply With Quote
  #4  
Old 31 Oct 2009, 09:04
imported_silkroad imported_silkroad is offline
 
Join Date: Dec 2003
Originally Posted by profanitytalker View Post
Will splitting the mysql database and files to different servers make my forum faster or should I just upgrade to a dedicated server?
FWIW, you can significantly increase your server performance by moving the static content (images and javascript) to an inexpensive content delivery network (CDN). We use SimpleCDN, Mirror Bucket, with satisfactory results.
Reply With Quote
  #5  
Old 31 Oct 2009, 19:41
gmerin gmerin is offline
 
Join Date: Dec 2008
impo, having a dedicated physical (not 2 vps running on the same physical box) database server is always preferable (because the database will run with as much of the live data cached in memory {disc i/o is the performance killer} as possible given the available ram) as long as you have an excellent or dedicated (ie private) network connection between the application server and the dbms server. many LAMP systems run the database and application on the same server due to costs, and because doing so permits you to not open the database to external connections (for security concerns).
Reply With Quote
Reply

Similar Threads
Thread Thread Starter Forum Replies Last Post
Add-On Releases YSLOW 1.0.3 (Make Your Forum Faster) Jack0919 vBulletin 3.7 Add-ons 448 05 Jul 2015 17:17



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

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


New To Site? Need Help?

All times are GMT. The time now is 01:24.

Layout Options | Width: Wide Color: