Connect To Mysql From Many Remote Virtual Hosts
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.
View Complete Thread with Replies
Sponsored Links:
Related Forum Messages:
Users Cannot Connect To Remote MySQL Server
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 Replies!
View Related
Can't Connect To Remote Desktop
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 Replies!
View Related
How To Connect Virtual PC To Host PC
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 Replies!
View Related
Remote SQL Connect Web Hosting
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 Replies!
View Related
Apache 2.0 Virtual Hosts
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 Replies!
View Related
About Apache Virtual Hosts
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 Replies!
View Related
Name Based Virtual Hosts - Anything I Should Know
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 Replies!
View Related
Virtual Hosts Slower
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 Replies!
View Related
Tomcat Virtual Hosts And Permissions
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 Replies!
View Related
Seperate Virtual Hosts File
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 Replies!
View Related
IP Based Virtual Hosts (Incoming HTTP)
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 Replies!
View Related
Email Issue: Remote Hosts Cannot Find Hostname
Our mail queue is getting stuffed with emails because remote hosts cant find our hostname..... Should we change the hostname? Should we change the main IP? Submit a ticket with the DC? (This'll be faster, thats a last min option) hostname: piper.bluepipes.net IP: 208.53.131.149 (i think)
View Replies!
View Related
Init: You Should Not Use Name-based Virtual Hosts In Conjunction With SSL!!
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 Replies!
View Related
Win 2003 Apache 2.2 Virtual Ssl Hosts
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 Replies!
View Related
MySQL Can't Connect To Socket.....
I saw following error in some of my site in my server. Coppermine critical error: Unable to connect to database ! MySQL said: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) or following error : Invalid mysql server connection Please help me how can I resolve this error ! /etc/my.cnf : [mysqld] datadir=/var/lib/mysql skip-locking skip-innodb skip-networking safe-show-database query_cache_limit=1M query_cache_size=16M ## 32MB for every 1GB of RAM query_cache_type=1 max_user_connections=200 max_connections=500 interactive_timeout=10 wait_timeout=20 connect_timeout=20 thread_cache_size=128 key_buffer=64M ## 128MB for every 1GB of RAM join_buffer=1M max_connect_errors=20 max_allowed_packet=16M table_cache=1024 record_buffer=1M sort_buffer_size=1M ## 1MB for every 1GB of RAM read_buffer_size=1M ## 1MB for every 1GB of RAM read_rnd_buffer_size=1M ## 1MB for every 1GB of RAM thread_concurrency=8 ## Number of CPUs x 2 myisam_sort_buffer_size=64M server-id=1 collation-server=latin1_general_ci [mysql.server] user=mysql basedir=/var/lib [safe_mysqld] err-log=/var/log/mysqld.log pid-file=/var/lib/mysql/mysql.pid open_files_limit=8192 [mysqldump] quick max_allowed_packet=16M [mysql] no-auto-rehash #safe-updates [isamchk] key_buffer=64M sort_buffer=64M read_buffer=16M write_buffer=16M [myisamchk] key_buffer=64M sort_buffer=64M read_buffer=16M write_buffer=16M [mysqlhotcopy] interactive-timeout My server details : 1 GB RAM P4 3.00 HT
View Replies!
View Related
Users Cannot Connect To MySQL Via Phpmyadmin
It seems I am having issues with WHM/CPanel. I cannot connect to mysql via phpmyadmin through WHM as a root and get this error #2002 - The server is not responding (or the local MySQL server's socket is not correctly configured) All users get the same error when they try to access mysql from cpanel. The access seems to be only for valid for 192.168.1.% Would allowing access to localhost will help and how can I do that for all users?
View Replies!
View Related
MySQL Cannot Connect To Database Via PHP
I got this weird problem with my VPS which has MySQL 4.1.22 running on it. Everything works fine for sometime and then out of a sudden, it stop recognizing the mysql users and refused to allow my PHP scripts to access the database. It seems that I needed to restart mySQL server to resolve the issue. Then out of the blues, the same problem occurs. I am running Cpanel on a VPS and there isn't any overloading as the database access is pretty light on my 512mb VPS. I contacted my web host about the issue and it seems like all they do is to restart the mySQL. This cannot be a solution as it happens at least once or twice a day depending on how soon I could catch the problem. All the time this problem occurs, the MYSQL Server is still active and working. I can even access it through PHPMyAdmin but not through the scripts. I just added an hourly crontab so as to restart the MySQL server as a stop gap.
View Replies!
View Related
UK Virtual Private Server (VPS) From Hosts Using Gyron.net Network
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 Replies!
View Related
Can't Connect To MySQL Server On 'localhost' (10055)
Do you guys know anything about this? My server works perfectly with INSERT, UPDATE, DELETE for mysql. but after like 12 hours later, my application crashes and I get this "Can't connect to MySQL server on 'localhost' (10055)" and I would have to restart my applications and everything will be working perfectly. Do you guys have any idea why this happen? I do have a lot of connections coming in and out of my server. Would that mean anything?
View Replies!
View Related
Allow Remote Mysql Access
I have a Ubuntu Lamp server setup in my building which is used for development purposes. So I also have phpmyadmin setup and am using a Mysql Query browser and Mysql Administrator desktop programs to administor the database on the server. However I am not able to connect to the server from my desktop. I am able to login to my myphpadmin but not able to login via the Mysql Query Browser program. Hopwing someone can help. I have read about port forwarding and also read a post about editing the my.cnf file on the server and changing the Bind-Address= 127.0.0.1 to the actual hostname but before I start editing the actual configuration files on the server I want to see if their is another way as I am worried that if I change the me.conf file that the phpmyadmin may stop working?
View Replies!
View Related
Remote MySQL 5.0 Hosting
I'm running a VPS at TekTonic.net and so far I have only one problem. I love TekTonic's services in general, but for some crazy reason, I can't get my MySQL server to work. I've asked MySQL's support staff, and they haven't found an answer to date. I can do just about anything on my MySQL server EXCEPT add/remove a database, which creates a problem. A BIG problem. what I'm looking for now is a remote MySQL host that will accept connections from my TekTonic-hosted VPS.
View Replies!
View Related
CPanel Remote MySQL
just want to know if you use 2 servers ( A & B ) both with cPanel, suppose that you do use the remote MySQL on server B serving website on server A. How do we access phpmyadmin? Do you guys experience this?
View Replies!
View Related
Accessing MySQL From Other Hosts
I have a mySQL db on Host A and I want to be able to access its data from Host A/B/C/D/E. Questions: 1. If I have your typical reseller account with WHM and CPanel, would I just use localhost for each site on Host A or would I only use localhost for the domain it is on? (Assume mysite1.com and mysite2.com is on the same reseller account, and the db phpmyadmin is at mysite1.com/phpmyadmin.) 2. For Host B/C/D/E, how would I let them have access to the mySQL db on Host A? Do I just add them to the Access Hosts section of the Database Manager section of CPanel? Would that involve putting each IP address in there or its nameserver or what? Would a wildcard be useful here?
View Replies!
View Related
Connecting To Remote MySQL Failing
I'm facing some odd issues with 2 servers located in the same datacenter. One server is the HTTP server, and every 5 minutes it works, then for 5 minutes Server One and Server Two (MySQL) hate each other and refuse to talk to each other. Not only can neither not connect to each others MySQL, but also neither can ping each other. The odd thing is, Server Three can however connect to the Server Two MySQL with no problems during this period. It seems to be just the communication between Server One and Server Two that keeps getting halted. I've tried "service iptables stop" to disable the firewall, and changing SELinux to disabled, but neither have fixed it.
View Replies!
View Related
Host For Remote MySQL Connection
I have developed a desktop system that uses MySQL data. I want to use a host to access the data but my current provider only allows access to MySQL data via a web server. Can anyone suggest a host that would provide direct connection to a MySQL database?
View Replies!
View Related
Remote Dedicated Mysql Server
i am getting mysql down issues with my current dedicated server. I would like to move my database to a dedicated server where only mysql will be running. Just wondering if this will be faster than the localhost? I have planned to buy dedicated server from another hosting company so definitely there will be a good enough connectivity distance.
View Replies!
View Related
Move Mysql Db From Remote Server
how can i move mysql db from remote server ? (via SSH or most pratical way) suppose that... source server domain : google.com host : localhost user : zode pass : 123 db : source destination server domain : yahoo.com host : localhost user : hala pass : 456 db: target
View Replies!
View Related
Remote Mysql Server In WHM
I see option to setup remote Mysql server in WHTM but wonder can i connect 2 servers through private network then fill in Remote server address something like 192.168.1.2. If it is possible it would save me a lot of bandwidth for both servers.
View Replies!
View Related
DDos And Remote Mysql Server Two
i have two server one for running apache and second is sql server.Now come to problem. I have a very strange type of ddos attacks on my httpd server and due to these attacks my apche server failed many times (10 to 15 times)in a day. When i checked max http connection use by a single ip then i am surprised to see that my remote sql server ip is using maximum of http connections and behind this there is some other ips whose doing the same. I installed media layer it seems to work fine for me but suddenly he blocked my remote sql server ip due to using maximum http connection lolz its very strange any body please help me out of this problem.
View Replies!
View Related
Cpanel Mysql Remote Connection USE EXIST DB
A have set up a cpanel with remote mysql server. My demo config: cpanel: centos VPS with cpanel WHM (demo) mysql: debian VPS the configuration is OK, it works. We have got 200 customers, and we will to change to cpanel. The MYSQL server is on a solaris zone. It is possible to make the remote connecting with it. I will import the 200 users MYSQL databases to cpanel, with privileges (user settings). The mail/web dir a will import manuali to cpanel server(copy-paste-setuser:group).
View Replies!
View Related
Remote MYSQL (cPanel) Small Error
I have create a remote mysql database in whm for another server on my network. Now my problem is that the remote mysql in fact works as the data is still being pulled from it with mysql disabled on the main server. I did however put in the root password during the remote mysql server setup. Now the only problem I seem to be having is the databases dont show up in any cpanel accounts and phpmyadmin doesnt work. but all sites using a database made before this change still work.
View Replies!
View Related
MySQL Remote Connection Problem After A Heavy Usage
I have 2 identical Fedora8 boxes with Apache 2.2.8, MySQL 5.0.45 and PhP 5.2.4. I use one as the Web+DB server (say box A), and the other (box B) just as the Web server connecting to the DB server on box A. I use this 2 machine configuration to test a LAMP based-Web application. I have a client program on other machines that can emulate a massive web workload to these 2 servers; it can emulate hundreds to thousands of users using the application simultaneously. Before running the test, the connection to the DB server from both boxes seem fine. Using the mysql client program on either box A or B trying to connect to the DB, the connection goes through instantly. In the /etc/my.cnf file, I have max_connections=4096 and max_user_connections=4096. Note that the web app uses one single db user to connect to the db. To allow remote connection, I inserted one record into the user table of the mysql db whose the host field's value is '%' (allow connection from all remote hosts). After running the test (which I found out that many requests sent to box B failed), mysql client program on box A is still able to connect to the db instantly; but the one on box B has a problem: it takes extremely long (5 - 10 minutes or even more) to establish the connection, it doesn't time out, just takes that long. I believe that's the cause for the failure of requests to box B.
View Replies!
View Related
Intermittent "Can't Connect To MySQL Server"
I started getting small periods of intermittent connection errors about once every hour, lasting for about 1 to 5 minutes each time: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' I enabled the error log and did some other monitoring and established 2 things: - the server doesn't crash/restart, it keeps running throughout the errors - the errors do not match the load on the website, as sometimes when 500 users are online there are no errors, but when 300 are online they may by prolific I checked many forums and then made 5 changes: - changed the directory containing the mysql.sock file so only file owners or superusers can delete files from it - I changed the default socket file setting in both my.cnf and php.ini - I read about SELinux causing such a problem, so I disabled SELinux completely, rebooted the server and double-checked that it is indeed disabled. - I changed the maximum amount of open files allowed by the operating system from 1024 to 30000. Despite all these changes, I still get the errors. I then read that there is a workaround by using TCP/IP instead of the sock file. I tried that, but I still get the error intermittently in the form of: Can't connect to MySQL server on 127.0.0.1 MySQL server 4.1.20, PHP 4.3.9, client API 4.1.20, CentOS 4.3, Intel P4 2.8GHz 1GB RAM
View Replies!
View Related
MYSQL Error "Could Not Connect To The Database"
Last night i went to install GD on my server(Linux RH) I went through the process /scripts/easyapache and at the end of it gave me this error "...Unable to connect to host: 127.0.0.1......Failed......Unable to connect to host: 127.0.0.1......Fail ed......Unable to connect to host: 127.0.0.1......Failed......Unable to connect to host: 127.0.0.1..... .Failed......Unable to connect to host: 127.0.0.1......Failed......Unable to connect to host: 127.0.0.1 ......Failed......Unable to connect to host: 127.0.0.1......Failed......Unable to connect to host: 127. 0.0.1......Failed......Unable to connect to host: 127.0.0.1......Failed......Unable to connect to host: 127.0.0.1......Failed......Unable to connect to host: 127.0.0.1......Failed......Unable to connect to host: 127.0.0.1......Failed......Unable to connect to host: 127.0.0.1......Failed... The was no content, the test may be unable to connect to 8080 simply because tomcat is still initila izing. You can try to go to http://localhost:8080/ to manually check it. -- End test 'Basic tomcat port running test' -- Post check of 'httpd' process Ok -- End post apache restart tests -- Executing '/scripts/initfpsuexec' Executing '/scripts/initsslhttpd' Executing '/scripts/gentomcatlist2' Compiling report... Sending report (336 bytes)... If you want to create a support ticket with cPanel regarding this please reference 'BuildAP Report Id': '528932' Report processed. You can change how PHP is configured. As root, simply execute: /usr/local/cpanel/bin/rebuild_phpconf --help for more information. Build Complete Verbose logfile is at '/usr/local/cpanel/logs/easy/apache/build.1198389830' Now I am unable to connect to MYSQL databases, MYSQL is still running from what I can see. I have base knowlage of Linux as well.
View Replies!
View Related
"Can't Connect To Local MySQL Server" + "IPS Driver Error"
During peak times (especially weekends) many of my site's users have been reporting intermittent 'IPS Driver Errors' in the forums and the following error in the coppermine gallery: Quote: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (11) (The forums and the gallery are the main parts of the site). I'm assuming that the site is having problems handling the number of users trying to connect to SQL. I tried increasing the max_connections and max_user_connections settings in my.cnf but it doesn't seem to have made a significant difference. What do I need to do to fix this? Would I need to upgrade my server specs or is it something to do with the server settings? my server specs: AMD Dual/Dual Opteron 270 with 4GB RAM.
View Replies!
View Related
Universal Hosts (uni-hosts) Two Week Mini Review
I was in the market for a new dedicated server after a couple of years with my previous provider. The previous provider did nothing wrong but they were no longer competitive when it came to CPU and memory. I moved first to geekrack. And I left them after a week and a half as they never were able to get my rDNS records setup. I found Universal Hosts on this forum and gave them a shot. I had asked for an operating system that they didn't offer normally (Debian 64 bit) and they said that they could do it. However, when my server was setup it was 32 bit Debian instead. They apologized and had Debian 64 bit setup less than 24 hours later. When I asked them to get rDNS records setup it took a few hours but they were setup correctly and they worked. Universal Hosts is also a BurstNet reseller but compared to my other attempt at using a BurstNet reseller they are fantastic. While the initial config was incorrect they worked quickly to fix it and were very professional about it. So after two weeks - so far so good. Keep up the good work UniHosts!
View Replies!
View Related
Directadmin Hosts Or Cpanel Hosts
Recently I stumbled along a host on here with a good rep and that uses direct admin. Because they were very nice on the live support I signed up to see what direct admin was like. Its very diferent from cpanel. Some parts seem to be harder to use like the phpmyadmin requires the username and password to the database you created not the control panel username and password like cpanel. Although I guess that could be a good security feature just in case some one gets into the control panel they can not get into the phpmyadmin, then again if they are smart and were able to get into the control panel they could get into ftp and look what the username and password is on the config file for the script you are using. The bandwidth meter seems to be better in direct admin although I think its acting up for me as its putting yesterdays bandwidth on todays. I was told by the host that it updates every 2 hours and at first it did but now its gone to every day. Oh and unlike cpanel this bandwidth meter includes bandwith used by the control panel. Niether one from what I can tell counts sftp though at least for the hosts I have right now.
View Replies!
View Related
How Do I Secure Remote Access To Remote Access Products
I have windows servers that I'll be co-locating very soon. I have purchased a Dell 2161ds-2 and an APC remote boot power strip. Could someone please tell me the best way to secure remote access to these products. Do I put them on public IP's and allow them through the firewall or do I put them behind the firewall and access them after I authenticate through the firewall.
View Replies!
View Related
|
TRACKER
