General :: MySQL And Apache Configuration For Busy Server?
Mar 4, 2011
I need to tune the mysql and apache server for the comparatively busy webserver. My scenario is like this.
1. The Web request is around 2000 request at a time or more.
2. Each web request will generate one mysql query.
3. The query to database is all read.
4. This server load will be at peak for around 3-4 hours after that the load will subside. As the task will be published, around 300,000 will be viewing the page.
5 quad servers are deployed, load is balanced via DNS but performance is not as expected. Centos 5.5 is used as OS. Top command shows The mysql process is around 185%!
View 3 Replies
ADVERTISEMENT
Feb 18, 2010
Just setup an Apache2 server, and I would like to setup a login. I also wanted to use the same method that is setup for vsftpd For vsftpd I've created a mysql database.... structured as:
Code:
mysql> use vsftpd
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql> describe accounts;
[Code]...
View 2 Replies
View Related
Mar 16, 2010
Good tutorial, using images for a lamp server that has, MySQL,PHP, Apache, FTP with all the fruit for running a server that will host a Gallery, forum and main site
I know there's heaps around for Ubuntu 9.10, but its not quiet what I'm looking for as in Gd, ImageMagick and some extras for Apache mods
View 1 Replies
View Related
Dec 20, 2009
how to do Mysql, PHP, Apache installation configuration, module/library update
View 2 Replies
View Related
May 26, 2011
I have installed latest Nagios and Nagios plugins. Nagios is working properly, but when I go to the browser n write the www.server-name.com/nagios, it gives
Not Found
The requested URL /nagios/ was not found on this server. How can I tell Apache to open Nagios on adding /nagios in my URL.
View 2 Replies
View Related
Apr 21, 2011
I'm running a linux cloud server with the following config
1.2ghz Processor allocation
752MB Ram
The site loads slow and clicking a link almost freezes the page for a second. Also, the page loads could be much faster. We've been running mysqltuner and have pretty much optimized all slow queries. Is there anything we can do to fine tune the server for faster and more responsive?
Httpd.conf
Timeout 20
KeepAlive Off
MaxKeepAliveRequests 100
KeepAliveTimeout 5
<IfModule prefork.c>
code....
View 2 Replies
View Related
Apr 2, 2011
I have to run multiple instances of apache on the same physical machine, as we have different OAM policies for different domains.is in the httpd.conf file can I have ServerName same in two instances of apache, like
ServerName: prod_machine (actual machine name)
In the vhconf files I do have different servernames for virtual hosts. Apache instances are running on same IP but different ports. I am including various vhost files in the main httpd.conf file. Can I skip servername in the main httpd.conf file and include different servernames in the virutal hosts configs. OS: Solaris10
View 1 Replies
View Related
Jun 2, 2010
i am using liferay5.2(mysql included in the download pack) on fedora. while liferay is working fine but i cannot connect to mysql.i am getting the error
[
[root@localhost ~]# ln -s /var/lib/mysql/mysql.sock /tmp
[root@localhost ~]# /etc/init.d/mysqld start
Timeout error occurred trying to start MySQL Daemon.
[code]....
i didnt find the mysql.sock file in the location /var/lib/mysql/mysql.sock. i cannot find the portal-ext.properties file also to make intial settings.
View 9 Replies
View Related
Jul 29, 2010
Running slackware13.1 with mysql on box2 and apache on box1 both in same lan. How do i configure mysql for apache connection? I have looked at many mysql config. howto which i can follow but i'm confused about whether the connection type is considered remote connection because the 2 services are on seperate boxes but are in same lan? Apache will be serving public webpages not just to the lan.
View 1 Replies
View Related
Jul 10, 2010
We are working on a new ERP for the company. This will run in MySQL 5.1.x, the GUI will be Web, the language PHP. This is a big project, is a good option to have the 3 applications in the same server or is better to have Mysql on 1 server and httpd+php on other server?
Speaking that I want to virtualize this app with Xen on Centos 5.5 as Host and the guest's will run Ubuntu.
View 3 Replies
View Related
Mar 15, 2010
I found the desktop version but I am wondering is there a server version where apache php mysql are all there?
View 1 Replies
View Related
Sep 24, 2010
I have a problem with AMXbans. My Linux is Slackware 13.0. , mysql is version 5.0.84, Apache/2.2.13,PHP 5.2.3 from locahost or real IP in internet explorer i see this error " Lost connection to MySQL server at 'reading initial communication packet', system error: 111".
In /var/log/httpd/error_log I see this error:
" [error] [client IP] PHP Warning: mysql_connect()
[<a href='function.mysql-connect'>>function.mysql-connect</a>]:
Lost connection to MySQL server at 'reading initial communication packet',
system error: : 111 in /var/www/htdocs/web/include/config.inc.php on line 48,
referer: http://My real IP/web/
//connect to db - "this is line 46"
$config->db_host=gethostbyname($config->db_host); "this is line 46"
$mysql = mysql_connect($config->db_host,$config->db_user,$config->db_pass) or die (mysql_error()); - "this is line 48"
View 1 Replies
View Related
May 25, 2009
I run mysqld on another server. I just switched to another dedicated server now, and i'm having trouble connecting to the mysqld server. If i run the php script from the bash console( php connect.php ) it works perfectly and connects to the mysqld server. However, if i run the script from apache ( http://localhost/connect.php ) it returns this: Can't connect to MySQL server on '(mysqld real ip)' (13) Mysql connection from another server(old httpd server) works perfectly, so it's not from the database server.
View 4 Replies
View Related
Apr 16, 2010
i have apache and mysql running, i can access my web server by visiting localhost on port 80 but for some reason when it doesnt work when i try using my ISP provided IP address... (it used to work).. i have my router setup with a DMZ on my LAN IP (my computers IP, this is the computer in my home network that serving with apache).. i also cant seem to shut down my mysql server (theres an update ive been trying to get) even when i use sudo...
View 5 Replies
View Related
Jul 17, 2010
I just installed Centos 5.5 on one of my systems today and something is eluding me. Basically I had a web site and forum software (phpBB, but I don't think it's that, other forum software like Xoops does the same thing) running on Fedora 13, and I copied it over to the new Centos installation. Apache is running fine and displays a PHP test file and .html files just fine.
MySQL seems to be fine, I can log into that, show databases etc. Just can't get any forum software to know there is MySQL there. I did change the path of the site, and the databases, and edited /etc/my.cnf and /etc/httpd/conf/httpd.conf to reflect that. Thought I made the needed changes in /etc/php.ini but who knows. Seemed like everything should have tar'd up and moved easy, but not the case...
View 5 Replies
View Related
Apr 11, 2011
I have been tearing my hair out with this. As part of a backend perl script i am holding the Epoch time as session data using apache session and mysql so i can delete sessions after an expiry period. When I retrieve the time it is about three months old even when i only just set it. The code example below best describes the problem:
View 5 Replies
View Related
Jul 11, 2011
I'm working on a side project where I would like to install three ubuntu server systems,each with only one task.So server0 would be the apache server, server1 would be the database and server2 would be the file server.which key terms I should be researching?
View 9 Replies
View Related
Aug 12, 2010
I started over combining the first parts of this guide: [URL]..ubuntu8.04 (Only the first few parts in terms of configuration and naming). Then I used this guide: [URL]..Surprisingly enough all steps worked.
1. Now I need to set up LAMP servers with MySQL master/slave replication and Apache rsync.
2. Next i need to add BIND to both my Load Balancers with master/slave backup and replication...
Are there any guides to look at to follow on these? Can tou point me to the right direction for BIND with replication.
View 1 Replies
View Related
Mar 21, 2011
I have install Mandriva 2009 and install apache server but its not strating on default configuration file . What I should do for starting apache . i have tried /etc/init.d/httpd start but apache is not running .
View 1 Replies
View Related
Aug 15, 2010
I am configuring apche on rhel5, I got default page successfully, and virtual page too, when I keep only one file index.html in virtual folder it goes well, that file opens correctly, but when I keep other html files except index.html server shows default page again.
View 2 Replies
View Related
Feb 1, 2009
I'm dual booting Windows XP and the latest version of Ubuntu.
I am trying to setup VHCS (vhcs.net)
In order to do so, it requires:
* Postfix (Version 2 or greater)
* ProFTPd
* Apache (Version 2 or greater)
* Courier POP3 and IMAP
* Bind9
* MySQL (Version 4 or greater)
* iptables
how to install on Ubuntu. I have done it with Windows XP, but not Ubuntu
View 14 Replies
View Related
Apr 21, 2010
how to connect to mysql database using php in Apache on Ubuntu?
View 4 Replies
View Related
Jun 18, 2015
Since upgrading from Wheezy to Jessie I have not been able to start the MySQL-server. When I do a "systemctl start mysql" I get the following answer on the console:
Job for mysql.service failed. See 'systemctl status mysql.service' and 'journalctl -xn' for details.
Entering 'systemctl status mysql.service' the answer is:
● mysql.service - LSB: Start and stop the mysql database server daemon
Loaded: loaded (/etc/init.d/mysql)
Active: failed (Result: exit-code) since Don 2015-06-18 18:35:41 CEST; 4min 1s ago
Process: 11272 ExecStart=/etc/init.d/mysql start (code=exited, status=1/FAILURE)
syslog and hostname.err don't show any pertinent messages.
View 4 Replies
View Related
Jul 2, 2009
I am new to linux. Currently I am using ubuntu 8.10 desktop operating system. As part of my academic project. I need to configure webserver to access from external. I installed all these using apt-get packages but when it comes to configuration. I am really not understanding. I read some documentation about this configuration but I couldn't get and fully in confused. I formatted my machine 3 times. When I tried to use localhost in firefox its working fine.
1. I need to change port from 80 to 7574. In port.conf I changed, in place of 80. I kept 7574. After that I restart and tried to access but its not working.
2. My admin provide to me. 7574 port to route it into my machine. When the user hits for suppose:
59.160.188.190:7574/project/route.html
It should goes to:
192.168.202.236:7574/project/route.html
Project folder is in /var/www
I wrote the form, to update user vehicle details. They can able to update their details in mysql server from any where.
3. Just I need the application user can access my files and update from their desktop by using path:
59.160.188.190:7574/project
How to update user details (there is no login form is directly visible to every one) in server from their desktop. What I need to configure.
View 1 Replies
View Related
Mar 20, 2010
I have apache running on my server, and also Zoneminder, a surveillance system running on the same machine. Both services runs without glitches, and I think apache's config as well as ZM's config are fine. I am not sure I understand how apache (not to mention the whole thing zoneminder, apache, web browser...) works. Pretty hard to manage when you dont know what you are doing. Also, when I try the supposed to work zoneminder webpage in my web browser, I get nothing (a blank page), or sometimes a "Not found" error message. The latest seems to be from apache because it is the same font as the "It works!" message when I try http://localhost:80
The only bit of information I have so far is in the apache error log (/var/log/httpd/error_log) and it says:
Code:
[Sun Mar 21 00:35:14 2010] [error] [client 192.168.0.100] script '/srv/httpd/htdocs/zm.php' not found or unable to stat
[Sun Mar 21 00:46:04 2010] [error] [client 127.0.0.1] File does not exist: /srv/httpd/htdocs/zm
It seems that the "zm.php" is missing.... That would be why Apache cant find the page?
View 14 Replies
View Related
Apr 28, 2010
If any one knows about Apache-Tomcat installation.
View 5 Replies
View Related
Sep 30, 2010
i have several sites hosted on one machine (Apache 2.2 on Debian). They are configured at /etc/apache2/sites-available/ with this configuration (part of it):
RewriteMap lowercase int:tolower
RewriteRule ^(.+) ${lowercase:%{SERVER_NAME}}$1 [C]
RewriteRule ^(([^./]+.)?site1.com)/(.*) /www/site1.com/www/root/$3 [L]
RewriteRule ^(([^./]+.)?site2.com)/(.*) /www/site2.com/www/root/$3 [L]
RewriteRule ^(([^./]+.)?site3.com)/(.*) /www/site3.com/www/root/$3 [L]
RewriteRule ^(([^./]+.)?site4.com)/(.*) /www/site4.com/www/root/$3 [L]
[Code]...
View 1 Replies
View Related
Aug 16, 2010
CentOS 5.5 + Apache 2.2(httpd.conf) + SSL confiuguration(ssl.conf) gives following error in FireFox.Secure connection failed.An error occured during a connection to localhost.SSL received a record that exceeded the maximum possible length.Errorcode:s_error_rx_record_too_longThe page you are trying to view cannot be shown because the authenticity of the received data could not be verified.
View 1 Replies
View Related
Dec 17, 2010
how to configure a web/database server.
Given:
IBM x3650 M3 with 6 x 300GB SAS and 16GB RAM CentOS 5.5 (LAMP) Software RAID with LVM haven't tried hardware RAID.
Here's the task:
Task 1. 3x300GB SAS will goes to /boot, /root, /var* and swap (RAID1 for /boot and RAID5 for the rest with LVM). Task 2. 3x300GB SAS will goes to MySQL Database (RAID5 and LVM). * My web content will be stored here. (/var/www/html)
I know how to perform Task 1, but I'm not familiar with Task 2. So how it can be done? What specific directory should i used to store my database?
View 1 Replies
View Related
Aug 3, 2011
how to install and run php, mysql & apache in rhel6 in 64bits redhat
View 2 Replies
View Related
