If I have two database servers, and I am looking for maximum performance vs high-availability, what configuration would be best?
Assuming the architecture is two load-balanced web/app servers in front of two db servers, will I be able to have both db servers active with synced data, with web1 to db1, web2 to db2 setup? Is this active/active?
I'm also aware that the two db servers can have their own schema to manually 'split' the db needs of the app. In this case daily backups would be fine. We don't have 'mission critical data.'
If it matters, we have traffic around 3,000-7,000 simultaneous users.