|
|
Posted by Captain Paralytic on 11/13/07 10:02
On 13 Nov, 09:47, "2401 members, members can post"
<Paul_Me...@2cuk.co.uk> wrote:
> 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.
Navigation:
[Reply to this message]
|