Database server on web server?

For general questions and discussions specific to the AbleCommerce GOLD ASP.Net shopping cart software.
Post Reply
User avatar
deverill
Lieutenant (LT)
Lieutenant (LT)
Posts: 64
Joined: Tue Jan 06, 2009 11:58 am
Location: Key West, FL
Contact:

Database server on web server?

Post by deverill » Tue Dec 13, 2016 11:26 am

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
Jim Sewell - Web Programmer
Trusted Tours & Attractions

User avatar
NC Software
AbleCommerce Partner
AbleCommerce Partner
Posts: 4620
Joined: Mon Sep 13, 2004 6:06 pm
Contact:

Re: Database server on web server?

Post by NC Software » Thu Dec 15, 2016 11:00 am

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.
Neal Culiner
NC Software, Inc.

Odettes
Lieutenant Commander (LCDR)
Lieutenant Commander (LCDR)
Posts: 102
Joined: Wed Apr 02, 2008 11:00 am
Location: Stockholm, Sweden
Contact:

Re: Database server on web server?

Post by Odettes » Sat Dec 17, 2016 6:13 am

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.
Sincerely,
Thomas Berglund

https://traileronline.se
AbleCommerce Gold R11 Custom

User avatar
Katie
AbleCommerce Admin
AbleCommerce Admin
Posts: 2651
Joined: Tue Dec 02, 2003 1:54 am
Contact:

Re: Database server on web server?

Post by Katie » Sat Dec 17, 2016 8:07 am

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
Thank you for choosing AbleCommerce!

http://help.ablecommerce.com - product support
http://wiki.ablecommerce.com - developer support

Post Reply