vBulletin Mods

The Official vBulletin Modifications Site
https://www.vbulletin.org/forum/showthread.php?t=227035

Will spliting the mysql database and files to different servers make my forum faster?
by profanitytalker
29 Oct 2009 21:15

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?

RenatoMN 31 Oct 2009 01:19

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.

profanitytalker 31 Oct 2009 08:28

Thanks RenatoMN

imported_silkroad 31 Oct 2009 09:04

Quote:

Originally Posted by profanitytalker (Post 1907973)
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.

gmerin 31 Oct 2009 19:41

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).


All times are GMT. The time now is 07:12.

Powered by vBulletin® Version 3.8.14
Copyright © 2021, MH Sub I, LLC dba vBulletin. All Rights Reserved. vBulletin® is a registered trademark of MH Sub I, LLC
Copyright ©2001 - , vbulletin.org. All rights reserved.