The Arcive of Official vBulletin Modifications Site.

Tips: database on seperate dedicated server · **Released**: 03-15-2006

What are some server and vb configuration tips for those of us that have a forum database on its own seperate server?

Erwin · #2 03-15-2006, 07:32 PM

Most important tip - use the internal network IP address to connect to the db server rather than the external web IP - this will save you bandwidth since internal network traffic usually is free.

Fallback · #3 03-15-2006, 07:37 PM

Ok. I ask this because I think my setup was not done correctly. Pages are taking twice as long to be generated since switching to a setup that has the db on one dedicated box and the php files on the other. It was set up using the hosthame "mydb.myserver.com" instead of "localhost" in the vb config and not using an ip and pages are taking looong to generate and load.

Is this related to what you mention about ip?

Erwin · #4 03-15-2006, 09:25 PM

Mmm... instead of hostname, use the internal IP address. Your hostname may be linked to your external IP which may explain the slowness.

alexi · #5 03-23-2006, 03:58 AM

Quote:

Originally Posted by Erwin

Most important tip - use the internal network IP address to connect to the db server rather than the external web IP - this will save you bandwidth since internal network traffic usually is free.

Actually it's much more than the fact it is free. Running that connection on your public address OR on the same NIC card will choke your boards. I know of one case where a lot of time was put into figuring out what was wrong with a particular board and as soon as they switched to a second NIC for the private traffic all their load problems dissapeared.

kerplunknet · #6 03-23-2006, 03:05 PM

An internal IP looks like this, generally:

192.168.X.X

Fill in "X" with a number.

I would also recommend using a gigabit switch and gigabit ethernet cards.

bada_bing · #7 03-23-2006, 04:07 PM

You will also want to make sure that this is not a hardware issue between the server that your vb site resides on and your database server. For example a switch with a misconfigured port speed or hub between both servers make sure that the connectin between both servers is not bottle-necked or saturated with traffic.

Paul M · #8 03-23-2006, 04:14 PM

Yep, if possible have a seperate nic on the web and db server, link them directly, configure a private address on each, and use those addresses.

GrCh_Jeff · #9 03-23-2006, 04:52 PM

Quote:

Originally Posted by alexi

as they switched to a second NIC for the private traffic all their load problems dissapeared.

what do you mean private traffic?

alexi · #10 03-23-2006, 05:09 PM

Private traffic would be the traffic in between the web server or servers and the database server. Public traffic would be your users coming in to the web server.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.10003 seconds Memory Usage 2,287KB Queries Executed 23 (?)
More Information
Template Usage: (1)SHOWTHREAD (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)ad_showthread_beforeqr (2)bbcode_quote (1)footer (1)forumjump (1)forumrules (1)gobutton (1)header (1)headinclude (1)modsystem_post (1)navbar (6)navbar_link (120)option (1)pagenav (1)pagenav_curpage (1)pagenav_pagelink (10)post_thanks_box (10)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (10)post_thanks_postbit_info (9)postbit (10)postbit_onlinestatus (10)postbit_wrapper (1)spacer_close (1)spacer_open (1)tagbit_wrapper Phrase Groups Available: global inlinemod postbit posting reputationlevel showthread	Included Files: ./showthread.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/functions_bigthree.php ./includes/class_postbit.php ./includes/class_bbcode.php ./includes/functions_reputation.php ./includes/functions_post_thanks.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 showthread_start showthread_getinfo forumjump showthread_post_start showthread_query_postids showthread_query bbcode_fetch_tags bbcode_create showthread_postbit_create postbit_factory postbit_display_start post_thanks_function_post_thanks_off_start post_thanks_function_post_thanks_off_end post_thanks_function_fetch_thanks_start post_thanks_function_fetch_thanks_end post_thanks_function_thanked_already_start post_thanks_function_thanked_already_end fetch_musername postbit_imicons bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete postbit_display_complete post_thanks_function_can_thank_this_post_start pagenav_page pagenav_complete tag_fetchbit_complete forumrules navbits navbits_complete showthread_complete
Messages:

The Arcive of Official vBulletin Modifications Site.

It is not a VB3 engine, just a parsed copy!