vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=15)
-   -   Will spliting the mysql database and files to different servers make my forum faster? (https://vborg.vbsupport.ru/showthread.php?t=227035)

profanitytalker 10-29-2009 07:15 PM

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?

RenatoMN 10-30-2009 11:19 PM

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 10-31-2009 06:28 AM

Thanks RenatoMN

imported_silkroad 10-31-2009 07:04 AM

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 10-31-2009 05:41 PM

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 03:40 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01365 seconds
  • Memory Usage 1,717KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (5)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete