0
votes
1answer
53 views

What are good systems for managing Drupal infrastructure? [closed]

I work in a company which is about to migrate most applications from in-house custom built Java/Tomcat applications to Drupal. Due to company policies, applications and websites need to run on ...
0
votes
1answer
108 views

MySQL: Error establishing a database connection

I'm running a DigitalOcean.com Virtual Server with the typical Ubuntu LAMP Stack for a few WordPress sites. Of course, every week or two the MySQL service seems to crash. If I restart MySQL or the ...
1
vote
1answer
67 views

MySQL suddenly taking 2000 ms per request, instead of 200

UPDATE: finally remembered to look at munin, and it seems that one of the HDDs is the root of the problem after all, unless I'm totally reading this wrong. Here's the munin output: ...
0
votes
1answer
30 views

mysql client won't run on my Ubuntu instance

Running a LAMP server on Ubuntu 12.04. Trying to run mysql from the command line like so: root@server:~# mysql -u 'wp-user' -p and I'm getting mysql: ambiguous option '--v' (vertical, version) ...
0
votes
1answer
421 views

Xubuntu Desktop 14.04 - service mysql start unknown job

I installed fresh XUbuntu desktop 14.04 (as a dev system) and then lamp server using sudo apt-get install lamp-server^. I can type mysql and mysql console run but if I try service mysql start I got: ...
-3
votes
1answer
94 views

Improve LAMP performance Ubuntu 12.0.4 [closed]

cpu 1.3% mem 476/490MB swap 347/511mb tasks: 43, 29 thr; 1 running load average: 0.10 0.08 0.06 via htop:<br> /usr/sbin/apache2 -k start (listed 8x @ 8.1% mem each) /usr/sbin/mysqld (listed ...
0
votes
2answers
34 views

Distributed LAMP vs DB and Web Server same box

We have a very read heavy semantic web (RDF) application which is RHEL 5/Apache 2.2.3/Tomcat 6/Java 6 on one Server, and MySQL 5.1 on another. Apache and MySQL are backported Red Hat repo stuff, so ...
0
votes
1answer
48 views

How to determine what memory was freed

We have a somewhat complex LAMP stack running a variety of websites using Litespeed instead of Apache on Centos 5. Once everything is up and running, the memory usage of the system is fairly ...
1
vote
4answers
164 views

Setting up dev environments with big databases

This is my first time here. I recently joined as a system admin at a company and my recent assignment is to make friendlier dev environments for our devs. Until now our devs connect to our remote box, ...
2
votes
1answer
55 views

Need advice on documenting LAMP web site

I need to document my web site. It is a music web site on Linux/Apache/MySQL/PHP on AWS. I need to document everything: architecture (5 servers), database (100+ tables), php classes, programming ...
0
votes
1answer
80 views

server out of memory - mysql processes?

I have inherited a system build in PHP (LAMP) and it keeps going offline due to running out of memory every week or so. There's 4gb of RAM available. I've asked my hosting provider twice to look in to ...
0
votes
1answer
117 views

Optimal setup for bulk CSV import

We're currently running a Wordpress site but need to import 10,000 - 20,000 posts per day from CSV files. Our current setup is an all-in-one LAMP server with 8GB RAM and 8 Virtual Cores. The import ...
0
votes
1answer
139 views

LAMP stack everything seems to be working except sites are blank

I have a LAMP stack, Ubuntu 12.04.3 LTS PHP 5.3.10-1ubuntu3.8 with Suhosin-Patch (cli) (built: Sep 4 2013 20:05:42) Apache/2.2.22 (Ubuntu) MYSQL 5.5.32-0ubuntu0.12.04.1 (Ubuntu) Codeigniter 2.1.0 ...
0
votes
2answers
191 views

MySQL geographic replication cloud

I currently have a standard local LAMP setup, (2 web servers, master/slave MySQL, load balancer). This is severing me well locally, but my global users experience slowness. I want to setup some ...
-6
votes
1answer
255 views

2GB RAM VPS with LAMP. How can i improve performance and loading times? [closed]

I recently upgraded my VPS(OpenVZ VT) to 2GB of RAM. Despite the configuration changes i make to the LAMP stack the websites loading times take up to 5-10 seconds to fully load. I use prefork with apc ...
1
vote
3answers
679 views

MySQL server keep on crashing

I'm facing a problem that i can't figure out, for some reason my MySQL server keeps on crashing after 30-40minutes the server load itself isn't too high, it's not even 0.5 (for 2 cpu machine) i've ...
0
votes
0answers
235 views

Mysql won't start after replacing data in datadir.

so I have a little problem. I had errors with our old system and was unable to backup the old databases properly so I went ahead and backed up the datadir which had all of the databases folders inside ...
0
votes
1answer
74 views

Table Locking - Large number of inserts - How do I identify the source of the inserts?

I usually post on Stack Overflow, but I think this may be the more appropriate forum for this question.... I have a dedicated server that servers several million pages monthly. We use LAMP. We're ...
0
votes
2answers
60 views

Testing after migrating LAMP install on CentOS 6

I copied the /var/www/html/site directory to a new server and all of the /etc/httpd conf files, installed the necessary Perl modules, php, and ran cat mysqldumpfile.sql |mysql db_name to import the ...
0
votes
1answer
153 views

MySQL using large amounts of CPU while idle

A webserver (Apache + MySQL) locked so badly that I had to powercycle it, and immediately logged in to see what was going on afterward. Load average was over 3%, with MySQL hovering between 20% and ...
0
votes
1answer
112 views

mysql 5.6+ lamp AMI

I used couple of ec2 instance, ebs etc. Now I need to configure new system, and I think AMI search sucks! What I need is Ubuntu,64-bit, ebs mount, lamp+phpmyadmin, MySql Version > 5.6 . Is there ...
0
votes
0answers
396 views

odd “waiting for localhost” loading delay on wordpress ubuntu 12.04 server LAMP install

I have just installed wordpress (last version) on /var/www/wordpress on a default ubuntu server 12.04 LAMP installation. Every time I want to load something on this wordpress (even the login screen) ...
0
votes
3answers
321 views

MySQL reinstall questions

For some reason my /var/run/ dir on debian6 had it's chown and chmod changed. Problem is from what? Outcome is that mysql fails. I'm guessing the easiest way to fix is to reinstall MySQL. (Previously ...
0
votes
2answers
148 views

Mysql very slow, out-of-the-box configuration

I just installed AMP stack on a VPS. I logged in to mysql console and found out that queries were incredibly slow. A single update query, targeting 1 row in a table with ~200 rows took 0.5 seconds to ...
1
vote
1answer
219 views

How can I narrow down why Apache randomly stops serving pages?

I am running a Turnkey Linux LAMP stack (based on Ubuntu). The server is hosting a relatively large WordPress installation with a pretty hefty amount of allocated RAM (on a dedicated machine). We get ...
-1
votes
2answers
877 views

MySQL 5.5.27 crashes randomly on centOS 5

I am using godaddy's dedicate server to host my web application, it's centOS 5(I have no idea why they are still using this.), I installed mysql in that server, everything was running OK since one ...
1
vote
1answer
89 views

Best way to Install Lampp setup on Ubuntu

What is the best way to install a lampp setup in ubuntu? I know to install using xampp. Is it ok for using as a central development server? Or if am installing individually what are the packages i ...
-3
votes
1answer
186 views

LAMP servers performance: Can I improve them by adding more RAMs? [duplicate]

Possible Duplicate: How do you do Load Testing and Capacity Planning for Web Sites Let me refine my questions: 1. How can I improve MySQL performance? 2. Will adding more RAMs help? 3. Will ...
2
votes
4answers
2k views

Need working guide to install latest Apache or Nginx, PHP & MySQL for production

Ok I'm told the best and easiest way to install Apache/Nginx, PHP, MySQL for production these days is to pull in the software using apt-get or similar package manager for your specific distro. The ...
1
vote
2answers
88 views

What is the recommended linux user to create MySQL databases under LAMP?

I'm trying to set up a simple LAMP system while keeping some basic security in mind. If I want to create a MySQL to be accessed by PHP, under what user should create databases? Any references to best ...
1
vote
3answers
574 views

Cannot Log Into phpMyAdmin - Nothing Happens

I'm running a simple LAMP server at home from which I host a personal blog. The server is running Arch Linux, with the latest-and-greatest versions of Apache, MySQL, and PHP. In order to easily ...
1
vote
1answer
4k views

How to install mysqlnd for php 5.3.3 on Centos 6.2

I have just down graded my PHP-installation from 5.3.9 to 5.3.3. This in order to be able to use yum/EPEL instead of compiling everything myself. Appearently, mysqlnd-support isn't available in ...
0
votes
3answers
282 views

Database server, Webserver - RAM versus Server Load relationship between servers

We have a website running on 2 servers: 1 database server, 1 webserver. Our understanding was that we had 4GB RAM on the webserver and 8GB RAM on the database server. The site is database intensive ...
0
votes
1answer
71 views

Shared Hosting using Linux [closed]

I am planning to set up a server hosting multiple websites on a single high-end Linux server on Virtualization-enabled Hardware using a LAMP stack. I have decided to go with Centos 6.2 as a KVM host ...
1
vote
0answers
376 views

Can I run Zend Server along with already-installed LAMP Stack?

I already have Apache2+MySQL+PHP installed and am using it on Ubuntu Linux. I would like to test out the Zend Framework installation bundled with Zend Server, since the server is supposed to be ...
1
vote
2answers
437 views

Increasing the concurrent user performance in LAMP application

We have a LAMP application where we have started to feel the performance pinch due to large number of concurrent users connecting to the application. I have looked at the individual parameters of ...
1
vote
1answer
201 views

mysql always using maximum connection

I have LAMP server having 4 core CPU and 32 GB RAM.We are running a large website on it. I have following issues now in my server. When I use Mysqlreport tool to monitor the mysql server i am always ...
-1
votes
2answers
144 views

What configurations need to be set for a LAMP server for heavy traffic? [closed]

I was contracted to make a groupon-clone website for my client. It was done in PHP with MYSQL and I plan to host it on an Amazon EC2 server. My client warned me that he will be email blasting to about ...
2
votes
4answers
472 views

Server not coping, cpu load averages spike to 33.0

Basically I have a server failing under load. Its a editorial news site that see irregular traffic spikes. I'm tearing my hair out trying to stabilise the LAMP configuration. Current Time: Wednesday, ...
3
votes
3answers
819 views

Copy MySQL to RAM as a poor man's memcached replacement?

What about this idea: I've got a 4GB MySQL database, with few UPDATEs. On system startup I copy it to RAM and run it from there. Every couple of hours or even on UPDATES, I dump it to disk. ...as ...
-3
votes
2answers
103 views

Is it enough just to install LAMP? [closed]

I use yum to install LAMP on Centos, like this: yum install httpd mysql mysql-server php php-mysql chkconfig --levels 235 httpd on chkconfig --levels 235 mysqld on service httpd start service ...
2
votes
1answer
174 views

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 ...
0
votes
2answers
149 views

Running 2 LAMP stacks on one instance

I have a working installation of apache and mysql using standard ports, and my host file points domains to 127.0.0.1. I'm in the process of switching my LAMP stack to Zend Server but want my old set ...
0
votes
1answer
337 views

Installed LAMP server and php myadmin, no .my.cnf file

I just installed apache LAMP server along with phpmyadmin to make database editing easier. Now that I've installed everything, I can't find the .my.cnf file that should have been generated. I thought ...
3
votes
3answers
5k views

phpmyadmin connecting to a remote server [closed]

I have two servers (ubuntu 10.04 amd 64). one i plan on the webserver, the other i plan on being the database server. The webserver is the only server with access to the outside world. I installed a ...
2
votes
5answers
667 views

Track resource usage on Ubuntu server while I'm sleeping?

I've got a pretty typical LAMP server running a web site but sometimes, during the night, resource usage skyrockets and the site becomes unresponsive. There are a lot of logged errors about being ...
3
votes
1answer
639 views

LAMP memory management (CentOS)

First of all, I have to say I am not an expert in server administration. I have done web programming for 10+ years on several platforms, but have most of the time come to a readymade situation where ...
0
votes
2answers
337 views

Accessing databases from different domains on same server

I have a LAMP server - on there I have multiple domains. Each domain has its own user, db's, public_htmls/, etc. I need to access Domain A's database from a web app on Domain B in php. Currently I ...
0
votes
1answer
234 views

cron to merge xml into sqlite every two hours - lamp

I'm looking to auto pull an xml file from an offsite url and merge it into a sqlite db every two hours. The server is lamp. (If it is too difficult to do for sqlite, then merging the xml into a mysql ...
0
votes
3answers
139 views

MySQL on Linux (Redhat) freezing with queries on large tables

We have a server running LAMP which contains a number of zencart sites. We noticed a problem when trying to view orders in one of the sites and it timed-out. Now when I do: "select * from orders" ...