Connect To Mysql From Many Remote Virtual Hosts

Jan 9, 2007

I have a set up where server 1 holds a mysql DB and a virtual host. server 2 holds many virtual hosts in apache (16) connecting to this DB.

The virtual hosts all hold the same script, but the single VH on server 1 receives about the same amount of visits as all the VHs of server 2.

server 1 is very busy at times, like 100% CPU and a load around 10 for long period of times.
server 2 is not very busy, around 30% CPU usage and 0.6 CPU load.

Yet, users on server 2 experience *much slower* response times than the ones on server 1.

The obvious reason could be the network between the two, but I'm not convinced (6 seconds for a query run from server 2 when it brings back 1 row and takes 0.01 second from server 1).

I was wondering what other reasons it could be.

The mysql processlist is weird:

Code:
mysql> show processlist;
+-------+----------+---------------+----------+---------+------+--------------------+------------------------------------------------------------------------------------------------------+
| Id | User | Host | db | Command | Time | State | Info |
+-------+----------+---------------+----------+---------+------+--------------------+------------------------------------------------------------------------------------------------------+
| 81817 | mysite | localhost | mysite | Sleep | 865 | | NULL |
| 94992 | mysite | server2:47927 | mysite | Sleep | 188 | | NULL |
| 96890 | mysite | server2:50881 | mysite | Sleep | 26 | | NULL |
| 97213 | mysite | server2:51010 | mysite | Sleep | 22 | | NULL |
| 97391 | mysite | server2:51085 | mysite | Sleep | 36 | | NULL |
| 97919 | mysite | server2:51300 | mysite | Sleep | 49 | | NULL |
| 97927 | mysite | server2:51306 | NULL | Sleep | 49 | | NULL |
| 97933 | mysite | server2:51282 | mysite | Sleep | 48 | | NULL
| 97933 | mysite | server2:51282 | mysite | Sleep | 48 | | NULL |
| 97958 | mysite | server2:51321 | mysite | Sleep | 26 | | NULL |
| 97961 | mysite | server2:51323 | mysite | Sleep | 46 | | NULL |
| 98104 | mysite | server2:51344 | mysite | Sleep | 39 | | NULL |
| 98169 | mysite | server2:51376 | NULL | Sleep | 36 | | NULL |
| 98177 | mysite | server2:51388 | mysite | Sleep | 9 | | NULL |
| 98365 | mysite | server2:51461 | mysite | Sleep | 26 | | NULL |
| 98377 | mysite | server2:51427 | mysite | Sleep | 26 | | NULL |
| 98380 | mysite | server2:51468 | mysite | Sleep | 6 | | NULL |
| 98394 | mysite | server2:51474 | mysite | Sleep | 26 | | NULL |
| 98404 | mysite | server2:51479 | mysite | Sleep | 26 | | NULL |
| 98418 | mysite | server2:51486 | mysite | Sleep | 26 | | NULL |
| 98419 | mysite | server2:51487 | mysite | Sleep | 26 | | NULL |
| 98429 | mysite | server2:51496 | mysite | Sleep | 2 | | NULL |
| 98503 | mysite | server2:51520 | mysite | Sleep | 22 | | NULL |
| 98512 | mysite | server2:51524 | mysite | Sleep | 22 | | NULL |
| 98514 | mysite | server2:51525 | mysite | Sleep | 20 | | NULL |
| 98519 | mysite | server2:51526 | mysite | Sleep | 22 | | NULL |
| 98557 | mysite | server2:51514 | mysite | Sleep | 21 | | NULL |
| 98568 | mysite | server2:51548 | mysite | Sleep | 20 | | NULL |
| 98581 | mysite | server2:51557 | mysite | Sleep | 5 | | NULL |
| 98617 | mysite | server2:51572 | mysite | Sleep | 18 | | NULL |
| 98620 | mysite | server2:51574 | NULL | Sleep | 18 | | NULL |
| 98630 | mysite | server2:51577 | mysite | Sleep | 17 | | NULL |
| 98644 | mysite | server2:51584 | mysite | Sleep | 17 | | NULL |
| 98681 | mysite | server2:51601 | mysite | Sleep | 15 | | NULL |
| 98698 | mysite | server2:51604 | mysite | Sleep | 14 | | NULL |
| 98704 | mysite | server2:51606 | mysite | Sleep | 14 | | NULL |
| 98714 | mysite | server2:51610 | NULL | Sleep | 14 | | NULL |
| 98736 | mysite | server2:51619 | NULL | Sleep | 13 | | NULL |
| 98748 | mysite | server2:51626 | NULL | Sleep | 12 | | NULL |
| 98753 | mysite | server2:51628 | mysite | Sleep | 12 | | NULL |
| 98785 | mysite | server2:51635 | mysite | Sleep | 11 | | NULL |
| 98820 | mysite | server2:51654 | mysite | Sleep | 10 | | NULL |
| 98821 | mysite | server2:51655 | mysite | Sleep | 10 | | NULL |
| 98822 | mysite | server2:51656 | mysite | Sleep | 10 | | NULL |
| 98823 | mysite | server2:51657 | mysite | Sleep | 10 | | NULL |
| 98836 | mysite | server2:51660 | mysite | Sleep | 9 | | NULL |
| 98840 | mysite | server2:51662 | NULL | Sleep | 9 | | NULL |
| 98841 | mysite | localhost | NULL | Query | 0 | NULL | show processlist |
| 98901 | mysite | server2:51680 | mysite | Sleep | 6 | | NULL |
| 98903 | mysite | server2:51651 | mysite | Sleep | 7 | | NULL |
| 98920 | mysite | server2:51684 | mysite | Sleep | 6 | | NULL |
| 98947 | mysite | localhost | mysite | Sleep | 1 | | NULL |
| 98954 | mysite | server2:51696 | mysite | Sleep | 5 | | NULL |
| 99024 | mysite | server2:51710 | mysite | Sleep | 1 | | NULL |
| 99031 | mysite | server2:51712 | mysite | Sleep | 2 | | NULL |
| 99032 | mysite | server2:51686 | mysite | Sleep | 2 | | NULL |
| 99041 | mysite | server2:51694 | mysite | Sleep | 2 | | NULL |
| 99049 | mysite | server2:51717 | mysite | Sleep | 2 | | NULL |
| 99058 | mysite | server2:51720 | mysite | Sleep | 1 | | NULL |
| 99063 | mysite | server2:51685 | mysite | Sleep | 1 | | NULL |
| 99064 | mysite | server2:51722 | mysite | Sleep | 2 | | NULL |
| 99073 | mysite | localhost | mysite | Sleep | 1 | | NULL |
| 99075 | mysite | server2:51724 | mysite | Sleep | 1 | | NULL |
| 99086 | mysite | localhost | mysite | Query | 1 | Creating tmp table | SELECT DISTINCT * |
| 99089 | mysite | localhost | mysite | Sleep | 1 | | NULL |
+-------+----------+---------------+----------+---------+------+-----------

