Stack Overflow
Stack Overflow

Questions tagged [hardware-infrastructure]

14 questions
152
votes
18 answers

Why is it not advisable to have the database and web server on the same machine?

Listening to Scott Hanselman's interview with the Stack Overflow team (part 1 and 2), he was adamant that the SQL server and application server should be on separate machines. Is this just to make sure that if one server is compromised, both…
Tai Squared
  • 12,273
  • 24
  • 72
  • 82
4
votes
1 answer

How does a typical medium to large web application "grow up" infrastructure-wise?

The skinny: When Facebook / Twitter / Youtube (whatever) went from basic idea in software to... bigger (maybe 100,000 users?), how did they grow? Is there a "best practices" growth path for medium sized web applications? The real question: When…
Sy Moen
  • 243
  • 1
  • 2
  • 8
2
votes
2 answers

Physical Cores vs Virtual Cores in Parallelism

When it comes to virtualization, I have been deliberating on the relationship between the physical cores and the virtual cores, especially in how it effects applications employing parallelism. For example, in a VM scenario, if there are less…
Code Curiosity
  • 55
  • 1
  • 5
2
votes
1 answer

Performance of separate application and database servers vs all-in-one

We are migrating an existing application that requires a decent database setup. We've run a simple mysqlslap test on two server configurations - combined app & db server, separate app & 2 db servers (master/slave): mysqlslap --auto-generate-sql…
xylar
  • 7,433
  • 17
  • 55
  • 100
2
votes
4 answers

Would it ever be wise to have a SQL server per web server?

I'm wondering if, under the circumstances that You get lots more reads than writes Your SQL server of choice is cheap/free and offers a fast mirroring/replication service Your database isn't insanely large rather than having separate SQL servers…
mcintyre321
  • 12,996
  • 8
  • 66
  • 103
1
vote
2 answers

Is Infrastructure as Code (IaC) meant for software infrastructure, virtual hardware infrastructure or both?

Based on the Wikipedia concept Infrastructure as code (IaC) is the process of managing and provisioning computer data centers through machine-readable definition files, rather than physical hardware configuration or interactive configuration…
EliuX
  • 11,389
  • 6
  • 45
  • 40
1
vote
1 answer

Get Server Information using PHP

I have 'n' numbers of internal private IP address in my organization which are not identified. I want to find information regarding those unidentified IP address like what is the hostname, what kind of device it is (server, router, switch etc) and…
Rohit
  • 87
  • 1
  • 4
  • 10
1
vote
1 answer

Is running Docker on bare metal maintainable?

I want to create web services that will be distributed as docker containers on my platform. Running Docker on a physical machine is faster in comparison to running it in a VPS, as there is no overhead from a virtual OS layer. However, a VPS is more…
RoyB
  • 3,104
  • 1
  • 16
  • 37
0
votes
1 answer

Get hardware information (e.g lscpu) of an Amazon Rds Instance from the CLI

How do I connect to the underlying instance of an AWS RDS database instance(e.g db.m5d.xlarge) to get the hardware information? I am interested in knowing the hardware information of the instance type used to launch the database. What I intend to…
tyler
  • 3
  • 1
0
votes
1 answer

SQL Server optimization

My application (industrial automation) uses SQL Server 2017 Standard Edition on a Dell T330 server, has the configuration: Xeon E3-1200 v6 16gb DDR4 UDIMMs 2 x 2tb HD 7200RPM (Raid 1) In this bank, I am saving the following tables: Table:…
user3512987
  • 3
  • 1
0
votes
4 answers

hardware infrastructure for public web application

I'd like to start a free budget/personal finance site and will need plenty of horsepower and storage. I'm definitely a nubee, so how does one get started in terms of hardware infrastructure? Do I need to get a dedicated IP from my ISP and obtain…
magellings
  • 175
  • 2
  • 10
0
votes
1 answer

Is it fair to say that "hadoop is a hyper-converged Infrastructure application"?

We hear a lot of buzzwords these says about big data and new data center infrastructure. I am just confused, is it fair to say that "hadoop is a hyper-converged Infrastructure application"?
Hello lad
  • 17,344
  • 46
  • 127
  • 200
-1
votes
1 answer

Distributed Spark and HDFS Cluster with 6 to 7 Nodes hardware configuration

I am planning to spin my development cluster for trend analysis for Infrastructure Monitoring application which I am planning to build using Spark for analysing failure trend and Cassandra for storing incoming data and analysed data. Consider…
Nitesh
  • 1
  • 2
-2
votes
3 answers

Had only one public subnet to VPC, and added NAT gateway to that public subnet instance, but i'm not able access the instance using NAT ip address

I had only one public subnet to VPC,and added NAT gateway to that public subnet, but i'm not able access the instance using NAT ip address. @1)I'm able to ping the instance, with public Ip address(added icmp to security group), but by using NAT…
raju
  • 129
  • 1
  • 9