MySQL Forums
Forum List  »  NDB clusters

Re: 100MBit vs. GBit
Posted by: Mikael Ronström
Date: April 11, 2005 03:52PM

Thomas Jonas wrote:

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!

Options: ReplyQuote

Written By
April 11, 2005 07:31AM
Re: 100MBit vs. GBit
April 11, 2005 03:52PM
April 20, 2005 06:37PM
April 22, 2005 02:43AM
April 26, 2005 12:37AM
April 26, 2005 12:41AM
June 06, 2005 10:47AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.