Register Members List Search Today's Posts Mark Forums Read

Thread Tools
Old 06 Nov 2012, 11:43
chefy chefy is offline
Join Date: Jul 2012
MySQL replication


I have configured a slave mysql server and replication is now running. I got it working by the mysql shell. Now I noticed that in config.php there is a section where you can enter the details of your mysql slave server:

Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

Should I fill that information? What is the purpose of doing that? Is it intended to distribute the load of my mysql master server to my mysql slave server?

Reply With Quote
Old 06 Nov 2012, 12:25
kh99 kh99 is offline
Join Date: Aug 2009
Real name: Kevin
If you want to enable that feature, you also need to add '_slave' to $config['Database']['dbtype'] (which should be near the top of the file).

I'm not a database admin person, but my understanding is that if you set up the config.php to use a slave, the slave will be used for most "read" operations, which speeds things up because writing and updating causes delays. I could be wrong but I don't believe vbulletin makes any attempt to direct requests to one server or the other to balance the load.
Reply With Quote

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
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

New To Site? Need Help?

All times are GMT. The time now is 19:24.

Layout Options | Width: Wide Color: