Announcement

Collapse
No announcement yet.

Slave Database Configuration?

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • FireFish
    replied
    Originally posted by Zachery View Post
    No,

    A Master-Slave setup is for preformance. You send write queries to the master server, and most read queries to the slave server. It helps improve preformance becasue write queries lock tables/rows depending on the database table type, and reads do not.
    So, . . you'd suggest it for a forum that has X number of users a day, on average.

    What's the X?

    I know it would vary on server performance, but, just a ballpark average.

    1,000? 10,000? 100,000? 900,000 users a day?

    Leave a comment:


  • Zachery
    replied
    Originally posted by arisythila View Post
    Bump to find out more information about this.

    I'm basically wanting to have vBulletin update two databases on two different servers. and if primary is down, it uses secondary, or vice versa..

    Is this what this function is used for?

    Thanks
    No,

    A Master-Slave setup is for preformance. You send write queries to the master server, and most read queries to the slave server. It helps improve preformance becasue write queries lock tables/rows depending on the database table type, and reads do not.

    Leave a comment:


  • arisythila
    replied
    Bump to find out more information about this.

    I'm basically wanting to have vBulletin update two databases on two different servers. and if primary is down, it uses secondary, or vice versa..

    Is this what this function is used for?

    Thanks

    Leave a comment:


  • FireFish
    replied
    Slave Database - Performance Enhancements?

    Will having a slave database enhance any performance in my forum? Is it a clone of the Primary or is it a cache for recent queries?

    Leave a comment:


  • scudd
    replied
    I could do with some info on this as well, we have a dedicated server and a site that uses huge amounts of mysql data when the site is loaded, if we were get another server and bang in a slave would 'database1' keep 'database2' up to date automatically and resort to that should the 'database1' mysql become overload with requests?

    Any info would be appreciated...

    Or, better still, if you could let me know how you keep vB running when 1000+ people all login, in the space of 10 mins on a saturday afternoon I would love to know? we've done just about every tweak and optimisation in the book, and still get probs when 800+ members are logged in.. if you want to see it collapse for yourself go to: http://www.fsicrew.info/ at 3pm gmt on any satrurday..
    Last edited by scudd; Wed 12 Dec '07, 6:16pm.

    Leave a comment:


  • Skynet-ITS
    replied
    Actually, I've got it and I still need to ask :-p

    We've got a master-master replication setup, with obviously only one of them used as master since mysql doesn't support replicated sequences yet.

    So, the question is, what will vbulletin use the slave server info for ? Is it sufficiently intelligent to only use it for reads, or will it play silly and mess up my database consistency by writing as well ?

    Leave a comment:


  • Steve Machol
    replied
    It's one of those things that if you have to ask, you don't need it.

    Leave a comment:


  • attroll
    replied
    Originally posted by Wayne Luke
    It is used for installations that have MySQL replication for their vBulletin installation.
    OK. What ever that means. I suppose if I don't know what it means then I don't need to worry? Is there a link or some post that discribes this more?

    Leave a comment:


  • Wayne Luke
    replied
    It is used for installations that have MySQL replication for their vBulletin installation.

    Leave a comment:


  • IAMWhitey
    replied
    bump for more info on this as well

    Leave a comment:


  • attroll
    started a topic Slave Database Configuration?

    Slave Database Configuration?

    I would like to know more about this function that is in the new 3.5 config. Is there documentation somewhere that talks about this or explains it? This is all the config file says:

    If you have multiple database backends, this is the information for your slave server. If you are not 100% sure you need to fill in this information,
    do not change any of the values here.

    $config['SlaveServer']['servername'] = '';
    $config['SlaveServer']['username'] = '';
    $config['SlaveServer']['password'] = '';
    $config['SlaveServer']['usepconnect'] = 0;
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Working...
X