Questions tagged [scaling]

142 questions
2
votes
2 answers

How to use a distributed PostgreSQL database on a web site?

I want to host a web site, the back end will be a PostgreSQL database server. I would like to have multiple web servers, in different data centers for redundancy. I would then round robin DNS each web server to distribute the load. To do this,…
Anthony D
  • 145
  • 1
  • 8
2
votes
1 answer

Google App Engine vertical scaling

I know Google Cloud (Google App Engine) can autoscale instances horizontally: you have 1 server with certain parameters, when it's overloaded autoscaler launches new server and balances load between them. But I can't find any informations if Google…
2
votes
2 answers

How do I force apache to drop requests after a predetermined amount of time?

I'm setting up a system that has hard requirements on the response time. How do I force Apache2 to drop requests in the queue after 200ms if it hasn't been served? Background One of our internal services needs to interface with another service. The…
Loading
  • 21
  • 1
  • 3
2
votes
0 answers

scaling website to perform equally fast worldwide

Our website is growing and we get more and more customers all around the world. We use Nginx, PHP and MySQL Our servers are in UK, so it is fast in Europe, but the further we got away from servers - the slower the website becomes. (Call me captain…
Katafalkas
  • 523
  • 2
  • 8
  • 20
2
votes
1 answer

MongoDB PHP EC2 Setup Configuration

I am new to web development and server set up. I am looking for some advice or a link to a tutorial on setting up a production system up. Right now, I have a server (Ubuntu, Apache, MongoDB, and PHP). It receives a request, PHP queries Mongo, and…
w3rthl3ss
  • 135
  • 2
  • 7
2
votes
4 answers

What should I do to scale OUT a Sql2008 database?

I'm about to scale UP our sql2008 database. Simple. But I might need to scale OUT our sql databases. For a simple scale out situation (ie distributing the processing load), are there some good initial best practices? i know there's so many solutions…
Pure.Krome
  • 6,508
  • 18
  • 73
  • 87
2
votes
3 answers

How do multiple servers work in terms of databases?

I don't know an awful lot about servers, but I do know that there are many ways you can improve the performance of running a web application, in terms of hardware. For example, starting with a single server, you can: Move the database onto another…
Alex Coplan
  • 585
  • 1
  • 10
  • 19
2
votes
1 answer

File storage for replicated front-end web servers?

We are a company running a website with ~800k unique visitors each month with a constant growth rate of 35-40%. We have just gone from having one server to a dedicated mysql database and an nginx+passenger front end server. We're hitting the next…
miccet
  • 131
  • 5
2
votes
1 answer

Scaling advice LAMP + Load balancers

My current setup: 1 Http Load Balancer 3 Apache Frontend Server 1 Mysql Load Balancer (Balancing reads across all three, writes go to master only) 3 Mysql Database Server (1 master, 2 slave) All is good, but I have sudden scheduled bursts of…
bradley
  • 137
  • 1
  • 5
2
votes
2 answers

Small vs Medium EC2 instances for horizontal scaling with Elastic Load Balancer

I am having some debating around scaling Amazon EC2 instances. I have developed my app using ASP.NET, so I have to choose to go with a Windows EC2 instance. MySQL and images are served from other instanced, so the scaling goes (for now) only for the…
Liron Harel
  • 431
  • 1
  • 4
  • 13
2
votes
1 answer

Scaling by moving Database to Amazon RDS

We have a situation with an Application which is hosted on a dedicated server where we are anticipating a potential surge in traffic. The major bottleneck on the app is MySQL which is heavy on read and write. Although we have multiple levels of…
robjmills
  • 990
  • 9
  • 26
2
votes
3 answers

MySQL Hardware Specs

Currently we have a database that is 35gb in size and is running on a Virtual Machine with 2GB of RAM. The database is expected to increase at a rate of 3 to 4Gb per day continuously. What are the suggested hardware specs for this type of setup? CPU…
Jonar
  • 171
  • 4
  • 13
2
votes
1 answer

How to properly loadbalance separate fastcgi servers

We are running bigger deployment with multiple servers running Django applications under apache2 and mod_wsgi. We are considering switch to apache2 + fastcgi and moving fcgi processes to separate application server "layer". My question is: how to do…
Almad
  • 151
  • 7
2
votes
7 answers

How to deploy web application for 2 million users?

I've been tasked with figuring out how to do a large scale deployment for a high availability, high traffic, dynamic, flash based web application. There is a good possibility that this application can grow to 2 million users or possibly a lot more.…
lysdexic
  • 366
  • 1
  • 4
  • 11
2
votes
2 answers

Why do we get TCP disconnects when using AWS Elastic Load Balancer?

We are running our servers on AWS EC2 instances. The servers have to provide HTTP on port 80 and RTMP (TCP) on port 1935. Running a single instance works fine. But as soon as I use Elastic Load Balancing to balance the load between two EC2 instances…
Jan Deinhard
  • 2,383
  • 5
  • 26
  • 33