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_databa se";
?>
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 1 1355
On 13 Nov, 09:47, "2401 members, members can post"
<Paul_Me...@2cu k.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_databa se";
?>
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. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
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 use the spread library (www.spread.org) in Python via
the SpreadModule (http://www.python.org/other/spread/). The
|
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 ?
|
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
port is blocked on the firewall so the app won't connect. Changing the
firewall config is not an option, nor is reconfiguring the app.
So, my question is this. Is there a way to develop an app that
|
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: Untitled3.xsd
The message in XMLSPY in Untitled3.xsd is: The file is not valid: The
content model of complex type { no name } is not a valid restriction
of the content model of complex type 'Condiment_Type'
|
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 traffic. It then captures or
copies all the traffic and simalteanously send it out of port 4321.
Another possible example: telnet sends info out on port 23. I want
that information captured and sent out in real-time (or almost) of port
80. And...
| |
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 and I'm starting to think the
answer is no. I've searched this group and have not seen anything
discussing this.
the base type. All values of the restricted type are also valid
according to the base type".
|
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 transfer and merge from Tables hosted on Server
1 TO Tables hosted on Server 2.
|
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.
|
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 asynchat. I use it to connect to several clients inside the asyncore.loop construct.
This part of the application works fine. However, along with talking to clients through sockets, I need to talk to some Spread groups, obviously using spread. My...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
| |
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |