We are using AWS Aurora MySQL, creating 2 instances, DB-Main and DB-Secondary (read replica) as shown below, but if we configure both DBs as shown in Case 1, errors occur in various areas such as searching and posting, and they do not work.

On the other hand, in Case 2, if I leave $config[‘SlaveServer’][*] at its default value and configure only DB-Main, all functions work.



How can I configure vBulletin to work with both DB-Main and DB-Secondary (read replica)?





## DB Service: AWS Aurora MySQL

- DB-Instances:

- DB-Main

- DB-Secondary (read replica)





## Case1: core/includes/config.php



$config['MasterServer']['servername'] = '[DB-Main]';

$config['MasterServer']['port'] = 3306;

$config['MasterServer']['username'] = 'dbuser';

$config['MasterServer']['password'] = 'secret';

$config['MasterServer']['usepconnect'] = 0;



$config['SlaveServer']['servername'] = '[DB-Secondary]';

$config['SlaveServer']['port'] = 3306;

$config['SlaveServer']['username'] = 'dbuser';

$config['SlaveServer']['password'] = 'secret';

$config['SlaveServer']['usepconnect'] = 0;





## Case2: core/includes/config.php



$config['MasterServer']['servername'] = '[DB-Main]';

$config['MasterServer']['port'] = 3306;

$config['MasterServer']['username'] = 'dbuser';

$config['MasterServer']['password'] = 'secret';

$config['MasterServer']['usepconnect'] = 0;



$config['SlaveServer']['servername'] = ''

$config['SlaveServer']['port'] = 3306;

$config['SlaveServer']['username'] = '';

$config['SlaveServer']['password'] = '';

$config['SlaveServer']['usepconnect'] = 0;

Devami...