How to config more than 1 slave-database server ?

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • citrix
    Member
    • Oct 2006
    • 99
    • 3.8.x

    How to config more than 1 slave-database server ?

    How have I to config more than 1 database-slave server? Is it like :

    $config['SlaveServer']['servername'] = '';
    $config['SlaveServer']['port'] = 3306;
    $config['SlaveServer']['username'] = '';
    $config['SlaveServer']['password'] = '';
    $config['SlaveServer']['usepconnect'] = 0;

    $config['SlaveServer_1']['servername'] = '';
    $config['SlaveServer_1']['port'] = 3306;
    $config['SlaveServer_1']['username'] = '';
    $config['SlaveServer_1']['password'] = '';
    $config['SlaveServer_1']['usepconnect'] = 0;

    $config['SlaveServer_2']['servername'] = '';
    $config['SlaveServer_2']['port'] = 3306;
    $config['SlaveServer_2']['username'] = '';
    $config['SlaveServer_2']['password'] = '';
    $config['SlaveServer_2']['usepconnect'] = 0;
    If I have more than one, is there a load balancing active or how does this work?
  • Wayne Luke
    vBulletin Technical Support Lead
    • Aug 2000
    • 74132

    #2
    vBulletin doesn't support Load Balancing in this manner. You would have to look into MySQL Enterprise Cluster to get the capabilities that you are looking for.
    Translations provided by Google.

    Wayne Luke
    The Rabid Badger - a vBulletin Cloud demonstration site.
    vBulletin 5 API

    Comment

    • citrix
      Member
      • Oct 2006
      • 99
      • 3.8.x

      #3
      I now typed in the data for the slave server as needed. After uploading the config.php I get an mysql error. What could have caused this ?
      It added the "_slave" and typed in the correct slave-database information ?!

      /edit: I'll recheck the database backup of the slave. If I put the slave data as master, it doesnt work.

      P.S. Why neednt I to enter a database name with the slave database ? just "localhost" user and password.
      Last edited by citrix; Wed 14 Jan '09, 7:47am.

      Comment

      • Wayne Luke
        vBulletin Technical Support Lead
        • Aug 2000
        • 74132

        #4
        The database name has to match the Master Server database name. Your slave MySQL database should not be on Localhost unless your Master is on a different server. Do not run the Master and Slave on the same server.
        Translations provided by Google.

        Wayne Luke
        The Rabid Badger - a vBulletin Cloud demonstration site.
        vBulletin 5 API

        Comment

        Related Topics

        Collapse

        Working...