The Arcive of Official vBulletin Modifications Site.

Multiple copies of MySQL on a single server · **Released**: 08-18-2006

Does anyone know if this would help the searching issues on a larger board? My load is reasonable until a dozen people try to search at the same time. I was hoping that this might help the table locking and keep me from having to get a new server (or set of servers) until next year.

If you think it would help, does anyone know how to go about installing a second copy of mysql?

COBRAws · #2 08-20-2006, 03:38 AM

Im not quite sure, but it would be better if you used multiple DB's and used just one for searches. Because the load will double if you install multiple instances of mysql in a single box.

my 2 cents.
If Im wrong just let me know.

afx1 · #3 08-20-2006, 04:32 AM

Don't install multiple db servers on the same machine...it won't do anything, at all. Do a quick search on these forums for "big boards" or slow search. You should get a few good tips on speeding that up.

Erwin · #4 08-29-2006, 06:01 AM

Well, that's not exactly true - having 2 post tables, even if they're on the same server, and only search one of them will reduce table locking and may reduce loads overall associated with that. However, it's better to offload search to a separate slave server.

dbembibre · #5 09-06-2006, 08:41 AM

Separate slave server and separate image server (to help main server)

my 2 cents

jason|xoxide · #6 09-06-2006, 02:42 PM

Quote:

Originally Posted by Erwin

Well, that's not exactly true - having 2 post tables, even if they're on the same server, and only search one of them will reduce table locking and may reduce loads overall associated with that. However, it's better to offload search to a separate slave server.

That's what I thought. The box I have seems to be more than powerful enough to handle the sites as long as there is little-to-no table locking.

I have a second server "available" (for testing, not permanent use) and I tried setting up a slave server a month or so ago but it didn't go well. For one, no "CREATE TABLE", "ALTER TABLE", or "DROP TABLE" statements were replicated to the slave. That means that any time I upgraded vBulletin or made some other DB change that those changes would not be replicated and the slave would break. Next, I had problems with the connection between the servers being dropped. Finally, when it did work, the site actually seemed slower for general use (but without the load peaks from searches).

Erwin · #7 09-07-2006, 03:50 AM

You can set it up so that only certain tables need to be replicated, but this involves a recode of search.php.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.04198 seconds Memory Usage 2,254KB Queries Executed 22 (?)
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)bbcode_quote (1)footer (1)forumjump (1)forumrules (1)gobutton (1)header (1)headinclude (1)modsystem_post (1)navbar (6)navbar_link (120)option (7)post_thanks_box (7)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (7)post_thanks_postbit_info (6)postbit (7)postbit_onlinestatus (7)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_postinfo_query fetch_postinfo 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
Messages:

The Arcive of Official vBulletin Modifications Site.

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