Allocating MySQL cluster nodes for MogileFS database

[Jared Klett]

hello Mogile folks,

	glad to be here! I've set up MogileFS successfully on my network
and so far I really like what I see. it's shaping up to be exactly the
solution we're looking for.

	(thus, this is probably the first in a series of e-mails I'll be
sending with questions. *grin*)

	right now I have a single MySQL instance running the MogileFS
database on an underpowered server (just for testing) and want to
migrate to using MySQL cluster with the latest 5.1 release and continue
testing.

	here is how I plan to allocate the cluster nodes:

file1 - mogstored, mogilefsd, mysqld node, ndb_mgmd
file2 - mogstored, mogilefsd, mysqld node, ndb_mgmd
file3 - mogstored, mogilefsd, mysqld node, ndb_mgmd
file4 - mogstored, mogilefsd, mysqld node, ndb_mgmd
cluster1 - ndbd node
cluster2 - ndbd node

	so as you can see, the file servers will be pulling quadruple
duty while the cluster storage nodes will be dedicated machines.

	my rationale for piling on to the file servers is as follows:

* each mogilefsd will have a local mysqld node to talk to
* the cluster management node (ndb_mgmd) is very light, according to the
MySQL 5.1 docs
* the load on the trackers (mogilefsd) will be less when spread across
the 4 file servers

	here is a quick run down on the file server specs:

* Dual-core 2.8 Ghz P4
* 2 GB memory (will probably upgrade to 4 GB before going into
production)
* 3ware 9550SX-12MI (RAID-1 for system, 10 x 400 GB JBOD for mogdata)

	and the MySQL cluster storage nodes:

* Dual Opteron 2.4 Ghz (Troy)
* 8 GB memory (may upgrade to 16 before going into production)
* 3ware 8006-2LP (RAID-1 for system)

	am I way off base here? asking for trouble (performance
problems)? if so, what should I move off the file servers to other
machines?

	I apologize in advance for the typical "here's my setup, what
should I expect" question, which is hard to answer, I know. basically
I'm like any other frugal geek, trying to squeeze as much out of my
hardware as I can.

cheers,

- Jared

-- 
Jared Klett
Co-founder, Blip.tv
646.526.8948 (cell)
JaredAtWrok  (aim)
http://blog.blip.tv