Load balancing DotNetNuke with Amazon with autoscale

Load balancing DotNetNuke with Amazon with autoscale

I am new to cloud services and need somebody to help me in getting started
with my project.
I have been tasked with building a web environment for a production .Net
application that utilizes DotNetNuke as a front-end CMS.
My end goal (hopefully) is the following:
Create two always-on web servers running DotNetNuke (with the ability to
scale on the fly with autoscaling when under heavy traffic)
Create two always-on SQL servers running SQL Server (with the ability to
scale on the fly with autoscaling when under traffic)
Ideally, I'd like my servers to have static private addresses configured
as such:
Public IP -NAT-> Private IP (172.x.x.x) -> Interface1 -> [Web Cluster] ->
Interface2 -> Backend Private IP (10.x.x.x) -> [Database Cluster]
This particular application sees heavy traffic and currently our managed
provider is not really giving us what we need in terms of performance
(latency issues, stability issues, etc).
That said, I would like these resources to also be load balanced, and
continuously identical to one another. I don't have the option of using
Amazon's database services for this, nor do I have the option of using
Beanstalk.
Is this even possible? I've found some documentation online that loosely
relates to what I'm looking for, but I feel like I'm not experienced
enough with Amazon to really understand what these tutorials are talking
about.
Any help or guidance would be greatly appreciated.