Why so many sleeping processes from server 2, and none or almost none from server 1 ?
Is it normal that every query from server 2 is open on a different port ? Should they be grouped by virtual host, or is there one different port for each script running concurrently?

What could be a reason for server 2 having problems to open connections on server 1, and how to solve it?

Right now I'm about to deport more users from server 1 to new virtual hosts on server 2, hoping it will lower the load on the first machine and overall accelerate the response times. I just thought I'd post here first because this all seems very weird to me and i thought someone with an external look might tell me what I'm doing wrong. And also if network would be the problem maybe that's not the clever thing to do to make more users remote.

ADVERTISEMENT

Plesk 12.x / Linux :: Unable To Connect To MySQL Hosts

Jul 18, 2014

After changing my web hosting (same system : VPS, same version of linux : CentOS 6 , but passage from Plesk 11 to 12), i am now unable to connect remotely via TCP-IP to my mysql databases (with third-party tools like Mysql Workbench, Toad...) ! I never met this problem before.

The only way to connect is to use a "Standard TCP-IP over SSH" connection method ... but i don't want (i did'nt need this method before) !

Though, remote connections are allowed from any host in the settings.

View 3 Replies View Related

Users Cannot Connect To Remote MySQL Server

May 8, 2009

I have a few users that have a hosting account with me and are trying to connect to their own MySQL servers elsewhere. Both said that they are able to connect to the MySQL server with other hosting accounts but not the ones hosted with me. I asked if they had setup permissions to allow remote connections from my server and they confirmed that they did.

