...
The idea is to have MASTER/SLAVE(s) configuration. This will separate WRITE/READ database requests between 2+ servers (1 Master and 1+ Slaves replicated from Master).
- all Admin requests go to MASTER
- all Front READ requests go to SLAVE
- all Front WRITE requests go to MASTER
- all Front Search READ go to MASTER
...
To enable load balancing:
...