Announcement

Collapse
No announcement yet.

Slave server not working for me

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

  • Wayne Luke
    replied
    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.

    Leave a comment:


  • yi.zhou@xplusz.com
    replied
    bump

    Leave a comment:


  • yi.zhou@xplusz.com
    started a topic Slave server not working for me

    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?

Related Topics

Collapse

Working...
X