vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   Big Board Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=172)
-   -   3.6 and the big boards (https://vborg.vbsupport.ru/showthread.php?t=117693)

Erwin 06-07-2006 04:43 AM

Quote:

Originally Posted by alexi
Erwin, just curious why did you decide to implement the one monster server database solution as opposed to the master slave concept?
I'm trying to figure out where I want to go right now, do I want a huge DB server like quad dual operon's or 2 dual opteron servers.

I don't like the idea of separating writes to the master and reads to a slave, so what I've done is run a master db server, and have a slave replicating only forum, post, thread, user and shoutbox, and running search and IP searches off this slave, as well as shoutbox reads - this offloads a LOT of the load off the master db server and prevents the master from being slowed down.

alexi 06-07-2006 06:04 AM

Erwin- would your opinion change now that VB says they have fixed master/slave?

Zachery 06-07-2006 06:52 AM

I'm sure he'd actually need to see and try the code before giving an opinion on it.

alexi 06-07-2006 06:59 AM

well yea Zachery, if it didn't work that would probably change everyone's opinion :)


All times are GMT. The time now is 02:58 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.01283 seconds
  • Memory Usage 1,714KB
  • 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)pagenav
  • (1)pagenav_curpage
  • (1)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (4)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
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete