1
vote
2answers
20 views

Limiting MySQL User to connect from Second interface

The web server and the MySQL servers have a second interface on a network with no public internet access. How can a MySQL user be restricted to connect only from within the private network and ...
0
votes
1answer
39 views

Need Server requirement estimates for my application [duplicate]

I am a newbie to Web Development and am trying to estimate the server requirements based on my application configuration. My application will have to perform simple database look-up based on unique ...
-1
votes
1answer
35 views

separate mysql server and webserver and consequences [closed]

I have a web application. bought a pretty strong server for it. Server specification is below: CPU: DUAL E5-2620 RAM: 32 GB DDR3 HDD: 2 x 300GB SAS 10K Network: 100mbps/10TB internet. WebServer ...
5
votes
4answers
387 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
0answers
28 views

Do I get any benefit by separating mysql from web server? [closed]

I currently have 20+ websites on a server and mysql is running on the same server. I am considering separating the mysql to another server and make all the websites get data from it. Do you think ...
0
votes
1answer
124 views

WHM/CPanel system applying a per-user MySQL resource limit

Through testing of our server, I have come to the conclusion that our server is somehow limiting usage per user to MySQL. When I run mysqltuner.pl, the script pegs one of the processors for several ...
-1
votes
1answer
51 views

Mounting ssd. Expectations vs reality about server load

I'v installed SSD on my server and moved tmp folder, mysql data folder and 2 most loaded websites(php) on it. I'v expected that server load will fall a little bit, but it seems that it is on the same ...
1
vote
2answers
397 views

Malware : Identifying & Cleaning Malware on a LAMP site

EDIT : Further information / investigation information contained in the comments to this post Apologies for the vague title - had trouble summarising this one. I have recently discovered that one of ...
0
votes
2answers
165 views

vps( Intel(R) Xeon(R) CPU L5520 @ 2.27GHz) vs dedicated (Intel(R) Xeon(R) CPU E3-1240 V2 @ 3.40GHz) beats it by 40ms in few mysql calls

as the title says i am pretty puzzled here as to why would the first(Linode) server beat the pretty well-known liquid-web dedicated server by 40-50miliseconds(averaging 10ms to complete vs 50-60ms on ...
0
votes
2answers
592 views

MySQL Tables crashing randomly

This is one of the many random Tables that get corrupted. Any ideas why and what would be causing this? How do I keep MySQL tables from crashing and MySQL from crashing? Repairing USR_wp537 ...
0
votes
2answers
100 views

Can I use two machines to set up memcache server for a php web app?

I have a web server which hosts my PHP web app and my MySQL server. I would like to throw out one more machine there to use it for memcache/memcached. In order to use Memcache, should I have a ...
1
vote
0answers
40 views

Apache + mysql + varnish eating all server memory with low very traffic [duplicate]

Possible Duplicate: Why does Red Hat Linux report less free memory on the system than is actually available? I've just installed Varnish in front of Apache2 to run a Magento ecommerce. Now ...
1
vote
1answer
170 views

PHP/MySQL Performance Testing with Just PHP [closed]

I'm trying to diagnose a server where the website is loading very slowly, but unfortunately my client has only provided me with FTP access. I've got FTP access so I can upload PHP scripts, but can't ...
-1
votes
1answer
123 views

How to cope with 10,000 people accessing a webserver in an hour? [closed]

I have a share hosting, and I charge 100$/year to host company websites. Those websites have a maximum of 2000 person per month access onto the site, mostly Wordpress. So everything is fine until a ...
0
votes
0answers
211 views

Remote mysql server slow

I need some help on speeding websites loading. I have two virtual machines created on my ESXi host. Thay are both on public IP addresses and that is how they communicate. On one virtual machines I ...
0
votes
1answer
129 views

Minimal MySQL dedicated server

I'm hosting an application with 1 server for the application and 1 server for the database. I did a fresh install of Ubuntu 10.04 LTS and installed mysql-server on the server, now I'd like to begin ...
0
votes
1answer
119 views

Querying a web API vs local database during a traffic spike?

I wasn't sure whether this was best suited to SO or SF, I originally posted this on SO - Link to original - but it seems to me now that it probably is better suited to SF. Moderators please feel ...
0
votes
1answer
809 views

Need help configuring Apache, MySQL, PHP on Centos Linux

I am new to Linux (CentOS) and have been trying to setup up this web application https://github.com/craigrodway/printmaster on CentOS for the last couple hours. The instruction from the author is a ...
0
votes
1answer
47 views

update of mysql server without break

Hy, I want to update my databases on my mysql server, but for now i usually take my server down before to the update. I wonder if there is any solution to make the update without any disruption of ...
0
votes
1answer
442 views

Reset Linode root password

I've recently been put in charge of a Ubuntu server in the Linode platform. This webserver is running a production Rails application with a MySQL database. I need to ssh into it to download a copy ...
0
votes
1answer
215 views

mysql/web server failover setup using reverse proxy

I have two webservers and at the moment have DNS - Round Robin setup so that they are somewhat 'failsafe' this was only ever a temporary failover solution and I am now looking at a more permanent and ...
3
votes
3answers
1k views

Where do I find .SQL files on Ubuntu Server?

I am migrating web servers. I'm kind of stuck on migrating the MySQL databases. I was wondering where to find the .SQL files, that I need for migration, under Ubuntu Server. I think the .SQL files are ...
0
votes
1answer
50 views

Questions about migrating a web server

I am about to migrate my web server. I am using Ubuntu Server on both systems. I've never done this and I need to know what I should look out for. Can I just copy the var directory? I have many ...
0
votes
2answers
672 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 ...
0
votes
1answer
124 views

Ubuntu web server unable to connect to web but still serves pages

I have been running our website on an ubuntu server for the last few months and all has been going well. However today the server will not allow connections externally so I cannot update wordpress ...
0
votes
1answer
240 views

Idle RAM usage increased from 144MB to 510 MB after upgrade to MySQL v5.5.16

So I am on a pretty tight budget (like a lot of folks) and I have a VPS running using Centos v6.0 x86. It has 1024 MB of RAM. I have Apache 2 and MySQL running. I recently upgraded to the latest ...
0
votes
1answer
33 views

Which OS (from stock) to act as an all-encompassing web application server for a java web app? [closed]

I am about to purchase a hosting package from Jumba for a VPS. (http://www.jumba.com.au/vps) They provide 3 options for OSes: CentOS 5 64-bit Debian 6.0 64-bit Ubuntu 10.10 64 bit Given these ...
-3
votes
1answer
58 views

Doubts about best choices for a webserver [closed]

I have this config. Quad core i7 930 (x64) 6gb ram WEBSITE architecture php language for website mysql and it is possible the use of cassandra SSL protocol three hundred thousand visits (daily) ...
0
votes
1answer
75 views

Web Server sercurity (used only for web services)

I am using a Virtual Private Server for accessing Web-Services used only on the Mobile devices, there are many entries in the access and error log, even there is nothing on the web server. I am ...
0
votes
2answers
166 views

Memcached and Mysql architecture

Right now we have 2 servers. webserver + memcached mysql server the mysql server is a new and a strong server and it is not being utilized fully. I was debating if I should migrate the memcached ...
4
votes
4answers
686 views

Run a Virtual Server or buy a Physical Server?

I am kind of having a hard time making a server decision. I will be setting up a server which will drive a very small, information only, website (maybe 10 visitors a day) as well as provide a private ...
1
vote
4answers
400 views

Unix command to download a file off my server?

I have a few php files on my server that I created and I'd like to download them to this computer for backup purposes. Is there an easy way to do this? (I'm connected to my server via SSH). Also, are ...
1
vote
3answers
934 views

How should I determine the right max_connections value for mysql on my web server?

Currently, it has none set... It is a debian machine running apache, php and mysql. What is the best way to determine the best value for this settings? Bonus points if you can also elaborate on how ...
8
votes
2answers
296 views

My server setup for a heavily used API

I will soon be buying a bunch of servers for an application that I am about to launch but I have concerns about my setup. I appreciate any feedback I get. I have an application which will make use of ...
0
votes
1answer
179 views

web server mysql replication over slow adsl lines

I would just like some recommendations. Currently i am sitting with a vps server in europe that hosts my webserver and my mysql database. It servers our clients as a place to download documents and ...
2
votes
2answers
101 views

General firewall / security procedures for webservers & databases

My webserver and database server are separate. All I've done to secure the webserver is used ufw and denied from all except ports 22, 80, and 443. What else really needs to be done there? On my ...
0
votes
1answer
133 views

Typical user database setup

I am putting together a small consumer website and am at the point to design and implement the users' database. I get from my PHP register form a username, a salt, a hashed pw, and some other data ...
1
vote
2answers
99 views

MySQL Database on my own computer

I am running Abyss Web Server on my personal computer and need to do some DB work with my website, but cannot access my actual hosting account with my hosting provider. Is there a way to kind of ...
0
votes
1answer
56 views

Managing multiple users on the same MySQL server

So, I'm going to be offering a LAMP for myself and a few of my friends. I want to make it so each user can create databases and delete them, etc. without seeing the other user's databases. I don't ...
0
votes
1answer
111 views

Best way to administrate web-app? [closed]

i'm looking for the best and safest way to administrate my mysql-databases etc. on my server. any advice on this? thanks
1
vote
1answer
89 views

Mysql Capacity with some Server specifications

I wonder how many capacity of Mysql. Please tell me with details of some Server Specifications(OS,CPU,RAM...). Thanks in advanced, Rithy
-2
votes
2answers
98 views

Linux Web Server Configuration

I am in a need to have my own web server as I use to have few websites to be tested on monthly basis. I plan to get some cheap P4 laptop which will do that task and am planning to install Ubuntu on ...
1
vote
1answer
212 views

How to setup port forwarding from my Webserver (apache) to my Database server (mysql)

and thank you for your help so far. Here is my problem: I have two remote dedicated servers, one webserver that runs apache, and one db server that runs mysql. The apache server is visible on the ...
0
votes
1answer
130 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 ...
1
vote
7answers
4k views

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 ...
0
votes
1answer
135 views

Web Server Setup

In my workplace, we want to implement your own web server for at leat 100 Apache/PHP/MySQL web pages. My boss is opposed to hiring skilled personnel, he think we can do ourselves. Currently, we are ...
3
votes
4answers
1k views

the right Servers architecture for a large facebook application?

We are a group of 3 students, we created a facebook application with more than 753,320 active users right now, application hosted on LAMP 1&1 server : - AMD Opteron 1352 4 x 2,1 GHz - 4 GB RAM. - ...
1
vote
3answers
203 views

Apache or nginx: for 10 requests a second on a tiny server?

What would you recommend for a small server setup, maybe 10 requests a second (using php and mysql, dynamic content)?
2
votes
3answers
198 views

What security is gained by separating the database from the web server (2 tier web architecture)?

I have confidential data stored in a mysql database that is served by a web server running on the same physical box. If I separate the two servers (and even put a firewall in between) how exactly have ...
0
votes
3answers
230 views

Web-Server directory permissions

I would like some help understanding web-server directory permissions. Apache, CentOS, PHP, Mysql Example, I have multiple sites in /var/www/html They are in paths like: ...