Go Back   vb.org Archive > Community Discussions > Modification Requests/Questions (Unpaid)
  #1  
Old 11-27-2001, 06:45 PM
philliplewisuk philliplewisuk is offline
 
Join Date: Nov 2001
Posts: 16
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I need some help, Im willing to pay for it to.

I own a VERY busy board.. 300-400 people on there at any time and the server cant handle it. I want to make it have 1000 at any time!

Now my idea is either to make it work with mods or to run it off 2 servers by sharing the user database.

Any help will be needed. I will pay anyone for it.

Thanks

Phil
10282728 (ICQ)

PS.. i dont want to have the php on one server and database on another. it will still slow the forum, i guess!
Reply With Quote
  #2  
Old 11-27-2001, 08:29 PM
Scott MacVicar Scott MacVicar is offline
 
Join Date: Oct 2001
Location: Glasgow, Scotland
Posts: 1,199
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

You could use one server as a dedicated mysql.

Or to the current server make sure that mod_gzip, zlib, zend optimizer and that your my.cnf settings are correct, also turn on the gzip option in the control panel.

The gziped output will decrease bandwidth and the zend optimizer and my.cnf improvements will improve performance.

The end solution is having a front server and a dedicated mysql server to ensure speed.

Scott
Reply With Quote
  #3  
Old 11-27-2001, 08:32 PM
philliplewisuk philliplewisuk is offline
 
Join Date: Nov 2001
Posts: 16
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Yeah a own server for the mysql would be cool but it wont work. the forum just dies. The vb cant handle more then 400 continue connections!

Reply With Quote
  #4  
Old 11-27-2001, 08:47 PM
Scott MacVicar Scott MacVicar is offline
 
Join Date: Oct 2001
Location: Glasgow, Scotland
Posts: 1,199
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

taking the load of mysql off the current server and putting it on another would improve the performace alot.

Whats the specs for the server and are both servers located in the same location?

Vb.com and this site use a dedicated mysql and a dedicated one for frontend and they can take alot of users. I also run a dedicated mysql and the server load on the main server is considerably less.
Reply With Quote
  #5  
Old 11-27-2001, 08:59 PM
philliplewisuk philliplewisuk is offline
 
Join Date: Nov 2001
Posts: 16
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I got plenty of servers

512 ram, pent 3 1000

etc

i try to do the php on one server and the mysql on another but then i cant get it to connect..

etc.
Reply With Quote
  #6  
Old 11-27-2001, 09:06 PM
Scott MacVicar Scott MacVicar is offline
 
Join Date: Oct 2001
Location: Glasgow, Scotland
Posts: 1,199
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

you'll need to set privledges on the mysql server to accept from the php servers IP.

Then on the php side user the other servers local network address as the host, you might need to ask your hosts what this address is.

My mysql one is 192.168.1.46
Reply With Quote
Reply

Thread Tools
Display Modes

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 01:51 PM.


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.04438 seconds
  • Memory Usage 2,194KB
  • Queries Executed 11 (?)
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
  • (1)ad_showthread_firstpost
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (6)post_thanks_box
  • (6)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (6)post_thanks_postbit_info
  • (6)postbit
  • (6)postbit_onlinestatus
  • (6)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
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete