Re: cluster network load

[Michael Dvorak]

Dear Stewart,

thank you for your reply!

We have tested the direct connection between datanodes with a crosssover cable on GBE network cards on the rear of the cluster servers.

On the front site (to the mysql api nodes) is a GBE switch. The api nodes communicate over the switch with the mysql cluster.

The ndb_mgm is on the api node.

The traffic over the crosslinked site is at least 11Mbit. The rest of the traffic e.g 200MBit goes on the other site over the GBE switch.

It seams that only write transactions goes over the crosslinked site. All read transactions goes over the front side!?

Is this ok? or do we have an configuration misstake?

Our configuration looks like this:

# Management Server
[NDB_MGMD]
Id=1
HostName=192.168.222.101
# Data Nodes
[NDBD]
Id=2
HostName=192.168.222.201
[NDBD]
Id=3
HostName=192.168.222.202
#API Nodes
[MYSQLD]
[MYSQLD]
[MYSQLD]
[MYSQLD]
[MYSQLD]
[MYSQLD]
# TCP/IP Connections
[TCP]
NodeId1=2
NodeId2=3
HostName1=1.1.0.1
HostName2=1.1.0.2

The performance of the hole cluster doesn't increas.

We have made another test. We increase the number of data nodes to 4. The traffic goes over a GBE switch completely.
The performance with 4 data nodes is very poor at least of 50% as with 2 data nodes.

Have you an idea what we can do? We should go only with the system in 2 weeks!

Are there parameters that should be configured?

Hope that you can help us!

Mike