What am I missing? Do I need to configure my firewall somehow? I figured the connection is just using port 80 since it's from an PHP script right?

View 4 Replies View Related

Apache :: Virtual Hosts With Windows 8 Hosts File

Aug 11, 2013

I am running Apache2.2, PHP5.I have been running with virtual hosts on a Windows 7 environment fine for a couple of years successfully, but have just had to move to a Windows 8 environment.It looks like Apache and PHP have installed and are working fine, but my Virtual hosts are now not being recognised. From what I can tell, it is the Windows 8 hosts file that is having a problem, as it looks as though it is now just setup to Block websites.

If I make the host file just have the one line127.0.0.1 localhost entry, then the very first Virtual Host from my apache config file will come up, but the rest are not found.If I put the usual 127.0.0.1 mywebsite.name aliasname is appears as though my website works momentarily and then is blocked..

View 7 Replies View Related

How To Connect Virtual PC To Host PC

Jun 10, 2007

I've downloaded and installed the Microsoft Virtual PC image for testing IE6. The development copy of my website is on the host PC, running on Windows XP/Apache/PHP. I need to use IE6 on the virtual PC to view pages served up by Apache on the host PC.

I know this requires networking them together, but I've no idea how to do that. I've installed the Microsoft Loopback Adapter on the host PC, and told the virtual PC it can use that adapter in the Virtual PC settings dialogue, but on the host PC the loopback adapter says "limited or no connectivity".

(Before someone suggests it, I've been using MultipleIEs. Trouble is, you can't test printing with that - you need a proper copy of IE6.)

View 9 Replies View Related

Can't Connect To Remote Desktop

Dec 14, 2008

I signed up for a Win2k3 VPS account with 3dgwebhosting. I'm a newbie to Plesk and win2k3 so I spent the first day getting head around Plesk.

I then logged into Remote Desktop only to find someone else had beat me. They'd hacked in and downloaded a mass email client, email stripper and obviously sent out spam from a 2mb text file of email addresses.

I didn't spend long in Remote Desktop, but while there I switched on Windows Firewall, changed my admin login password and logged off.
Now, 24 hours later, I can't get back in. I get the error - This computer can't connect to the remote computer. Try again.....

I can still login through Plesk, FTP and ExpressionWeb.

Is FW keeping me out of RD or has the hacker returned?

View 2 Replies View Related

Remote SQL Connect Web Hosting

Aug 5, 2007

shared hosting for multiple websites, but I have some specific requirements:

1) Remote connections to a SQL database (using SQLCompare)
2) ASP.NET 2.0
3) A decent control panel to set things like subdomains up

Other features such as disk space aren't as important to me. I'm just having trouble finding any hosting that allows remote connections. Right now I'm using godaddy and it's great... just no remote connections.

View 11 Replies View Related

How Can I Connect My Printer With My Server,and Remote Print

Jan 22, 2007

i rent a server,and i also have a printer on my office, how can i connect my printer with my server,and remote print?

View 6 Replies View Related

Apache 2.0 Virtual Hosts

Oct 13, 2007

I just have a question about an Apache 2.0 error. I am running a web host and I am using VHCS for my web hosting control panel which creates virtual hosts in Apache's config files. Whenever I have a certain number of virtual hosts (200 or more roughly) Apache will start giving me problems with no messages about what went wrong. Some examples of what Apache does is that it will crash when I run "apache2ctl restart" or it just won't run when I start it sometimes. It really annoys me since I'm wondering if it's an Apache memory issue. Any ideas on what to do or how to solve this dilemma?

View 2 Replies View Related

Proftpd :: Set Up Virtual Hosts

Jun 8, 2009

What I want to do is setup virtualhosts for my clients and set the user/group that their files upload as. been on google and im guessing ill need to setup mod_auth?

View 2 Replies View Related

About Apache Virtual Hosts

Nov 15, 2008

i bought some webspace and i have uploaded mywebsite.I need to configure my domain atomuss.com to have virtual hosts.How is that done?.I have tried contacting my webmaster and it seems he is making himself unavailable everytime i speak want a word with him.
Anybody..

View 5 Replies View Related

Name Based Virtual Hosts - Anything I Should Know

Nov 26, 2008

I'm aware that millions of websites using shared hosting are configured with name based virtual hosting.

I'm just wondering now how name based vhosts could be a disadvantage for hosting our websites?

Currently we have a static IP address for each website, apache configured with vhosts for each of these IP Addresses.

I was thinking about re-configuring to name based vhosts, use up less IP Addresses and only have one or two for domains to point to per server.

Is there anything I should know about name based vhosts?

Currently I know of the following issues:

- I can't setup SSL (I don't think?) without a unique IP, but this doesn't matter to me.

- Apache may be making DNS lookups?

This post may seem a bit silly overall, I doubt there is anything important to note about name based vhosts, but just wanted to know if anyone knew something I should know.

Our current ip based vhost setup works, but it would be nice to drop usage on all of those IP Addresses and we have no need for IP address access from browsers and whatnot.

View 4 Replies View Related

Virtual Hosts Slower

Jun 26, 2007

I seem to be experiencing slower bw throughput in speedtests on my server today on a domain that is on a shared ip as a virtualhost in apache 2.2.x on fedora core 6.

Right now this domain is pushing somewhere around 35Mbits out and 1Mbit in.

When I d/l from this domain I see pausing and overall performance is roughly 1/2 of what it was yesterday (400K/sec versus ~800K yesterday), when the site was only doing about 3Mbits.

However, another domain on this same server that is not on a shared IP, when I test it, I get my usual 100% d/l speed.

My server is not under heavy load, .02, .06, .00 with 95% idle cpu.

I'm just wondering, should sites with high bw use definitely have their own IP, as shared/virtual hosting is known to cause slowness?

View 8 Replies View Related

Apache :: Virtual Hosts Through SSH

Jan 12, 2013

I have a little trouble with my Apache configurations. I have two computers with Ubuntu and Apache 2.2 - let's call them Home (192.168.1.2) and Server (192.168.1.3) connected with a router. I am working on Home, connecting to Server via ssh and mounting the web root directory of Server to Home via sshfs -> Server's /var/www becomes Home's /home/username/www. The problem is I can't really setup my Apache virtual hosts. I have a project in Server's /var/www/project, respectively Home's /home/username/www/project, and I want to create a virtual host on Home that lets me view the remote contents.

This is what I am adding to Home's /etc/hosts: 192.168.1.3 project

This is what I am adding to Home's /etc/apache2/sites-available/project:

<VirtualHost 192.168.1.3:80>
DocumentRoot /home/username/www/project
ServerName project
</VirtualHost>

After all this, when I open http://project/ in Home's browser, I just see the default apache page of Server (the one in /var/www).

View 1 Replies View Related

Apache :: Two Virtual Hosts With Only One Using SSL

Oct 12, 2013

I am messing with Apache at home and have managed to create virtual hosts with no problems, my next step was to produce a self signed SSL cert. which again has worked but it's redirecting my non-SSL virtual host to the host I have set-up for SSL for example:

- www.mysite1.com set-up with SSL and works as designed both http and https
- www.mysite2.com I don't want using SSL is working fine through http but if you try https it will then redirect to www.mysite1.com

View 1 Replies View Related

Tomcat Virtual Hosts And Permissions

May 22, 2008

I am just getting started with my first Linux VPS account and am having a problem that I hope someone can help me with. I am setting up multiple client accounts that will each have access to Tomcat Manager on their own domain so that war files can be deployed to the home directory of the respective account. I was able to get Tomcat Manager going for each domain, but when I try to upload a war file, I get a permission denied error. However, I don't get this error for the main VPS account.

What is the best way to resolve this? Is there a way to link a client account user to an instance of Tomcat Manager? Or do I have to assign the home directory of the account to a group that is common to the tomcat user (assuming that is what Manager is running under)? Or is there another option that is entirely better?

Just looking for some guidance before I hack up my new account too bad.

