List:Cluster« Previous MessageNext Message »
From:Tomas Ulin Date:October 29 2004 10:39am
Subject:Re: performance question
View as plain text  
Tobias,

do you have a special reason for specifying the TCP connections 
explicitly?  It will be done automatically for you.  As the connections 
are specified below you will be getting some strange behaviour.

T

Tobias Bär wrote:

> We want a setup a mysql cluster for our web portal to get a higher 
> performance.
> Our test cluster consists of 3 pcs. Each of the pcs has about 1,5gb 
> memory.
> After some problems with the database size we got a running system.
> But the results where miserable. The time for loading the page is now 
> about 65 secs! (with a normal mysql server about 2 to 5 secs)
> The bottleneck is obviously the network connection between the 
> database nodes and the api node (right side, only for communication 
> between DBs and MGM).
>
> overview about the structure:
>
>                  |   ---------   API (5)  / DB3 (4) / MGM (1) ---------|
>                  |                                                   
>                              |
> Apache --- |  ----------  API (6) /  DB2 (3)  -------------------- |
>                  |                                             
>                                    |
>                  | ----------- API (7) /  DB1 (2)  ---------------------|
>
> Every database node has the complete data (all nodes together in one 
> nodegroup; NoOfReplicas: 3). Is there a possibility to set up the 
> cluster to use only the db-node which is on the actual pc, f.e. API 
> (5) uses DB3 (4) getting all needed data and not every DBx to get 
> about 1/3 from each node?
>
> config.ini
> ----------------------------------------------------------
> [COMPUTER DEFAULT]
>
> [DB DEFAULT]
> NoOfReplicas: 3
>
> [API DEFAULT]
>
> [MGM DEFAULT]
> ArbitrationRank: 2
>
> [TCP DEFAULT]
> PortNumber: 28002
>
> [COMPUTER]
> Id:1
> HostName: 192.168.10.70
>
> [COMPUTER]
> Id:2
> HostName: 192.168.10.71
>
> [COMPUTER]
> Id:3
> HostName: 192.168.10.72
>
> [MGM]
> Id:1
> ExecuteOnComputer: 1
> PortNumber: 2200
>
> [DB]
> Id: 2
> ExecuteOnComputer: 2
> FileSystemPath: /var/lib/mysql-cluster/node2/
> DataMemory: 850M
> IndexMemory: 150M
> MaxNoOfTables: 256
> MaxNoOfOrderedIndexes: 256
> MaxNoOfUniqueHashIndexes: 128
> MaxNoOfTriggers: 1024
>
> [DB]
> Id: 3
> ExecuteOnComputer: 3
> FileSystemPath: /var/lib/mysql-cluster/node3/
> DataMemory: 850M
> IndexMemory: 150M
> MaxNoOfTables: 256
> MaxNoOfOrderedIndexes: 256
> MaxNoOfUniqueHashIndexes: 128
> MaxNoOfTriggers: 1024
>
>
> [DB]
> Id: 4
> ExecuteOnComputer: 1
> FileSystemPath: /var/lib/mysql-cluster/node4/
> DataMemory: 850M
> IndexMemory: 150M
> MaxNoOfTables: 256
> MaxNoOfOrderedIndexes: 256
> MaxNoOfUniqueHashIndexes: 128
> MaxNoOfTriggers: 1024
>
> [API]
> Id: 5
> ExecuteOnComputer: 1
>
> [API]
> Id: 6
> ExecuteOnComputer: 2
>
> # DB <> DB
> [TCP]
> NodeId1: 2
> NodeId2: 3
> [TCP]
> NodeId1: 2
> NodeId2: 4
> [TCP]
> NodeId1: 3
> NodeId2: 4
>
> # MGM <> DB
> [TCP]
> NodeId1: 1
> NodeId2: 2
> [TCP]
> NodeId1: 1
> NodeId2: 3
> [TCP]
> NodeId1: 1
> NodeId2: 4
>
> # DB <> API
> [TCP]
> NodeId1: 2
> NodeId2: 5
> [TCP]
> NodeId1: 3
> NodeId2: 6
>
> ----------------------------------------------------------
>
>
>
> Thanks.
>
> Regards,
> Tobias
>
>
>
>
>

Thread
performance questionTobias Bär28 Oct
  • Re: performance questionTomas Ulin29 Oct