XF 2.1 Writing to 2 databases does not work

[Academic]

Hi!

Following these instructions: https://xenforo.com/community/threads/suggestion-mysql-read-slave-write-master.14492/post-1173474

Writing to 2 databases does not work, the data is being inserted into one only. Any idea what can be the cause? Thanks!

$config['db']['adapterClass'] = 'XF\Db\Mysqli\ReplicationAdapter';

$config['db']['write'] = [
    'host' => 'localhost',
    'port' => '3306',
    'username' => 'user',
    'password' => 'pass',
    'dbname' => 'db',
];

$config['db']['write'] = [
    'host' => 'localhost',
    'port' => '3306',
    'username' => 'user',
    'password' => 'pass',
    'dbname' => 'db2',
];

$config['db']['read'] = [
    'host' => 'localhost',
    'port' => '3306',
    'username' => 'user',
    'password' => 'pass',
    'dbname' => 'db',
];

 

[arn]

Why would you want to write to multiple databases?

further down the thread you linked, xf looks to only support one read db and one write db. There’s only one variable that you are overwriting with the second declaration.

if u really want multi master, See https://xenforo.com/community/threads/suggestion-mysql-read-slave-write-master.14492/post-1173929