473,327 Members | 1,952 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,327 software developers and data experts.

Multiserver - Spread Traffic. Localhost restriction



Hi,

Ever suffer from 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
1 1338
On 13 Nov, 09:47, "2401 members, members can post"
<Paul_Me...@2cuk.co.ukwrote:
Hi,

Ever suffer from 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
Do not multi-post. Cross-post if you must but don't multi post It
wastes people's time.
http://www.blakjak.demon.co.uk/mul_crss.htm.

Nov 13 '07 #2

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

Similar topics

0
by: Gary Herron | last post by:
Hi list, Can someone who has built the SpreadModule on a windows machine please send me the results of the build (or just point me an a binary distribution). Here's why: I'm starting to...
1
by: René Dohmen | last post by:
I want to set up Multiserver Administration. The problem I encounter is a firewall between the master server and some target servers. What ports need to be set open to make this possible ?
9
by: google_groups3 | last post by:
Hi all. This is a bit of a long shot i think but right now i am all out of ideas, so any help is greatly appreciated! I have an app that sends information on a specific port. However, te...
5
by: bclark76 | last post by:
I am getting a strange error, maybe someone knows why it is occurring.. I get the following error when I try to validate Untitled8.xml in Altova XMLSPY: Validation error in another file:...
9
by: Hugh Janus | last post by:
Hi all, Does anybody know if it is possible with VB.NET to capture and redirect traffic that flows through a particular port? i.e. the app either listens or watches port 1234 for outgoing...
6
by: burkley | last post by:
In XML Schema, is it possible to derive a complex type via restriction and have the new derived type be in a different namespace than the original base type? I've banged on this for 2 days now...
3
by: 2401 members, members can post | last post by:
Dear Madams and Sirs, Ever had to split a website + SQL Tables ? Have a UNIX pc-linux-gnu on i686 + FEDORA 1) We have to split a sub-domain for the main domain name. 2) We have to build a...
1
by: Pseudonyme | last post by:
A Paris, Le 13 Novembre de l'an MMVII, My dear Sir and Madam, Ever be in a position of too-much traffic ? Point is, if the traffic increases, then the server is slow.
0
by: codewarrior1241 | last post by:
Hi all, I will try to be as clear as possible with my application, maybe ppl familiar with asyncore can help me out :-) Basically, I have python 2.5 in SuSe running with a server written using...
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: 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...
1
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...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
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
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

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.