5
votes
4answers
412 views

Is MySQL required on both the database server and the webserver? why?

Is MySQL required on both the MySQL database server and the web server that it is connecting to? If it is required on both the web server and database server, please explain why this is. Moreover, if ...
1
vote
1answer
66 views

How to share data across two data centers? [closed]

Let say I have 2 data centers in 2 different cities. Datacenter A to serve city A, and datacenter B to serve city B. How do I achieve the following scenarios: Redirect users in each city to ...
1
vote
4answers
357 views

Is 2-5 ms between web and database server appropriate? (Different Datacenters)

I currently have a dedicated web and database server running in datacenter (DC) 1. Im about to expand with yet another web server in datacenter 2 that will talk to the db in DC 1. The latency ...
0
votes
1answer
41 views

Website and DB Backup - Windows Dedicated Servers and SQL Express

I have inherited a number of dedicated windows web servers running websites and local SQL Express Databases. We want to backup both the sites and the databases remotely - maybe to some cloud storage ...
1
vote
2answers
165 views

Nightly Backups and Server Performance

At a certain time we run a few backup scripts to backup: code/files databases other important files on the server During this time the websites on the server grind to a hault giving timeouts and ...
0
votes
2answers
762 views

Error while connecting to sql database

I am trying to access a sql database remotely. The database and the server are on two different ips. i have tried commenting out bind-address line and all the other things people have suggested in ...
1
vote
1answer
393 views

Network communication between dedicated web and database server

We're at the juncture (I can even say, right time) that we need to separate our database server apart from our application web server. This we arrived at after careful & thorough monitoring of ...
-1
votes
1answer
96 views

Webserver Layout [closed]

I would like some advice about a network layout for a medium company hosting a website/web service. Currently I have the following Layout in place...Network Layout I would like the private area ...
0
votes
1answer
127 views

Web server to DB server connection speed [closed]

we are designing a cluster of 2xnginx, 2xapache, 2xmemcache, 2xmysql servers for a high traffic web site. Current web site runs on 1 dedicated web server and 1 dedicated db server. the current web ...
3
votes
1answer
2k views

Postgresql table drop taking very long time

I am kind of new to Postgresql and server administration so I am not quite sure if this is normal behavior or not. Right now I am trying to drop a table with the cascade option. The command I used ...
0
votes
1answer
40 views

DB/Webapp Server Requirements Advice

I am building a MySQL database with a web front end for a client. The client and their staff will use this webapp on a daily basis, creating anywhere from a few thousand, to possibly a few hundred ...
3
votes
2answers
3k views

What are the best strategies for scaling up my web application to be able to cope with a large volume of users?

I want to get some advice / best practices for how to go about developing a strategy for scaling up my a web application. I waffle on a bit here and show my limited knowledge but want to fill in my ...
0
votes
1answer
131 views

Two MySQL Services on One Ubuntu Server Install

I am setting up a web staging environment and want to have a duplicate but separate MySQL service on the same machine. Development environments will connect to one service and staging environments ...
0
votes
1answer
261 views

Limit on concurrent connections: Determined by webserver or database?

Does the webserver or is it the database that limits the number of concurrent connections?
-2
votes
4answers
115 views

Overloaded webserver issues

I am new to the area of web development and currently interviewing companies, the most favorite questions among what people ask is: How do you scale your webserver if it starts hitting a million ...
3
votes
2answers
985 views

Should I turn off swap on AWS EC2?

I'm running a webserver and database server on the same AWS EC2 instance. I know it's a bad idea to have swap for web server, so should I just turn it off? Will it affect the database service (I guess ...
0
votes
4answers
550 views

2 dedicated servers, one for the database server, and the other for webserver?

i wanted to buy 2 dedicated servers, and have one for holding the mysql database and the other one for running the web application, im not sure if thats a good idea. p.s. in terms of accessing data i ...
8
votes
5answers
970 views

Is it risky to have a database server and a web server on the same machine?

It seems like life would be simple to run the database server on the same machine as the web server, but are we taking a big secuirty risk by doing this? The environment will be Windows 2008 server, ...
1
vote
2answers
311 views

Should a database server be in a different VM instance as an application?

I'm setting up a database server as a separate VM in my server so that I can control resources, and make backups of just that instance. I own a server that will reside in a colo soon. Is this the best ...
2
votes
5answers
325 views

what's standard web server downtime?

I want to know the standard of web server, file server, database server and print server downtime per day.
1
vote
2answers
205 views

Internal Data through firewall to our web site: What are my options?

We have a rather large internal MS SQL Database. I need to provide an interface on our website to some of our buyers. What are some good options for providing data to the website through our firewall? ...
0
votes
5answers
828 views

Complicated server/router/firewall question

I think this is a fairly advanced question, I hope someone with experience can help me. Deep breath, here we go: We're a small, but growing, website that is looking to add another server in so we'll ...
1
vote
2answers
3k views

Data center vs Data warehouse

I've heard both of these terms used frequently. What is the difference between a Data center vs. a Data warehouse? Are these terms interchangeable?
3
votes
2answers
180 views

Should we move our database to our (shared) web host?

The company I work for has been using an Access database for the past eight or so years (I've only had to put up with it for five). We're beginning work on an online ordering system so it's about time ...