Re: 100MBit vs. GBit

[Mikael Ronström]

Thomas Jonas wrote:

Hi,
Actually most of the processing in 4.1 happens in the mysqld nodes so one slow machine
for mysqld and 8 fast machines for ndbd nodes means that your bottleneck is the mysqld
and so that is what you need to fix first. It is not uncommon that you can have 2 mysqld
nodes per ndbd node (you can have mysqld and ndbd's on the same machines) to get a
balanced load.

100 Mb Ethernet will definitely become a bottleneck sometime with those fast CPU's but
first take care of above.

More RAM if you need it to store data, more RAM is not needed for better performance since
all data need to be in RAM.

Rgrds Mikael

> Hi everyone!
> I'm currently testing MySQL 4.1.10a cluster on 10
> PCs. 8 are equipped with 2.8GHz P4, 1GB RAM and
> 100MBit ethernet interface, on those I have the
> data nodes running. The other two are slower
> machines, one for the ndb_mgm and the other one
> for mysqld.
> So far everything is working, but I'm not quite
> happy with the performance. In my opinion, the
> bottleneck is the ethernet interface. Will I have
> a big performance boost when upgrading my 8 data
> node computers with a gigabit ethernet interface?
> Or is an additional 1GB RAM for each of those 8 PC
> more useful? Or should I upgrade RAM &
> ethernet interface? Which hardware upgrade has a
> bigger impact on performance?
>
> Thank you guys!