View 3 Replies View Related

Seperate Virtual Hosts File

Nov 14, 2007

I have been reading the Separate Virtual Host Configuration Files configuration reference, but just not clicking.

I want to take each of my httpd.conf domain configurations and store them in seperate files on the drive.

Can someone give me real world examples from their config of what is needed in httpd.conf and then what is needed in each seperate host file.

View 8 Replies View Related

Win 2003 Apache 2.2 Virtual Ssl Hosts

Mar 30, 2007

I have been tearing my hair out over this, I have a small problem, I am trying to set up multiple virtual hosts using ssl on port 443. I have followed instructions and set up IP based hosts with my single network card having two different IP's. but the problem is that the second IP is not recieving any requests from the router as it is using the certificate from the first host and diverting to the result of the first sites authentication process.

any one know how I can do this, the first router forwards all requests to the second more secure router which then forwards to the server which is working fine. I need to get this to work and don't know how. both routers support NAT and ther servers first IP address has been assigned a NAT IP.

I can't include the conf file as the board won't let me until I have posted 5 times....but if you need it I can email it or something

the virtual hosts on port 80 are name based....does this matter?

View 0 Replies View Related

Apache 2.2 Windows Virtual Hosts

Jun 24, 2013

Ok so I just installed apache 2.2 on windows server 2008.

I would like to set it up so if I go to 99.144.79.25(Server IP) I get index1.html. If I go to example.com which points to 99.144.79.25 I get index2.html. If I go to example3.com which points to 99.144.79.25 I get index3.html.

So kind of like, if the domain folder is not found on my server, give the page index1.html.

In the long run I want to run a bunch of sites with different domains, testing right now though.

View 1 Replies View Related

Init: You Should Not Use Name-based Virtual Hosts In Conjunction With SSL!!

Jul 11, 2008

Just discovered Apache log: ssl_engine_log

As far as I can tell, SSL is working perfectly on my server. Though I am wondering why I am getting errors logged? By the looks of it, I've been getting them every day since I opened my server.

