Go Back   vb.org Archive > vBulletin Modifications > Archive > vB.org Archives > General > Big Board Discussions
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools
How does one set up multiple servers? Details »»
How does one set up multiple servers?
Version: , by azn_romeo_4u azn_romeo_4u is offline
Developer Last Online: Aug 2013 Show Printable Version Email this Page

Version: Unknown Rating:
Released: 01-09-2008 Last Update: Never Installs: 0
 
No support by the author.

Like one for the website and one for the db.
Also is the db server only for one db or can it house more than one?
When does one want to get a setup like this?
Would you recommend one when you have 1mill+ posts and 10k visits per day.

Thank you.

Show Your Support

  • This modification may not be copied, reproduced or published elsewhere without author's permission.

Comments
  #2  
Old 01-10-2008, 04:55 AM
Ted S Ted S is offline
 
Join Date: Dec 2003
Location: SoCal
Posts: 3,954
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

A 2 server setup is fairly simple... right now your forum is connecting to the local server, when you add a second machine for the database, your forum connects to that over an internal ip address. Your database server is just like a local database server, it can serve one db or twenty, although most of the time if you're splitting them out it's because you want more dedicated resources and don't want to be sharing them.

When do you do to this setup? When you need it either because you can see a slow down in services or because you forecast one (and hopefully not because your site is crashing from overload although that's often the case).

The number of visits and pageviews is telling but not the whole story. Sites running a barebones installs with short sessions might be able to do two, three, even four times the traffic of one with more features, addons or visitor activity. If your site runs well at that level there's little reason to make a change... if it doesn't then you should look at optimization options and if those are maxed out, a second server is probably the ideal solution.
Reply With Quote
  #3  
Old 01-10-2008, 01:34 PM
Lynne's Avatar
Lynne Lynne is offline
 
Join Date: Sep 2004
Location: California/Idaho
Posts: 41,180
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

We moved over to a two server setup when I started noticing that our server loads were constantly over 2 (and often sitting around 4 or 5) and we were noticing a slow down on the site that no amount of server optimization would fix. Oh, and also when we had enough money in the paypal account to afford the move.
Reply With Quote
  #4  
Old 01-10-2008, 11:31 PM
azn_romeo_4u azn_romeo_4u is offline
 
Join Date: Feb 2006
Posts: 227
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

>_<

Anyone know who I would go to, for a setup like that? <O.O> I don't know much about setting it up myself.
Reply With Quote
  #5  
Old 01-11-2008, 02:32 PM
AWS's Avatar
AWS AWS is offline
 
Join Date: Nov 2001
Location: Joliet, IL
Posts: 235
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

You need to get 2 dedicated servers. When you order them make sure they are either on the same vlan or are connected to a private switch. Once you get the server you install mysql on one of them and the webpages on the other. You set up the software to connect to the private IP of the server the db is on.
Reply With Quote
  #6  
Old 01-11-2008, 04:54 PM
Ted S Ted S is offline
 
Join Date: Dec 2003
Location: SoCal
Posts: 3,954
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by azn_romeo_4u View Post
>_<

Anyone know who I would go to, for a setup like that? <O.O> I don't know much about setting it up myself.
It's really not that difficult. Have your hosting provider configure a second server with the latest version of mysql setup and no other services running (i.e. no webserver, no mail server, no ftp) and link it over a vpn or internal network (something that avoids traffic having to go over any open network). Turn your forum off, copy your database to the new server and point vbulletin to it as well. Run a few tests and you're good to go.

If that's still more than you want to manage, you should be able to find someone in the Paid Requests forum who can assist.
Reply With Quote
  #7  
Old 01-22-2008, 11:16 PM
klyde's Avatar
klyde klyde is offline
 
Join Date: Sep 2005
Posts: 11
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

And with more than 2 servers????
Reply With Quote
  #8  
Old 01-24-2008, 05:44 PM
AWS's Avatar
AWS AWS is offline
 
Join Date: Nov 2001
Location: Joliet, IL
Posts: 235
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

With more than 2 you configure mysql to use the other servers as slaves. If you want to distribute the load you use a load balancer.
Reply With Quote
  #9  
Old 02-19-2008, 03:43 AM
IronMountain IronMountain is offline
 
Join Date: Sep 2007
Posts: 38
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by azn_romeo_4u View Post
Like one for the website and one for the db.
Also is the db server only for one db or can it house more than one?
Your database server can house as many databases as the server can handle, there's no limit

Quote:
When does one want to get a setup like this?
Definitely agree on the Paypal comment. Once you can afford to move and you feel your forum isn't that fast, you probably should...no visitor wants to visit a slow forum. But you should be making money off your forum (ads/donations) before you consider moving)

Quote:
Would you recommend one when you have 1mill+ posts and 10k visits per day.
The posts might qualify but your visitor count isn't that high yet. It also depends on what kind of server you have now.

Quote:
Anyone know who I would go to, for a setup like that? <O.O> I don't know much about setting it up myself.
If you don't know much about server setups, you can get "server management" from the hosting company. Or you can go for managed servers (which have the management portion built into the pricing)

Hope that helps.
Reply With Quote
  #10  
Old 02-24-2008, 03:34 AM
Amenadiel's Avatar
Amenadiel Amenadiel is offline
 
Join Date: Sep 2006
Posts: 171
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I have 50k visitors and 1.6M posts, and I'm fine with one Xeon dual core server, but I switched over from apache to lighttpd.

I'm considering upgrading my server to a quad core one, it's still cheaper than a 2 machine array, but I believe I'd just need to point database in includes/config.php to the new DB server.

What about slave database? Does it relieve server load or it's just for backup purposes?
Reply With Quote
Reply


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


All times are GMT. The time now is 02:03 PM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.04727 seconds
  • Memory Usage 2,296KB
  • 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
  • (5)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