I need help to determine or review MS SQL diagram for new build.
What I want to accomplish is HA and HP MS SQL cluster build.
That would contain:
1. load balancer for WEB\Application server that would be hosted on VM, Win 2012r2
2. Side A 2 nodes cluster (active, passive) Physical servers - Win 2012r2
3. Side B 1 warm server for DR. Physical servers - Win 2012r2
4. SUN data storage.
I am wondering is this diagram has any logic.
What can be change to improve availability, performance, DR, etc.
What hardware components do I need to accomplish this?
If you want to implement a real DR side you have to use a synchronization between Side A and Side B (SQL Server Mirroring or SQL Server Always On or BI-Directional Transactional Replication).
You don't need a FailOver Cluster on Side A (as currently) with shared storage because it increases the Availability but it has no DR role. It is expensive and it does not meet your requirements.
Unfortunately there is no standard technology in case of MS SQL Server for scallability (to increase performance). So it is not so easy than in case of Oracle RAC. But if you use Database Mirroring / Always On / Transactional Replication then you can use Seconday Read-Only servers for Reporting, Statistic or backup purposes.
My recommendation: Remove failover cluster on Side A, build a (low bandwith) network between Side A and Side B and build an AlwaysOn cluster between Side A and Side B.
This will keep the current availability level, but give Disaster Recovery role and increase performance because Side B is read-only (for reporting or backup) and posibility for addidional read-only servers.