Register Members List Search Today's Posts Mark Forums Read

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

Hi,

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?

Thanks.
Reply With Quote
  #2  
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
Reply



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: