Monday, April 1, 2019

configuration - Ideal server for web application, database and email hosting



Hoping for your thoughts and insights regarding a new server config.



Currently, we're running everything on one server, which seems to run fine. No complaints of speed issues. This includes, MailEnable, DNS, a single Web Application a few small websites and SQL Server 2005. It's 5 years old and for a number of reasons we want to upgrade it. In addition, we're looking to add an additional web application. Both currently see about 300-500 users per day. Ideally, the new one would grow to thousands per day within a year.



So, for the purpose of scoping, lets put it at:





  • a few very small & low-traffic info only static websites

  • Mailenable with maybe 20 accounts, 5 domains.

  • 2 web apps - highly database driven, with SQL server 2008 backend. One with 500 users/day. The other with 5000 /day.

  • DNS for the 2 web apps and small websites.

  • SQL Server 2008.



So, assuming we only need to cope as this for a maximum for the next year or 2, would the following hardware be enough to support it:




» Processor: AMD x6 1055T HEXA Core
» RAM: 8GB DDR SDRAM
» HD1: 2 x 250GB SATA RAID 1 (+250 GB 7200 RPM SATA hard drive)
» HD2: SATA Backup Drive (+250 GB SATA (7,200 rpm))
» Bandwidth: 6000GB Monthly Transfer



It's a challenge to try to find a balance, so really looking forward to all your feedback.



Thanks!


Answer




You'll have to be careful with SQL Server, because it's designed to use as much RAM as is available, not to mention thrashing the drive (though you're not clear on how BUSY those 5000 users per day will be. One transaction per second will be easily handled, for example).



Based purely on that, I'd sooner run the DB on a separate box. If you're not expecting much database traffic (e.g. caching of certain requests, etc.), your hardware could probably handle it.


No comments:

Post a Comment

linux - How to SSH to ec2 instance in VPC private subnet via NAT server

I have created a VPC in aws with a public subnet and a private subnet. The private subnet does not have direct access to external network. S...