gwinans
Active member
To assist with scalability, it would benefit XenForo greatly to have the ability to send reads to a secondary server.
Config:
This will allow very simplistic horizontal scaling. It can be done as a round-robin system or each slave can host a specific portion of data.
Checks would need to be made to ensure that the slave being read from isn't behind - if it is significantly behind, read from the master or move to the next slave.
Config:
Code:
$config['db']['master']['host'] = ...
...
$config['db']['slave'][1]['host'] = ...
...
$config['db']['slave'][5]['host'] = ...
Checks would need to be made to ensure that the slave being read from isn't behind - if it is significantly behind, read from the master or move to the next slave.
Upvote
11