Multiple database servers for performance vs failover 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.
If you are using mySQL, and you are not concerned about possible differences between your two databases, albeit for a short while, you could just set up mySQL Replication. 

This is different to the active-active clustering you have asked about.  Active-active clustering implies that 2 or more nodes are actively hosting services, but in a mySQL / SQL Server context, you will not have explicit "synched" data in they way you mean. Instead this could be better achieved by replication or SQL2012 AlwaysOn (if you considered using it).