Page 1 of 1

Database server on web server?

Posted: Tue Dec 13, 2016 11:26 am
by deverill
Hi everyone,

We are trying to consolidate the insane number of servers we are using and a suggestion was made to let one server share the web server and the database server for three GOLD R11 store. The server is very under utilized. The server we are considering is a 12 core server that hasn't gone above 10% CPU usage and has 24GB of memory available. Our current DB server is a dual core with 8GB ram total.

I know the common advice many years ago was to never do this, but with modern servers and the unique personality of AbleCommerce's stores I thought I should ask here. Also, is there any statement I've missed from AC themselves on this?

Has anyone else done this recently?
Thanks
Jim

Re: Database server on web server?

Posted: Thu Dec 15, 2016 11:00 am
by NC Software
Servers today are tremendously powerful, yes, in the past I'm not sure if it was a licensing thing or performance or combination thereof. I would consider adding more RAM as SQL Server will use it. RAM is cheap typically, max out your server if you can. You should be fine. Just keep in mind SQL Server licensing based on procs/cores.

Re: Database server on web server?

Posted: Sat Dec 17, 2016 6:13 am
by Odettes
It's not for prestanda reason you shouldn't mix database and web servers on the same server, it's all about security.
Best practice is to have the web server facing the Internet and the database server on it's own internal net.

Re: Database server on web server?

Posted: Sat Dec 17, 2016 8:07 am
by Katie
Yes, Thomas is correct if you wish to be PCI compliant. It is for security reasons that you will want to separate the webserver and database server.

Reference: http://www.ablecommerce.com/Able_Gold_R12_PCI_Guide.pdf

Page 9.

It would probably be better to consolidate all the websites to as few servers as possible.

Thanks
Katie