Slave server not working for me

[[email protected]]

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?

[[email protected]]

bump

[Wayne Luke]

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.