Announcement

Collapse
No announcement yet.

Slave server not working for me

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

  • Slave server not working for me

    Hi there, I'm on vbulletin 5.3.2 right now and I have following as my config for master and slave server:

    $config['Database']['dbtype'] = 'mysqli_slave';
    $config['MasterServer']['servername'] = '****************';
    $config['MasterServer']['port'] = 3306;
    $config['MasterServer']['username'] = 'root';
    $config['MasterServer']['password'] = 'root';
    $config['MasterServer']['usepconnect'] = 1;

    $config['SlaveServer']['servername'] = '****************';
    $config['SlaveServer']['port'] = 3306;
    $config['SlaveServer']['username'] = 'root';
    $config['SlaveServer']['password'] = 'root';
    $config['SlaveServer']['usepconnect'] = 1;

    The problem is when I enable slave server, I can read forum without any issue, but when I create topic or reply I got "Invalid node id specified" error, is slave server working for you guys?

  • #2
    bump

    Comment


    • #3
      The slave server architecture isn't really recommended anymore. This was a workaround for table locking when using MyISAM tables in older versions of vBulletin. All of your tables should be using InnoDB on MySQL 5.6 or higher. You should be able to get better performance than using the old master/slave architecture. If you need even more performance, looking into a proper MySQL/MariaDB cluster would be the proper solution.
      Translations provided by Google.

      Wayne Luke
      The Rabid Badger - a vBulletin Cloud demonstration site.
      vBulletin 5 API - Full / Mobile
      Vote for your favorite feature requests and the bugs you want to see fixed.

      Comment

      Related Topics

      Collapse

      Working...
      X