Go Back   vb.org Archive > vBulletin 5 Connect Discussion > vB5 Programming Discussions
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools Display Modes
  #1  
Old 01-11-2016, 02:46 PM
hosler hosler is offline
 
Join Date: Oct 2015
Posts: 4
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default Master-Slave mysql replication

Hey fellas,
Been trying to get a master-slave setup using MariaDB 10. Everything seems to work fine until I tell vbulletin about the slave server. Everything gets super flaky when I enable the slave server in config.php. I start getting errors like this:
Code:
Critical Error

We are currently experiencing technical difficulties. Please check back in 24 hours.
I get these errors about 50% of the time.

Anyone know what this is a symptom of or what is the best way to debug? I tried turning debug mode on in the config.php, but I couldn't find any debug info anywhere.

P.S. Here is the guide I used to setup replication: https://www.digitalocean.com/communi...ation-in-mysql
Reply With Quote
  #2  
Old 01-11-2016, 02:53 PM
Dave Dave is offline
 
Join Date: May 2010
Posts: 2,583
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Are those 500 internal server errors?
Could you check the error logs of your web-server/PHP to see the exact error?
Reply With Quote
  #3  
Old 01-11-2016, 03:09 PM
hosler hosler is offline
 
Join Date: Oct 2015
Posts: 4
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I'm not seeing anything in my nginx error log when this happens.

Also sometimes I get this error instead of the previous one I mentioned: "Search result already expired, please try a new search." This error doesn't take up the whole screen, where the first error I mentioned in my first post did take up the whole screen and didn't render any images/styles/themes.

Here is the actual website: https://graal.in/

I'll leave the slave database enabled for a while.
Reply With Quote
  #4  
Old 01-11-2016, 03:15 PM
Dave Dave is offline
 
Join Date: May 2010
Posts: 2,583
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Hmm weird, my guess it's just an error announced by vBulletin 5 itself because something goes wrong inside of vBulletin. You could try posting on the official forums of vBulletin.com, maybe they can help you out.
Reply With Quote
  #5  
Old 01-11-2016, 04:10 PM
hosler hosler is offline
 
Join Date: Oct 2015
Posts: 4
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by Dave View Post
Hmm weird, my guess it's just an error announced by vBulletin 5 itself because something goes wrong inside of vBulletin. You could try posting on the official forums of vBulletin.com, maybe they can help you out.
yeah ive been trying, but I can't post anything yet. I guess I just need to wait longer for them to validate my forum account or something.

Anyway, the main reason im trying to do master/slave setup is to get a performance boost. my forums are just super slow and I can't figure out why.
Reply With Quote
  #6  
Old 01-11-2016, 04:12 PM
Dave Dave is offline
 
Join Date: May 2010
Posts: 2,583
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

What's the load on PHP, MariaDB and the web-server?
Any decent VPS should be able to handle < 100 concurrent users with ease.
Reply With Quote
  #7  
Old 01-11-2016, 04:22 PM
hosler hosler is offline
 
Join Date: Oct 2015
Posts: 4
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

It's a very light load. Anywhere between 0-4 active users with about 20 bots at any given time.
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 07:43 AM.


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.06406 seconds
  • Memory Usage 2,217KB
  • Queries Executed 13 (?)
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)bbcode_code
  • (1)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)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
  • (7)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