Go Back   vb.org Archive > vBulletin Modifications > Archive > vB.org Archives > General > Big Board Discussions
MySQL Replication Issues Details »»
MySQL Replication Issues
Version: , by jason|xoxide jason|xoxide is offline
Developer Last Online: Dec 2022 Show Printable Version Email this Page

Version: Unknown Rating:
Released: 08-10-2006 Last Update: Never Installs: 0
 
No support by the author.

So, I've decided to try and take advantage of the master/slave setup now that it's supposedly been improved in 3.6.0. Unfortunately, I'm having some issues.

First, "CREATE TABLE", "DROP TABLE", and "ALTER TABLE" statements don't seem to be replicated. Next, once I transfer a snapshot to the second box and setup vBulletin to use the slave server, I start getting "Error 127 from storage engine" errors on searches. Furthermore, ignoring the searches, my site actually seems to be slower than when it was just running on the single box.

Any advice?

Some more info:

Server 1 (serves web pages and master MySQL):
- (2) 2.8GHz Xeon Processors w/ HT
- 4GB of DDR2-400
- (3) 73GB 10K RPM SCSI Drives in RAID 5

Server 2 (serves other web pages w/ MySQL, none of any meaningful load, and slave MySQL for Server 1):
- (2) 2.8GHz Xeon Processors w/ HT
- 2GB of DDR2-400
- (2) 73GB 10K RPM SCSI Drives in RAID 1

Both servers run Plesk 7.5.4 in RHEL3, upgraded with ART RPMs. The kernel version is 2.4.21-47.ELsmp, the PHP version is 5.0.4, and the MySQL version is 4.1.20.

Show Your Support

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

Thread Tools

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 09:30 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.03610 seconds
  • Memory Usage 2,176KB
  • Queries Executed 14 (?)
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)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)modsystem_post
  • (1)navbar
  • (6)navbar_link
  • (120)option
  • (1)post_thanks_box
  • (1)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (1)post_thanks_postbit_info
  • (1)postbit_onlinestatus
  • (1)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