Hi AWS Experts;
We have an application based on Apache/PHP and PostgreSQL. And looking forward to host this with the AWS and now I'm performing a R&D prior to start off.
Below is the application type in brief;
1. Main purpose of this application is Media upload/download and streaming
2. 8000 active use base and 3000 concurrent will be expected during the peak time
3. Geographically 90% from Australia, New Zealand and the rest will from United Kingdom and South Asia
4. They expect about 25,000 to 40,000 users during next 3 years
In high level, I'm planning to deploy PostgreSQL Hot Standby Cluster, only the primary database will be OLTP, and the other two standby servers will be OLAP. (three servers in the cluster)
And initially two web servers(Apache) and two application servers(Apache) will be placed and this should be scale up adding more web and app servers whenever required.
Depending your experience with AWS, is it possible to archive my goal ? what are the important things to consider here ?
Thanks a lot for your time !