Hello,
Need an advice in how to build an architecture for our ecommerce business
So at the moment we hosted with Hostgator dedicated server and frankly we are pretty much fine with it
Our issue is that 3 times a year we have big spikes in traffic like 10 times to our regular day to day traffic and then we are having troubles
So I'm trying to find solution which will help us:
- scale when needed to be ready for traffic spikes
- to have back up in case there is problem with server, db....
So the plan i have in my head is next:
1. Keep Hostgator dedicated server fro Apache
2. Move Mysql to another dedicated server, which will be Master
3. Add Rackspace Cloud server for Apache
4. Add Rackspace Load Balancer and balance traffic between Hostgator and Racksapce
5.Create Another Mysql server at Rackspace which will be Slave
6. Add Loadbalancer for for 2 Mysql servers i have. In case if one fails to make it auto switch to the 2nd one (Slave)
Any opinion or expert advice would be very much appreciated
Thanks