473,320 Members | 1,825 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

PHP HTTPD Process + MYSQL Multi-server


Always MultiPost and Cross-Post messages to enhance the chance to
reach you.
Bob
Hi,

Ever be in a position of too-much traffic ?
Point is, if the traffic increases, then the server is slow.
TOP command on a Linux/Unix/Fedora Apache/2.0.50 shows :
- 50% of the CPU : for HTTPD process
- 20% of the CPU : for Analog Process
- 20% of the CPU : for MYSQLD Process
The direct analysis would pretend that HTTPD is the problem. BUT may
be HTTPD is waiting for MYSQLD answer.
We have problem to analyse the sources of the lack of performance.
1) Idea ONE was to split sub.domains within other servers with
independant databases merged and consolidated into a single one using
exchange of tables.
2) Idea TWO was to have MYSQL hosted on one server and sub.domains
split over different servers.
SERVER1 : MYSQL
SERVER2 : oaks.bobby.com
SERVER3 : liveoaks.bobby.com
SERVER4 : bobby.com
We know ebay is ebay.com and these administrators might split over
servers depending on variables that our team does not manage.
3) We tried to go with Idea TWO and we are facing a problem.
Creating a user on SERVER1
Name : bobbob
Data Privilege : SELECT
INSERT
UPDATE
DELETE
FILE
Information related to connections
Server : % (all servers)
FLUSH PRIVILEGES ;
Then, on SERVER2 :
<?
$host = "207.36.16.15";
$user = "bobbob";
$pass = "bobbob";
$bdd = "adv_database";
?>
It does not work : Cannot access the database on SERVER1 from
SERVER2.
Even, we tried to add specfic provileges to bobbob.
Many Thanks for any operational answer from your knowledge and
background experience.
Bob

Nov 13 '07 #1
2 1671
it is quite possible that a firewall (iptables) refuses all outside
connections to port 3306. try consulting the sysadmin on server1
2401 members, members can post wrote:
Always MultiPost and Cross-Post messages to enhance the chance to
reach you.
Bob
Hi,

Ever be in a position of too-much traffic ?
Point is, if the traffic increases, then the server is slow.
TOP command on a Linux/Unix/Fedora Apache/2.0.50 shows :
- 50% of the CPU : for HTTPD process
- 20% of the CPU : for Analog Process
- 20% of the CPU : for MYSQLD Process
The direct analysis would pretend that HTTPD is the problem. BUT may
be HTTPD is waiting for MYSQLD answer.
We have problem to analyse the sources of the lack of performance.
1) Idea ONE was to split sub.domains within other servers with
independant databases merged and consolidated into a single one using
exchange of tables.
2) Idea TWO was to have MYSQL hosted on one server and sub.domains
split over different servers.
SERVER1 : MYSQL
SERVER2 : oaks.bobby.com
SERVER3 : liveoaks.bobby.com
SERVER4 : bobby.com
We know ebay is ebay.com and these administrators might split over
servers depending on variables that our team does not manage.
3) We tried to go with Idea TWO and we are facing a problem.
Creating a user on SERVER1
Name : bobbob
Data Privilege : SELECT
INSERT
UPDATE
DELETE
FILE
Information related to connections
Server : % (all servers)
FLUSH PRIVILEGES ;
Then, on SERVER2 :
<?
$host = "207.36.16.15";
$user = "bobbob";
$pass = "bobbob";
$bdd = "adv_database";
?>
It does not work : Cannot access the database on SERVER1 from
SERVER2.
Even, we tried to add specfic provileges to bobbob.
Many Thanks for any operational answer from your knowledge and
background experience.
Bob
Nov 13 '07 #2
2401 members, members can post wrote:
Always MultiPost and Cross-Post messages to enhance the chance to
reach you.
Bob
Hi,

Ever be in a position of too-much traffic ?
Point is, if the traffic increases, then the server is slow.
TOP command on a Linux/Unix/Fedora Apache/2.0.50 shows :
- 50% of the CPU : for HTTPD process
- 20% of the CPU : for Analog Process
- 20% of the CPU : for MYSQLD Process
The direct analysis would pretend that HTTPD is the problem. BUT may
be HTTPD is waiting for MYSQLD answer.
We have problem to analyse the sources of the lack of performance.
1) Idea ONE was to split sub.domains within other servers with
independant databases merged and consolidated into a single one using
exchange of tables.
2) Idea TWO was to have MYSQL hosted on one server and sub.domains
split over different servers.
SERVER1 : MYSQL
SERVER2 : oaks.bobby.com
SERVER3 : liveoaks.bobby.com
SERVER4 : bobby.com
We know ebay is ebay.com and these administrators might split over
servers depending on variables that our team does not manage.
3) We tried to go with Idea TWO and we are facing a problem.
Creating a user on SERVER1
Name : bobbob
Data Privilege : SELECT
INSERT
UPDATE
DELETE
FILE
Information related to connections
Server : % (all servers)
FLUSH PRIVILEGES ;
Then, on SERVER2 :
<?
$host = "207.36.16.15";
$user = "bobbob";
$pass = "bobbob";
$bdd = "adv_database";
?>
It does not work : Cannot access the database on SERVER1 from
SERVER2.
Even, we tried to add specfic provileges to bobbob.
Many Thanks for any operational answer from your knowledge and
background experience.
Bob

Bob,

Check comp.database.mysql for your answer. This isn't a PHP question -
you need to set MySQL up properly.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
js*******@attglobal.net
==================

Nov 13 '07 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: Adam Smith | last post by:
Hello, Installing PHP 4.3.6 on a i386 platform w/ FreeBSD 4.9 O/S installed and running apache_1.3.31 make with ./configure --with-mysql --with-apxs=/usr/local/apache/bin/apxs...
0
by: Ganbold | last post by:
Hi, I'm new to multi-threaded programming and reading the book "Programming with POSIX Threads" and trying to understand concepts and coding. What I'm trying to do is to rewrite mysql client...
0
by: Yun Guan | last post by:
Hello mysql gurus, I am trying to run perl on mysql database on Red Hat box. I want to install DBI and DBD:mysql using CPAN: perl -MCPAN -e shell cpan>install DBI The above succeeded, but...
0
by: Vic | last post by:
Hi all, When I test the Delete multi table function in MySQL, DELETE table_name ...] FROM table-references I accidentally delete all data in one table. All data in that table are gone...
3
by: saracen44 | last post by:
Hi I have MyISAM tables When I'm deleting parent I want to delete children in the same time. How can I do It? What are possibilities? Thanks
1
by: Yun Guan | last post by:
Hello, I have problems installing DBD:mysql on Red Hat Linux 9, either from CPAN, or mannual install. The error is the same, something related to this Kid.pm file under perl. Should I reinstall...
22
by: nd02tsk | last post by:
Hello! I have a couple of final ( I hope, for your sake ) questions regarding PostgreSQL. I understand PostgreSQL uses processes rather than threads. I found this statement in the archives: ...
39
by: windandwaves | last post by:
Hi Folk I have to store up to eight boolean bits of information about an item in my database. e.g. with restaurant drive-through facility yellow windows
0
by: Yahoo! Groups | last post by:
--qmZXHrzahTmnWjcAmzfDy9efU1qhZy1O5P65Uoe Content-Type: text/plain Content-Transfer-Encoding: 7bit We are unable to process the message from <mysql@freebsd.csie.nctu.edu.tw> to...
3
by: menzies | last post by:
Hi, I"m new to this forum, but I have been trying all day to install DBD::mysql onto my Intel MacBook. I've read lots of forums pages and none have gotten me to a successful 'make test' or a...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.