ndb cluster for help

Hi everyone:
  We have evaluated MySQL performance on both single machine environment and MySQL cluster disk-base environment.And following is the testing result:

1. Under the Single Machine Environment: the selecting rate and insert rate are 900 records per second and 1000 record per second.
2. Under the cluster environment, the selecting and insert rate only with 300 records and 500 records per second.

  The testing results as per attached, we would appreciate if you can explain how such discrepancy should have happened, and how the single   machine working environment is better than the cluster working environment. Are there some problems of our ndb cluster configuration,or is   the ndb cluster performance so at present?

  Our testing environment and cluster topology chart are as follow:

1> hardware environment:

    Cpu: Celeron(R)2.93GHz
    Mem:1G
    Net:100M

    Os: Linux 2.6.15-23-server
    MySql: mysql-5.1.19-beta-linux-i686-glibc23 3> cluster topology chart:

                         ++++++++++        HA        +++++++++++
                         + LVS    +<---------------->+  LVS    +
                         +        +       |          +         +
                         ++++++++++       |          +++++++++++
                                          |               
                           ----------------------------------
                               |                        |

                          ++++++++++                ++++++++++


                          + MySql  +                + Mysql  +   
                          + Server +                + Server +

                          ++++++++++                ++++++++++


                               |                          |
                               ---------------------------- 
                                            | 
                                        +++++++++++
                                        +         +             ++++++++++++++++++++ 
                                        + ndb     +             +Management server + 
                                        + Storage +<----------->+                  +
                                        +         +             ++++++++++++++++++++
                                        +++++++++++
                                             |
                                    -------------------- 
                                       |            |      
                                    ++++++++     ++++++++
                                    + data +     + data +
                                    + node +     + node +
                                    ++++++++     ++++++++      

    /etc/mysql/ndb_mgmd.cnf
    [NDBD DEFAULT]
    NoOfReplicas=2
    DataDir= /home/ndb_data
    DataMemory=800M
    IndexMemory=300M
    MaxNoOfAttributes=5000
    MaxNoOfConcurrentOperations=500000
    MaxNoOfTables=1600
    MaxNoOfTriggers=10000
    NoOfFragmentLogFiles=200
    TimeBetweenLocalCheckpoints=12
    DiskPageBufferMemory=200M #def
    SharedGlobalMemory=100M #def 20M
    FileSystemPath=/home/ndb_data
    [NDB_MGMD]

        id=1
        HostName=192.168.0.24
    [NDBD]
        id=2
        HostName=192.168.0.22
Do you need help?
In addition to our free technical library, Pantek provides professional IT services to companies who utilize Open Source software:
Learn more about Pantek's Technical Support offerings
Place an order for 24/7/365 Technical Support here
Learn more about Pantek, who we are, and what we do
Chat with a Live Operator
Related lists.mysql.com Links
announce
benchmarks
bugs
certification
cluster
commits
dotnet
gui-tools
internals
java
maxdb
myodbc
mysql
mysqldoc
packagers
perl
plusplus
replication
win32
Request more information about Pantek
        DataDir=/home/ndb_data
   [NDBD]
        id=3
        HostName=192.168.0.26
        DataDir=/home/ndb_data
   [TCP]
       NodeId1=2
       HostName1=192.168.5.7
       NodeId2=3
       HostName2=192.168.5.26
  [MYSQLD]
      Id=4
      HostName=192.168.0.23
  [MYSQLD]
      Id=5
      HostName=192.168.0.25     

 Thanke you for your help!
 Best Regards! Received on Wed Jul 25 04:28:51 2007