> If you are running close to the same setup with no problems then I feel a > little better about it not being a issue of pure traffic.
Yes, we operate in a very similar way to you. (BTW, we have had very good results with a PHP based cache facility that simply stores the db driven pages over a selectable time period; good if your pages don't change that much! Capacity increased 4000% or so; would imagine something similar exists for perl) > I don't think the link between the machines is a issue, both machines are > dedicated and at the same location, I've tried using both the external and > internal (10.0.x.x) IP to connect to the DB with the same results and in all > cases both machines have had entries in their hosts file for one another. > > As for simultaneous connections, that is something that I still need to go > through the logs and come up with a real number for those time frames.. I > don't know anyway to see a real number of actual users using Apache via the > command line (is there such a thing?). I've always done ps -ef | grep httpd | wc -l a few times which shows the processes, you can get a good idea of whether the site is busy or not. I don't know how to actually find the exact number of users, I suppose netstat ? > One thing I wonder that I forgot to ask - does using IP address as the host > for a user in mySql matter? Meaning before DNS switched over I wanted to get > everything up and running so I created all the mysql user accounts based on > the IP address of the web server (and not name). > I would think if this were a issue at all I would be getting "denied" > messages and it wouldn't work 100% of the time, but I thought I would throw > it out there. I'd do everything by IP, especially for the "internal" stuff. It might be worth trying a dedicated cable+two separate network cards in each server to handle MySQL traffic. Just a thought, but could packets be getting lost between the two servers (network overloaded or out of ports on eth0 or ..?) Post your exact network setup (machines, switches/hubs etc) and that might give some more clues? Good luck John --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