Here's a few:
[30/Jun/2008 04:30:46 04877] [warn] Init: (host.mywebsite.com:443) You configured HTTP(80) on the standard HTTPS(443) po$
[30/Jun/2008 04:30:46 04877] [warn] Init: SSL server IP/port conflict: mywebsite.com:443 (/usr/local/apache/conf/httpd.c$
[30/Jun/2008 04:30:46 04877] [warn] Init: You should not use name-based virtual hosts in conjunction with SSL!!
[30/Jun/2008 04:54:05 04877] [warn] Init: (host.mywebsite.com:443) RSA server certificate is a CA certificate (BasicCons$
[30/Jun/2008 04:54:05 04877] [warn] Init: (mywebsite.com:443) RSA server certificate CommonName (CN) `www.mywebsite.c$
[30/Jun/2008 04:54:05 04877] [warn] Init: (host.mywebsite.com:443) You configured HTTP(80) on the standard HTTPS(443) po$
[30/Jun/2008 04:54:05 04877] [warn] Init: SSL server IP/port conflict: mywebsite.com:443 (/usr/local/apache/conf/httpd.c$
[30/Jun/2008 04:54:05 04877] [warn] Init: You should not use name-based virtual hosts in conjunction with SSL!

View 5 Replies View Related

IP Based Virtual Hosts (Incoming HTTP)

Jul 31, 2007

I have set up IP-Based Virtual Hosts, as I have been requested to set it up for SSL.

I have successfully set up all redirects and routes using the IFCONFIG and ROUTE.

My query is this, I have noticed that each HTTP request actually has to come in through the Virtual IP address (which is assigned to each site) from outside. Else it just displays the default host. Does this mean I have to have a separate phone line and router for each web-site I wish to host?

I am using Apache on Fedora Core 6.

View 4 Replies View Related

Apache :: 2.4.9 For Windows With Multiple Virtual Hosts

Jun 5, 2014

I have my Apache 2.4.9 for Windows with multiple Virtual Hosts, the main one is configure like this:

Code:
NameVirtualHost vhost1.domain.org:80
<VirtualHost vhost1.domain.org:80>
ServerName vhost1.domain.org
DocumentRoot "C:/Apache24/htdocs"
ServerAdmin techsupport@domain.org
# ErrorLog "logs/vhost1.domain.org-error.log"
# CustomLog "logs/vhost1.domain.org-access.log" common
</VirtualHost>

The rest like this:

Code:
NameVirtualHost vhost2.domain.org:80
<VirtualHost vhost2.domain.org:80>
ServerName vhost2.domain.org
DocumentRoot "C:/Apache24/htdocs/vhost2"
ServerAdmin techsupport@domain.org
# ErrorLog "logs/vhost2.domain.org-error.log"
# CustomLog "logs/vhost2.domain.org-access.log" common
</VirtualHost>

There is no *:80 anywhere and still when I go to any vhost it always load the main one.

What else do I need to check?

View 19 Replies View Related

Plesk 12.x / Linux :: Add New Certificate To All Virtual Hosts

Feb 13, 2015

I installed a new certificate, made it default, assigned it to the shared ip address and made the plesk panel use it.

The problem is we have 200 virtual hosts using the old certificate. Is there a way to reconfigure all those domains easily.

View 13 Replies View Related

UK Virtual Private Server (VPS) From Hosts Using Gyron.net Network

Mar 25, 2009

I current have a VPS hosted with a host who rent racks from Gyron.net at Telstra Londong Hosting Center Datacenter (Docklands) and im very satisfied with the network but im looking to change hosts, so im looking to find hosting companies that also rent racks/network from Gyron.net.

So does anyone knows hosting companies that rent space/racks/network from Gyron.net?

View 3 Replies View Related

Apache :: Why All Virtual Hosts Route Back To Same Document

Oct 7, 2014

I am trying to configure Apache 2.2 on Linux Mint 17 ( derived from Ubuntu 14 LTS).

I am wanting to create a variety of localhost sites all for development. One of those is built on Laravel 4. I have followed every tutorial I can find yet, for some reason which I do not understand ALL my sites route back to the Laravel root document when called from the browser. Just don't get it.

Here is my hosts file:

Code:

127.0.0.1 localhost
127.0.1.1 vince-XPS-8300
127.0.0.1 auburntree
127.0.0.1 example

Here is the Laravel conf file:

Code:

NameVirtualHost *:80

<VirtualHost *:80>
ServerAdmin mail@shaw.ca
ServerName auburntree
DocumentRoot /var/www/auburntree/public

ErrorLog ${APACHE_LOG_DIR}/error.log
CustomLog ${APACHE_LOG_DIR}/access.log combined
</VirtualHost>

Here is the alternative "example" conf file with just "hello world" in it.

Code:

NameVirtualHost *:80

<VirtualHost *:80>
ServerAdmin mail@shaw.ca
ServerName example
DocumentRoot /var/www/example/test.html

ErrorLog ${APACHE_LOG_DIR}/error.log
CustomLog ${APACHE_LOG_DIR}/access.log combined
</VirtualHost>

Both conf files have been enabled.

View 3 Replies View Related

Plesk 11.x / Windows :: Moving Virtual Hosts Directory To Nas

May 1, 2014

I use Nas to manage the customer site folder.

So the folder directory will be "as1webhostxxx" this format

I found that plesk panel default directory is inetpubvhosts

How to move the Virtual Hosts Directory to Nas ?

View 9 Replies View Related

Apache :: Transfer All Virtual-hosts On New Installation - Configuration

Feb 20, 2015

I just installed a new server and I would like to transfer all virtual-hosts on new Apache installation.

I updated all IP addresses in each .config file and simply uploaded the edited conf files into new /etc/apache2/sites-available folder. I rebooted Apache, but through Webmin I can not see them on Existing virtual hosts list. Why? Do I need to manually re-add all the 30 sites?

View 1 Replies View Related

Restart Apache After Reboot In Order To Get Virtual Hosts Working?

Sep 13, 2014

I am having to restart https after a reboot in order to get the virtual hosts working.

If I DON'T restart https, all I get is the system default page and NOT the individual vhost index pages.

View 4 Replies View Related

Copyrights 2005-15 www.BigResource.com, All rights reserved