SLOW Connection: 2 Webservers Using A Single Database Server
Jul 24, 2007
I am developing an application on a load balanced network.
It is configured as follows:
Webserver1, Webserver 2 (Fedora 5 - Linux, Apache, Zend Opt, PHP)
and a DataBase Server (MySQL)
When the webserver attempt to use the Database server the connections and page output are REALLY slow!
The database server is within the webservers local intranet - so I thought it would be a lot faster.
----------
Here is a quick test: : :
Testing Database Connection on localhost
Connecting to Database... 0.00054502487182617 seconds
SELECT * FROM users... 0.00076389312744141 seconds
Testing Database Connection on '192.168.1.200'
Connecting to Database... 19.998768091202 seconds
SELECT * FROM users... 0.0021719932556152 seconds
20 seconds to connect to the database server...
View 3 Replies
ADVERTISEMENT
Mar 1, 2008
I rented a server from VD a month ago and hosted some of my websites. But I'm constantly noticing that my websites are loading very slow. How can I check if other users are experiencing the same problem, or if the problem lies with my Internet connection?
View 4 Replies
View Related
May 7, 2009
I am using Putty to connect to my server via ssh.
When opening a direct connection, i can login quickly without any problem
Quote:
login as: gracie
gracie@server1's password:
Last login: Thu May 7 07:31:26 2009 from 192.168.0.5
gracie@server1 [~]# sudo su -
Password:
root@server1 [~]#
When I open a connection FROM ANOTHER SERVER, I have to wait more than 20 seconds
Quote:
login as: tech2
tech2@server2's password:
Last login: Thu May 7 07:32:07 2009 from 192.168.0.5
tech2@server2 [~]# ssh gracie@192.168.0.222
Password:
After I enter the password, I waited 20 seconds before I am logged in.
View 2 Replies
View Related
Feb 3, 2015
WINDOWS SERVER Plesk Panel version 12.0.18
Error: Test the database server connection failed:
mysqlnd cannot connect to MySQL 4.1+ using the old insecure authentication. Please use an administration tool to reset your password with the command SET PASSWORD = PASSWORD('your_existing_password'). This will store a new, and more secure, hash value in mysql.user. If this user is used in other scripts executed by PHP 5.2 or earlier you might need to remove the old-passwords flag from your my.cnf file
View 1 Replies
View Related
May 7, 2015
I freshly installed Plesk 12.0 on Ubuntu 14.04. Everything works accept the MySQL database creation.
When I try to create one, i get this error :
error: the test connection to the database server has failed because of network problems: connection refused...
View 1 Replies
View Related
Jul 21, 2007
I use Charter as my ISP. Normally my connection speeds are VERY fast to the majority of the web. However, my own website has become like molasses in January (it wasn't always this way, or I would have not chosen my host), as can the entire hosting service. For the sake of discussion, I use two networked PC's, one is Win2K and the other is XP. Both are using the latest free version of ZoneAlarm, NO virus checker. I have a Linksys router. Asking for tech support with Charter is equivalent to wanting to discuss the methods for rebooting your PC with someone who didn't grow up speaking English. I've tried, it's useless.
(Warning: my site is about nude art photography, so don't look if you don't want to see that. The site is pencilartist.com, and I am hosted with Lunar Pages.)
I've run tracert several times, and I always come up with a timeout on the first hop.
I've asked a friend to view both my site and Lunar Pages from his Charter account (lives 5 miles from me) and he says both come up in nanoseconds. I've tried various online speed checkers, and they all give blazing results.
Here's the latest tracert:
Quote:
Tracing route to pencilartist.com [216.227.212.182]
over a maximum of 30 hops:
1 * * * Request timed out.
2 21 ms 11 ms 13 ms 10.208.128.1
3 10 ms 11 ms 11 ms 68.186.73.29
4 11 ms 23 ms 13 ms 68.186.73.49
5 15 ms 17 ms 24 ms 12.87.58.5
6 17 ms 19 ms 17 ms tbr1.st6wa.ip.att.net [12.122.111.14]
7 16 ms 15 ms 15 ms 12.127.6.57
8 17 ms 19 ms 25 ms so-3-2-0.gar1.Seattle1.Level3.net [4.68.127.109]
9 19 ms 17 ms 18 ms ae-31-53.ebr1.Seattle1.Level3.net [4.68.105.94]
10 45 ms 16 ms 18 ms ae-1-100.ebr1.Seattle1.Level3.net [4.69.132.17]
11 39 ms 38 ms 33 ms ae-61-61.csw1.SanJose1.Level3.net [4.69.134.194]
12 48 ms 49 ms 40 ms ae-63-63.ebr3.SanJose1.Level3.net [4.69.134.225]
13 41 ms 37 ms 55 ms ae-2.ebr3.LosAngeles1.Level3.net [4.69.132.10]
14 56 ms 57 ms 53 ms ae-78.ebr2.LosAngeles1.Level3.net [4.69.135.13]
15 71 ms 53 ms 47 ms ae-21-54.car1.LosAngeles1.Level3.net [4.68.102.1
08]
16 46 ms 45 ms 44 ms ge1-1.cr01.lax01.mzima.net [64.156.173.126]
17 46 ms 52 ms 52 ms xe1-0.cr01.lax02.mzima.net [64.235.224.182]
18 47 ms 45 ms 49 ms ge2-lunarpages.cust.lax02.mzima.net [72.37.172.2
6]
19 45 ms 60 ms 46 ms ge2-lunarpages.cust.lax02.mzima.net [72.37.172.2
6]
20 48 ms 47 ms 45 ms lioba.lunarpages.com [216.227.212.182]
Trace complete.
So is the problem just in my local connection? What is happening?
View 2 Replies
View Related
Apr 20, 2008
For about the last two weeks I've had issues connecting with the website that I help run www.learnoutloud.com from my home connection which is Time Warner Cable Internet connection in Los Angeles. I'm on a Dell laptop Inspiron 6000 running Windows XP. I'm always able to connect to the site but what's happening is the page will get hung up on loading a single image usually and then it will take about a minute just to load that last image. And sometimes the page won't load at all, but all it takes usually is hitting the refresh button and the page loads instantly. I was hoping this issue would just go away, but it's been persistent after numerous restarts of our cable modem and switching from wireless to plugged in and so forth. And it's really only happening for our site and no others, which is just puzzling.
At our office on our DSL connection our site loads fine and we haven't had any customer complaints about the site loading slow like this. Our traffic numbers have stayed steady so I don't think it's a global problem connecting with our site. At home I conduct a trace route and it looks good:
Tracing route to learnoutloud.com [72.34.53.155]
over a maximum of 30 hops:
1 5 ms 5 ms 1 ms 192.168.1.1
2 15 ms 13 ms 12 ms cpe-76-170-64-1.socal.res.rr.com [76.170.64.1]
3 12 ms 11 ms 9 ms 76.166.6.77
4 11 ms 12 ms 12 ms tge9-3.bwlaca1-rtr2.socal.rr.com [76.166.1.6]
5 11 ms 12 ms 16 ms tge9-2.bwlaca1-rtr1.socal.rr.com [76.166.1.4]
6 14 ms 15 ms 47 ms tge2-2-0.lsanca1-rtr1.socal.rr.com [66.75.161.20
1]
7 15 ms 18 ms 25 ms xe-8-1-0.edge3.LosAngeles1.Level3.net [4.78.195.
189]
8 15 ms 15 ms 15 ms ae-12-69.car2.LosAngeles1.Level3.net [4.68.20.4]
9 16 ms 15 ms 25 ms INTERNAP-NE.car2.Level3.net [4.71.36.78]
10 15 ms 15 ms 27 ms border1.po2-bbnet2.ext1.lax.pnap.net [216.52.255
.86]
11 16 ms 38 ms 25 ms insiderh-2.border1.ext1.lax.pnap.net [63.251.209
.106]
12 19 ms 29 ms 18 ms 72.34.41.10
13 32 ms 18 ms 18 ms 72.34.53.155
Trace complete.
Does anyone know what the heck is going on and how I can fix this?
View 3 Replies
View Related
Jul 1, 2014
OS CentOS 6.5 (Final)
Plesk version 12.0.18 Update #6, last updated at July 2, 2014 11:13 AM
The system is up-to-date; last checked at June 27, 2014 04:43 AM
All current websites on the server seem to work fine any new subscriptions we cannot get working at all.
We can connect via FTP to new sites SOMETIMES - just cant get directory listing. When we can connect and get into a directory it slows down.
In Active mode:
Command:MLSD
Response:425 Unable to build data connection: Connection refused
Error:Failed to retrieve directory listing​
Install Wordpress via the Parallels panel it loads and says it is all there, just can't log or display any pages. The default Parallels page is displayed.
Upload a html page via the File Manager in Parallels and it displays the default Parallels page.
Unpack the Wordpress tar file via File Manager and it displays the default Parallels page.
The Wordpress feature in Parallels says it is working fine, can't display any page, can't log in as it returns a 404 page or the default Parallels page.
Create a site in Presence builder and Parallels says there is a site. The default Parallels page is displayed when opening the site.
Go to DOMAINS and there is 0mb in space used and there are files listed in the File Manager - none of which can be displayed.
View 3 Replies
View Related
Jul 17, 2014
I am looking for setup a gateway (reverse proxy I guess?), specifically how to configure Apache to point to different webservers depending on domain name.
I currently have a single webserver running multiple virtual domains all accessible via a single external IP address.
I would like to break this into 2 servers each running multiple virtual domains accessible via gateway with a singe external IP address.
As an example, a single internet IP address points to port 80 on the gateway machine. The gateway machine will determine if its example1.com, example2.com, example3.com or example4.com. If its example1.com or example2.com it will direct internally to webserver1 and if its example3.com or example4.com it will direct internally to webserver2.
Webserver1 and webserver2 each host different websites via virtual hosts.
Is this possible and if so, what is the correct configuration of the gateway machine. I currently have installed apache2 with mod_proxy enabled, but I am struggling with configuring it properly.
View 1 Replies
View Related
Dec 9, 2007
Usually I install every single PHP application on a new database. But I was thinking of installing a Joomla website and a SMF forum on one database with different table suffixes. Whether I install them in the same database or a different database, they will still be on the same host.
So does it make any difference to put them in different databases or should I just put them in one database?
The site/forum is for a little WoW guild website and it might get maybe 30ish visitors a day.
View 10 Replies
View Related
Mar 9, 2007
Why does this happen? How should I fix it? Can I just restart the sql service? How to do so?
This either means that the username and password information in your wp-config.php file is incorrect or we can't contact the database server at localhost. This could mean your host's database server is down.
* Are you sure you have the correct username and password?
* Are you sure that you have typed the correct hostname?
* Are you sure that the database server is running?
If you're unsure what these terms mean you should probably contact your host.
View 5 Replies
View Related
Jan 24, 2007
I have built a database driven site with PHP & MySQL. Pages download quicker on some connections than other (obviously), however this is not due to connection speed. The web host server seems to respond very slowly to my boss's network (which is on a proxy server). Could it be that this problem is related to the web host? i.e. could it be that the web host is unequipped to deal quickly with this type of network?
On my home connection (2Mbps), pages often download instantly, however occaisionally I have to wait 10-20 seconds to receive the page from the host.
Finally, could you recommend an excellent web host to use with our site? My boss wants to offer a professional service where server response is quick. We are based in the UK.
View 1 Replies
View Related
Oct 9, 2014
I just tested the WP creation feature of PP12 and I get the following error when I attempt to view the newly created CMS...
"Error establishing a database connection"
If I navigate to the database page and click webadmin, I can connect and see the WP database created. Everything works in phpMyAdmin.
Going to ../wordpress/wp_login.php returns the error.
View 3 Replies
View Related
Nov 18, 2008
I have a Linux(RHEL5) dedicated server.Tomcat version 5.x is running integrated with Apache and now i want to install tomcat 6.x integrate with apache without effecting older tomcat version. it will run as it is.
How can i do this and if yes then how can i set tomcat home path for both versions.
CATALINA_HOME=<Which path for both> and how to install it.
View 5 Replies
View Related
Apr 22, 2009
is there any sort of ssl certificate that will 'secure' any domain, hosted on a single server?
For example, I have the following domains and subdomains:
google.com
test.google.com
mywebsite.com
hello.example.com
All will be hosted on the same server (same IP) and I want all to be secured, through a SIGNED certificate, not a self signed. I assumed that wildcard ssl would be fine for this, but I just took a look and it's only for subdomains: example.example.com hello.example.com.
Is there any way of having every subdomain and domain secured, using ssl, through one certificate? I don't want to have to buy individual certificates for every domain, that'd be... expensive.
View 7 Replies
View Related
Sep 8, 2008
Based on todays equipement I know a person can spend Thousands on a good server, I'm looking to build my own and just want some advice on which way to go.
I'm thinking of just building the server pc in one case and the hard drive setup will be in a seperate case with the following:
3ware 9690SA-8E controller
Mass-Storage 8x by A-Tech Fabrication for a case
8 - SATA2 SEAGATE 1TB (7200rpm) 32MB on the controller as RAID
Can anyone give advice on what would be a good setup if you were running 1 single server for local businesses. I don't want to hear just pay for a provider as I've heard that one before now I'm looking to know what hardware setup you would run I like to play and learn. Even though sometimes the headache playing isn't as much fun as we sometimes may have hoped.
What are m/b and processor options for running a server?
What is min. amount of ram a person should run using linux and cpanel?
Should linux be on a max. amount of space for root and server files on a seperate mnt?
What connection up/down would be min. for usage of about 5gig/month?
View 5 Replies
View Related
Mar 6, 2008
i got my server. I'm still shopping for hard disks but the server is pretty much there.
i'm in Houston, Texas. i'll like to know if anyone can give me tips on what to look for in colo. what question should i ask or be aware of.
my budget is $100 per month. i don't use much bandwidth and it doesn't have to be premium bandwidth with basic service.
View 1 Replies
View Related
Jan 31, 2007
From reading these boards for a couple years now, I always had the impression that colo was cheapest in Texas or thereabouts, and was priciest in places like NYC. (Of course, I'm referring to relatively comparable service.)
Now I finally have a need for a single server colo (1U). The most-mentioned places in Texas on these boards are cologuys, colo4dallas, etc. Most of them have reasonable rates listed right on their website, around $100-170 for the bandwidth that I need, about 1.5Mbps.
But I've also been requesting quotes from various providers in NYC, who are also popular on these boards. And while there are some in the $200-250 range, which is what I was expecting, there are some that are mentioned highly on these boards (toqen, thenynoc, razorblue, etc.) that are quoting $60-100/month for the same amount of bandwidth.
I.e., not only comparable but in fact *lower* than the Texas colos.
What am I missing here? It's very possible that I'm comparing apples to oranges, cuz I really don't know any of these businesses. Just forming an opinion based on what gets recommended here on a consistent basis.
View 4 Replies
View Related
Feb 28, 2007
Does anyone know if there are providers left in Dallas that provide single server colocation solutions? If so, who are they and what can I expect in terms of pricing?
I am used to reselling shared and dedicated servers, but I've leased them for long, I could have paid for them by now. Some of my clients have their own systems too. They tend to request Dallas.
View 14 Replies
View Related
Jan 4, 2007
I am starting a small template based company. How many unique websites in their own unique folder can I host on a single server?
These websites would not get many hits, maybe a few hundread to a few thousand a month per site. My goal is to minimize the number of accounts I will have to open up with a web service provider.
Should I purchase 1 package per site or is there a way to get around this. Each unique site would have its own unique domain.
View 7 Replies
View Related
